Skip to content
UdemyExcelPaid courseAll LevelsCertificate

Easy Excel Dashboards, Models, Visualizations & Power Query (Udemy.com)

Build Professional Dashboards with No Formulas. Rapid Step by Step Beginner to Advanced. Get & Transform Data with Ease

Created by: Jonathan Ng

Last updated June 2023

icon
What you will learn

  • Rapidly build interactive dashboards which are robust and easy to update

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.6 out of 5higher than 63% of them
  • Reviews464#231 of 356 by number of reviews
  • Length2.5 hoursshorter than 80% of them
  • Last updatedJune 2023earlier than 54% of them

icon
Course Description

Rapidly build robust dashboards in Excel by following a simple step by step process that requires no formulas. Beginners can get started easily due the lack of formulas. Advanced users will learn to structure their dashboards like software developers so that they become more automated with no additional work. 

Not many people are aware how much can be done with no or very few formulas in Excel. This not only makes the design simpler it also makes it more robust, reduces risk and improve performance. 

Jonathan trained as a Microsoft Certified Trainer and has used advanced Excel for over a decade. 

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Jonathan Ng

I've always enjoyed figuring out how to get things done in the most efficient way possible. How do you achieve 10x more results with 10x less work? Whether you're looking to get in shape, learn a new sport, invest for your future or get better at your job there are tips, tricks, strategies and shortcuts that can help you achieve that more effectively. 

One of your key tools will absolutely be the effective use of technology. Technology is a multiplier of results and learning to use the right technology for the job is key. 

icon
More courses by Jonathan Ng

$99.99

$79.99

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.6

464 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Jaime Galloway on 11/28/2022

Great course! Learned so much! There were parts of Excel I didn't know about prior to this course and I know I'll be able to analyze my data better now. My only constructive criticism is that it would have been nice to either have a quiz under each section or for this course to be something where you pull up excel and follow along as the course is showing different tools. I don't know about everyone else but I definitely learn better and retain more that way. Other than that, it was great!

By Sarah Golden-Waters on 11/29/2020

This course is fantastic! It's fast-paced so far, but it's ok because I can just pause and rewind as needed, and so much great info is packed in! I thought I knew a lot about Excel already, but I'm surprised over and over again in this course by all the amazing things I never knew it could do.

By Naju Mehra on 5/18/2020

Enjoying it thoroughly so far, Jonathan explains it very well and goes at a good pace so that there is time to absorb the knowledge. The only comment I would make is to be able to provide students some the sample data files he is using so that students can have a hands on experience. But I really love it, Jon is doing a great job!

By Todd Brannon on 11/2/2019

Great introduction to Power Query and some great use cases for examples. Would have liked more depth but honestly, this was a great balance between depth and length of course just to get you started with dashboards, modelling, some more advanced visualizations in Excel, and Power Query. You can easily rip through this course in a day or two, especially if you already have a strong Excel skillset.

By Geoff Pheysey on 8/13/2019

Yes particularly interested in query and relationships/modelling etc. Some interactive examples would have been good to really help get to to grips with some of these tools. i.e. sample data sets and tasks to perform some of these functions, as demonstrated. Overall a really good overview of what can be achieved.

By Ejetavwo Mukoro on 1/16/2019

Excellent... The Instructor took me from ZERO to HERO in visualizing data in excel without using formulae within 2hours . Wow. Awesome. Great explanations and straight to the point in delivering the course objectives. Already bought R Tidyverse and R Shiny Flex.... Am so excited and cannot wait to start analyzing data using R. Thanks.

By Gabriel Coyle on 12/9/2018

The instruction is organized, and he focuses on the most useful information: how to curate the methods of analysis. Thus, he doesn't overload the instruction with irrelevant details. This is the best Udemy course I've taken so far, and it is because of the instructor's approach to learning.

By Seamus Hand on 7/18/2018

The course helped me to think more strategically about what is the right tool and what distinct steps to plan with a data project. My previous approach would be to jump into a workbook and get stuck in. Jonathan is also quite motivational in that he is motivated to find the best tool for the job to get the job done and to move on to something more exciting - rather than getting lost in how wonderful the tool is.

By Partho Mitra on 3/30/2018

A lot of the things in this course is something that I was working on but the course was helpful on why aspect of it where I was doing things because it made sense and this course gave me the background logic on why I was doing it the way I was. Thanks for the to the point and at the same time detailed explanation!

By Michelle Oaks on 3/20/2018

Excellent! I'll be looking for ways to apply the tips and techniques learned in my work in reporting and analytics (currently using Excel 2013). The scenarios were practical and easy-to-follow. I will take additional courses by Jonathan to increase my technical skills as I found the training to be interesting, informative, and a bit fun!

Showing all 10 reviews on CourseDuck

Read all 464 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100