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) 👇
Check out my full courses and ebooks here
👉 https://www.howtoexcel.org/courses/
DOWNLOAD the example workbook here
📖 https://www.howtoexcel.org/downloads/
SUBSCRIBE & get my 3 FREE eBooks
📧 https://www.howtoexcel.org/newsletter/
CONNECT with me on social
Facebook: https://www.facebook.com/howtoexcelblog
Twitter: https://twitter.com/howtoexcelblog
LinkedIn: https://www.linkedin.com/in/john-macdougall/
Thanks for all your support!
