MS Excel Exam Guide: Analyzing and Visualizing Data

MS Excel Exam Guide: Analyzing and Visualizing Data, available at $79.99, has an average rating of 4.5, with 34 lectures, 2 quizzes, based on 700 reviews, and has 20964 subscribers.

You will learn about 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 This course is ideal for individuals who are Data Analysts who want to expand their analytical toolkit or And Business Analysts looking to further their technical abilities It is particularly useful for Data Analysts who want to expand their analytical toolkit or And Business Analysts looking to further their technical abilities.

Enroll now: MS Excel Exam Guide: Analyzing and Visualizing Data

Summary

Title: MS Excel Exam Guide: Analyzing and Visualizing Data

Price: $79.99

Average Rating: 4.5

Number of Lectures: 34

Number of Quizzes: 2

Number of Published Lectures: 30

Number of Published Quizzes: 2

Number of Curriculum Items: 36

Number of Published Curriculum Objects: 32

Original Price: $199.99

Quality Status: approved

Status: Live

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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome and Course Overview

Lecture 2: Excel Versions and Add-ins

Lecture 3: EXTRA: Learning Path

Lecture 4: Get the Materials

Chapter 2: Consume and Transform Data Using Microsoft Excel

Lecture 1: Company Background and Business Case

Lecture 2: Manual Lookups using VLOOKUP and Tables

Lecture 3: Easier VLOOKUPs using Tables

Lecture 4: Limitations of Manual Lookups and Combinations

Lecture 5: Introduction to Queries

Lecture 6: Transformations

Lecture 7: Advanced Transformations – Append and Merge

Lecture 8: Advanced Transformations – Pivot, Unpivot, and Group By

Lecture 9: Importing CSVs and Multiple Files

Chapter 3: Modeling Data using Microsoft Excel

Lecture 1: Introduction to Excel's Data Model

Lecture 2: Enhancing your Data Model with Relationships

Lecture 3: Introduction to Measures and DAX

Lecture 4: Common DAX Functions

Lecture 5: Dates and Calendar Tables

Lecture 6: Advanced DAX Functions

Lecture 7: Advanced DAX Functions Pt. 2

Lecture 8: Basic MDX Functions

Lecture 9: Creating KPIs

Lecture 10: Organizing Data using Hierarchies

Lecture 11: Optimizing your Data Model

Chapter 4: Presenting and Visualizing Data with Microsoft Excel

Lecture 1: Creating and Using Pivot Tables

Lecture 2: Presenting Data Using Pivot Charts

Lecture 3: Quick note around Power BI Publisher for Excel

Lecture 4: How Microsoft Excel Integrates with Power BI

Chapter 5: Additional Resources

Lecture 1: Types of Questions on the Excel 70-779 Exam

Chapter 6: Congratulations!! Don't forget your Prize 🙂

Lecture 1: Bonus: How To UNLOCK Top Salaries (Live Training)

Instructors

Ben Young
Oxford MBA and Tableau Professional
SuperDataScience Team
Helping Data Scientists Succeed
Ligency Team
Helping Data Scientists Succeed

Rating Distribution

1 stars: 4 votes
2 stars: 5 votes
3 stars: 68 votes
4 stars: 238 votes
5 stars: 385 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu