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+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift 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
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business 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
Office Productivity Microsoft Excel Dashboard

Excel Dashboard Secrets - Create Awesome Excel Dashboard

Learn Dash-Boarding by creating 17 Live Excel Dashboards! Master advance Excel techniques by creating Dashboards
Rating: 3.8 out of 53.8 (112 ratings)
1,568 students
Created by Amey Dabholkar
Last updated 8/2015
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Present data in an Effective format
  • Create awesome Static Dashboards
  • Create Interactive dynamic Dashboard
  • Learn some Excel techniques by creating Dashboard
  • Show off their dash boarding skills to colleagues and Boss

Requirements

  • Just a time of 20 Minutes a day to Learn
  • Microsoft Excel 2007+ (Some tricks requires 2010+)
  • Learn / Revise the basics and intermediate concepts in Excel
  • A Pen and Paper to note some important points

Description

Latest: Course Updated on 25th March 2015.

Added 2 New Excel Dashboards. !!

1. Excel In Cell Chart Dashboard

2. Excel Gantt Chart Dashboard

Other:

Excel Dashboard Homework, Improved Quiz, Private Function Vs Public Function Excel Article

Over 2.5 Hours + of Dashboard content fully loaded with Advance Excel Techniques

Exercise Files which will help you to revise the content later

Over 800+ students having great content engagement !!!


Excel Dashboards are a powerful tool to communicate and summarize complex Excel data. This complex data can be presented by creating Dashboard. Dashboard will help to quickly analyse the data, Find the draw backs, Expect the future outcomes and lots more

Master the creation of Interactive dashboard and learn to present it in a presentable format. Learn new techniques which will help to create complex Excel Dashboard.

Learn:

  • Advance formulas and Functions
  • Learn to analyse the data
  • Learn to present the data in effective format
  • Learn to do complex excel task in a simpler way
  • Learn secrets of Charting
  • Learn Interactive Elements (Combo boxes, List boxes , Check boxes …)
  • Learn the effective utilization of Excel Features

Learn it by Your way!!

Udemy Provides access to the course for Lifetime. Hence repeat the course as many times you want and make your concepts clear. Learn anywhere and anytime.

Get the answers ready from the discussion corner.

Is this course for me?

This course is designed for a particular type of people who are aware with the basics and looking forward to master the intermediate techniques. Check out if this course is for you:-

  • If you need to analyse the data and find out the conclusion
  • Your Job is to analyse the data and present it to clients
  • Want to learn more in Excel
  • For Managers who have to take quick and quality decisions by analyzing data
  • For Managers who are managing the performance of the company
  • Students who want to learn more and advance in Excel
  • For IT Professionals who want to develop carrier in Excel
  • For anyone who wants to use Excel as a base to create projects and reports
  • For Excel lovers who wants to learn more..

Practically this course is suited for anyone who knows excel. This course is generally carried in fast pace and hence one needs to familiar with the basic and advance concepts in Excel

Dashboards are ULTIMATE PRODUCTIVITY SUITES

Contents and Overview of Lectures

There are over 30 + Lectures containing video and Downloadable Materials. The downloadable material are crucial part of learning Excel Dashboards. When one wants to revise the technique learned before he can achieve this by using Exercise Files provided in the course materials

Upon the completion of the course students have a variety of techniques which can be applied to the live data and create the reports. Students will be focused on how to create a dashboard without wasting lot of time.

Click the "take this course" button, top right, now ...every hour you delay is costing you money...

-Amey Dabholkar

Who this course is for:

  • Any Advance or Intermediate Excel User
  • This course should NOT be taken by New or Beginner Excel Users
  • Manager working in any stream who requires to present / Project / Analyse the data
  • Employee whose work is to create reports and present it in Effective Format
  • Any Excel lover who wants to learn more skills in Excel
  • An Excel user who is knowing basics/Advance and want to learn Excel at an Intermediate Level

Course content

20 sections • 41 lectures • 3h 8m total length

  • Preview01:54
  • Preview01:26
  • All Exercise FIles (.Zip File)
    00:06

  • Exercise Files --- Download This First
    00:02
  • Create a Scrolling Table -- Show data in Effective Format to the Viewers
    14:53

  • Exercise Files -- Download This First
    00:01
  • Create Scrolling Chart and use Dynamic Label -- Show chart in Effective manner
    15:56

  • Exercise Files -- Download this First
    00:01
  • Highlight Selected row or column -- Make data easily view able
    12:04

  • Exercise Files -- Download This first
    00:01
  • Create Awesome Excel Graphics -- Make Dashboard Look Perfectly Designed
    09:14

  • Exercise FIles -- Download This First
    00:01
  • Dynamic Sales Dashboard -- Making things arranged properly
    15:11
  • Dynamic Sales Dashboard -- Completing your dashboard
    12:14

  • Exercise Files -- Download This First
    00:01
  • Comparative Dynamic Sales Dashboard and Combo box Tutorial
    08:12

  • Exercise Files -- Download This First
    00:01
  • Income Expense Chart -- Express The Income and Expenses in the New Way
    05:06

  • Exercise Files -- Download This First
    00:01
  • Preview07:08

  • Exercise Files -- Download This First
    00:01
  • Roll Over Method Demonstration and a small Dashboard with Roll Over method
    07:27

Instructor

Amey Dabholkar
Excel Educator and Professional
Amey Dabholkar
  • 4.0 Instructor Rating
  • 141 Reviews
  • 2,720 Students
  • 3 Courses

Amey Dabholkar, is recognized in his teaching Microsoft Excel. He owns and runs his website which delivers high quality Excel content and articles. The website features tutorials which are in form of video and comprehensive article. He is also renowned Udemy Premium Instructor delivering high quality content. His Dashboard Course (Part One) which was one of the best launch in year 2014 received over 1000+ Students and high quality interaction.

Comments, Feedback includes that the person/student could apply the technique very next day. He teaches by giving real life Example with current industry standards hence users are satisfied with it. Ask questions till convinced because he provides lifetime updates and support for his course.

Business world/ corporate world now requires the deep knowledge of dashboarding, data mining, analysis etc. Excel is a very good application which can perform these thing

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