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.

23 results Found
Live 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
  • May 08, 2019
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
On-Demand Webinar

Excel - Pivot Tables 101

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

  • Intermediate
  • 60 Mins
Recorded Webinar

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

  • Basic & Intermediate
  • 60 Mins
Recorded Webinar

Excel - Building Data Input Forms

Booking forms, sales order forms, invoices, loan agreement forms and surveys. These are just a few examples of forms that can be created using Excel (although the list of examples is endless). By adding a splash of co ...

  • Basic & Intermediate
  • 60 Mins