Description
Condition - Very Good
The item shows wear from consistent use, but it remains in good condition and functions properly. Item may arrive with damaged packaging or be repackaged. It may be marked, have identifying markings on it, or have minor cosmetic damage. It may also be missing some parts/accessories or bundled items.
Mastering Excel: Building Dashboards
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.