In this step-by-step tutorial, learn the top 20 best Microsoft Excel tips and tricks.

👋 Resources called out in this video:
– Excel sheet that I used if you want to follow along:
– In-depth Pivot Table tutorial:

⌚ Timestamps
0:00 Introduction
0:17 Convert image to table in Excel using phone
1:29 Use Excel for free on the web
2:08 Use Ideas to generate insights on your data
3:19 Define names for cells
4:42 Absolute & relative cell references
6:35 Macros
8:35 Data types
9:38 Xlookup function
11:47 Sum function
12:43 Concatenate and flash fill
13:48 Sumif function
14:45 Countif function
15:35 IF function
16:48 Calculate difference between dates & convert function
18:11 Adjust column width & row height automatically
18:56 Freeze panes
19:33 Pivot Tables
21:14 Drop down lists
22:16 Import data from web
23:54 Collaborate with others & comment
24:45 Wrap up

📃 Watch related playlists and videos
– Excel:

🚩 Connect with me on social:
– LinkedIn:
– Twitter:
– Facebook:

🔔 Subscribe to my YouTube channel

🎬 Want to watch again? Navigate back to my YouTube channel quickly

kevin stratvert, excel, excel tips and tricks, excel functions, excel formulas and functions, formulas and functions, formulas, functions, function, formula, excel tutorial, excel tutorial formulas, how to use excel formulas, how to use excelo, microsoft excel tutorial, formulas in excel, excels basics, beginners, tutorial, how to, formula excel, learning excel, microsoft, microsoft excel, excel tutorials

See other Tips articles