Interactive Excel Dashboards

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 80 lectures (9h 43m) | Size: 4 GB

Create impressive, interactive Dashboards in Excel, from scratch!
What you'll learn:
About Dashboard architecture and inspiration
How to prepare data for analysis (cleaning data)
Useful formulas for creating dashboards in Excel
How to create and edit Pivot Tables in Excel
How to create Pivot Charts from Pivot Tables
Advanced chart techniques in Excel
How to add interactive elements (form controls) into your dashboards
How to create a Sales Dashboard from scratch
How to create an HR Dashboard from scratch

Requirements
Microsoft Excel for Windows. The course was created using Excel 2019/365 for Windows. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.
Intermediate knowledge of Microsoft Excel.

Description
**Includes exercises and two, follow-along Dashboard Projects**

Have you ever looked at an interactive dashboard in Excel and thought "I wish I could create something like that!". Well, now you can. We've drawn on our years of expertise as a Microsoft Excel training provider and have put together the ultimate Excel dashboards course.

We'll teach you how to create dashboards that look amazing, that are fully interactive so you (or anyone else!) can change the data they are seeing, and that can be updated with new data in a couple of clicks.

If you need to analyze and present data in Excel, then this course will show you step-by-step how to create jaw-dropping Excel dashboards that leave people wondering how you became that good in Excel!

In this advanced Excel course, we look at how to create stunning, interactive dashboards in Excel.

Once we've taught you all the techniques you need to create your dashboards we end the course with two, super projects:

Creating a fully interactive Sales Dashboard from scratch

Creating a fully interactive HR Dashboard from scratch

In this course you will learn:

About Dashboard architecture and inspiration

How to prepare data for analysis (cleaning data)

Useful formulas for creating dashboards in Excel

How to create and edit Pivot Tables in Excel

How to create Pivot Charts from Pivot Tables

Advanced chart techniques in Excel

How to add interactive elements (form controls) into your dashboards

How to create a Sales Dashboard from scratch

How to create an HR Dashboard from scratch

This course includes:

9+ hours of video tutorials

70+ individual video lectures

Exercise files to practice what you learned

Certificate of completion

This course was recorded using Excel 365. It's also relevant to those using other, recent versions of Microsoft Excel including Excel 2019, 2016, and 2013.

Who this course is for
Those wanting to create visually appealing dashboards in Excel
Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions
Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge.