## EXCEL DASHBOARD COURSE

Create attractive Advanced Excel Dashboard for Data Analytics and Visuals using Excel Tools, Functions and Excel Macros.

This Course includes:

“I am very impressed with Yoda Learning courses – I particularly like the short videos that allow me to get to a topic quickly and the other gem is the shortcuts.”

## Course Curriculum

0101 – MRTS Sales Dashboard Question
0102 – MRTS Sales Dashboard Solution 01
0103 – MRTS Sales Dashboard Solution 02
0104 – MRTS Sales Dashboard Solution 03
0105 – MRTS Sales Dashboard Solution 04
0106 – MRTS Sales Dashboard Solution 05
0107 – MRTS Sales Dashboard Solution 06
0108 – Power Generation Tracker Question
0109 – Power Generation Tracker Solution

0201 – Introduction to Dashboard -Why, When, and How
0202 – Design Tips and Ideal Data Formats
0203 – Drawing Excel Charts
0204 – Building Up and Down Indicators on Charts
0205 – Trend Sparkline with Variations
0206 – Bar Sparkline an Win and Loss Sparkline
0207 – Pie Chart and Formatting Tips
0208 – Two-axis Charts
0209 – Thermometer Charts
0210 – Stacked Charts
0211 – Spider Charts
0212 – Bubble Charts
0213 – Bullet Charts
0214 – Showing Forecasting with Line Charts
0215 – Waterfall – New Charts in 2016
0216 – Format Specific Period, Data Points, Maker, XY, Positive and Negative
0217 – Conditional Formatting in Charts
0218 – Histogram Chart
0219 – VLOOKUP and HLOOKUP
0220 – MATCH and CHOOSE
0221 – INDEX Function
0222 – Indirect Function
0223 – Pivot Tables Basics
0224 – Pivot Charts Basics
0225 – Form Control with Example
0226 – Check Box Controlled  Graph
0227 – List Controlled Graph
0228 – Chart with Interactive Legend
0229 – Graph using Macro
0230 – Overview of Dashboard
0231 – Identifying of unique items for a dashboard
0232 – How to make lists in a dashboard
0233 – Building dashboard  basic layout and formatting tips
0234 – Linking values in dashboard
0235 – Using Dynamic functions
0236 – Calculating values based on criteria
0237 – Putting all the charts together – Dashboard Conclusion – Quick Recap
0238 – Dashboard Tour
0239 – Graphs Tour

0301 – Introduction to Dashboard Course
0302 – Introduction to 1st Dashboard
0303 – Understanding the data
0304 – Text Function
0305 – Dynamic data Create Table
0306 – Naming the dynamic data and the using it in function
0307 – Preparing 1st Pivot and updating data
0308 – Classic view and Filling Blank with zero in Pivot
0309 – Create Chart for comparison from the Pivot
0310 – Create Trend line from the Pivot
0311 – Creating Pie chart from slab Report from Pivot
0312 – Preparing Framework for Dashboard
0313 – Inserting Slicer using Chart
0314 – Customize Slicer Setting

0401 – Brief on 2nd Dashboards
0402 – Importing Dats From the Internet
0403 – Converting Line Item into a Currency Table
0404 – Calculation of Currency Using INDEX and MATCH
0405 – Creating slabs Using Vlookup True Parameter
0406 – Creating Qtrs based on Financial or Calendar Selection
0407 – Preparing the base by removing duplicate for Dashboard
0408 – AverageIF for Calculating Country Wise Salary
0409 – Sustituting ERROR with zero using IFERROR
0410 – Introduction to Function INDIRECT Part 1 and 2
0411 – Using Function INDIRECT to Retrieve AVERAGEIF From Relevant Sheet
0412 – Using Function Countif with INDIRECT to calculate NO OF Emp
0413 – Calculating Contribution Country wise NO OF Emp
0414 – Using NameRange to simplify calculation
0415 – Using NameRange with formula in 2nd Dashboard
0416 – Introduction to Offset Function
0417 – Offset Function in Excel
0418 – Using Offset Function in Dashboard
0419 – Use of MINIF in Dashboard
0420 – Use of MAXIF in Dashboard
0421 – Using Average to get Designation wise Experience Result
0422 – Using MAXIF with multiple conditions
0423 – Using MINIF with multiple conditions
0424 – Dynamic Dropdown list
0425 – Longitude and Latitude with plotting data on dashboard
0426 – Using REPT function based on the percentage calculation
0427 – Activation of Developer Tab and screaming scroll Bar
0428 – Inserting Trend Chart based on Dats
0429 – Advance INDEX and MATCH
0430 – Inserting Sparkline
0431 – Insert World Map into the Chart
0432 – Plotting Data on Map Chart
0433 – Controlling Map Preview  form Dropdown
0434 – Summarizing 2nd Dashboard

0501 – Brief on 3rd Dashboards
0502 – Implementation of OFFSET for dynamic data
0503 – Creating Trend Chart from 2 Pivot Table
0504 – Modifying the Chart Settings for better view
0505 – Using Macro recording for Trend Chart 00
0506 – Using macro to update pivot based on the Job Type
0507 – Triggering macro with any change in sheets
0508 – Creating Name Range using shortcut
0509 – Use of MAXIF and MINIF with single and multiple parameters
0510 – Create chart to represent multiple parameters effectively 00
0511 – Create chart to represent multiple parameters effectively 01
0512 – Preparing data for Spiderweb chart and change the graph setting
0513 – Using macro to Hide and Unhide working sheets
0514 – Inserting Trendline and formatting for better view
0515 – Conclusion of all 3 dashboard

## COURSE INSTRUCTOR

### Rishabh Pugalia

Course Narrator

Worked with KPMG, and became a Chartered Accountant
Traded Interest Rate Futures, and then worked with J.P. Morgan (Fixed Income)

## We’ve helped over 7,800 learners overcome their learning “plateau”...

Don’t take my word for it – check out this feedback from some of the professionals representing virtually every business domain, background and experience level…
“I am very impressed with Yoda Learning courses – I particularly like the short videos that allow me to get to a topic quickly and the other gem is the shortcuts.”
Peter Klugsberger
Mckinsey & Company
“The courses are not only technically very knowledgeable, but also genuinely helpful for professionals who want to work smarter, not harder.”
Karnika Bhalla
Delloite
“The training curriculum and course was extremely well designed, thorough and catered to use cases relevant to our domain of work.”
Yoshika Chhabra
E & Y

Excel Dashboard Course
\$ 29
• 72 HD Videos
• 4.3 Hours of Video

14 days Money-back Guarantee

### DO YOU PROVIDE SUPPORT DURING THE COURSE?

We have a chat panel in every lecture window. You can take screenshots, upload file, and send queries to our support desk. QnA should be related to the case study files ONLY.

### WHAT VERSION OF EXCEL DO YOU TEACH?

We use Excel 2013 and we have added all new features up to Office 365.

### DO I GET A CERTIFICATE AT EACH LEVEL?

No, you do not get a Certificate at each level. We only provide the course completion certificate.

No. But, you can watch the videos unlimited number of times.

### CAN I ACCESS THE COURSE FROM MORE THAN ONE COMPUTER?

Yes, you can access the course from only 2-3 devices (computer or mobiles) with your login credentials.

### EXPLAIN THE REFUND POLICY.

You can ask for refund within 14-days of enrollment. No questions asked.