fbpx

Learn Excel Dashboard Course

Learn to create 4 types of dashboards from scratch with 100+ techniques.  Dashboard fundamentals, Design tips, Data formats, Formatting, Data cleaning, Sparklines, Spider, waterfall and bubble charts, List- controlled graphs, pivot tables and dynamic functions.

  • Video Lessons = 111+ (3.5 Hrs)
  • Lifetime Access
  • Lifetime Support
  • 4.8/5 Rating

Here’s the level of the course:

Intermediate Skills

You will be able to implement mini projects
  • Importing Data from the Internet
  • Converting Line Item into a Currency Table
  • Calculation of Currency using INDEX and MATCH
  • AverageIF for calculating Country Wise Salary
  • Dynamic Dropdown
  • List longitude and latitude with plotting data on dashboard
  • Using REPT Function based on the percentage calculation
  • Advanced INDEX and MATCH with multiple references

Advanced Skills

Ninja-Level Skills
  • Preparing the base by removing duplicate for Dashboard
  • Implementation of OFFSET for dynamic data
  • Using macro to update pivot table based on the Job Type
  • Preparing data for Spiderweb chart and change the graph setting
  • Use of Array functions like MAXIF and MINIF with single and multiple parameters
  • Creating Name Range using shortcut and many more
  • Extract data from multiple sheet using OFFSET, INDIRECT and CELL
  • Button-controlled charts and spark lines

Watch Free Lessons on Excel VBA

What do TOP Excel Bloggers think about my course…

Big Peoples Reviews

Learner Testimonials

I would like to tell you that I am very impressed with your courses so far – I particularly like the short videos that allow me to get to a topic quickly and then move on (your competitors mostly offer 20-30 min videos which is a bit much to keep one’s attention span). The other gem in your training are the shortcuts, I found no other course with the same insights.

peter-kuluberg-excel
Peter Klugsberger
ex-McKinsey & Co. served various senior roles (CEO, COO) in various companies

Because I use spreadsheets daily, I’m often using the Shift+down arrow to highlight and then manipulate data. Of course, this takes FOREVER! As I am advancing in my role at work, it is very important for me to learn more advanced Excel skills. I chose this video b/c it was short and condensed. I could literally watch it on my breaks at work and then use it right away. I really like that. Well done!

barbara
Barbara Jones
Finance Professional

I’ve been using Pivot Tables for a couple of years, so was expecting most of this to be familiar. But this course proved me wrong. From simple tips and keyboard shortcuts, to whole features I never knew existed, I constantly found myself muttering things like “oh wow, I had no clue about that”. Things that I can actually put into practice in my job. It’s a great feeling. Kudos to the team on a great course

Placeholder
Peter Thomas
Accounting Professional

I’ve helped these COMPANIES

I-have-helped-this-company

GET ACCESS TO THE EXCEL DASHBOARD COURSE

About the Instructor

Instructor-Rishabh-PugaliaRishabh Pugalia | Linkedin Profile
 4.8 Average Rating | ? 839 Reviews |
? 12,589 Classroom Students |? 40,000 Students Online

ex-KPMG, ex-J.P. Morgan | Chartered Accountant
Taught 12k+ participants across PwC, EY and Deloitte over last 10 years

I am a Chartered Accountant from India. I have worked with KPMG (Audit) and J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time)

After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2020. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Uber, Tata Group, Rio Tinto use these video courses to excel at work.

If I’m going to succeed in my mission of helping 1 million professional in the next five years, I NEED YOU to succeed… I can’t reach my goal without helping you reach yours!

Single sheet tracker - 35 mins

  • MRTS Sales Dashboard Question
  • MRTS Sales Dashboard Solution 01
  • MRTS Sales Dashboard Solution 02
  • MRTS Sales Dashboard Solution 03
  • MRTS Sales Dashboard Solution 04
  • MRTS Sales Dashboard Solution 05
  • MRTS Sales Dashboard Solution 06
  • Power Generation Tracker Question
  • Power Generation Tracker Solution
  • Download Practice Files for SIngle Sheet Tracker

Dashboard fundamentals - 160 mins

  • Introduction to Dashboard – Why, When and How
  • Design Tips and Ideal Data Formats
  • Drawing Excel Charts
  • Building Up and Down Indicators on Charts
  • Formatting cells and tables in Excel
  • Trend Sparkline with variations
  • Bar Sparkline an Win and Loss Sparkline
  • Pie chart and formatting tips
  • Two-axis charts
  • Thermometer chart
  • Stacked Chart
  • Spider chart
  • Bubble chart
  • Bullet chart
  • Showing forecasting with line charts
  • Waterfall – New Charts in 2016
  • Format Specific Period, Data Point, Marker, XY, Positive and Negative
  • Conditional Formatting in Graphs
  • Histogram Chart
  • VLOOKUP and HLOOKUP
  • MATCH and CHOOSE
  • INDEX Function
  • Indirect Function
  • Pivot tables basics
  • Pivot charts basics
  • Form Control with example
  • Check box controlled graph
  • List controlled graph
  • Chart with interactive legend
  • Graph using Macro
  • Overview of Dashboard
  • Identifying of Unique items for a dashboard
  • How to make lists in a dashboard
  • Building dashboard basic layout and formatting tips
  • Linking values in dashboard
  • Using Dynamic functions
  • Calculating values based on criteria
  • Download Practice FIles

Pivot Table Dashboard - 58 mins

  • Introduction to Dashboard Course
  • Introduction to 1st Dashboard
  • Understanding the data
  • Text Function
  • Dynamic data Create Table
  • Naming the dynamic data and the using it in function
  • Preparing 1st Pivot and updating data
  • Classic view and Filling blank with zero in Pivot
  • Create Chart for comparison from the Pivot
  • Create Trend line from the Pivot
  • Creating Pie Chart from Slab Report from Pivot
  • Preparing Framework for DashBoard
  • Inserting Slicer using Chart
  • Customize Slicer Setting

Map chart dashboard using Advanced Excel functions - 117 mins

  • Brief on 2nd Dashboards
  • Importing Data from the Internet
  • Converting Line Item into a Currency Table
  • Calculation of Currency using INDEX and MATCH
  • Creating Slabs using Vlookup True Parameter
  • Creating Qtrs based on Financial or Calendar Selection
  • Preparing the base by removing duplicate for Dashboard
  • AverageIF for calculating Country Wise Salary
  • Substituting ERROR with zero using IFERROR
  • Introduction to Function INDIRECT Part 1 and 2
  • Using Function INDIRECT to Retrieve AverageIF from relevant sheet
  • Using Function CountIf with INDIRECT to calculate No OF Emp
  • Calculating Contribution Country wise No Of Emp
  • Using NameRange to simplify calculation
  • Using NameRange with formula in 2nd Dashboard
  • Introduction to Offset Function
  • Offset Function in Excel
  • Using Offset Function in Dashboard
  • Use of MINIF in Dashboard
  • Use of MAXIF in Dashboard
  • Using Average to get Designation Wise Experience result
  • Using MAXIF with multiple conditions
  • Using MINIF with multiple conditions
  • Dynamic Dropdown List
  • longitude and latitude with plotti a g data on dashboard
  • Using REPT Function based on the percentage calculation
  • Activation of Developer Tab and creating Scroll Bar
  • Inserting Trend chart based on data
  • Advance INDEX and MATCH with multiple references
  • Inserting Spark Line
  • Insert World Map into the chart
  • Plotting Data on Map Chart
  • Controlling Map Preview from dropdown
  • Summarising 2nd Dashboard

Dynamic Dashboards using Excel Macros - 52 mins

  • Brief understanding on Dynamic Dashboards using Excel Macros
  • Implementation of OFFSET for dynamic data
  • Creating Trend Chart from 2 Pivot Table
  • Modifying the Chart Settings for better view
  • Using Macro recording for Trend Chart 01
  • Using macro to update pivot based on the Job Type
  • Triggering macro with any change in sheets
  • Creating Name Range using shortcut
  • Use of MAXIF and MINIF with single and multiple parameters
  • Create chart to represent multiple parameters effectively 01
  • Create chart to represent multiple parameters effectively 02
  • Preparing data for Spiderweb chart and change the graph setting
  • Using macro to Hide and Unhide working sheets
  • Inserting Trendline and formatting for better view
  • Conclusion of all 3 dashboard

Start Learning Today

No Frills

Free Course Lessons

$FREE
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
WATCH NOW
No Frills

Lifetime Access

111+ Course Lessons
$48
  • 111+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now
Office Training Bundle Package

All Courses

Unlimited Learning [All YL Courses]
$297
  • 177+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now

Looking for subscription plan? Get All Courses in $39/mo: Enroll Now

Badges For YodalearningSecurity badges For YodalearningOnline Security Payment SuccesfullAdvanced Excel Payment Succesfull

Course Completion Certificate By Yodalearning

Unlock your completion certificate

  • Complete any premium course at Yoda Learning Solutions
  • You are awarded a completion diploma
  • The diploma can be verified via URL and exported to LinkedIn to boost your career and impress potential employers.

Personal Guaranteed

How does it work?

The process is really smooth. After enrolling for the Course, you’ll get a link. With the given link you can register for the course. Enjoy lifetime access and support with the course. Watch the video courses 24×7 as per your interest.

how-it-works

Frequently Ask Questions

What do you get in the Excel Dashboard?

An accelerated, Practical approached Advanced Excel Dashboard Tutorials to teach you the skill needed to compete in the competitive work environment. (111+ video tutorials)

– All Advanced tutorials case studies related to videos.
– Access to all video tutorials 24 x 7 – learn excel online from anywhere.
– A 30-day money-back guarantee (we want you to be 100% satisfied with our Excel Dashboard tutorials)
– You will also get support for doubt and assistance to implement your learning in real-life challenges.

How do I enroll for the Excel Dashboard online?

You can enroll for this course online by just a click on Enroll Now button Payments can be made using any of the following options and receipts of the same will be issued to the candidate automatically via email.
– Visa/Master Card credit and debit card
– PayPal

How much time required to complete Excel Dashboard Training?

This is a self-paced, lean Training program with videos from basics to advanced tutorials. Watch the preview of videos tutorials to get a flavor the program’s uniqueness and relevance. Online courses may not be your first preference. But I promise this – After watching 3 videos, this courses will give a tough fight to your usual classroom training. We think someone with intermediate background can complete the course in 2-3 weeks

What if I’m unhappy with my Excel Dashboard course? Do I get a refund?

We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund. To know more please go through our Refund Policy.

How can you say that my speed will improve?

Simple – Our feedback form from each corporate clients give us a rating between 4.8 to 5 (5 being the highest). We will empower you with tips and tricks based on real issues faced by 1000s of students we teach. We created these advanced tutorials after so many years of research and hundreds of hours of training.

Contact Me

Still confused on which Course to take?

 Email [email protected]

 Call Now! +91 80800 42523 / +1-203-349-9909