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
Cartoon People
NEW: Cartoon People in Microsoft Office let’s you add a little fun to your Excel files as well as making them more engaging
Build an Infographic-Style Bar Chart in Excel
Learn how to create an impressive, eye-catching and engaging infographic that will wow your audience
LAMBDA – A Beginner’s Guide
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.
Remove Protection When Password is Unknown
If you lose or forget the password, it cannot be recovered. That is not 100% true. In this tutorial I show you how to do it.
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.
Storing List Based Data in Worksheet Cells: Pros v Cons
The row-and-column structure of Excel make it ideal for storing list-based data. But it’s not all sweetness and light
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