YoVDO

Excel: Creating a Basic Dashboard

Offered By: LinkedIn Learning

Tags

Microsoft Excel Courses Data Visualization Courses Data Summarization Courses Data Management Courses PivotTables Courses Sparklines Courses Excel Dashboards Courses

Course Description

Overview

Learn how to surface and summarize your data effectively in an Excel dashboard.

Syllabus

Introduction
  • Improve decision-making by creating dashboards
  • What you should know
1. Setting Up the Supporting Workbook
  • Manage data using Excel tables
  • Manage PivotTables and PivotCharts
  • Summarize Excel table and PivotTable data
  • Filter Excel table and PivotTable data
  • Define conditional formats
  • Define an icon set conditional format
  • Streamline charts for dashboards
  • Create sparklines
2. Creating a Dashboard Worksheet
  • Create and manage cell links
  • Link cell contents to a shape
  • Use PivotTable data in a formula
  • Extend your dashboard using hidden rows
  • Hide gridlines and set zoom levels
Conclusion
  • Next steps

Taught by

Curt Frye

Related Courses

Intro to Statistics
Stanford University via Udacity
Introduction to Data Science
University of Washington via Coursera
Passion Driven Statistics
Wesleyan University via Coursera
Information Visualization
Indiana University via Independent
DCO042 - Python For Informatics
University of Michigan via Independent