Excel Training to Enhance Your Career and Increase Your Earnings
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 marketFree Pivot Table Training Videos
Upcoming Live Online Training
- 24-Apr-18 : Excel - Pivot Tables - Beyond the Basics
- 24-Apr-18 : Outlook - Inbox Hero Inbox Zero
- 25-Apr-18 : Excel - Powerpivot and Power Query
- 25-Apr-18 : Excel - Creating High Impact Business Reports
- 26-Apr-18 : Mastering Microsoft Excel Pivot Tables & Pivot Charts
- 26-Apr-18 : Excel - Pivot Tables 101
- 27-Apr-18 : OneNote - Bringing Order to your Digital Chaos
- 27-Apr-18 : Excel - Business Intelligence and Data Insights with Dashboards
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 Tutorials
My latest written and video based Excel tutorials. For more tutorials, please visit the Tutorials section (use the menu at the top of the screen)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
read moreExcel – Create a Pivot Table Using Excel Online
Excel Online, the browser-based version of Excel is available to anyone who has a free Microsoft account (as well as a paid-for Office365 account). In March 2018, Microsoft added the ability to create pivot tables to Excel Online
read moreINDEX & MATCH v VLOOKUP / HLOOKUP
VLOOKUP and HLOOKUP are very useful functions however sometimes their inflexibility lets them down. Here I explain how INDEX and MATCH can be used instead
read moreExcel Slicers – 2 Pivot Tables Based on Different Data Sources
I have 2 (or more) pivot tables in a file. The pivot tables are not connected to the same data source. I am unable to connect the slicer to all the pivot tables. How can I attach a Slicer to both/all pivot tables?
read moreExcel 2010 – Create a Combo Chart
A combo (or combination chart) is a chart that plots multiple sets of data using two different chart types. A typical combo chart uses a line and a column. Despite being out of support for several years, Excel 2010 is still in use in many organisations, however,...
read morePower Pivot and Power Query
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 moreExcel – What is a Dashboard?
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 moreExcel 2016 – Create a Map Chart
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 map
read moreRounding Time to the Nearest 15 Minutes
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