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

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

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Apply for this course