English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 0h 46m | 421 MB
Did you know that you can quickly create a dashboard in Excel even if you’re pressed for time? While many people assume that dashboards are complicated and limited to the most advanced Excel power users, it’s simply not true–all you need is a little practice. In this short course, Excel MVP Jordan Goldmeier demystifies dashboards and shows you how to create your first interactive dashboard in minutes.
Explore the basic components of a dashboard in Excel: tables, PivotTables, PivotCharts, slicers, and timelines. Learn how to plan a dashboard, create a summary table, build a time series chart, and then finalize your dashboard so it’s ready to share with stakeholders. Jordan gives you quick, easy-to-use tips and techniques so you can start visualizing your data immediately.
Table of Contents
Introduction
1 Transform the way you present data to leaders
2 What is a dashboard
3 What to know before starting
Excel Dashboard Components
4 Store data in Excel tables
5 Create PivotTables for data summaries
6 Visualize data with PivotCharts
7 Add interactivity with slicers and timelines
Creating Your First Dashboard
8 Get familiar with the data
9 Create a summary table
10 Build impactful charts
11 Add interactivity with slicers and timelines
12 Lay it all out
Conclusion
13 Continue your Excel dashboards journey
Resolve the captcha to access the links!