Top 25 Microsoft Excel Tips and Tricks for 2022

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

Very useful content

But flashfill is not working in my office 365!

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

"AMP goes to 11" :D:D:D

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

You spelled Keith wrong

Excellent video.
I am new to Excel and I am currently on a trading course. I sent my trades to the course by email.

These buy-and-sell trades were done on an Excel spreadsheet. However, the support department from the course sent me this message.


Dear Richard,
Thank you for sending your trades.

Please, be advised that all trades must be in one file. Also, each trade must have bought and sold chart.

I don't know how to do this and the support department is not very helpful. Can u help?

I have completed 25 buy-and-sell trades.
I hope I don't have to do all the trades again from scratch.

I would welcome your support.

SUPER helpful!! Thank you so much!!!!!

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

I didnt know the speak command .. Thanks

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

Super useful, thank you

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

These tips and tricks very helpful

I have some problems with Right drag fill series in the Microsoft 365, couse' don't have (and can't find) this little window (under my mouse) and any lists, that can help me to fill series. Can anybody help me?

Nice video, thanks. When will Excel offer a better way to search in COMMENTS? Some of my COMMENTs are lengthy and it's very inconvenient to find my SEARCH string within the COMMENT and then have to cut and paste it into NOTEPAD to search again.

I really enjoyed this video - straight forward and to the point. The tips and tricks you revealed had me in awe. I'm relatively new to the Excel domain and your video have me wanting more, more and more. Thank you for a job well done.

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.

Great video!

Is there a way to write an Number like 1 and autocomplete it to a word like “very good”?

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!

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!!!

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.

Great information but delivery is somewhat to fast for me.

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 :)

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!!

Informative, thanks for posting

Thank you 🎄🎄🎄😀

@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!!!

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

Fantastic just Fantastic,thank you.

Please share link to download file for practice

Awesome tips, thank you!

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!

I can't find pdf as an option in get data/file.

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!!

This is fantastic. Thanks for this.

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

Amazing tips 😊😊

Great - 🙏 so much, Mike!!

"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!

Really great tips 👍

wow amazing tips love Excel

Your videos are so informative. Keep them coming.