Mr.Mike Thomas

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

Although it is perfectly possible to use Excel without ever creating a formula or using a function if you don’t, you’re missing out on a huge part of the application’s power. Without formulas and functions, Excel would not be able to perform its calculations ...

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

No matter what business you are in, a dashboard is a critical tool in your communication armory 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 ...

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

  In this session you will learn how to create and edit macros using Excel’s Macro Recorder and Macro Editing Tool Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? Do you have a time-consuming Excel-based process tha ...

Do you spend time each month importing data into Excel from other sources such as CSV files, text files, web pages, databases and SharePoint? Do you spend more time than is necessary getting your data into the right format for your reports, performing repetit ...

Power BI is not Excel. It’s an application from Microsoft that turns your raw data into stunning interactive visual reports, providing you with real-time insights into your data and enabling you to make better business decisions. This training will walk you th ...

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

Power Pivot puts the "power" into Pivot Tables (hence the name!). Power Pivot removes many of the limitations and frustrations that advanced users find with Pivot Tables. For example, using Power Pivot you can. Create Pivot Tables from multiple Excel-based ...