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
🔔 Subscribe to my Channel: https://aka.ms/MikeYouTubeSubscribe
📢 Connect with me on Social:
Twitter: https://twitter.com/mtholfsen
LinkedIn: https://www.linkedin.com/in/miketholfsen
Instagram: https://www.instagram.com/mtholfsen
Pinterest: https://www.pinterest.com/miketholfsen
TikTok: https://www.tiktok.com/@mtholfsen
Wakelet: https://www.wakelet.com/@mtholfsen
#Excel #Microsoft
