Excel: Creating a Basic Dashboard

Description

In this course, you will :

• shows you how to effectively summarise spreadsheet data to support decision-making across your organisation
• explains how to create a supporting workbook, including how to manage and filter data, streamline dashboard charts, and create sparklines
• goes over the steps involved in creating a dashboard worksheet
• covers creating and managing cell links, using PivotTable data in a formula, adding hidden rows to your dashboard, and more.

Syllabus :

1. Setting Up the Supporting Workbook

• Manage data using Excel tables
• Manage PivotTables and PivotCharts
• Summarize Excel table and PivotTable data
• Filter Excel table and PivotTable data
• Define conditional formats
• Define an icon set conditional format
• Streamline charts for dashboards
• Create sparklines

 

2. Creating a Dashboard Worksheet

• Create and manage cell links
• Link cell contents to a shape
• Use PivotTable data in a formula
• Extend your dashboard using hidden rows
• Hide gridlines and set zoom levels

Show more