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.

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 - Power Pivot – Taking Your Pivot Tables to The Next Level
In this training, you will learn, using practical examples, how Power Pivot provides Business Intelligence functionality & reporting within the familiar environment of Excel.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 exam..

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 applications in the MS Office Suite). VBA is used to automate tasks that would otherwise have to be performed manually by pressing keys and selecting items with the mouse - an..

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

BEST SELLER - 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..

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

Excel - Advanced Reporting - Best Practices, Tools and Techniques
No matter what business you are in, a report is a critical tool in your communication armory. As with any communication tool, presentation is everything. Get it right and it offers the reader (typically a CEO, shareholder or Project Manager) a valuable insight into the Key Performance Indicators (KPI’s) upon which a business or project is measured. Get it wrong and you'll end up with something that nobody u..

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

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

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 Charting Techniques for Infographics and Dashboards I - Unique, Fun and Dynamic Visualizations
"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 understand and engaging.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..

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 duplicate rows, removing blank rows, removing unnecessary columns, converting case, changing date formats and more).Do you spend more time than necessary performing data cleaning..

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 case, changing date formats and more).Do you spend more time than necessary performing data cleanin..