Course Content
المحتوى
0/43
01 Introduction to Excel Power Query: Getting Started
06:17
01 Introduction to Excel Power Query: Getting Started
06:17
02 Installing the Power Query Add-in for Excel 2010 and 2013
06:17
03 Overview of Query Editor in Power Query
06:17
04 Importing Data from the Web Using Power Query
06:17
05 Importing Data from TEXT Files Using Power Query
06:17
06 Importing Data from CSV Files into Excel Using Power Query
06:17
07 Importing Data from Another Excel Workbook Using Power Query
06:17
08 Getting Data from the Current Excel Workbook to Power Query
06:17
09 Combining Excel Tables in the Same Workbook Using Power Query Append Method
06:17
10 Combining Excel Tables in the Same Workbook Using Power Query Formula Method
06:17
11 Merging Tables in Excel Using Power Query
06:17
12 Combining Tables from Different Workbooks into One Table in Excel Using Power Query
06:17
13 Combining All Excel Files in a Folder Using Power Query
06:17
14 Combining CSV or Text Files in a Folder Using Power Query
06:17
15 Getting a List of File Names from a Folder in Excel Using Power Query
06:17
16 Splitting Columns in Power Query
06:17
17 Merging Columns in Power Query
06:17
18 Filtering Data in Power Query
06:17
19 Sorting Data in Power Query
06:17
20 Replacing Values in Power Query
06:17
21 Filling Down in Power Query
06:17
22 Transposing Data in Power Query
06:17
23 Grouping Data in Power Query
06:17
24 Unpivoting Data in Excel Using Power Query
06:17
25 Managing Dates in Power Query Using Locale
06:17
26 Column Operations: Rename, Move, Delete, Duplicate in Power Query
06:17
27 Adding Date and Time Columns in Power Query
06:17
28 Transforming Text with Extract Options in Power Query
06:17
29 Adding an Index Column in Power Query
06:17
30 Adding a Custom Column in Power Query
06:17
31 Adding a Conditional Column in Power Query
06:17
32 Adding Columns from Examples in Power Query
06:17
33 Overview of Power Query Functions
06:17
34 Useful Text Functions in Power Query
06:17
35 Creating IF OR and IF AND Functions in Power Query
06:17
36 Overview of M Formula Language in Power Query
06:17
37 Inserting Comments in M Code in Power Query
06:17
38 Converting Queries to Functions in Power Query
06:17
39 Extracting Data from a Table Based on User Selection in Excel Using Power Query
06:17
40 Getting File Names from a Folder Based on User Selection in Excel Using Power Query
06:17
41 Refreshing Queries in Excel Power Query
06:17
Final Exam - Mastering Excel Power Query: A Comprehensive Guide
Mastering Excel Power Query: A Comprehensive Guide

This lesson teaches you how to aggregate all Excel files from a specified folder into one dataset.

Previous
Next
0% Complete