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.55 (702 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
MS Excel Exam Guide: Analyzing and Visualizing Data
20,969
students
4 hours
content
Jan 2025
last update
$79.99
regular price

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

Screenshots

MS Excel Exam Guide: Analyzing and Visualizing Data - Screenshot_01MS Excel Exam Guide: Analyzing and Visualizing Data - Screenshot_02MS Excel Exam Guide: Analyzing and Visualizing Data - Screenshot_03MS Excel Exam Guide: Analyzing and Visualizing Data - Screenshot_04
2751520
udemy ID
1/10/2020
course created date
2/25/2020
course indexed date
Bot
course submited by