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
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.
Excel Video-Based Training CoursesInvest in Yourself - training courses to improve your Excel skills
Excel - More Than a Numbers Game
One of Excel’s strengths is how it handles lists and text-based data. In this 1 hour course I’ll show you some some simple-but-effective ways to save time when working with lists and text in general.
Automating Excel with Macros
If you’re at the stage where you repeat the same process on a regular basis, you need to learn how to create a macro. This short course teaches you how to create and edit simple macros.
What They're SayingA few written testimonials from happy and satisfied Excel Trainer customers
Thank you so much. I have to say that was one of the best webinars I have ever taken. Mike did a great job!Tianna Ruelas
Can We Work Together?Personal chemistry is just as important as product knowledge. An effective Trainer for one person may not be a good match for another.
You need to be able to understand what I’m saying, you need to like my voice. You need to like my training style, you need to like my examples. So how can you do that? Well here’s a 20 minute video of me delivering training on how to use the VLOOKUP and HLOOKUP functions. if you like what you see, then please come back for more!
Excel TutorialsA few written and video based Excel tutorials. For more tutorials, please visit the Tutorials section (use the menu at the top of the screen)
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
In Excel 2016 for Windows, the new TEXTJOIN function allows you to combine the values from a range of cells.read more
When I tried to run PowerMap on Excel 2016 for Windows, running in a VM on my iMac, up popped a message telling me that my video driver may not support DirectX. Here’s how I fixed itread more
Excel displays numbers containing more than 11 digits in “exponential format” (e.g. 8.2978E+11). This tutorial shows how to display the numbers as proper numbers (e.g. 829780189348)read more
This short video gets you started with Pivot Tables. It uses Excel 2016 for Windows but users of earlier versions of Excel will find it beneficial too.read more
There are times when you need to create a Pivot Table from data that is stored in multiple Tables or ranges, either on the same sheet or separate sheets. This video demonstrates how to do it.read more
In this video I explain one of the short-comings of the VLOOKUP function and how to get around the problem using the MATCH functionread more
In this tutorial I explain why adding up a column of time values results in a 0 and how to fix the problem.read more
In this short video I explain how to group a list of dates in a Pivot Table so that they display in blocks of 7 daysread more