The Excel Trainer: Solving Business Problems with Technology

Welcome to The Excel Trainer

I’m Mike Thomas. I have over 30 years experience designing and delivering training courses and I’ve been working with Excel since the early 90’s as a User, a Developer and a Trainer.  

Through my training courses, videos, written tutorials and application development skills, I hope that I can help to make a difference to you and your business. 

Latest Tutorials

Below you will find the latest tutorials from The Excel Trainer blog. For older posts, please click here or click the Tutorials link on the menu

LAMBDA – The Latest Excel Craze

Need to know LAMBDA? Need to know it FAST? This is the video for you! No prior knowledge needed and in 15 minutes you’ll be up to speed with one of the most powerful function in Microsoft Excel.

5 Reasons Why XLOOKUP Beats VLOOKUP

XLOOKUP is branded as a VLOOKUP Killer but what’s so good about it. In this post I present 5 reasons why it’s time to switch

July 2021: New Ribbon – Hit or Miss

Microsoft recently announced visual updates for Office including a new startup screen and an updated Ribbon, replete with rounded corners.

The Data Model – The Way Forward

This post will cover many of the points that are raised and the questions that are asked when I talk about Power Pivot and The Data Model in my Excel training sessions.