Using Excel to Create Dashboard

Description

Dashboard reports allow managers to step back from the details and see the key trends and relationships that drive their companies. Excel is an excellent tool for creating these reports.

Dashboard reports use the same features you see in magazine articles and allow you to summarize key data in an interactive, visual way. 

Find out how this tool can help you.  

Outline/Table of Contents

v      The Advantages of Dashboard Reporting With Excel

v      How to Create Mini-Charts for Dashboard Reporting

v      Charting Techniques for Dashboard Reporting

v      Using Charts with Worksheets

v      How to Use Excel’s Camera Tool

v      How to Funnel Data into Dashboard Reports

v      How to Use Spreadsheet Databases for Dashboard Reporting

v      How to Build Dashboard Reports in Excel

v      Magazine-Quality Dashboard Designs