Microsoft Advanced Excel Dashboard : Zero To Hero (Complete)

  • Overview
  • Curriculum
  • Instructor
  • Review

About This Course

Create Attractive Advanced Excel Dashboard for Data Analytics with Visual using Excel Tools, Functions and Excel Macros

Microsoft Excel Dashboard help user visualizes complex scenarios and problem better. Manager with the help of Advanced Excel dashboard can make better business decisions.

Our course is meant for professional working at different levels of careers, i.e., From MIS executive to Data Analyst.

MS Excel made it easy to make Dashboards for any Analytics. Business user can easily analyze data to create powerful reports and dashboards in a fraction of the time of traditional spreadsheets.

In this course, you'll learn to make dashboard in Excel in different ways:

  1. Dashboard using Pivot Table like Multiple  Pivot, Interlinked Pivot, Slicer buttons to control charts, Advanced Charts, etc.

    • Text Function in Excel

    • Naming   the dynamic data and the using it in function

    • Create   Chart for comparison from the Pivot table

    • Create   Trend line from the Pivot table

    • Creating   Pie Chart from Slab Report from Pivot table

    • Inserting   Slicer using Chart & Customize   Slicer Setting

    • more..

  2. Dashboard using Excel Functions:

    • 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 

    • Insert World Map into the chart 

    • Plotting Data on Map Chart and Controlling Map Preview from drop-down

    • Preparing the base by removing duplicate for Dashboard 

    • more..

  3. Dashboard using Excel Macros & Functions

    • 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

    • more..

This course is for all business users who want to learn how to create management reports, analyze data and create interactive dashboards using Excel 2010 and later versions.

Important information before you join:

  • Once enrolled, you have unlimited, lifetime access to the course!

  • You will have instant and free access to any updates I'll add to the course.

  • I will give you my full support regarding any issues or suggestions related to the course.

  • Access to all videos 24 x 7 - learn online from anywhere

  • 30-day money back guarantee (we want you to be 100% satisfied) 

--------------------------------------------------------------------------------------------------------------------------------

If you have read this far, next action is JOINING this course. Invest 4 hrs. for the benefit of lifetime Ninja status on Advanced Excel Dashboard Course.

  • Analyze data and create reports in a fraction of the time of spreadsheets

  • Create new powerful calculations, KPIs and Key Metrics

  • Plot data on Map in Advanced Excel Dashboard

Course Curriculum

Instructor

Profile photo of Yoda Learning
Yoda Learning

20,000 Classroom Students | 100,000+ Students Onlineex-KPMG, ex-J.P. Morgan | Chartered AccountantTaught 12k+ participants across PwC, EY and Deloitte over last 10 yearsI 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...

Review
4.9 course rating
4K ratings
ui-avatar of Ancy Daniel
Ancy D.
2.5
2 years ago

Too Fast on 2nd Dashboard

  • Helpful
  • Not helpful
ui-avatar of Manigandan
Manigandan
5.0
2 years ago

content is superb and before moving on the dashboard building part you have provided exercise for that function separately to make everyone to understand the concept clear. Learned so many things from the videos amazing.

  • Helpful
  • Not helpful
ui-avatar of Hemasunder Duddi
Hemasunder D.
5.0
3 years ago

Learnt text function for the first time

  • Helpful
  • Not helpful
ui-avatar of An Le Thuy Nguyen
An L. T. N.
4.0
4 years ago

Good course so far

  • Helpful
  • Not helpful
ui-avatar of Yazeed Alhwjaily
Yazeed A.
5.0
4 years ago

it was really good course

  • Helpful
  • Not helpful
ui-avatar of Aishani Lal
Aishani L.
4.5
4 years ago

The concept is clear and functions are well defined

  • Helpful
  • Not helpful
ui-avatar of Anurag Gupta
Anurag G.
5.0
4 years ago

got to know shortcuts that saves time

  • Helpful
  • Not helpful
ui-avatar of Buzibwa Kizito
Buzibwa K.
4.0
4 years ago

Most definitely good for my development!

  • Helpful
  • Not helpful
ui-avatar of Yogeshkumar
Yogeshkumar
4.0
4 years ago

yes

  • Helpful
  • Not helpful
ui-avatar of Ankur Singhal
Ankur S.
5.0
4 years ago

very good

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses