-
This course teaches you to create well-designed dynamic Excel dashboards so you and your colleagues can see trends and make quick decisions informed by data.
By participating in this Microsoft Excel Dashboard course you'll gain the widely sought-after skills necessary to effectively analyze large sets of data.
For Ease of Understanding and Learning the Course comes in 3 Parts – Basic, Intermediate and Expert Level.
In the Basic (Part 1) of the Lecture Series the Focus is on using the Basic Dashboard Features available in Excel in a more Innovative Way. Here You will Learn 12 Basic Level Dashboards which are easy to Implement and can be real handy tools for creating Visually Appealing Dashboards Quickly.
In the Intermediate and Expert Level (Part 2 and 3) we will learn how to use multiple PivotTables, Pivot Charts and PivotTable tools to create a dynamic excel dashboards. Then we'll give users the ability to quickly filter the data the way they want with Slicers and a Timeline, which allow your PivotTables and charts to automatically expand and contract to display only the information that users want to see. In addition, you can quickly refresh your dashboard when you add or update data. This makes it very handy because you only need to create the excel dashboard report once.
So Lets Get Started with the Basic Level Dashboards First.
Overview
Syllabus
-
- Introduction
- Things to know before you start
- Repeat Chart
- Double Doughnut Chart
- Pie In Pie Chart
- Tornado Chart
- Bullet Chart
- WFM Chart
- Within Cell Chart
- Funnel Pyramid Chart
- Sparkline Chart
- Sunburst and Treemap
- Congratulations
