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 Personal Development Mindfulness Meditation Personal Transformation 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 Retargeting
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
Office Productivity Microsoft Excel Dashboard

Microsoft Excel Dashboards & Data Visualization Mastery

The only Microsoft Excel Dashboard, Data Visualization & Data Analysis course for INTERMEDIATE to ADVANCED EXCEL users!
Rating: 4.3 out of 54.3 (125 ratings)
10,164 students
Created by MyExcelOnline John Michaloudis, Jordan Goldmeier
Last updated 11/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Students will learn ADVANCED skills to create Dashboards and data visualizations in Excel
  • Students will become EXPERTS at creating INTERACTIVE ANALYSIS
  • Students will be able to QUICKLY CREATE Dashboards, Reports, and Interactive Applications (WITHOUT macros)
  • Become more PRODUCTIVE at using Microsoft Excel which will SAVE YOU HOURS per day & ELIMINATE STRESS at work!
  • We teach you how to use Microsoft Excel with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!
  • Increase your Microsoft Excel SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
  • DOWNLOADABLE Excel workbooks so you can keep on your desktop & practice!
  • Test your skills with various real life Quizzes & Homework Practice Activities & Assignments!
  • Personal Excel support from Professional Excel Trainers with 30+ Years of combined Excel Training!

Requirements

  • This course is for INTERMEDIATE or ADVANCED Excel users. If you are brand new to Excel with no prior knowledge, this course is NOT for you.
  • Excel for Windows 2010, 2013, 2016, 2019, Office 365 and Excel for Mac 2011 and 2016

Description

You’re Just Seconds Away From Leveraging Microsoft Excel Dashboards, Data Visualization & Data Analysis That Will Make It Possible For YOU To:

  1. Increase your Microsoft Excel SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!

  2. Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!

  3. Use Excel with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

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

This course is the first of its kind! 

A course tailored specifically toward the Intermediate to Advanced Excel developer. If that's you, you likely spend hours each day in Excel. Whether that's managing finances, making projections, tracking projects, and creating Excel dashboards for special projects.

You are not new to Excel. In fact, you can wrangle your way around most features and concepts. However, what you really need is instruction. Searching Google and forums can only get you so far.

This course is what you've been waiting for!

It's a quick deep dive into concepts like Array Formulas and formula-driven development. As you progress the course, you'll see how each module builds atop the last. You'll be exposed to often overlooked features, like Excel's form controls, which can drive tremendous interactivity.

And we'll even run through the rules of data visualization, to make sure what you build communicates its message.

By the end of this course, you won't just good at data visualization and dashboards, you'll be a master Excel builder!

There are tons of labs and mini dashboards throughout the course. Whatever you build for the course, you can use right away.

See you on the inside....

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

Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Excel Dashboard & Data Visualization level & skills...

…saving HOURS each day, DAYS each week and WEEKS each year and eliminating STRESS at work...

...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job…

...All whilst impressing your boss and STANDING OUT from your colleagues and peers...

...THEN THIS COURSE IS FOR YOU!

Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills!

To enroll, click the ENROLL NOW button  (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...

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

>> Get LIFETIME Course access, downloadable Excel workbooks, Quizzes, Assignments, 1-on-1 instructor SUPPORT and  a 100% money-back guarantee! *** 

>> Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Excel ***

Who this course is for:

  • INTERMEDIATE Excel users looking to take their skills to the next level
  • Data workers with titles like ANALYST, MANAGER, PROGRAM MANAGER, FINANCIAL MANAGER, BUSINESS ANALYTICS DEVELOPER, and DATA SCIENTIST
  • Managers, financial analysts, business analysts looking to really wow their colleagues with Excel
  • People who want to change career and apply for a new job
  • If you want to leverage Excel to stand out from the crowd, save hours each day, eliminate stress & get a promotion or pay-rise, then you are invited to join this course!

Course content

16 sections • 76 lectures • 6h 55m total length

  • Preview00:49
  • 1.2 Why Even Use Excel?
    07:35
  • 1.3 Why Dashboards + Datavis?
    05:23
  • 1.4 Interactive Dashboards in Excel
    10:19
  • Section 1 Quiz
    1 question

  • 2.1 Thinking outside the cell
    06:47
  • 2.2 Why develop differently
    03:40
  • 2.3 Inserting the camera tool
    02:57
  • 2.4 How to use the camera tool
    07:54
  • 2.5 Development Principles
    12:49
  • Section 2 Quiz
    2 questions

  • 3.1 Formula Editing Tips
    11:52
  • 3.2 Excel Calculation Engine
    09:08
  • 3.3 Writing Better Formulas
    11:10
  • Section 3 Quiz
    2 questions

  • 4.1 Lookup Functions
    02:44
  • Preview03:24
  • 4.3 How to use INDEX/MATCH
    06:29
  • 4.4 Combining formulas
    04:24
  • 4.5 How to use Array Formulas
    02:49
  • 4.6 Array Formulas Demo
    20:44
  • Homework: Array Formulas
    00:01
  • 4.7 Section Review
    02:20
  • Section 4 Quiz
    2 questions

  • 5.1 Introduction to Excel Tables
    03:43
  • 5.2 Inserting a New Excel Table
    08:35
  • 5.3 Working with Tables
    07:29
  • 5.4 Excel Tables Demo
    04:34
  • 5.5 Rules for using Excel Tables
    02:35
  • Homework: Excel Tables
    00:01
  • Section 5 Quiz
    2 questions

  • 6.1 Introduction to Sorting Functions
    19:20
  • 6.2 Creating Filters with SUMPRODUCT
    01:38
  • 6.3 Filtering on Excel Tables
    17:26
  • 6.4 Data Aggregation
    13:26
  • 6.5 Section Summary
    02:12
  • Homework: Table Sorting
    00:01
  • Section 6 Quiz
    3 questions

  • 7.1 The DEVELOPER Tab
    01:32
  • 7.2 Excel Form Controls
    03:44
  • 7.3 Form Controls Demo
    14:55
  • 7.4 Form Control Basics
    01:59
  • 7.5 Creating a Scrollable Table
    07:26
  • Homework: Creating a Scrollable Table
    00:03
  • Section 7 Quiz
    3 questions

  • 8.1 Introduction to Formula-driven Development
    05:06
  • 8.2 The Information-Transformation-Presentation Dynamic
    29:11
  • Section 8 Quiz
    1 question

  • 9.1 Section Introduction
    01:50
  • 9.2 Creating an Interactive Legend
    07:18
  • 9.3 Perfecting the Interactive Legend
    16:50
  • 9.4 Maintaining the Interactive Legend
    03:11
  • Homework: Creating an Interactive Legend
    00:03

  • 10.1 Section Introduction
    00:38
  • Preview06:56
  • 10.3 Formatting the Interactive Chart
    05:05
  • 10.4 Maintaining the Interactive Chart
    02:51
  • Assignment: Creating an Interactive Chart
    00:02

Instructors

MyExcelOnline John Michaloudis
Chief Inspirational Officer at MyExcelOnline
MyExcelOnline John Michaloudis
  • 4.4 Instructor Rating
  • 4,751 Reviews
  • 88,980 Students
  • 12 Courses

Hello fellow Excel lovers/beginners/experts/users!  My name is John and I am the Chief Inspirational Officer at MyExcelOnline.

I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish (and Excel)

My journey in to Excel began after I graduated and have since helped many of my colleagues around the world understand this underutilized but powerful tool. Now its my turn to teach YOU the power of Excel with these high quality and easy to understand tutorials.

My aim is to get you to become comfortable & confident in Excel and use its power to make your job a lot easier & save you time, create interactive reports that will reach top management and ultimately make you stand out from your colleagues and get that promotion or pay rise that you deserve.

I have taught over 50,000 students on Udemy alone plus over 100,000 people on my website - MyExcelOnline.  I have an active Excel blog where I post free Excel tutorials as well as an Excel podcast where I interview fellow Excel experts & share their insights.

I am currently living in the North of Spain (Basque Country) and I´m married and have one cheeky boy & a newly born baby girl! You could describe me as a football lover, wine & beer drinker, food indulger and occasional gym goer. 

Join one of my courses and get ready to change your life...

Jordan Goldmeier
Chief Data Anarchist
Jordan Goldmeier
  • 4.3 Instructor Rating
  • 125 Reviews
  • 10,164 Students
  • 1 Course

Jordan Goldmeier is an internationally recognized analytics professional and data visualization expert, author and speaker. A former chief operations officer at Excel.TV, he has spent years in the data training trenches. He is the author of Advanced Excel Essentials and Dashboards for Excel, and currently working on this 3rd book, Becoming a Data Head (Wiley, 2021), on helping managers communicate, challenge, and understand data science with a common language and expectation.

His work has been cited by and quoted in the Associated Press, Bloomberg BusinessWeek, and American Express OPEN Forum. He is currently an Excel MVP Award holder, an achievement he's held for six years, allowing him to provide feedback and direction to Microsoft product teams. He is also a volunteer Emergency Medical Technician.

Past clients include NATO Training Mission, the Pentagon, Principal Financial, H&M, Stony Brook University, and Element6.

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