Excel: Creating a Basic Dashboard

 Description

In this course, instructor Curt Frye shows you how to summarize spreadsheet data effectively to support decision-making throughout your organization. Curt explains how to set up a supporting workbook, including how to manage and filter data, streamline charts for dashboards, and create sparklines. He also goes over the process of creating a dashboard worksheet. Curt covers creating and managing cell links, using PivotTable data in a formula, extending your dashboard with hidden rows, and more.

 Course Objectives

• Managing data using Excel tables
• Managing PivotTables and PivotCharts
• Summarizing table and PivotTable data
• Defining conditional formats
• Creating sparklines
• Sketching your dashboard layout
• Creating and managing cell links
• Linking cell contents to a shape
• Linking to a PivotTable cell
• Extending your dashboard using hidden rows

 Level

This is a Intermediate level learning activity.

   Length

The total duration of assets in this course is 1 hour and 6 minutes.

 Author & Release date

This course was produced by Curt Frye on 2 August 2022.

 Contact details