The Excel Trainer: Solving Business Problems with Technology
Who I am and What I Do
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.
Popular Excel Tutorials
A selection of my 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 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
Why You Should NOT Buy Excel 2019
Hopefully I’m not too late with my advice. Hopefully nobody has yet bought Microsoft Office 2019. So why am I recommending the you don’t buy it?
Excel – Import a List of Tasks into Outlook
I created a short video in response to a question that I received via email… “Is it possible to import a due date listing on an Excel spreadsheet to Outlook and set up reminders for these due dates?”
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
Excel – 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
INDEX & 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
Excel 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?
Excel 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,...
Power 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?