Top 25 Microsoft Excel Tips and Tricks for 2022

This step-by-step Excel tutorial shows the top 25 tips and tricks for Microsoft Excel i 2022. 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 365. This includes things like Excel Ideas, Excel Import PDF, Cool Excel Keyboard shortcuts, XLOOKUP, hidden gems 💎 and new updates.

📝 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

📢 Connect with me on Social:

#Excel #Microsoft

[liveitup]

Long time excel user and working at a consultancy. I thought I knew it all. I'm humbled and grateful. Thank you.

[SethFewell]

@Mike Tholfsen, ANOTHER fantastic video! I love seeing the new things that you can do in Excel. These are some major timesavers, and in a few cases, headache-savers too. Thank you!!!

[tomahman]

I've seen dozens of Excel features over the years but your presentation was by far the best, well done!

[dawneharris]

A colleague introduced me to your videos and I am so delighted she did. You give so many great tips and tricks that will take my Excel skills to the next level. Thank you for sharing!!

[briansmylie]

I enjoyed this video very much, you don’t waist time and your examples are clear and straightforward. The shortcuts are really useful, I learned a lot.

[patrickoberli]

Great and extremely helpful video Mike Tholfson!
I will celebrate the moment when you tell us, that the chart diagram can be built on pivot tables and included as a linked graph in PowerPoint!
Please don't make me wait too long :)

[mariuspretorius]

"Whether you're a beginner, intermediate or long-time Excel user you'll find something useful in this video." I can concur with that. I'm a long-time Excel user and I didn't know about the feature for importing data from a PDF document. Thank you!

[SavageGothamChess]

Your videos are so informative. Keep them coming.

[literalchills]

i am just 6 minutes into this video and honestly, this is the best thing that has happened to me today....i have gained more knowledge than my entire university days combined. i just subscribed and promise to watch all relevant videos!!!

[Permagrinful]

I've been using excel since Lotus was in town, taken classes and use it daily but I just learned so many things that I didn't know. Thank you!

[johnjoseph]

Very, very, very good. Almost all are amazing tips

[warrenjoseph]

Instantly subscribed after watching this really well done video. Thank you!

[davidbrady]

This is such a fantastic video! I subscribed and set notifications, because your videos are so extremely helpful and save me so much time with Teams and Excel! Thank you!

[RA-rhlb]

I didnt know the speak command .. Thanks

[touchofficial]

I'm from Cambodia, Thanks for sharing 😊🙏❤️

[magedaziz]

Love it, very useful!! I came from TikTok🙂

[cyberx]

Very good ctrl + e is godlike shortcut !!! :D

[RA-rhlb]

Thanks a lot for posting these valuable tips from Excel. Could you please let me know where did you get the amount for the stock in tips 15? thanks in advance

[Trishbw]

Hi Mike, I purchased office pro 2021 and cant seem to access an excel sheet from way back to open in the current format. Thanks if anyone can answer.

[TomHarold]

Hi Mike, I really need some help. I have a set of raw data that includes numbers assigned to different buildings I report on- each building has it's own number code. There are groupings of these buildings that are organized into different regions. I want to build a column in my raw data tab that will take whatever the building number is in it's corresponding row, and label it the appropriate region (like 400 = Eastern, 410 = Western). This way, I can simply add more raw data and not have to manually add this part. I am using Excel 2016 currently. Thank you!!