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

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: Visual Updates to Excel

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

Power Pivot and The Excel Data Model

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.

Do You Want Early Access to Excel Updates?

Each month Microsoft release a new “version” of Excel to Office 365 subscribers. By signing up to The Office Inside Program you can get early access. This post explains how to do so

Why You Should NOT Buy Excel 2019

Hopefully I’m not too late with my advice. Hopefully nobody has yet bought Microsoft Office 2019. So why am I recommending the you don’t buy it?

Excel – Import a List of Tasks into Outlook

I created a short video in response to a question that I received via email… “Is it possible to import a due date listing on an Excel spreadsheet to Outlook and set up reminders for these due dates?”

Excel – NEW in March 2018: Geography and Stock Data Types

Until now Excel users have only been able to store text, numbers, dates and formulas in cells. Well now, Microsoft have added 2 new data types – Geography and Stocks. These data type will fundamentally change what’s possible with Excel