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

Excel Webinars

60-90 minute live Excel training sessions delivered by me via The Internet.

Some of these are delivered on behalf of other organisations. Some are organised by myself.

Learn More

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.

PluralSight

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!

dracoe

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 2016: Creating a Pareto Chart

A Pareto Chart shows the relative frequency of items in descending order. They are often used as the basis for creating a prioritization tool so that, for example process improvement activities can be organised.

read more

Creating a Heat Map with Excel

A heatmap is a graphical representation of data where the individual values contained in a matrix are represented as colours. This tutorial shows you how to create one in Excel.

read more

Print Filename and Sheet Name in Footer

When you look at a printout from Excel, sometimes there is content at the bottom of each page that is not part of the actual workbook. This is the Footer. Although Excel allows you to put anything in the Footer, typically this area of the page contains a page number,...

read more

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

The Excel Trainer: Excel-Based Training and Business Solutions