TOP 30 EXCEL TRICKS FOR BEGINNERS

 

Top 30 Quick Excel Tips & Tricks for Beginners

 

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​) 👇

Share: