☑️ Top 30 Quick Excel Tips & Tricks for Beginners

preview_player
Показать описание
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

DOWNLOAD the example workbook here

SUBSCRIBE & get my 3 FREE eBooks

CONNECT with me on social

Thanks for all your support!
Рекомендации по теме
Комментарии
Автор

Check out my full courses and ebooks here

HowToExcelBlog
Автор

Hi John. A great set of tips! Thanks for sharing :)) Thumbs up!!

wayneedmondson
Автор

Man... I've been using Excel since forever, and there were *at least 6 tips* in your list I'd never heard of before. 🤦🏻‍♂️Thanks a ton! 👍✋

rgarlinyc
Автор

Nice Tutorial!I'd Forgotten Some Of These Tricks And How Useful They Can Be.Thank You John :):):)

darrylmorgan
Автор

very good and informational i got so much lesson after wataching this

almasshaukat
Автор

Excellent video...I always learn something new! Thank You

deniseroberson
Автор

Hi great video - I have been using excel for many years but several of those tips are new to me - so fantastic stuff. Keep it up.

GregDavies
Автор

Suggestion; On Data Bars in cells; if you adjust to taller cell rows with the text formatted in the middle of the row, the data bars are much more visible at a glance.

reginaldmarselus
Автор

Thank you for this video. Is there a way to quickly navigate to the last row of your column when there is/are blanks on it? because ctrl+ ⬇️ doesn’t work.

LS-zocr
Автор

Thanks! How did you put this yellow circle around that black cross? I have yellow circle around my arrow but not around this black cross.

shoppersdream