Essentials of Building Excel Dashboards

Focused View

Donald F.

1:02:53

196 View

1. Introduction

1. Welcome.mp4

01:02

2. Introduction.mp4

01:46

2. Setup

1. Managing Data with Excel Tables.mp4

05:31

2. PivotTables and PivotCharts.mp4

05:52

3. Filter Excel table and PivotTable data.mp4

07:00

4. Conditional formats.mp4

09:19

5. Streamline charts for dashboards.mp4

04:31

6. Create sparklines.mp4

04:17

3. Dashboard Worksheet

1. Create and manage cell links.mp4

06:22

2. Link cell contents to a shape.mp4

06:13

3. Use PivotTable data in formula.mp4

05:08

4. Extend dashboard with hidden rows.mp4

02:40

5. Hide gridlines and set zoom level.mp4

01:58

4. Conclusion

1. Conclusion.mp4

01:14

Description

Learn All About Creating Excel Dashboards

What You'll Learn?

Learn the process of creating a dashboard worksheet
How to summarize spreadsheet data
Learn to set up a supporting workbook
How to manage and filter data
Learn to streamline charts for dashboards and create sparklines
How to create and manage cell links using PivotTable data in a formula
Learn about extending your dashboard with hidden rows

Who is this for?

Business Professionals who use Excel

Data analysts

Anyone wanting to learn to create Excel dashboards and reports

What You Need to Know?

Microsoft Excel to follow along

More details

Description
In this course you will learn the basics of creating Excel dashboards. This course takes you through all you need to know to make beautiful Excel dashboards from start to finish.Â You will learn how to create dashboards in Excel.
Dashboards in Microsoft Excel provides a powerful tool for summarizing and evaluating the performance of your business or organization.Â Mastering those skills you need to create effective dashboards will let you work quickly and make great decisions.Â
An Excel Dashboard provides insight, analysis and alerts.Â They're fully interactive and dynamic and can help with project management, customer service, retail management, financial forecasting and much more.
This comprehensive Excel Dashboard Course will teach you the simple techniques you can apply in Excel to make amazing dashboards that will set your skill level apart from the crowd.
Learn how to build Excel Dashboard reports from the ground up. By applying the simple techniques, you will have the skills to be able to create reports that save loads of time.
A dashboard is a visual representation of key metrics that allow you to quickly view and analyze your data in one place. Dashboards not only provide consolidated data views, but a self-service business intelligence opportunity, where users are able to filter the data to display just whatâ€™s important to them. In the past, Excel reporting often required you to generate multiple reports for different people or departments depending on their needs.
Who this course is for:
Business Professionals who use Excel
Data analysts
Anyone wanting to learn to create Excel dashboards and reports

User Reviews

Rating

average 0

Total votes0

Focused display

Excel Dashboard

Donald F.

Instructor's Courses

With over 30 years in the Business management field, I have worked with a variety of Fortune 500 companies. Through my consultant company, we are focused on what truly matters – doing the right thing to advance and deepen relationships. We relentlessly seek the success of our clients through the expertise of our consultants. Our work together is deeply human and is changing the face of IT and management consulting.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.