Microsoft Excel is the main tool for many people working with financial information and this course introduces the financial tools and formulas available in Excel.
- Understand KPI data
- Advanced functions
- Advanced protection
- Advanced charts
- PivotTables and PivotCharts
- Conditional formatting
Participants should be able to:
- Have the understanding of what type of data is required to be collected and how best to format in order to create useful KPI Dashboards
- Know how to access, construct and order nested and concatenated formulas in order to turn simple collated data into suitable KPI Dashboard data
- Know how to convert KPI Dashboard data into effective reporting graphs and PivotTables which can be used in forecasting and performance review meetings.