Excel Training to Enhance Your Career and Increase Your EarningsNo-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
60-90 minute live Excel training sessions delivered by me via The Internet.
Upcoming Live Training Dates
- 27-Mar-17 : PowerPivot and Power Query
- 28-Mar-17 : Mastering Excel Formulas and Functions
- 29-Mar-17 : PowerPivot and Power Query
- 30-Mar-17 : Building a Reporting Tool with Pivot Tables and Charts
- 04-Apr-17 : Excel - Managing Lists and Databases
- 05-Apr-17 : Excel - Mastering Formulas and Functions
- 11-Apr-17 : Automating Excel - An Introduction to VBA
Welcome to The Excel Trainer
Who I am and What I Do
I’m Mike Thomas. I have over 25 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.
As I said at the top of the page, “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.” Through my training courses, videos and written tutorials, I hope that I can help to make a difference.
Latest Excel TutorialsMy latest written and video based Excel tutorials. For more tutorials, please visit the Tutorials section (use the menu at the top of the screen)
Do you need to create pivot tables from multiple datasets? Do you spend too much time cleaning up imported data before it can be used?read more
One of the training courses that I deliver is how to create a dashboard in Excel. In this short video I explain what an Excel-based dashboard means to me.read more
A Map Chart (new in the November 2016 release of Excel 2016 for Office 365 subscribers) allows you to quickly and easily display geographic data as a mapread more
I was recently asked how to round a time to the nearest 15 minutes. The question was in relation to the “7 minute rule” where employee clock in and clock out times are rounded to the nearest quarter hour.read more
The NETWORKDAYS.INTL function will calculate the number of working days between 2 dates but will also allow you to define which days are weekends. Useful for regional variations.read more
Heatmaps are just one way to analyse and present data in a visual way. They are especially useful when it comes to geographic-based data.read more
Last week I was then asked “how can you display the median of a set of values in a pivot table?” It’s not simple because median does not exist as an option. In this tutorial I show you how to do it.read more
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
A Win Loss chart displays positive and negative values as different colours, helping you to quickly spot trends in a set of figures. This tutorial shows how to create one.read more