Mastering Excel: Building Dashboards

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