At VidCon in Anaheim, CA on July 11, 2019, YouTube Playlists were Announced as a new product. Link to join Learning Playlist: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lPPRiJO5dCUratRGpGx3aT This video introduces you to this new YouTube Learning Playlist product with the excelisfun YouTube Channel Data Analysis & Business Intelligence Class. Check it out and have fun learning!!!

View on YouTube

Download Excel File: https://ift.tt/2G82VCN
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
7 Methods to Jump To Any Excel Worksheet in the Excel Workbook:
1. Click with Cursor to select new Worksheet
2. Scroll Arrows to show new Worksheets without changing Active Worksheet
3. Ctrl + Left-Click Right Scroll Arrow to show Last Worksheet
4. Ctrl + Left-Click Left Scroll Arrow to show First Worksheet
5. Ctrl + PageDown to select next Worksheet to right
6. Ctrl + PageUp to select next Worksheet to left
7. Right-Click Sheet Scroll Arrows to open list of all Worksheets

View on YouTube

In this video, I will show you seven ways to insert and use a checkmark symbol (Tick mark) in Excel.

The following methods of inserting a checkmark symbol in Excel are covered in this video:
1) Copy and Paste the Check Mark (✓)
2) Use the Keyboard Shortcuts
3) Using the Symbols Dialog Box
4) Using the CHAR Formula
5) Using Autocorrect
6) Using Conditional Formatting to Insert Check Mark
7) Using a Double-Click (uses VBA)

A checkmark symbol is different than a checkbox. While a checkbox is an object that floats over the worksheet, a checkmark is a part of the cell and is entered just like you enter the text. This means that you can format the checkmark by changing its size, color, or font type.

The easiest way to insert a checkmark in Excel is to simply copy it and paste it. Although this is a manual process, it can be great when you only want a few of these checkmarks/tick marks.

Below is a checkmark (tick mark) symbol and you can copy and paste in Excel:

✓

You also have keyboard shortcuts in Excel that you can use to insert a checkmark directly into the cell. Note that these keyboard shortcuts will work only when you change the cell formatting to Wingdings or Wingdings 2.

You can also use the CHAR formula to get the checkmark symbol in Excel. This function uses the ANSI code of the checkmark symbol and gives you the corresponding character, For this to work, you need to change the cell formatting to Wingdings.

The good thing about using a formula is that it allows you to get the result based on the cell value. For example, you can get the checkmark if the cell value crosses the 200-mark (example covered in the video).

Autocorrect is another way to insert a checkmark symbol by adding an autocorrect text. For example, you can create a system where as soon as you enter ‘cmark’ and hit the space key, it would automatically convert the ‘cmark’ to a checkmark. The exact process is covered in the video.

Conditional Formatting is another method covered in the video. You can quickly get the checkmark (tick mark) or the cross mark based on the cell value. To do this, you need to apply conditional formatting icons to the cells that have the values.

And the last method covered in this video is using VBA to automatically insert a checkmark as soon as you double-click on a cell. This works by adding a short VBA code in the Excel workbook. Once the code is copied, when you double click on any cell in the specified column, it would automatically insert the checkmark and when you double-click again, it would remove it.

Below the VBA code that does this (exact steps to copy the code in the VB Editor is shown in the video):

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 2 Then
Cancel = True
Target.Font.Name = “Wingdings”
If Target.Value = “” Then
Target.Value = “ü”
Else
Target.Value = “”
End If
End If
End Sub

Remember to save the workbook as an Excel macro-enabled workbook.

You can read more about this tutorial here: https://ift.tt/2JsICCa

⚡ Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel

📌 This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website).

This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc.

⚡ Please subscribe to this channel to be the first to know when new Excel tutorials come out – https://www.youtube.com/c/trumpexcel

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

#Excel #ExcelTips #ExcelTutorial

View on YouTube

Download Excel File: https://ift.tt/2XFfRpL
Download Start Power BI Desktop: https://ift.tt/2JpVBV1
Download Finished Power BI Desktop File: https://ift.tt/2XBDUG3
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs

Learn how to create a DAX Calculated Colum and DAX Measure for Half Year Running Totals in Power BI Desktop or Excel Power Pivot.
Topics:
1. (00:01) Introduction
2. (00:20) Files to download
3. (00:51) Overview of Data Model
4. (01:05) DAX Calculated Column for Half Year Date Table Attribute
5. (02:13) DAX & Excel Worksheet Formulas can mix Data Types – this is different than Power Query
6. (03:00) What is Filter Context?
7. (04:30) DAX Measure for Running Total using FILTER, ALL, MAX, VALUES and CALCULATE DAX Functions
8. (09:28) Format DAX Measures
9. (10:30) Conclusion

View on YouTube

Download Excel File: https://ift.tt/2xnWrLb
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
Learn how to create a PivotTable that shows Half Year Totals Sales Calculation and Half Year Running Total (Cumulative) Calculations using a Logical Formula in a Calculated Column in an Excel Table.

View on YouTube