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:!AmxrofZZlZ-whKMxYi3HuSk1aLx-PA?e=BIFDPp
– 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

Leave a Reply

Close Menu