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.

1 - Introduction

1 - Welcome and Course Overview

2 - Excel Versions and Addins

3 - EXTRA Learning Path.html

4 - Get the Materials.html

2 - Consume and Transform Data Using Microsoft Excel

5 - Company Background and Business Case

5 - Excel-70-779.zip

6 - Manual Lookups using VLOOKUP and Tables

7 - Easier VLOOKUPs using Tables

8 - Limitations of Manual Lookups and Combinations

9 - Excel-70-779.zip

9 - Introduction to Queries

10 - Transformations

11 - Advanced Transformations Append and Merge

11 - Join-Types.pptx

12 - Advanced Transformations Pivot Unpivot and Group By

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

13 - Importing CSVs and Multiple Files

3 - Modeling Data using Microsoft Excel

14 - Introduction to Excels Data Model

14 - Mortgages-Data-Model.xlsx

15 - Enhancing your Data Model with Relationships

16 - Introduction to Measures and DAX

17 - Common DAX Functions

18 - Dates and Calendar Tables

19 - Advanced DAX Functions

19 - Advanced-DAX-Formulas.pptx

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

20 - Advanced DAX Functions Pt 2

21 - Basic MDX Functions

22 - Creating KPIs

23 - Organizing Data using Hierarchies

24 - Optimizing your Data Model

4 - Presenting and Visualizing Data with Microsoft Excel

25 - Presenting-Data-Practice.xlsx

26 - Presenting Data Using Pivot Charts

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

28 - How Microsoft Excel Integrates with Power BI

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

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy