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
September 16 2024
01 : 00 PM EST
60 Minutes
Excel – Build Even More Powerful Pivot Tables: DAX Essentials
In today's data-driven world, having a strong command of Excel is essential, and understanding the Data Analysis Expressions (DAX) formula language is the key to unlocking the true potential of Excel's Power Pivot and Data Model features. This session is for intermediate Excel users who are already familiar with Pivot Tables, Power Pivot, and the Data Model but are hungry for more. We will delve deep into D..
Mike Thomas
October 16 2024
01 : 00 PM EST
60 Minutes
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 ..
Mike Thomas
November 06 2024
01 : 00 PM EST
90 Minutes
Power BI Demystified: Transforming Data into Stunning Visuals
Are you ready to embark on a journey that will revolutionize the way you work with data? Welcome to "Power BI Demystified: Transforming Data into Stunning Visuals.”Discover the power of Microsoft's revolutionary application, Power BI. Designed for beginners, this comprehensive training session will introduce you to the world of data visualization and insights like never before.Say goodbye to the days of rel..
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 - 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 ..
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..
Excel - Creating an Interactive Dashboard
No matter what business you are in, a dashboard is a critical tool in your communication armoury and as with any communication tool, presentation is everything. Although there are many tools that can be used to create a dashboard, Excel is commonly used due to its power, it’s flexibility and the fact that most people have it installed on their computer. This training focuses on what you need to know to crea..
Excel - Effective Data Visualization Without Charts
Data visualization is the representation of numerical data in a visual format so that your audience can quickly and easily understand it and gain insight from it. Until a few years ago it was enough to take a set of numbers and create a bar chart or pie chart. Although in the right situation these traditional charts are still appropriate, things have moved on and we're constantly hearing words like data vis..
Excel - Mastering Lookup Functions
"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 match?""I've heard of VLOOKUP but what's HLOOKUP and what’s XLOOKUP?"These are just a few of the questions I get asked on a regular basis. You can get the answers to these questions (and more) by attending this training session dedicated to mastering..
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’s data analysis and Business Intelligence (BI) toolkit.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 summarize..
Excel - Power Pivot - Take Your Pivot Tables to the Next Level
Power Pivot removes many of the limitations and frustrations that users find with creating Pivot Tables in Excel. For example, using Power Pivot you can.Create Pivot Tables from multiple lists/tables without the need to combine them into a single list first (goodbye LOOKUP and all the issues that it brings)Create Pivot Tables from large datasets without worrying about file size, performance, or needing more..
Excel - Power Pivot – Pivot Tables For 21st Century Data Analysis
Power Pivot removes many of the limitations and frustrations that users find with creating Pivot Tables in Excel. For example, using Power Pivot you can.Create Pivot Tables from multiple lists/tables without the need to combine them into a single list first (goodbye LOOKUP and all the issues that it brings)Create Pivot Tables from large datasets without worrying about file size, performance, or needing more..
Excel – Mastering Logic Functions
Have you ever needed to Automate entering different values into a cell depending on a certain criterion?Count the number of times a word, number or date appears in a range (and keep it current)?Add up a set of numbers that match a criterionReplace the ugly #NA or #DIV/0 with something more aesthetically pleasing?These are just some of the things that you can do using Excel's built-in Logic functions.Areas C..