MS Excel Exam Guide: Analyzing and Visualizing Data

Focused View

Ligency I Team,Ligency Team,Ben Young

4:00:56

34 View

1 - Introduction

1 - Welcome and Course Overview.mp4

03:10

2 - Excel Versions and Addins.mp4

06:00

3 - EXTRA Learning Path.html

4 - Get the Materials.html

2 - Consume and Transform Data Using Microsoft Excel

5 - Company Background and Business Case.mp4

05:22

5 - Excel-70-779.zip

6 - Manual Lookups using VLOOKUP and Tables.mp4

09:49

7 - Easier VLOOKUPs using Tables.mp4

05:23

8 - Limitations of Manual Lookups and Combinations.mp4

06:32

9 - Excel-70-779.zip

9 - Introduction to Queries.mp4

12:35

10 - Transformations.mp4

16:11

11 - Advanced Transformations Append and Merge.mp4

14:37

11 - Join-Types.pptx

12 - Advanced Transformations Pivot Unpivot and Group By.mp4

07:06

12 - Pivot-and-Group-By-Practice.xlsx

13 - Importing CSVs and Multiple Files.mp4

13:14

3 - Modeling Data using Microsoft Excel

14 - Introduction to Excels Data Model.mp4

11:50

14 - Mortgages-Data-Model.xlsx

15 - Enhancing your Data Model with Relationships.mp4

11:33

16 - Introduction to Measures and DAX.mp4

08:10

17 - Common DAX Functions.mp4

19:29

18 - Dates and Calendar Tables.mp4

19:28

19 - Advanced DAX Functions.mp4

15:52

19 - Advanced-DAX-Formulas.pptx

19 - Mortgages-Data-Model-Advanced-DAX-Starter.xlsx

20 - Advanced DAX Functions Pt 2.mp4

16:16

21 - Basic MDX Functions.mp4

10:03

22 - Creating KPIs.mp4

05:38

23 - Organizing Data using Hierarchies.mp4

04:27

24 - Optimizing your Data Model.mp4

04:44

4 - Presenting and Visualizing Data with Microsoft Excel

25 - Presenting-Data-Practice.xlsx

26 - Presenting Data Using Pivot Charts.mp4

08:30

27 - Quick note around Power BI Publisher for Excel.html

28 - How Microsoft Excel Integrates with Power BI.mp4

04:57

28 - Power BI Publisher for Microsoft Excel addin download.txt

5 - Additional Resources

29 - Exam formats and question types reference.txt

29 - Types of Questions on the Excel 70779 Exam.html

6 - Congratulations Dont forget your Prize

30 - BONUS Cloud Skills for ML AI COUPON inside.html

Description

Gain Skills in Data Analysis with Excel. Pass the Microsoft 70-779 Exam. Grow Your Career with an Excel Certification.

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

Who is this for?

Data Analysts who want to expand their analytical toolkit

And Business Analysts looking to further their technical abilities

What You Need to Know?

PC with internet connection

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

Hi there,We are the Ligency team. You will be hearing from us when new Ligency courses are released, when we publish new podcasts, blogs, share cheatsheets and more!We are here to help you stay on the cutting edge of Data Science and Technology. See you in class,Sincerely,Ligency Team!

Ligency Team

Instructor's Courses

Hi there,We are the Ligency PR and Marketing team. You will be hearing from us when new courses are released, when we publish new podcasts, blogs, share cheatsheets and more!We are here to help you stay on the cutting edge of Data Science and Technology.See you in class,Sincerely,The Real People at Ligency

Ben Young

Instructor's Courses

Hello! My name is Ben Young. My background is in data analytics and visualization, especially in the context of business strategy. I've worked in multiple industries (insurance, sales, non-profit, etc.) and across every job, analysis, and deliverable, there has been a constant need for data and the ability to interpret it. Tableau is my tool of choice, one that I've spent four years mastering, earning multiple professional certifications and tutoring hundreds of students in person and online. To top it all off, I recently completed an MBA at Oxford University, adding a high-level business perspective and context to my work. I look forward to working with you to take your Tableau skills to the next level!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.