Excel Training to Enhance Your Career and Increase Your Earnings

No-one learns Excel for fun. But if you have good-to-excellent Excel skills you’ll stand a better chance in today’s highly competitive job market

Pivot Table Resources

Pivot Tables are one of the most requested topics that I get asked about.

So to help you to learn, I’ve pulled together all my Pivot Table tutorials into a single page.

Learn More

Welcome to The Excel Trainer

Mike Thomas - Excel Trainer

Hello and welcome! My name’s Mike Thomas – also known as The Excel Trainer. I launched this website in 2012 as a way to share my knowledge and love of Excel. I’ve been working with Excel since the early 90’s (Excel v4) – as a user, a Developer (of Excel-based solutions) and a Trainer.

On this site, in addition to the 100+ written and video based tutorials covering many many different features of Excel, you’ll find details of Excel training courses and Excel webinars that I offer. I hope that through what I offer, I’m able to answer your Excel-related questions and help you to master the software.

Excel Video-Based Training Courses

Invest in Yourself - training courses to improve your Excel skills

Excel - More Than a Numbers Game

One of Excel’s strengths is how it handles lists and text-based data. In this 1 hour course I’ll show you some some simple-but-effective ways to save time when working with lists and text in general.

More Details

Automating Excel with Macros

If you’re at the stage where you repeat the same process on a regular basis, you need to learn how to create a macro. This short course teaches you how to create and edit simple macros.

More Details

PluralSight Courses

In 2015 and 2016 I authored 3 Excel-related courses for PluralSight – one of the leading providers of video-based online learning.


More Details

What They're Saying

A few written testimonials from happy and satisfied Excel Trainer customers

Thank you very much for this tutorial! Very clear and easy to follow! Cheers

Bill Huynh

Thank you so much. I have to say that was one of the best webinars I have ever taken. Mike did a great job!

Tianna Ruelas

Very clear and I liked the way you covered even the “TRUE” feature in Vlookup and where it may be useful. Thanks for taking your time in posting this tutorial…!

Vspalani Appan

Thank you very much for sharing this. It saved me a lot of time using this simple function. Kudos and Godspeed!


Can We Work Together?

Personal chemistry is just as important as product knowledge. An effective Trainer for one person may not be a good match for another.

You need to be able to understand what I’m saying, you need to like my voice. You need to like my training style, you need to like my examples. So how can you do that? Well here’s a 20 minute video of me delivering training on how to use the VLOOKUP and HLOOKUP functions. if you like what you see, then please come back for more!

Best tutorial I’ve seen to date. Thank you

Seamus Monaghan

Excel Tutorials

A few written and video based Excel tutorials. For more tutorials, please visit the Tutorials section (use the menu at the top of the screen)

Excel’s 10,000 Hour Limitation

I was recently asked why a time value divided by a number generated a #VALUE! error. The reason was because the time value was over 10,000 hours. This tutorial shows a workaround.

read more

VMWare, PowerMap and DirectX

When I tried to run PowerMap on Excel 2016 for Windows, running in a VM on my iMac, up popped a message telling me that my video driver may not support DirectX. Here’s how I fixed it

read more

Create a Pivot Table From Multiple Tables

There are times when you need to create a Pivot Table from data that is stored in multiple Tables or ranges, either on the same sheet or separate sheets. This video demonstrates how to do it.

read more

The Excel Trainer: Excel-Based Training and Business Solutions