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
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
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 to be organized. Or so the theory goes. With the average office worker receiving over 100 emails per day, the reality for most people is email overload, m..
Mike Thomas
Recorded Webinar
90 Minutes
Power BI - Create Compelling Interactive Reports
Power BI is an application from Microsoft that turns your raw data(loaded in from a variety of sources) into stunning interactive visual reports, providing you with real-time insights into your data and enabling you to make better business decisions.Gone are the days of submitting a request to the IT Department and waiting for them to produce a less than perfect report. With Power BI you can create those re..
Mike Thomas
Recorded Webinar
60 Minutes
Word Tips and Tricks
In today's world, it is very important to communicate using documents like letters, emails, books, etc. Microsoft Word is the standard word processor.This course will show you how to be more efficient in Microsoft Word.Areas Covered Topic Include:Selecting textNumber lists Bullet listsSectionsHeader and FooterPage number Table of Contents Index TablesScreenshotHyperlinkCourse Level - Begin..
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 armory and as with any communication tool, a presentation is everything. Although there..
Power Query - How to Import and Clean Data Quickly
Do you import data into Excel from other sources (such as CSV files, text files, web pages, databases, or SharePoint)? Does the data that you import need to be "cleaned" before it can be used? (cleaning refers to things like removing duplicate rows, removing blank rows, removing unnecessary columns, converting cases, changing date formats, and more).Do you spend more time than necessary performing data clea..