Interactive Excel Dashboards

Video Tutorials, Courses

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!


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

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.

**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.

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.




DOWNLOAD
uploadgig


rapidgator


nitro