Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Excel: Creating a Basic Dashboard

via LinkedIn Learning

Write review

Details

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Effort

1 hour 7 minutes
Sessions

Self-Paced
Level

Beginner

Found in

Part of

Prepare for the Excel Expert - Microsoft Office Specialist Exam for M365 Apps (MO-211)

Boot.dev

Learn Backend Development Part-Time, Online

Coursera

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Overview

Google, IBM & Meta Certificates – 40% Off

One Coursera Plus subscription covers most Professional Certificates on Coursera.

Unlock All Certificates

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

Reviews

4.7 rating at LinkedIn Learning based on 7245 ratings

Start your review of Excel: Creating a Basic Dashboard