Microsoft Excel: Essential Training for the 70-779 Exam, Gain Skills in Data Analysis with Excel. Pass the Microsoft 70-779 Exam. Grow Your Career with an Excel Certification.
PREVIEW THIS COURSE - GET COUPON CODE
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 P
Advertisement
