Excel Dashboard Tutorial From Basic to Advanced

Learn to create 4 types of dashboards from scratch with 100+ techniques

Excel Dashboards are a powerful tool to communicate and summarize complex Excel data. As a professional, you may have access to tons of data. But, the important aspect of decision making is drawing actionable and relevant conclusions.

If you give your boss an Excel file with customer call data 10,000 rows and 300 columns, your boss won't be able to take a decision from this raw data.You will still need to summarize this with key variables as levers so the dashboard operator can quickly draw patterns and derive conclusions.

I don’t want to make you shine for your Boss. I want you to become the BOSS. This MS Office Training will give you career-building skills that you can use to become better in making chart reports and more efficient at your job.

What’s covered in the Excel Dashboard course?

  • Dashboard fundamentals (Optional): Design tips, Data formats, Formatting, Data cleaning, Sparklines, Spider, waterfall and bubble charts, List- controlled graphs, pivot tables and dynamic functions. Skip this section if you’re already an intermedia user
  • Learn to create 4 types of dashboards from scratch with 100+ techniques
    • ✓ Single sheet tracker controlled by list field across multiple sheets
    • ✓ Pivot table dashboard using interlinked pivots, slicers and button-controlled charts
    • ✓ Map chart dashboard using Advanced Excel functions
    • ✓ Dynamic Dashboards using Excel Macros

You will learn the following techniques in excel dashboard:

  1. Naming the dynamic data and the using it in function
  2. Create Chart for comparison from the Pivot table
  3. Create Trend line from the Pivot table
  4. Creating Pie Chart from Slab Report from Pivot table
  5. Inserting Slicer using Chart & Customize Slicer Setting
  6. Creating Waterfall Chart
  7. Creating Bubble Charts
  8. Extract data from multiple sheet using OFFSET, INDIRECT and CELL
  9. Form controls for interactive dashboard.
  10. Creating Thermometer chart
  11. Importing Data from the Internet
  12. Converting Line Item into a Currency Table
  13. Calculation of Currency using INDEX and MATCH
  14. AverageIF for calculating Country Wise Salary
  15. Dynamic Dropdown
  16. Button-controlled charts and spark lines
  17. List longitude and latitude with plotting data on dashboard
  18. Using REPT Function based on the percentage calculation
  19. Advanced INDEX and MATCH with multiple references
  20. Insert World Map into the chart
  21. Plotting Data on Map Chart and Controlling Map Preview from drop-down
  22. Preparing the base by removing duplicate for Dashboard
  23. Implementation of OFFSET for dynamic data
  24. Using macro to update pivot table based on the Job Type
  25. Preparing data for Spiderweb chart and change the graph setting
  26. Use of Array functions like MAXIF and MINIF with single and multiple parameters
  27. Creating Name Range using shortcut and many more


Your Instructor


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

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 2021. 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, Flipkart, Uber, Tata Group, etc.

  • Trained 30K+ professionals through
  • 150K+ Online Students

Course Curriculum


  Download Working files for Section 1 & 2
Available in days
days after you enroll
  Download Working files for Section 2, 3 & 4
Available in days
days after you enroll
  Section 3: Map chart dashboard using Advanced Excel functions
Available in days
days after you enroll

FAQs


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
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.

Get started now!