The Data Analysis and Management Reporting Using MS Excel Workshop will equip participants to utilise advanced excel formulas, to create and manage pivot tables, charts and graphs in Excel, to perform Power Pivot and DAX in Excel, to employ basic concepts of collecting and sorting/validating data in Excel, to use data import functionality and connect to multiple data sources and systems, to use formulae and calculations within and across sheets, to link sheets and multiple files, to employ data visualisation with Excel and to utilise best practices for presenting data.

This programme is ideal for data analysts who are responsible for managing large transaction data sets and the presentation of summarised results, executives that influence decision making, finance and accounting personnel, managers and supervisors with internal and external reporting responsibilities and regulatory staff.