Skip to content
Write a review
UdemyExcelPaid courseBeginner levelCertificate

MS Excel Exam Guide: Analyzing and Visualizing Data (Udemy.com)

Gain Skills in Data Analysis with Excel. Pass the Microsoft 70-779 Exam. Grow Your Career with an Excel Certification.

4.5
705 reviews

Created by: Ben Young

Last updated June 2024

icon
What you will learn

  • Building queries in Excel
  • Combining data from multiple files
  • Modeling data in Excel’s Data Model
  • Transforming and cleaning data
  • Splitting data
  • Merging data
  • Pivoting data
  • Building relationships between data sets
  • Calculating implicit DAX measures
  • Calculating explicit DAX measures
  • Building Basic and Advanced DAX functions
  • Creating KPIs in Excel
  • Creating Hierarchies in Excel
  • Building and formatting Pivot Tables
  • Building and formatting Pivot Charts
  • Creating and using calendar tables
  • Understanding Question styles and formats for the Excel certification exam
  • Using both Excel with Power BI

How it compares

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

  • Rating4.5 out of 5higher than 39% of them
  • Reviews705#205 of 356 by number of reviews
  • Length4.2 hoursshorter than 62% of them
  • Last updatedJune 2024more recently than 55% of them

icon
Course Description

Microsoft Excel is one of the most important software programs ever created. Businesses large and small, in countries all around the world, run off of systems and processes built on and around Excel. With so many people using Excel as part of their day-to-day jobs, it is more important than ever for you to stand out from the crowd and certify your Excel skills so you can contribute and be entrusted with these business-critical opportunities.

Enter this course. Designed directly off the study guides and outlines for the Excel 70-779 Exam, this course provides not only the theory but also the practical and foundational skills needed to pass the certification exam and stand out from the crowd. Not only will you be well prepared for the exam, but you’ll also build out a skill set that will be in demand for years to come.

When you’re ready to professionally certify your Excel skills, this is the course for you.
Read More Beginner Beginner Level product length iconTime: 4.2h

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.

Get the Udemy discount

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

Ben Young

Hello! My name is Ben Young. My background is in data analytics and visualization, especially in the context of business strategy. I've worked in multiple industries (insurance, sales, non-profit, etc.) and across every job, analysis, and deliverable, there has been a constant need for data and the ability to interpret it. Tableau is my tool of choice, one that I've spent four years mastering, earning multiple professional certifications and tutoring hundreds of students in person and online. To top it all off, I recently completed an MBA at Oxford University, adding a high-level business perspective and context to my work. I look forward to working with you to take your Tableau skills to the next level! 

Read More

icon
More courses by Ben Young

$18.99

All courses by Ben Young

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

All Excel courses

icon
Reviews

4.5

705 ratings on Udemy

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

Write a review

By Fernando Reyna Duque on 12/28/2020

Nice work. Good course if taken as an Elementary 70-779 preparation. Not a 5-star though. I believe the lectures about DAX could be better. Specifically, the filter and row contexts should be explained deeply so that the attendee with no previous DAX knowledge can understand and build solid knowledge. Another example: the difference betwen SUM and SUMX is not explained. The CALCULATE, ALL and FILTER functions also deserve a much more detailed description. I guess someone with no previous DAX knowledge would get very confused.

By Sharubala Gunasekar on 12/23/2020

Amazing and excellent course! Ben is a great story-teller. He explained all topics and it's functionality through a practical example which was very easy to follow. He covered all the necessary topics needed to learn for the exam.

By Clayton A on 11/3/2020

Ben does a great job of thoroughly explaining the concepts as he demonstrates them. I really like that he shows the gotchas so you don't make those mistakes. Ben really knows his stuff and presents it in bite size chunks that you can follow and understand. I highly recommend this course!

By Roberto Alcivar Andrade on 9/12/2020

Amazing course, I graduated 3 years ago and during this time I just used Excel for basic stuff so I feel like I was rusted, It has been great to find this course, get the rust out and learn new excel features. Very worthy in every aspect. You won't regret it.

By Faisal Mohammed on 7/27/2020

One of the best course if someone wants to prepare for Excel Data Analysis. Can include more advanced topics on DAX and Visualizations. But in 4 hrs, this was great and concise. Videos are bit blurred in Modeling Data section.

By Joy Sunga on 7/3/2020

This is very helpful. I learned a lot since I am someone who knows very little about data transformation and pivot functions. Having the lectures archived, I will be able to go back and review specific functionalities as often as I need to. The only comment I have is there are video parts where the screen gets blurry. I hope you get to correct this. Other than this, I'd say the learning experiemce is worth it. I didn't know MS Excel can be a powerful tool. Thank you very much, SuperDataScience & Udemy.

By Muhammad Hisyam Jaelani on 7/2/2020

I think this course would be better if add a resume from every course. So if I or another user want to review the course, we can just see a resume. The course is very good but maybe the server or something like that must can be better than this. I often experienced buffer when I stream the video

By James Gachanja on 7/1/2020

Superb course. Very helpful to me as I will use what I have learnt in my day to day work. The lecturer is also superb, very clear and concise and actually making the concept sink in very well. Highly recommended course for learning advanced Excel!

By Rohan Kumar on 3/25/2020

I have been using excel since years but never realized it's power and depth of features on offer. This course does a very good job in introducing these features hence I will keep in mind in future in my work. Presentation is good and explanation is clear .

By David Mitchell on 2/22/2020

Good, but 1/3 of course is missing/TBD! Why publish a course when incomplete? Not a good practice.

Showing all 10 reviews on CourseDuck

Read all 705 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 : 90 / 100

MS Excel Exam Guide: Analyzing and Visualizing Data
Visit course on Udemy Write a review
  • Video Duration: icon 4.2h
  • Price: $79.99
  • Provider: icon Udemy
  • Updated: icon June 2024
  • Level: Beginner Beginner
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com