Dashboards provide at-a-glance views of KPIs (key performance indicators) relevant to a particular objective or business process (e.g. sales, marketing, human resources, or production). Dashboard reports allow managers to get high-level overview of the business and help them make quick decisions. Business Intelligence is a hot commodity in today’s world and dashboards are the most frequently used method of providing that information.
While most business users are familiar with the basic functionality provided by Excel's rich offering, power users often require a greater degree of functionality. Our specialised courses dig deeper into Excel's tool chest, exploring VBA for Excel, Microsoft Excel Dashboards, the power of pivot tables and a range of specialised Excel courses.
Click here to view our beginners, intermediate and advanced Excel training courses.
Pivot Tables are one of the most under-utilised tools in Excel. They are extremely powerful for reporting on large and complex data. The level 1 course is for people who have not had much experience creating pivot tables and covers the fundamentals of creating and using pivot tables.
This is an advanced course in pivot tables. It shows you how to use the powerful analysis features, how to create calculated fields and items and use conditional formatting within your pivot table reports. It also covers pivot charts and dashboards.
An advanced course beyond advanced! There is never time in an ordinary advanced course to go into many important advanced functions. And not everyone needs them. But, if you really want to take your Excel to super user level, then you need to know how to use these functions and how to combine them together.
This course is intended for a delegate who knows Excel to an advanced level. It is designed for people who work with large quantities of data and who need to be able to automate that process. People will be able to edit macros with confidence.