Mastering Excel: Building Dashboards

by Mark Moore

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 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 This course has pre-requisites, you must know the following topics to successfully complete the - Pivot Tables - Dynamic Charts - SUM, SUMIF - VLOOKUP - OFFSET - User Forms You will be using all of these to build interactive dashboards.

67 pages, Kindle Edition

First published May 12, 2015

About the author

Librarian note:
There is more than one author in the GoodReads database with this name
This profile may contain books from multiple authors of this name.

Reviews

[vimal]

Nice course content

Helpful tips for creating dashboard!!!
Could have covered few more techniques for creating dashboard.
Overall good content and gives a start to your excel dashboard journey