Mr.Mike Thomas

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

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

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

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

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

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

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 percentage (n ...

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