[ CourseWikia.com ] Excel - Power Query (Get and Transform)
大小
585.77 MB
文件数
136
Info Hash:
D92B2BF736A9B676B59AE8636DC7C3C5AF963C5D
收录时间
2026-02-08 14:36:27
更新时间
2026-02-08 14:36:27
文件列表 (136)
Get Bonus Downloads Here.url
181 B
~Get Your Files Here !/01 - Introduction/01 - Make your data useful with Power Query.mp4
3.38 MB
~Get Your Files Here !/01 - Introduction/01 - Make your data useful with Power Query.srt
1008 B
~Get Your Files Here !/02 - 1. What Is Power Query (Get & Transform)/01 - Power Query example.mp4
24.89 MB
~Get Your Files Here !/02 - 1. What Is Power Query (Get & Transform)/01 - Power Query example.srt
12.32 KB
~Get Your Files Here !/02 - 1. What Is Power Query (Get & Transform)/02 - Differences between Excel and Power Query.mp4
23.55 MB
~Get Your Files Here !/02 - 1. What Is Power Query (Get & Transform)/02 - Differences between Excel and Power Query.srt
11.13 KB
~Get Your Files Here !/03 - 2. Working with Queries/01 - Data types explained.mp4
17.93 MB
~Get Your Files Here !/03 - 2. Working with Queries/01 - Data types explained.srt
8.53 KB
~Get Your Files Here !/03 - 2. Working with Queries/02 - Query data from a table or range.mp4
9.28 MB
~Get Your Files Here !/03 - 2. Working with Queries/02 - Query data from a table or range.srt
4.73 KB
~Get Your Files Here !/03 - 2. Working with Queries/03 - Query data from another Excel file.mp4
7.87 MB
~Get Your Files Here !/03 - 2. Working with Queries/03 - Query data from another Excel file.srt
4.21 KB
~Get Your Files Here !/03 - 2. Working with Queries/04 - Load data only as a connection.mp4
10.75 MB
~Get Your Files Here !/03 - 2. Working with Queries/04 - Load data only as a connection.srt
5.73 KB
~Get Your Files Here !/04 - 3. Working with Columns/01 - Fill up and fill down.mp4
11.06 MB
~Get Your Files Here !/04 - 3. Working with Columns/01 - Fill up and fill down.srt
5.39 KB
~Get Your Files Here !/04 - 3. Working with Columns/02 - Split column by delimiter.mp4
16.17 MB
~Get Your Files Here !/04 - 3. Working with Columns/02 - Split column by delimiter.srt
6.98 KB
~Get Your Files Here !/04 - 3. Working with Columns/03 - Split into rows.mp4
11.87 MB
~Get Your Files Here !/04 - 3. Working with Columns/03 - Split into rows.srt
5.55 KB
~Get Your Files Here !/04 - 3. Working with Columns/04 - Add conditional and custom columns.mp4
13.42 MB
~Get Your Files Here !/04 - 3. Working with Columns/04 - Add conditional and custom columns.srt
6.2 KB
~Get Your Files Here !/04 - 3. Working with Columns/05 - Add column by example.mp4
24.94 MB
~Get Your Files Here !/04 - 3. Working with Columns/05 - Add column by example.srt
11.66 KB
~Get Your Files Here !/04 - 3. Working with Columns/06 - Merge columns.mp4
8.82 MB
~Get Your Files Here !/04 - 3. Working with Columns/06 - Merge columns.srt
5.09 KB
~Get Your Files Here !/04 - 3. Working with Columns/07 - Sort and filter data in Power Query.mp4
12.35 MB
~Get Your Files Here !/04 - 3. Working with Columns/07 - Sort and filter data in Power Query.srt
5.66 KB
~Get Your Files Here !/05 - 4. Working with Formulas/01 - Use IF formulas.mp4
7.06 MB
~Get Your Files Here !/05 - 4. Working with Formulas/01 - Use IF formulas.srt
3.63 KB
~Get Your Files Here !/05 - 4. Working with Formulas/02 - Nest IF and AND.mp4
8.7 MB
~Get Your Files Here !/05 - 4. Working with Formulas/02 - Nest IF and AND.srt
4.07 KB
~Get Your Files Here !/05 - 4. Working with Formulas/03 - AddDays to determine the deadline.mp4
9.55 MB
~Get Your Files Here !/05 - 4. Working with Formulas/03 - AddDays to determine the deadline.srt
4.32 KB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/01 - Pivot data in Power Query.mp4
7.16 MB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/01 - Pivot data in Power Query.srt
3.28 KB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/02 - Pivot and append data.mp4
11.57 MB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/02 - Pivot and append data.srt
5.64 KB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/03 - Pivot and don't aggregate.mp4
8.36 MB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/03 - Pivot and don't aggregate.srt
4.25 KB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/04 - Unpivot data in Power Query.mp4
16.46 MB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/04 - Unpivot data in Power Query.srt
7.32 KB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/05 - Unpivot warnings.mp4
7.4 MB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/05 - Unpivot warnings.srt
3.67 KB
~Get Your Files Here !/07 - 6. Grouping/01 - Group By feature.mp4
14.43 MB
~Get Your Files Here !/07 - 6. Grouping/01 - Group By feature.srt
6.24 KB
~Get Your Files Here !/08 - 7. Appending Queries/01 - Two data sets.mp4
7.9 MB
~Get Your Files Here !/08 - 7. Appending Queries/01 - Two data sets.srt
3.63 KB
~Get Your Files Here !/08 - 7. Appending Queries/02 - Multiple tables.mp4
17.58 MB
~Get Your Files Here !/08 - 7. Appending Queries/02 - Multiple tables.srt
7.82 KB
~Get Your Files Here !/08 - 7. Appending Queries/03 - Query data from a folder and import multiple files.mp4
21.01 MB
~Get Your Files Here !/08 - 7. Appending Queries/03 - Query data from a folder and import multiple files.srt
11.11 KB
~Get Your Files Here !/08 - 7. Appending Queries/04 - Append multiple sheets.mp4
14.03 MB
~Get Your Files Here !/08 - 7. Appending Queries/04 - Append multiple sheets.srt
5.86 KB
~Get Your Files Here !/09 - 8. Midterm Challenge/01 - Midterm challenge Get a count of all colors.mp4
19 MB
~Get Your Files Here !/09 - 8. Midterm Challenge/01 - Midterm challenge Get a count of all colors.srt
8.51 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/01 - Overview of joins in Power Query.mp4
9.5 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/01 - Overview of joins in Power Query.srt
7.48 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/02 - Walk through all six joins.mp4
35.86 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/02 - Walk through all six joins.srt
15.82 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/03 - Joins Left or right.mp4
6.77 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/03 - Joins Left or right.srt
2.7 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/04 - Outer join versus XLOOKUP.mp4
6.46 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/04 - Outer join versus XLOOKUP.srt
3.41 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/05 - Merge with multiple fields.mp4
9.58 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/05 - Merge with multiple fields.srt
4.52 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/06 - Approximate match equivalent of VLOOKUP Binning.mp4
14.57 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/06 - Approximate match equivalent of VLOOKUP Binning.srt
6.07 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/07 - Approximate match equivalent of VLOOKUP Conditional column.mp4
7.23 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/07 - Approximate match equivalent of VLOOKUP Conditional column.srt
3.72 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/08 - Cross Join.mp4
8.57 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/08 - Cross Join.srt
4.23 KB
~Get Your Files Here !/11 - 10. Drill Down to Create Variables/01 - Drill down to create a variable in Power Query.mp4
18.82 MB
~Get Your Files Here !/11 - 10. Drill Down to Create Variables/01 - Drill down to create a variable in Power Query.srt
8.38 KB
~Get Your Files Here !/12 - 11. Fuzzy Matching/01 - Fuzzy matching by percentage.mp4
24.48 MB
~Get Your Files Here !/12 - 11. Fuzzy Matching/01 - Fuzzy matching by percentage.srt
9.55 KB
~Get Your Files Here !/12 - 11. Fuzzy Matching/02 - Merging inconsistent data with a transformation table.mp4
16.46 MB
~Get Your Files Here !/12 - 11. Fuzzy Matching/02 - Merging inconsistent data with a transformation table.srt
7.61 KB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/01 - Challenge setup.mp4
4.46 MB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/01 - Challenge setup.srt
1.32 KB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/02 - Real-world challenge 1 Projects.mp4
15.31 MB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/02 - Real-world challenge 1 Projects.srt
7.24 KB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/03 - Real-world challenge 2 Donors.mp4
16.73 MB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/03 - Real-world challenge 2 Donors.srt
7.52 KB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/04 - Real-world challenge 3 Soccer team.mp4
19.17 MB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/04 - Real-world challenge 3 Soccer team.srt
7.56 KB
~Get Your Files Here !/14 - Conclusion/01 - Next steps.mp4
4.14 MB
~Get Your Files Here !/14 - Conclusion/01 - Next steps.srt
1.3 KB
~Get Your Files Here !/Bonus Resources.txt
386 B
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/01_02_Excel vs Power Query.xlsx
13.94 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/02_01_Data Types.xlsx
14.96 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/02_02_Query from a Table or Range.xlsx
12.47 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/02_04_Connection Only.xlsx
10.29 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_01_Fill Up Fill Down.xlsx
14.1 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_02_Import Survey Data.xlsx
11.56 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_02_Split by Delimiter.xlsx
13.26 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_03_Split into Rows.xlsx
14.2 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_04_Conditional and Custom Columns.xlsx
12.77 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_05_Column by Example.xlsx
12.73 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_06_Merging Columns.xlsx
14.26 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_07_Sort and Filter.xlsx
13.67 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/04_01_IF Formula.xlsx
13.8 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/04_02_Nested IF AND.xlsx
13.76 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/04_03_AddDays Function.xlsx
13.6 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_01_Pivot.xlsx
15.18 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_02_Pivot and Append.xlsx
19.83 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_03_Pivot - Dont Aggregate.xlsx
12.36 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_04_Unpivot.xlsx
16.51 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_05_Unpivot - Warning.xlsx
13.41 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/06_01_Grouping.xlsx
14.21 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_01_Append.xlsx
19.6 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_02_Append Multiple Datasets.xlsx
19.64 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_03_Magician Conference/Levitation.xlsx
9.02 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_03_Magician Conference/Magic as a Business.xlsx
9.05 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_03_Magician Conference/Mentalism.xlsx
9.77 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_03_Magician Conference/Street Magic.xlsx
8.98 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_03_Magician Conference/Working in Las Vegas.xlsx
8.98 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_04_Append Multiple Sheets.xlsx
16 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/08_01_MidTerm Challenge.xlsx
21.33 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_02_Joins.xlsx
12.58 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_03_Joins - Left Right.xlsx
16.2 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_04_OuterJoin XLOOKUP.xlsx
16.57 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_05_Merge Multiple Fields.xlsx
45.24 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_06_Approximate Match by Binning.xlsx
14.34 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_07_Approximate Match by Conditional Formatting.xlsx
14.3 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_08_Cross Join.xlsx
19.17 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/10_01_Drill Down.xlsx
28.39 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/11_01_Fuzzy Matching.xlsx
29.3 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/11_02_Transformation Table.xlsx
18.87 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_02_PQ Challenge - Projects - Solution.xlsx
34.79 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_02_PQ Challenge - Projects.xlsx
17.27 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_03_PQ Challenge - Donors - Solution.xlsx
35.16 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_03_PQ Challenge - Donors.xlsx
12.63 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_04_PQ Challenge Soccer Team - Solution.xlsx
125.91 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_04_PQ Challenge Soccer Team.xlsx
101.97 KB