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: https://youtu.be/m0wI61ahfLc
• Timestamp
  • 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