Be the goto person in your office by learning the very latest features in #Excel with these FREE resources A thread 🧵👇

Whenever someone asked me how to compare 2 lists in Excel, I'd tell them to use the MATCH function. Then I realised using COUNTIF was much easier and neater. So I made a video showing both methods. Which method do you prefer? Let me know! youtu.be/7_Hhayx8tow

Have you ever needed dependent filters in an Excel Pivot Table? Easy, right? Not with standard filters. But using Slicers it's simple. In this video I show you how. youtu.be/Z7mVht-TU5I #pivottables #excel

In my latest video you'll learn how to take the text from the selected button or buttons in a Slicer and display it in a cell youtu.be/m4MP8aXkMZs #excel #pivottable #slicer #Microsoft365

My Teams profile pic is the same as on here. Last week I got a message on Teams...Your profile picture caught my eye and I had to look up what xlookup was. I just wanted to reach out to say THANK YOU for having a profile pic like that. xlookup has changed my life

Did you miss any of my #excel and #powerbi live streams? This year, in addition to the 50 weekly videos I uploaded, I also delivered over 10 hours of content streamed live to YouTube. It's all available here - free and on-demand: youtube.com/@MikeThomas67/…

The IMAGE function is rolling out to Excel's Current Channel users, so here's a timely reminder of what it's all about youtube.com/watch?v=qXaMn0…

How to Hide Sheets so Users Can't Unhide Them Hiding sheets in an #Excel workbook is easy but so is unhiding them. Even adding a password to prevent unhiding can be worked around In this video I show you a more secure method of hiding worksheets youtu.be/I3NDVcymt38

Automatically Updating Drop-Down Lists in #Excel   Drop-down Lists make it easier for users to enter data into cells and prevent typos. Learn how to create a drop-down list from a range of cells so it automatically updates it when the source updates youtube.com/watch?v=Ky4wtB…

I'm delighted to share my latest thoughts through an article that I wrote for Executive Support Magazine You can read "Excel: Take Your Pivot Tables to the Next Level Using The Data Model" here: executivesupportmagazine.com/excel-the-data…

Need a FAST WAY to import data into Excel from SharePoint or OneDrive for Business? If so, this video is for you. youtube.com/watch?v=TWOek1…

Need a quick way to import data into #Excel from a CSV or Excel file that is stored in #SharePoint or OneDrive for Business? Check out this video youtube.com/watch?v=TWOek1…

MoreQuery is a new free addin for Excel for Mac that provides additional data sources for Power Query Short instructional video and download link here: youtube.com/watch?v=ZTiIJf… #excel #powerquery #mac

This video tackles a common data wrangling challenge…handling multiple middle names in a dataset. If you’ve ever encountered the complexity of dealing with names that have more than one middle name, this video is for you! youtube.com/watch?v=-VGHge…

Seen the latest feature available to Beta Insiders in #excel? Inserting an image into a cell from local storage (the IMAGE function only supports URL-based images). Check out my short video here: youtu.be/9x-6O6FBYPE Thanks to the Microsoft Excel team for making it happen

Have you ever needed to do unit conversions in #Excel? Inches to centimetres, Fahrenheit to Celsius, that kind of thing. The CONVERT function makes it really easy. Saves knowing the maths! Check out my short video: youtu.be/eVEgNbEgY7E

New Year...New Branding. "Have an Excellent Day"

Excel turns 40 at the end of this month. Launched on 30 Sept 1985, did you know that Excel 1.0 was Mac-only and that Windows users had to wait nearly 2 more years. 🍏 #Excel40 #Excel

As Excel’s 40th birthday approaches this month, now’s the perfect time to look back at where it all started. If you’re an Excel geek like me, set aside 30 minutes to watch this fascinating documentary on Excel’s story and its impact. youtube.com/watch?v=PI23HA… #Excel40 #Excel

Does the world need another video about the new =COPILOT() function in Excel? Probably not but it's getting one anyway... AI Comes to the #Excel worksheet... youtu.be/zZ2GSULEZwE