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: 1drv.ms/x/s!AmxrofZZlZ-whKMxYi3HuSk1aLx-PA?e=BIFDP…
In-depth Pivot Table tutorial:    • Pivot Table Excel Tutorial  
Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com/

⌚ 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:    • ❎ How to use Excel  

🚩 Connect with me on social:
LinkedIn: www.linkedin.com/in/kevinstratvert/
Twitter: twitter.com/kevstrat
Facebook: www.facebook.com/Kevin-Stratvert-101912218227818

🔔 Subscribe to my YouTube channel
youtube.com/user/kevlers?sub_confirmation=1

🎬 Want to watch again? Navigate back to my YouTube channel quickly
www.kevinstratvert.com/