Top 20 Microsoft Excel Tips & Tricks

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: https://1drv.ms/x/s!AmxrofZZlZ-whKMxY...
In-depth Pivot Table tutorial:    • Pivot Table Excel Tutorial  
Learn the fundamentals of Excel in just 2 hours: https://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:   / kevinstratvert  
Twitter:   / kevstrat  
Facebook:   / kevin-stratvert-101912218227818  

🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?...

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