Excel: Dashboards for Beginners

Focused View

45:55

156 View

1. Introduction

001. Transform the way you present data to leaders.mp4

01:25

002. What is a dashboard.mp4

06:34

003. What to know before starting.mp4

00:56

2. Excel Dashboard Components

004. Store data in Excel tables.mp4

05:00

005. Create PivotTables for data summaries.mp4

04:26

006. Visualize data with PivotCharts.mp4

02:18

007. Add interactivity with slicers and timelines.mp4

04:06

3. Creating Your First Dashboard

008. Get familiar with the data.mp4

02:06

009. Create a summary table.mp4

00:51

010. Build impactful charts.mp4

04:14

011. Add interactivity with slicers and timelines.mp4

02:22

012. Lay it all out.mp4

07:22

4. Conclusion

013. Continue your Excel dashboards journey.mp4

04:15

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Dashboard

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.