Utilizing Microsoft Excel Dashboards For Reporting

Target Audience: Anyone who has a good knowledge of the workings within Excel and need to make formal presentations of their raw data by using interactive charts to highlight their company’s KPIs.

About the Course:
An Excel dashboard is a very powerful tool that can be designed fairly easily to create an impact on the visualization of data presented. Dashboards enable a reader to quickly make sense of the raw number by presenting them in visually colorful charts and tables. It also gives valuable insights into the key performance indicators (KPIs) of the business. The most important aspect of dashboards is it is highly interactive where the user can filter and change its views.

You will learn the following:
Learn how to bring data into your spreadsheet.
Where will the data come from?
Manage the data and link it to the dashboard objects, like charts and tables.
How often will data be updated?
Design the dashboard report.
Learn to apply Excel functions like:
SUMPRODUCT; SUMIF; SUMIFS; AVERAGEIF; AVERAGEIFS; COUNTIF; COUNTIFS; COUNT; COUNTA; COUNTBLANK; RANK; SMALL; LARGE; DSUM; DCOUNT; DAVERAGE; DMAX; DMIN; VLOOKUP; HLOOKUP; INDEX; MATCH; IFERROR; OFFSET; INDIRECT; CHOOSE

In summary, an Excel Dashboard is simply a summary as follows:
Usually fits on one page
Displays key trends, comparisons and data graphically or in small tables
Provides the reader with conclusions to their objective
Is often interactive allowing the user to filter data and switch views themselves
Employs best practices that enable the report to be updated quickly and easily (often at the click of just one button)


Click Here Utilizing Microsoft Excel Dashboards For Reporting