20 Excel Tricks for Data Analysis | Excel Tutorials

Learn Excel tricks that Beginner Excel users don't know.

Download Excel tricks Practice files: https://bit.ly/3oTH85y

Checkout Full Advanced Excel Course Library: https://bit.ly/2JWUQ9f

Advanced Excel tricks to be discussed:
0:07 Excel #BeastMode - Data Analysis tricks
0:57 Excel Flash Fill (Excel Shortcut keys Ctrl + E)
Change the Date formatting using Excel Shortcuts (Ctrl + Shift + 3)
2:22 Excel Find & Replace (Excel Shortcut keys Ctrl + H)
3:02 Excel TEXT Function
4:40 VALUE Function in Excel
Change the Time Formatting using Excel Shortcuts (Ctrl + Shift + 2)
5:17 Insert Pivot Table in Excel
5:50 Pivot Table Date Grouping
6:43 Create Heat Map using Conditional Formatting
7:02 Excel Chart - Sparklines
Note: Sparklines features will be available from Excel 2010 onwards
7:40 Insert Pivot Table Slicer (Introduce in Excel 2010)
8:15 Create Excel Chart (Excel Shortcut keys F11)
8:52 Pivot Table Report Filter Pages

20 Excel Tricks you SHOULD know | Excel Tutorial
#advancedexcel #exceltips #exceltricks

Top 10 Must know Excel Shortcuts keys
https://www.youtube.com/watch?v=g1juJQI8Q64

Keep yourself updated. Follow us now!

Like us on https://www.facebook.com/yodalearning
Tweet us on https://www.twitter.com/yodalearning
Follow our boards at https://in.pinterest.com/yodalearning/pins/

Видео 20 Excel Tricks for Data Analysis | Excel Tutorials канала Yoda Learning Official