Mike Thomas

Mike has worked in the IT training business since 1989 where his expertise and experience covers designing, delivering training courses, writing training materials and recording and editing video-based tutorials. Although he is a subject matter expert in a range of Microsoft technologies and has worked extensively with Mac OSX and Mac-related software since 2006; however, his passion is for all-things-Excel and in 2012 he founded the website theexceltrainer.co.uk

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 designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

Live Webinar

By: Mike Thomas

Dec. 3, 2024

Excel - 10 Key Worksheet Functions to Skyrocket Your Productivity

Microsoft Excel contains almost 500 built-in worksheet functions. Strip away the ones nobody uses. Discount the ones that have a specialized use case and you're left with a small set of functi…

Industry: Software Duration: 90 Minutes Time: 10:00 AM PDT | 01:00 PM EDT

By: Mike Thomas

Dec. 9, 2024

Excel - Pivot Tables - The Key To Modern Data Analysis and Reporting

Whether you need to build an Excel-based dashboard, perform some serious data analysis, or simply summarize data for a personal project, Pivot Tables are one of the most powerful tools in Excel&rs…

Industry: Software Duration: 60 Minutes Time: 10:00 AM PDT | 01:00 PM EDT

Recorded Session

By: Mike Thomas

Recorded Session

Excel Power Query: The Powerful Get & Transform Tool for Importing and Manipulating Data

Do you work with Big Data? Do you import and manipulate large datasets in Excel? If so you will already be familiar with the limitations of Excel. Power Query, (known as Get and Transform in Excel…

Industry: Software Duration: 90 Minutes

By: Mike Thomas

Recorded Session

Microsoft Excel: Creating an effective and balanced KPI Dashboard for HR Professionals

Dashboards are an important part of managing and reporting on Human Resources. They form the basis of informed decision making and business insights. Dashboards have a variety of uses from keeping…

Industry: Software Duration: 90 Minutes

By: Mike Thomas

Recorded Session

Excel 2010-16 VBA Basics: 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.…

Industry: Software Duration: 90 Minutes

By: Mike Thomas

Recorded Session

Microsoft 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 …

Industry: Software Duration: 90 Minutes

By: Mike Thomas

Recorded Session

Excel - Pivot Tables for HR Professionals

Whether you need to build an Excel-based dashboard, perform some serious data analysis, or simply summarize data for a small project, Pivot Tables are one of the most powerful tools in Excel&rsquo…

Industry: Software Duration: 90 Minutes

By: Mike Thomas

Recorded Session

Email management : Best way to organize microsoft outlook emails

If you're like millions of other business professionals, you probably use Microsoft Outlook every day to manage your email, calendar, and to-dos. It's available for Windows, Mac, and mobil…