Excel - KPI Dashboard Spreadsheet

The KPI Dashboard.xlsx spreadsheet is a dashboard of key performance indicators (KPIs) for the Productivity Apps division. It provides an overview of the division's performance in terms of revenue, profit, and cash, based on data from 2017.

**Purpose of the Spreadsheet:**

* **Monitor Divisional Performance:** The spreadsheet allows you to track the performance of the Productivity Apps division over time, comparing actual results to budget and the previous year.

* **Analyze Trends:** The spreadsheet allows you to analyze revenue, profit, and cash trends for both the division and individual applications.

* **Identify Focus Areas:** The spreadsheet helps you identify focus areas for the division, highlighting the applications that are performing the most or least compared to budget and the previous year.

**How ​​to Use the Spreadsheet:**

1. **Select a Viewpoint:** Use the drop-down menu on the dashboard page to select the desired viewpoint. 2. **Refresh data:** Click the "Refresh Data" button to retrieve the latest data from the database.

3. **Navigate the table:** Use the scroll bars to navigate the table and view detailed data for each application.

4. **Analyze the charts:** Use the charts to view the performance of the division and individual applications over time.

5. **Filter the data:** Use the filters to select the data you want to view.

**Tips:**

* **Use the filters to analyze specific data:** For example, you can filter the data by month, application, or KPI.

* **Use the charts to visualize trends:** For example, you can use the line chart to visualize the profit trend over time.

* **Use the table to visualize detailed data:** For example, you can use the table to visualize the revenue, profit, and cash data for each application.