Microsoft Excel Training – Power Pivot, Power Query & DAX

سرفصل های دوره

Learn Advanced Excel analysis using Power Query, Power Pivot and DAX from Excel experts, Simon Sez IT

1. Introduction

1. Welcome and Overview

2. WATCH ME Essential Information for a Successful Training Experience

3.1 Exercise Files.zip

3. DOWNLOAD ME Course Exercise Files.html

4.1 PowerQuery, PowerPivot and Dax Demo Files.zip

4. DOWNLOAD ME Course Demo Files.html

5. What is Power Query

6. What is Power Pivot

7. Section 1 Quiz.html

2. Getting Started with Power Query

1. Exploring the Power Query Editor

2. Common Power Query Transformations

3. Editing an Existing Query

4. Import Multiple Files from a Folder

5. Connect to Data in Another Excel Workbook

6. IMPORTANT Checking the Location of your Querys Source

7. Get Data From the Web

8. Practise Exercise

9. Section 2 Quiz.html

3. Useful Power Query Features

1. Unpivoting Columns

2. Combine Data from Multiple Tables with Merge Queries

3. Use Merge Queries to Compare Two Tables

4. Stack Data into One Table with Append Queries

5. Duplicating and Referencing Queries

6. Grouping and Aggregating Data

7. Conditional Columns in Power Query

8. Practise Exercise

9. Section 3 Quiz.html

4. Creating the Data Model

1. Enable the Power Pivot Add-In

2. Understanding the Power Pivot Window

3. Creating Relationships Between tables

4. Managing the Relationships of the Model

5. Creating a PivotTable from the Data Model

6. Hide Fields from Client Tools

7. Grouping Queries

8. Practise Exercise

9. Section 4 Quiz.html

5. Introduction to DAX

1. Why use DAX

2. Creating Calculated Columns with DAX

3. Creating your First DAX Measure

4. The COUNTROWS Function

5. SUMX and RELATED Functions

6. Practise Exercise

7. Section 5 Quiz.html

6. More DAX Measures

1. Create a Date Table in Power Pivot

2. The CALCULATE Function

3. The DIVIDE Function

4. Using the DATESYTD Function

5. Calculate the Percentage of a Total

6. Practise Exercise

7. Section 6 Quiz.html

7. Using PivotTables and Slicers

1. Create PivotTables and PivotCharts

2. Using Slicers with your PivotTables

3. Create a Top 10 PivotTable

4. Practise Exercise

5. Section 7 Quiz.html

8. Closing

1. Wrap Up

9. Extras

1. EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar

2.1 PC Excel Most Used.pdf

2. EXTRA RESOURCE The Most Frequently Used Excel Shortcuts - Infographic.html

10. Bonuses

1. Ten Excel Tips and Tricks - Part 1

2. Ten Excel Tips and Tricks - Part 2

3. Ten Excel Tips and Tricks - Part 3

45,900 تومان

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

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

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

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