Sign in to confirm you’re not a bot
This helps protect our community. Learn more
These chapters are auto-generated

Top 30 Quick Excel Tips & Tricks for Beginners

0:00

Dropdown List

0:18

Fill Handle

1:18

Flash Fill

3:26

Email Excel File or PDF

4:43

Auto-Adjust Column Width

6:20

Insert Current Date or Time

6:58

Named Ranges

7:59

Data Bars in Cell

9:40

Copy a Sheet

10:48

Quick Navigation Keyboard Shortcuts

11:42

AutoSum

13:16

Quick Summary Statistics

14:21

Clear All Formats

15:01

Quick Analysis Tools

15:26

Freeze Panes

16:15

Transpose Data

17:37

Set Default Save Location

18:56

Skip Blanks

19:57

Absolute References

21:10

Merge Cells with Fill Justify

23:37

Copy & Paste Chart Formats

24:38

Show or Hide the Ribbon

25:32

Sheet Menu

25:54

Go To Special

26:24

Ctrl Enter

27:59

Show Formulas

29:52

Click & Drag to Edit Formulas

30:33

Highlight Duplicates

31:34

Sparklines

32:32

Group Sheets

34:31
☑️ Top 30 Quick Excel Tips & Tricks for Beginners
DOWNLOAD the example workbook here: 👉 https://howtoexcel.com/downloads Thanks for all your support!

Follow along using the transcript.

How to Excel

67.1K subscribers