This lesson of the Mastering Excel series teaches you how to build a complete dashboard in Excel. You will learn how to structure your Excel model correctly with the three layers: Data, Business Logic & Presentation. You will build several dynamic, interactive charts that will respond to a user's selection.
All this is done with no macro programming. This lesson teaches you how to use standard Excel features and link them together in creative ways to make very impressive dashboards.
IMPORTANT NOTE: This course has per-requisites, you must know the following topics to successfully complete the exercises:
- Pivot Tables
- Dynamic Charts
- SUM, SUMIF
- VLOOKUP
- OFFSET
- User Forms
You will be using all of these to build interactive dashboards.
All this is done with no macro programming. This lesson teaches you how to use standard Excel features and link them together in creative ways to make very impressive dashboards.
IMPORTANT NOTE: This course has per-requisites, you must know the following topics to successfully complete the exercises:
- Pivot Tables
- Dynamic Charts
- SUM, SUMIF
- VLOOKUP
- OFFSET
- User Forms
You will be using all of these to build interactive dashboards.
