Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence Excel Dashboard

Microsoft Advanced Excel Dashboard : Zero To Hero (Complete)

Create Attractive Advanced Excel Dashboard for Data Analytics with Visual using Excel Tools, Functions and Excel Macros
Rating: 4.3 out of 54.3 (337 ratings)
2,188 students
Created by Yoda Learning
Last updated 9/2017
English
English [Auto], Indonesian [Auto], 
30-Day Money-Back Guarantee

What you'll learn

  • 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
  • Learn 3 types of Dashboards in this course
  • Learn to make Excel Dashboard using Pivot tables
  • Learn to create Excel Dashboard using Functions
  • Learn to create Excel Dashboard using Macros and Functions
  • Get Conclusion of all 3 Excel dashboards

Requirements

  • Course works on all Microsoft Excel versions 2003, 2007, 2010, 2013, 2016. Of course the newer the better, but some features works same in all the versions.
  • You just need to have Basic understanding of Excel because i'll take you to the advanced level in this Excel Dashboard Course

Description

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

  • A 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.

Who this course is for:

  • People who analyze data and create new insight
  • People who do reporting and create dashboards
  • Professionals working with large amount of Data

Course content

5 sections • 64 lectures • 3h 56m total length

  • Preview03:08
  • Download the Excel Dashboard Practice Files + Shortcuts
    00:02

  • Preview01:06
  • Understanding the data in Excel
    01:41
  • Preview06:30
  • Dynamic Data to Create Table
    07:16
  • Naming the dynamic data and the using it in function
    04:21
  • Preparing 1st Pivot and updating data
    05:28
  • Classic view and Filling blank with zero in Pivot
    03:46
  • Create Chart for comparison from the Pivot Table
    01:46
  • Create Trend line from the Pivot table
    08:18
  • Creating Pie Chart from Slab Report from Pivot
    04:50
  • Preparing Framework for Dashboard
    02:14
  • Inserting Slicer using Chart
    03:18
  • Customize Slicer Setting
    04:30

  • Preview01:36
  • Importing Data from the Internet
    04:39
  • Converting Line Item into a Currency Table
    05:35
  • Calculation of Currency using INDEX and MATCH
    03:24
  • Creating Slabs using Vlookup True Parameter
    04:58
  • Creating Quarters based on Financial or Calendar Selection
    04:28
  • Preparing the base by removing duplicate for Dashboard
    02:36
  • AverageIF for calculating Country Wise Salary
    02:23
  • Substituting ERROR with zero using IFERROR
    02:16
  • Introduction to Function INDIRECT Part 1 and 2
    10:13
  • Using Function INDIRECT to Retrieve AverageIF from relevant sheet
    04:03
  • Using Function CountIf with INDIRECT to calculate Number of Employees
    04:18
  • Calculating Contribution Country wise Number of Employees
    02:29
  • Using NameRange to simplify calculation
    02:48
  • Using NameRange with formula in 2nd Dashboard
    05:18
  • Introduction to Offset Function
    02:57
  • Offset Function in Excel
    04:01
  • Using Offset Function in Dashboard
    03:58
  • Use of MINIF in Dashboard
    03:14
  • Use of MAXIF in Dashboard
    02:41
  • Using Average to get Designation Wise Experience result
    03:45
  • Using MAXIF with multiple conditions
    03:26
  • Using MINIF with multiple conditions
    01:28
  • Dynamic Dropdown List
    02:06
  • Longitude and Latitude with plotting data on Dashboard
    03:08
  • Using REPT Function based on the percentage calculation
    02:41
  • Activation of Developer Tab and creating Scroll Bar
    04:04
  • Inserting Trend chart based on data
    04:29
  • Advance INDEX and MATCH with multiple references
    03:47
  • Inserting Spark Line
    02:26
  • Insert World Map into the chart
    01:58
  • Plotting Data on Map Chart
    05:09
  • Controlling Map Preview from Dropdown
    03:39
  • Summarizing 2nd Dashboard
    03:29

  • Preview01:24
  • Implementation of OFFSET for Dynamic Data
    03:45
  • Creating Trend Chart from Two Pivot Tables
    03:46
  • Modifying the Chart Settings for Better View
    02:10
  • Using Macro recording for Trend Chart
    03:03
  • Using macro to update pivot based on the Job Type
    07:52
  • Triggering macros with any change in Spreadsheets
    02:42
  • Creating Name Range using Shortcut
    03:28
  • Use of MAXIF and MINIF with Single and Multiple Parameters
    02:38
  • Create chart to represent multiple parameters effectively - Part 01
    02:53
  • Create chart to represent multiple parameters effectively - Part 02
    03:41
  • Preparing data for Spiderweb chart and change the graph setting
    04:39
  • Using macro to Hide and Unhide working sheets
    06:31
  • Inserting Trendline and formatting for better view
    03:15

  • Conclusion of all 3 Excel dashboards
    03:25

Instructor

Yoda Learning
Data Analyst |MS Office Expert & PMP | Instructor/Programmer
Yoda Learning
  • 4.4 Instructor Rating
  • 8,282 Reviews
  • 122,782 Students
  • 28 Courses

     

20,000 Classroom Students | 100,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!

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.