Data Analysis & Dashboard Reporting in Excel

The VisiCalc row-and-column-based layout introduced in 1978 is what we know as spreadsheets today. These have evolved to become powerful business tools that are widely used across business functions. Step into any of the various departments in a business and you will find some business processes that are supported using Excel. ExcelŐs current advanced functionality together with its formatting and visual design capabilities creates a basis for its extensive use as a data analysis and business reporting tool.

Module One Introducing dashboards Defining a dashboard Defining a report User requirements Dashboard dimensions and filters Dashboard design principles Best practice in data modelling Excel functions and dashboards Ranges and tables Module Two Table design principles Custom number formatting Adding and customising sparklines Using conditional formatting Pivot tables Module Three Charting and visualisation techniques Top and bottom displays Variance displays Progress bars Bullet graphs Module Four Leverage macros to automate reporting Utilising form controls in dashboards Check boxes List boxes Option buttons