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
Social Network AnalysisUniversity of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX