Mr.Mike Thomas

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

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

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

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

Power Pivot, a free addin for Excel, written by Microsoft, puts the "power" into Pivot Tables (hence the name!). Power Pivot removes many of limitations and frustrations that many users find with Pivot Tables. For example, using Power Pivot you can… Create ...

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