Top 25 Microsoft Excel Tips and Tricks for 2021 // NEW features, hidden gems and time-saving tips

This step-by-step tutorial shows the top 25 Microsoft Excel tips and tricks for 2021. Whether you are a beginner, intermediate or advanced Excel user, you’ll find something helpful including new features in Excel. These Excel tricks and will help you get ramped up on Excel for 2021. This includes things like Excel Ideas, Excel Import PDF, Cool Excel Keyboard shortcuts, XLOOKUP, hidden gems and new updates.

More Excel help on our support site: https://support.microsoft.com/excel

12 Microsoft Excel New features: https://youtu.be/n47tIKDgUtE

Excel Analyze Data/Ideas: https://support.microsoft.com/en-us/office/analyze-data-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4

Excel playlist https://youtube.com/playlist?list=PLdHjJccRYryMeSVJ4231nmf-zondK6oK9

My Office Tips and tricks playlist: https://www.youtube.com/playlist?list=PLdHjJccRYryMeSVJ4231nmf-zondK6oK9

Table of contents
0:00 Introduction
0:10 Import PDF
1:08 Analyze Data (Formerly “Ideas in Excel”)
2:57 Flash fill
3:59 Geography and Map data
4:54 Version History
5:50 One-click email as attachment or PDF
6:44 XLOOKUP
8:26 Diagonal cell formatting
8:58 Sparklines
9:20 The best keyboard shortcuts
10:57 Auto-size columns or rows
11:21 Sheet Background
12:01 Delete Blank Rows
12:25 Conditional Formatting
13:18 Stock History and Wolfram Alpha
14:25 Screen shot/camera
15:24 Drop Down lists
16:10 Customize the Quick Access Toolbar (QAT)
16:52 Pivot table
18:58 Right drag fill series
19:25 Casing functions (UPPER/LOWER/PROPER)
19:58 Color your tabs/shortcuts
20:20 Photo of Excel table
21:13 Import data from web
21:49 Excel speaks