Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.


MS Excel Exam Guide: Analyzing and Visualizing Data

via Udemy


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

What you'll 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

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.

Taught by

Ben Young, Ligency I Team and Ligency Team


4.5 rating at Udemy based on 700 ratings

Start your review of MS Excel Exam Guide: Analyzing and Visualizing Data

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.