Enrolment options

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

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

Guests cannot access this course. Please log in.