Applied MathApplied ScienceArchitecture / Masters in ArchitectureBiological EngineeringBiomedical EngineeringBusiness ManagementBusiness Management/AdministrationCivil EngineeringComputer EngineeringComputer Information SystemsComputer NetworkingComputer ScienceComputing & Information TechnologyConstruction ManagementCybersecurityDesign/BuildElectrical EngineeringElectromechanical EngineeringEngineeringEngineering

Excel: Creating a Basic Dashboard

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.

Learn More