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

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera
Excel 2010
Miríadax
The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd
Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity
Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard