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: - Learn the fundamentals of Excel in just 2 hours: ⌚ 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