Excel: Creating a Basic Dashboard
Offered By: LinkedIn Learning
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
- 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
- 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
- Next steps
Taught by
Curt Frye
Related Courses
Intro to StatisticsStanford 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