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.

Created by: Ben Young
Oxford MBA and Tableau Professional

Created by: SuperDataScience Team
Helping Data Scientists Succeed

Created by: Ligency Team
Helping Data Scientists Succeed

What Will I 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

Target audience

• Data Analysts who want to expand their analytical toolkit
• And Business Analysts looking to further their technical abilities