Study Learn Grow
Learn How to Create Amazing Excel Dashboards with Pivot Table and Formulas

Learn How to Create Amazing Excel Dashboards with Pivot Table and Formulas

Excel Dynamic Dashboard is mostly one pager, that helps management tracking important metrics and take a decision based on it. Data can be presented in forms of Charts that are supported by data from same or other file.

Overview

About this Course
Excel Dynamic Dashboard is mostly one pager, that helps management tracking important metrics and take a decision based on it. Data can be presented in forms of Charts that are supported by data from same or other file.

Basic knowledge
Participants should have basic knowledge of Excel

I have divided this course in 4 Parts.

Part 1 Charts

Dynamic Dashboard Course Introduction
Column Chart
Line Chart
Pie Chart
Creating Combination
Creating Secondary Axis Chart
Creating Thermometer Chart
Creating Dynamic Chart
Part 2 Pivot Table

Understanding Pivot & Getting Sum, Count & %
Refreshing Pivot Table
Creating Yearly, Quarterly and Monthly Reports
Using Interactive Slicer and Timeline
Comparing Data of different years with Pivot
Creating Dynamic Dashboard with Pivot Table
Part 3 Formulas

CountIF in Same Sheet
CountIFs in Same Sheet
SUMIF Formula in Same Sheet
SUMIFs Formula in Same Sheet
CountIF and SumIF from other Sheet
IF Condition Formula
Advanced IF Condition
Concatenate Formula
Vlookup
Adding Dollar Sign in Vlookup
Vlookup with IFError
Vlookup with Match
Part 4 Interactive Controls for Dashboard

Using Dropdown to creating simple Interactive Chart
Project 2 Another Example of Dropdown
Creating Radio Button & understanding its concept
Creating Combo box
Creating List box
Scroll Bar Horizontal Example 1
Scroll Bar Horizontal Example 2
Scroll Bar Horizontal Example 3
5 Years Comparison Chart
Creating CheckBox
Happy Learning !

Course Information

Participants should have basic knowledge of Excel

What you will learn
In this course I will teach you from Basic to Advanced Level, till creation of Scroll bar, Radio button & List box to create Interactive Dashboard.

You will also learn Formulas (CountIF, SumIF, CountIFs & SumIFs) which is used to create summary reports and is used to create the dashboard with multiple criteria.

Anyone wanting to learn how to use Pivot Tables to manipulate data
Anyone who wants to make their life easier in Excel
Anyone who uses Excel regularly

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs