In this video you’ll learn 30 quick time saving Microsoft Excel tips and tricks for beginners.

1. Create a Dropdown List (0:16)
2. Fill Handle (1:18)
3. Flash Fill (3:25)
4. Email Excel File or PDF (4:42)
5. Automatically Adjust Column Width (6:19)
6. Insert the current date or time (6:57)
7. Named Ranges (7:59)
8. Data Bars in Cell (9:40)
9. Copy a Sheet (10:47)
10. Keyboard Shortcuts to Quickly Navigate a Workbook (11:42)
11. Auto Sum (13:15)
12. Quick Summary Statistics (14:21)
13. Clear All Formats (15:00)
14. Quick Analysis Tool (15:26)
15. Freeze Panes (16:15)
16. Transpose Data (17:37)
17. Set Default Save Location (18:55)
18. Skip Blanks (19:57)
19. Absolute References (21:10)
20. Merge Cells with Fill Justify (23:36)
21. Copy & Paste Chart Formats (24:38)
22. Show or Hide the Ribbon (25:32)
23. Activate Sheet Menu (25:53)
24. Go To Special (26:23)
25. Ctrl Enter (27:58)
26. Show Formulas (29:51)
27. Click and Drag to Edit Formulas (30:32)
28. Highlight Duplicates (31:33)
29. Sparklines (32:31)
30. Group Sheets (34:31)

Get your free Excel tips and tricks ebook here:
👉 https://www.howtoexcel.org/newsletter/