Mr. Mike Thomas

Area Of Expertise : MS-Excel
20 Years Of Experience

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.

26 results Found
Live Webinar

MS Excel: Building a Reporting Tool with Pivot Tables

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 and ...

  • Basic & Intermediate & Advanced
  • 90 Mins
  • Jun 11, 2019
Live Webinar

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'll already be familiar with the limitations of Excel. Power Query, (known as Get and Transform in Excel 2016) is designed to get you past these lim ...

  • Basic & Intermediate & Advanced
  • 90 Mins
  • Jul 10, 2019
On-Demand Webinar

Excel: Power Pivot - Taking Pivot Tables to the Next Level

Power Pivot, a free add-in for Excel, written by Microsoft, puts the "power" into Pivot Tables (hence the name!). Power Pivot removes many of the limitations and frustrations that many advanced users find with Pivot Tables. For example, usi ...

  • Basic & Intermediate & Advanced
  • 90 Mins
Recorded Webinar

MS Excel: Charts and Graphs for HR Professionals

"Every Picture Tells a Story" is a popular saying which is true not only in everyday life but in Excel too. Behind your set of numerical data is a story waiting to be told. The telling of this story needs to be to-the-point, easy to underst ...

  • Basic & Intermediate
  • 60 Mins
Recorded Webinar

Excel: 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 duplica ...

  • Intermediate
  • 90 Mins
Recorded Webinar

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 into Excel (and the other application ...

  • Intermediate
  • 90 Mins
On-Demand Webinar

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 lookup formula displaying an ugly error when it can't find a mat ...

  • Intermediate
  • 60 Mins
Recorded Webinar

Access: Queries - The Key to Powerful Data Analysis

In this training, you will learn how to build Queries in Microsoft Access. Queries let you ask questions about your data. Queries allow you to select specific data from your database. Queries are the key to generating effective and powerful report ...

  • Intermediate
  • 60 Mins
Recorded Webinar

Excel - Automating Tasks and Processes with Macros webinar

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 macros, create macros that can b ...

  • Advanced
  • 90 Mins
Recorded Webinar

Excel as a BI Tool: Creating High Impact Business Reports

The training will focus on 3 areas - creating summary reports using Pivot Tables; creating eye-catching charts and presenting geographic-based data. In the pivot tables section, you'll learn how to create a basic pivot table, display numbers as a ...

  • Basic & Intermediate & Advanced
  • 90 Mins