Speaker Profile
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.
Mike Thomas
January 17 2025
01 : 00 PM EST
60 Minutes
Excel – Reporting Simplified – Learn Pivot Tables from Scratch
Unlock the power of Excel's data analysis and Business Intelligence (BI) toolkit with Pivot Tables. Whether you're aiming to construct dynamic dashboards, conduct in-depth data analysis, or simply streamline data summaries for personal or business purposes, Pivot Tables are your key to success.In just a few clicks, without the need for complex formulas, you can effortlessly generate insightful reports, dyna..
Mike Thomas
February 17 2025
01 : 00 PM EST
60 Minutes
Excel - A Beginner’s Guide to Formulas
Think of any scenario that involves addition, subtraction, division or multiplication and that's where you'd use a formula. In addition to building formulas, the session will introduce you to Functions which are built-in formulas that have been programmed to perform a specific calculation. They can often be used to shorten and simplify what would otherwise be a long-winded manually-entered formula.Are you n..
Mike Thomas
March 18 2025
01 : 00 PM EST
60 Minutes
Excel - Lists and Tables - A Beginner’s Guide to Managing List-Based Data
Often perceived as a mere number-crunching tool, Excel's true prowess lies in its capacity to organize and manage list-based data efficiently and this training session is designed to unveil Excel's full potential beyond arithmetic computations. Whether you're dealing with employee rosters, inventories, course catalogues, or any other list-based information, Excel offers an impressive suite of features that ..
Mike Thomas
April 15 2025
01 : 00 PM EST
90 Minutes
Excel - Beyond the Bar Chart - Data Visualization and Data Story Telling Techniques
Revolutionize the way you communicate data with this cutting-edge training on Excel visual storytelling. Discover the power of visual data representation to transform complex numerical information into compelling, insightful visual narratives.The era of simple bar and pie charts has moved on. Today's data-driven environment demands more dynamic visualizations and infographics. Our session will guide you thr..
Mike Thomas
May 14 2025
01 : 00 PM EST
90 Minutes
Excel - 10 Key Worksheet Functions to Skyrocket Your Productivity
An often-asked question by Excel users is "Which Excel worksheet functions are truly essential?" In a world of over 500 built-in Excel functions, the key is to identify the ones that truly impact your productivity and success while discarding the rest. Let's sift through the clutter, leaving behind the rarely-used and highly specialized functions, to uncover a select set of Excel tools that are universally ..
Mike Thomas
June 17 2025
01 : 00 PM EST
90 Minutes
Excel - Build Advanced Pivot Table Solutions Using the Data Model & PowerPivot
Whilst Pivot Tables offer valuable data summarization features, they also have several limitations. They struggle with handling large datasets, they lack the ability to combine data from multiple datasets and the built-in calculation functionality is very simplistic.This training focuses on the Data Model and Power Pivot, two of Excel's hidden gems which help to overcome the built-in limitations. For exampl..
Mike Thomas
July 01 2024
01 : 00 PM EST
60 Minutes
Excel - CUBE Functions - Where the Data Model Meets the Spreadsheet
Unlock the full potential of your data with the power of CUBE functions in Excel! This training session is designed to help you master one of Excel’s most advanced tools for integrating and analyzing data from the data model. From creating dynamic reports to accessing specific datasets with precision, CUBE functions enable deeper insights and greater flexibility in your reporting. Whether you're an Excel po..
Mike Thomas
August 04 2025
01 : 00 PM EST
60 Minutes
Excel - Power Query – The Smart Way to Handle Data Cleaning and Transforming
Turn bad data into great data in minutes! Do you spend more time than is necessary importing and updating data from external sources such as databases, CSV files and web pages?Does the phrase "it's taking too long" describe how you feel about the time it takes to get your data into the right format for your reports?Do you regularly perform repetitive time-consuming "data cleaning and transforming" tasks suc..
Mike Thomas
September 01 2025
01 : 00 PM EST
60 Minutes
Excel Meets AI - How Microsoft Copilot Can Save You Time
This training is designed to revolutionize the way you work with Excel. Copilot is an AI-powered tool that enhances your Excel experience by automating complex tasks, providing intelligent suggestions, and improving overall efficiency. Whether you’re dealing with large datasets, creating intricate formulas, or simply trying to streamline your daily workflow, Copilot is here to help. This training will not o..
Mike Thomas
November 03 2025
01 : 00 PM EST
60 Minutes
Power BI - Data Cleaning and Transformation - From Raw and Poor to Report-Ready Overview
It's a known fact that raw data loaded into Power BI is hardly ever "report-ready" and requires "cleaning" to make it useable.Unnecessary rows and columns need to be removed, data that isn't required needs to be filtered out, dates are never in the right format and often aren't even dates, columns require splitting or merging, and "weird" characters must be removed. These are just a few examples of what is ..
Mike Thomas
Recorded Webinar
60 Minutes
Excel Pivot Tables
In today’s world, there are tons of data to manage. Data is coming from many different sources. It is very important to be able to process that data quickly and then summarize it into meaningful information. Many companies have reduced their IT staff, so more and more, it is up to each person to deal with all of this data. This webinar will show you how to take large amounts of data from many sources and pr..
BEST SELLER - Excel - Demystifying Pivot Tables
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 reports, dashboards and charts that help you to summarise, analyse, interpret and understand your data which in turn helps you to spot trends and get answers to the important questions on..
BEST SELLER - KPI Dashboards: How To Go From Pivot Tables to Excel Interactive, BI Dashboards
In this training session, you'll learn how to create a stunning, interactive professional-looking dashboard using Excel. This training will provide you with a solid foundation that you can use to build your own dashboards and reports.No matter what business you are in, a dashboard is a critical tool in your communication armoury and as with any communication tool, a presentation is everything. Although ther..
Excel - Automate Repetitive Tasks with Macros
Imagine the thrill of automating those repetitive Excel tasks that have been draining your productivity. Picture the convenience of effortlessly streamlining complex processes, leaving you with more time to focus on what truly matters. Now, consider the positive impact you can have on your team and clients by offering streamlined, error-free solutions.Excel macros are powerful tools that can transform your ..
Excel - Automation Beyond the Macro Recorder - VBA 101
VBA is Microsoft’s programming and automation language that is built into all the MS Office applications. Although Excel’s Macro Recorder allows you to automate a task by recording a series of keystrokes and mouse clicks, that’s where its functionality and power ends. To be able to do anything more, you need to harness the power of VBA.VBA is a fully-featured programming language that includes functionality..