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