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.
Some of these are delivered on behalf of other organisations. Some are organised by myself.
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.
Welcome to The 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.
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)
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
In this video I’ll show you how to add data labels to a chart and then change the range that the data labels are linked to.read more
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
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
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