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 pre-requisites, you must know the following topics to successfully complete the exercises:
- Pivot Tables
- Dynamic Charts
- SUM, SUMIF
- VLOOKUP
- OFFSET
- User Forms
Follow Along Workbooks
If you already have the book and you are looking for the follow along workbooks. Input your information below and I will send it to you in a few minutes. I won’t spam you. I send email tips and tricks every few weeks and I let you know when a new lesson is published. That’s all.
If you don’t see the sign up form below, try disabling any ad blockers. I promise you the form is there.
Enter your name and email below to get your follow along workbook