Excel: Creating a Basic Dashboard (LinkedIn Learning)

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.

Topics include:
  • 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

Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande.