Excel: Creating a Basic Dashboard [Repost]

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.

Learning 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