Level - Advanced
If you need to quickly and accurately make sense of your company's raw data, this Excel - KPI Dashboards course is for you. It introduces you to KPIs and dashboard design processes and will help you build an interactive KPI Dashboard.
2 days
This course introduces the financial tools and formulas available in Excel. You will learn how to handle raw data, use functions to create performance metrics, and build mini charts, pivot tables and pivot charts typically used in dashboards.
Participants should be able to:
Level - Fundamental
In this course you will learn how to add data, edit and move data and how to format and print spreadsheets. You will create charts and use formulas and functions for simple calculations.
Level - Advanced
This course concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.
Level - Advanced
This course concentrates on creating PivotTables and PivotCharts to present business data for analysis. It also focuses on how best to manage the underpinning business data using List Management techniques.
Level - Advanced
This course outlines analytic tools of Microsoft Excel which can be very useful for business planning and modelling.