Bringing information together
in an Excel dashboard.
For my MSc at the University of Dundee, I created an Excel dashboard to explore sales, customer, order and invoice data.
The work
Organising and checking data, then using Excel tables, pivot tables, slicers and charts to make it easier to explore.
The focus
Summarising total sales, average order value and monthly performance in a single dashboard, with charts to show trends.