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
0110 – Download Practice Files for Single Sheet Tracker

Download Course Curriculum

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 

Download Course Curriculum

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 

Download Course Curriculum

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

Download Course Curriculum

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

Download Course Curriculum