MS Excel Exam Guide: Analyzing and Visualizing Data
4.6 (410 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
20,360 students enrolled

MS Excel Exam Guide: Analyzing and Visualizing Data

Gain Skills in Data Analysis with Excel. Pass the Microsoft 70-779 Exam. Grow Your Career with an Excel Certification.
4.6 (410 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
20,360 students enrolled
Last updated 8/2020
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 4 articles
  • 8 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Requirements
  • PC with internet connection
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.


Who this course is for:
  • Data Analysts who want to expand their analytical toolkit
  • And Business Analysts looking to further their technical abilities
Course content
Expand all 29 lectures 04:12:29
+ Consume and Transform Data Using Microsoft Excel
9 lectures 01:30:49
Company Background and Business Case
05:22
Manual Lookups using VLOOKUP and Tables
09:49
Limitations of Manual Lookups and Combinations
06:32
Transformations
16:11
Advanced Transformations - Append and Merge
14:37
Advanced Transformations - Pivot, Unpivot, and Group By
07:06
Importing CSVs and Multiple Files
13:14
Connections, Queries, and Transformations
3 questions
+ Modeling Data using Microsoft Excel
11 lectures 02:07:30
Introduction to Excel's Data Model
11:50
Enhancing your Data Model with Relationships
11:33
Introduction to Measures and DAX
08:10
Common DAX Functions
19:29
Dates and Calendar Tables
19:28
Advanced DAX Functions
15:52
Basic MDX Functions
10:03
Creating KPIs
05:38
Organizing Data using Hierarchies
04:27
Optimizing your Data Model
04:44
Relationships, DAX, and KPIs
3 questions
+ Presenting and Visualizing Data with Microsoft Excel
4 lectures 23:53
Creating and Using Pivot Tables
10:09
Presenting Data Using Pivot Charts
08:30
Quick note around Power BI Publisher for Excel
00:17
How Microsoft Excel Integrates with Power BI
04:57
+ Additional Resources
1 lecture 00:27
Types of Questions on the Excel 70-779 Exam
00:27