Mike Thomas

Mike Thomas
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac.
In 2012 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials.
He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
-
Practical Excel – Building Pivot Table Based Reports and Dashboards
Pivot Tables are one of the most powerful tools in Excel’s data analysis and Business Intelligence (BI) armory. With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily build the reports, dashboards... -
Excel – Mastering Lookup Functions
“How do I compare the items in these two lists and see which are missing” “How do I look up a value in list ONE and pick up a related value from list TWO” “How do I avoid my... -
Practical Excel – Creating a Dashboard
No matter what business you are in, a dashboard is a critical tool in your communication armoury and as with any communication tool, presentation is everything. Although there are many tools that can be used to create a dashboard,... -
Excel VBA 101 – Automation Beyond the Macro Recorder
Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? If the answer is “Yes”, it’s time to learn how to create a macro. VBA is the programming language that is built in to Excel... -
Master Excel Formulas – Tips & Tricks with Real-World Examples
Although it is perfectly possible to use Excel without ever creating a formula or using a function if you don’t, you’re missing out on a huge part of the application’s power. Without formulas and functions, Excel would not be... -
2-Hour Virtual Seminar on Excel as a BI Tool – Power Pivot and Power Query 101
Power Pivot and Power Query are free addins for Excel, written by Microsoft (in fact in Excel 2016 and later Power Query is built into the application and not an addin at all). Power Pivot puts the “power” into... -
Excel as a Business Intelligence Tool – Pivot Tables
Microsoft Excel Pivot Tables are one of the most powerful tools in Excel’s data analysis and Business Intelligence (BI) armoury. With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily build the... -
Outlook – Master your Mailbox – Inbox Hero Inbox Zero
For most business users (and many home users too), Microsoft Outlook has become the standard application for managing emails, calendar appointments and to-dos. With an abundance of features and versions for desktop and mobile, there’s really no excuse not... -
Excel – Power Pivot – Taking Pivot Tables to the Next Level
Power Pivot, a free addin for Excel, written by Microsoft, puts the “power” into Pivot Tables (hence the name!). Power Pivot removes many of limitations and frustrations that many advanced users find with Pivot Tables. For example, using Power... -
Excel – Create High-Impact Business Reports
No matter what business you are in, a report is a critical tool in your communication armoury. As with any communication tool, presentation is everything. Get it right and it offers the reader (typically a CEO, shareholder or Project... -
Improve Your Excel Accuracy – Master VLOOKUP, MATCH and INDEX Functions
Do you want to improve the accuracy and integrity of your Excel workbooks? Do you want to save a ton of time and minimise data entry errors? VLOOKUP, HLOOKUP, INDEX and MATCH are some of the most well-known (and... -
Excel VBA 101 – Take Automation Beyond the Macro Recorder
Although Excel has a Macro Recorder for automating tasks and processes, there’s a limit to what the Macro Recorder can do. So where the Macro Recorder’s functionality ends, VBA takes over. In this session you will learn how to... -
Excel’s Power Query – Import, Manipulate, and Master Big Data
Do you work with “Big Data”? Do you import and manipulate large datasets in Excel? If so you’ll already be familiar with the limitations of Excel. Power Query, (known as Get and Transform in Excel 2016) is designed to... -
Achieve Greater Productivity With Outlook Contacts, Calendar & Tasks
For most people, Outlook is a way of managing their mailbox however that is only part of what Outlook is capable of. In addition to being the world’s most popular email client, Outlook is also your calendar, your to-do... -
Excel Beyond Numbers – Tame Lists and Tabular Data
If you think that Excel is all about working with numbers, then think again. More and more people are turning to Excel to help them to manage list-based and tabular data. In many cases they receive, download or import... -
The Excel VLOOKUP Crash Course
Do you want to improve the accuracy and integrity of your Excel workbooks? Do you want to save a ton of time and minimise data entry errors? VLOOKUP, HLOOKUP, INDEX and MATCH are some of the most well-known (and... -
Excel – Automate Tasks and Processes with Macros
Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? If the answer is “Yes”, it’s time to learn how to create a macro. In this session you will learn how to create and edit... -
Outlook – It’s Time to get Organized
If you’re like millions of other business professionals, you probably use Microsoft Outlook every day to manage your email, calendar and to-do’s. It’s available for Windows, Mac, mobile and there’s even a web version. So there’s no excuse not... -
Excel – Advanced Functions
Whether you need to calculate loan repayments, generate a profit-and-loss account, solve maths or engineering problems, in fact, think of any scenario that involves addition, subtraction, division or multiplication of numbers and you’ll find that Excel is the best... -
Excel – Managing Lists and Databases
If you think that Excel is all about working with numbers, then think again. More and more people are turning to Excel to help them to manage list-based and tabular data. In many cases they receive, download or import... -
Excel – Importing and Manipulating Big Data with Power Query
Do you work with “Big Data”? Do you import and manipulate large datasets in Excel? If so you’ll already be familiar with the limitations of Excel. Power Query, (known as Get and Transform in Excel 2016) is designed to... -
OneNote – Bringing Order to your Digital Chaos
For many people the holy grail of organization is a world where email overload doesn’t exist and where all those sticky notes and paper notepads are magically replaced by a digital paperless system. Using OneNote, a free application that... -
Excel – Improve Data Visualization with Maps, Charts and Infographics
There is a saying, “a picture is worth a thousand words”. In Excel that means finding ways to represent numerical data pictorially so that your audience can quickly and easily understand it. It’s often easier to look at a... -
Mobile Productivity – Microsoft Office on Mobile Devices & iPad
The iPad is at last being treated as a serious business tool. Rather than carry 2 devices, many users are choosing to trade-in their laptop and go iPad-only. One of the keys to being a productive mobile worker is... -
Excel – Automated Dashboards for Business Intelligence
No matter what business you are in, a dashboard is a critical tool in your communication armoury and as with any communication tool, presentation is everything. Although there are many tools that can be used to create a dashboard,...