TheExcelTrainer

Experienced Trainer providing Excel training services including video tutorials, live training and consultancy.

[TheExcelTrainer @TheExcelTrainer]

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

https://t.co/y9A1wspHBQ

[TheExcelTrainer @TheExcelTrainer]

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.

https://t.co/ZBYBwxXm73

#Excel40 #Excel

[TheExcelTrainer @TheExcelTrainer]

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

[TheExcelTrainer @TheExcelTrainer]

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

[TheExcelTrainer @TheExcelTrainer]

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: https://t.co/qB6Kle3U7u

[TheExcelTrainer @TheExcelTrainer]

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: https://t.co/vEoe5zzRD8

Thanks to the @msexcel team for making it happen

[TheExcelTrainer @TheExcelTrainer]

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!

https://t.co/7L7KAcLs2w

[TheExcelTrainer @TheExcelTrainer]

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:

https://t.co/ZfHjrt6i1y

#excel #powerquery #mac

[TheExcelTrainer @TheExcelTrainer]

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

https://t.co/kv8OnnoAsw

[TheExcelTrainer @TheExcelTrainer]

Need a FAST WAY to import data into Excel from SharePoint or OneDrive for Business?

If so, this video is for you.

https://t.co/kv8OnnoAsw

[TheExcelTrainer @TheExcelTrainer]

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: https://t.co/WnXJ77K4n4

[TheExcelTrainer @TheExcelTrainer]

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

https://t.co/uONBysE2K4

[TheExcelTrainer @TheExcelTrainer]

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

https://t.co/oAJRJAxaNa

[TheExcelTrainer @TheExcelTrainer]

The IMAGE function is rolling out to Excel's Current Channel users, so here's a timely reminder of what it's all about

https://t.co/TalRjKeuxX

[TheExcelTrainer @TheExcelTrainer]

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:

https://t.co/2bWB34wH27

[TheExcelTrainer @TheExcelTrainer]

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

[TheExcelTrainer @TheExcelTrainer]

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

https://t.co/nhQgAeW6hZ

#excel #pivottable #slicer #Microsoft365

[TheExcelTrainer @TheExcelTrainer]

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.

https://t.co/Cy0P0EhhTB

#pivottables #excel

[TheExcelTrainer @TheExcelTrainer]

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!

https://t.co/1FPLicMbpi

[Mike Thomas @thomasmike]

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

A thread 🧵👇