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 Amazon AWS CompTIA Security+ 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 Coaching 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 Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
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

This course includes:

  • 7 hours on-demand video
  • 1 article
  • 15 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel

Visually Stunning Microsoft Excel Dynamic Dashboard Course

Become an Excel Dashboard Expert : 11 Basic, 3 Intermediate and 4 Advanced Level Dynamic Dashboards without any VBA code
Rating: 4.1 out of 54.1 (247 ratings)
2,566 students
Created by The Dronaachaarya
Last updated 1/2019
English
30-Day Money-Back Guarantee

What you'll learn

  • The Art of creating Visually Stunning Excel Dashboards.
  • You will start with 11 Basic Level Dashboards and gradually move to 3 Intermediate and 4 Advanced Level Charts.
  • Practicing the charts along with the course will make you a Master of MS Excel Dashboards.

Requirements

  • Basic Working Knowledge of Microsoft Excel.
  • Knowing basic funtions in Excel.

Description

This course teaches you to create well-designed dynamic Excel dashboards so you and your colleagues can see trends and make quick decisions informed by data.

By participating in this Microsoft Excel Dashboard course you'll gain the widely sought after skills necessary to effectively analyze large sets of data. 

In this topic, we’ll discuss how to use multiple PivotTables, PivotCharts and PivotTable tools to create a dynamic excel dashboards. Then we'll give users the ability to quickly filter the data the way they want with Slicers and a Timeline, which allow your PivotTables and charts to automatically expand and contract to display only the information that users want to see. In addition, you can quickly refresh your dashboard when you add or update data. This makes it very handy because you only need to create the excel dashboard report once.

You will start with 11 Basic Level Excel Dashboards and gradually move to 3 Intermediate and 4 Advanced Level dashboard. Practicing the dashboard along with the course will make you a Master of Microsoft Excel Dashboards.

Who this course is for:

  • This course is meant for students who wish to create beautiful Dynamic Dashboard using MS Excel for Data Visualization and Analysis.
  • Anyone who would like to take his Excel Skills to the next level.
  • Anyone who is into MIS, Data Analytics and Database Management System

Course content

4 sections • 31 lectures • 6h 46m total length

  • Preview03:34
  • Preview11:20

  • Preview10:29
  • Preview07:16
  • Pie in Pie
    06:42
  • Tornado Chart
    13:55
  • Heatmap Chart
    04:26
  • Bullet Charts
    11:59
  • WFM Chart
    12:36
  • Within Cell Dashboard
    09:28
  • Funnel Pyramid Chart
    09:28
  • Sparkline Dashboard
    12:46
  • Preview09:57

  • Dropdown Dashboard
    10:08
  • Target Achievement Comparison Chart
    14:41
  • All in One Chart
    33:55

  • Productwise Comparison Sales Dashboard - Part 1
    22:03
  • Productwise Comparison Sales Dashboard - Part 2
    11:58
  • Productwise Comparison Sales Dashboard - Part 3
    24:15
  • Productwise Comparison Sales Dashboard - Part 4
    12:49
  • Introduction to Multiple KPI Dashboard
    03:38
  • Multiple KPI Dashboard 1
    14:30
  • Multiple KPI Dashboard 2
    22:44
  • Multiple KPI Dashboard 3
    14:45
  • Introduction to the Call Center Dashboard
    04:32
  • Call Center Dashboard 1
    22:42
  • Call Center Dashboard 2
    15:39
  • Call Center Dashboard 3
    23:50
  • Call Center Dashboard 4
    14:36
  • Call Center Dashboard - Version 2
    15:33
  • Congratulations - You are Now a Excel Dashboard Ninja.
    00:32

Instructor

The Dronaachaarya
Excel for Excellence
The Dronaachaarya
  • 4.3 Instructor Rating
  • 294 Reviews
  • 11,961 Students
  • 3 Courses

Dronaachaarya is a group of passionate teachers who are dedicated to Quality Online Education.  We know that learning is easier when you have an excellent teacher. That's why most of our educators have achieved an advanced degree in their field. Our faculty are passionate about the subjects they teach and bring this enthusiasm into their Online Courses. 

The Major Focus of Dronaachaarya Teachers is to embrace the pursuit of excellence both inside and outside the classroom. We encourage critical thinking and emphasize the learning process over rote memorization.  

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