Mr.Mike Thomas

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

This training is aimed at users who have very limited knowledge of Excel. If you know what a spreadsheet is, and can navigate around and enter and edit data but want to learn more, this training is for you! It will give you a solid foundation and will equip y ...

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

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

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

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

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

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

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