Here Are the Files You Need…

This module contains the dashboard and the Access database:

This module contains the resulting dashboard, the Access database and the first version of the tutorial, created using Excel 2003.

This is the Excel dashboard: Download the Excel Dashboard

This is the Access Database: Download the Access Database

This is the Access Database for Access 2002-2003: Download the Access 2003 Database

If you don’t have Access, instead of a blank sheet start with this one:  Data for Lookup Tutorial. This is just the data. Please watch the videos about connecting to Access, because you still need to add named ranges and formulas.

… and some bonus

These are files I have to tutorials for, but you may like to explore them.

1. Demographic Dashboard VBA-Free Edition: Download the VBA-Free dashboard

2. Growth of Walmart: Download the Walmart Dashboard for Excel 2010. Contains the Excel dashboard, the Access file and odc files.

 

walmartdashboard