[ CourseWikia.com ] Excel - Power Query (Get and Transform)

Creation Time	Sept. 13, 2024, 3:31 a.m.
Last Access Time	April 29, 2025, 11:48 p.m.
File Size	585.8 MB
Keywords	and Power Get Excel CourseWikia - Transform Query com
Total Requests	137
Total Files	136
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

~Get Your Files Here !/10 - 9. Merging Data with Joins/02 - Walk through all six joins.mp4 35.9 MB
~Get Your Files Here !/04 - 3. Working with Columns/05 - Add column by example.mp4 24.9 MB
~Get Your Files Here !/02 - 1. What Is Power Query (Get & Transform)/01 - Power Query example.mp4 24.9 MB
~Get Your Files Here !/12 - 11. Fuzzy Matching/01 - Fuzzy matching by percentage.mp4 24.5 MB
~Get Your Files Here !/02 - 1. What Is Power Query (Get & Transform)/02 - Differences between Excel and Power Query.mp4 23.6 MB
~Get Your Files Here !/08 - 7. Appending Queries/03 - Query data from a folder and import multiple files.mp4 21.0 MB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/04 - Real-world challenge 3 Soccer team.mp4 19.2 MB
~Get Your Files Here !/09 - 8. Midterm Challenge/01 - Midterm challenge Get a count of all colors.mp4 19.0 MB
~Get Your Files Here !/11 - 10. Drill Down to Create Variables/01 - Drill down to create a variable in Power Query.mp4 18.8 MB
~Get Your Files Here !/03 - 2. Working with Queries/01 - Data types explained.mp4 17.9 MB
~Get Your Files Here !/08 - 7. Appending Queries/02 - Multiple tables.mp4 17.6 MB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/03 - Real-world challenge 2 Donors.mp4 16.7 MB
~Get Your Files Here !/12 - 11. Fuzzy Matching/02 - Merging inconsistent data with a transformation table.mp4 16.5 MB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/04 - Unpivot data in Power Query.mp4 16.5 MB
~Get Your Files Here !/04 - 3. Working with Columns/02 - Split column by delimiter.mp4 16.2 MB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/02 - Real-world challenge 1 Projects.mp4 15.3 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/06 - Approximate match equivalent of VLOOKUP Binning.mp4 14.6 MB
~Get Your Files Here !/07 - 6. Grouping/01 - Group By feature.mp4 14.4 MB
~Get Your Files Here !/08 - 7. Appending Queries/04 - Append multiple sheets.mp4 14.0 MB
~Get Your Files Here !/04 - 3. Working with Columns/04 - Add conditional and custom columns.mp4 13.4 MB
~Get Your Files Here !/04 - 3. Working with Columns/07 - Sort and filter data in Power Query.mp4 12.3 MB
~Get Your Files Here !/04 - 3. Working with Columns/03 - Split into rows.mp4 11.9 MB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/02 - Pivot and append data.mp4 11.6 MB
~Get Your Files Here !/04 - 3. Working with Columns/01 - Fill up and fill down.mp4 11.1 MB
~Get Your Files Here !/03 - 2. Working with Queries/04 - Load data only as a connection.mp4 10.7 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/05 - Merge with multiple fields.mp4 9.6 MB
~Get Your Files Here !/05 - 4. Working with Formulas/03 - AddDays to determine the deadline.mp4 9.5 MB
~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 !/03 - 2. Working with Queries/02 - Query data from a table or range.mp4 9.3 MB
~Get Your Files Here !/04 - 3. Working with Columns/06 - Merge columns.mp4 8.8 MB
~Get Your Files Here !/05 - 4. Working with Formulas/02 - Nest IF and AND.mp4 8.7 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/08 - Cross Join.mp4 8.6 MB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/03 - Pivot and don't aggregate.mp4 8.4 MB
~Get Your Files Here !/08 - 7. Appending Queries/01 - Two data sets.mp4 7.9 MB
~Get Your Files Here !/03 - 2. Working with Queries/03 - Query data from another Excel file.mp4 7.9 MB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/05 - Unpivot warnings.mp4 7.4 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/07 - Approximate match equivalent of VLOOKUP Conditional column.mp4 7.2 MB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/01 - Pivot data in Power Query.mp4 7.2 MB
~Get Your Files Here !/05 - 4. Working with Formulas/01 - Use IF formulas.mp4 7.1 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/03 - Joins Left or right.mp4 6.8 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/04 - Outer join versus XLOOKUP.mp4 6.5 MB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/01 - Challenge setup.mp4 4.5 MB
~Get Your Files Here !/14 - Conclusion/01 - Next steps.mp4 4.1 MB
~Get Your Files Here !/01 - Introduction/01 - Make your data useful with Power Query.mp4 3.4 MB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_04_PQ Challenge Soccer Team - Solution.xlsx 125.9 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_04_PQ Challenge Soccer Team.xlsx 102.0 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_05_Merge Multiple Fields.xlsx 45.2 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_03_PQ Challenge - Donors - Solution.xlsx 35.2 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_02_PQ Challenge - Projects - Solution.xlsx 34.8 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/10_01_Drill Down.xlsx 28.4 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/08_01_MidTerm Challenge.xlsx 21.3 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_02_Pivot and Append.xlsx 19.8 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_02_Append Multiple Datasets.xlsx 19.6 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/09_08_Cross Join.xlsx 19.2 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/11_02_Transformation Table.xlsx 18.9 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_02_PQ Challenge - Projects.xlsx 17.3 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_04_OuterJoin XLOOKUP.xlsx 16.6 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_04_Unpivot.xlsx 16.5 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/07_04_Append Multiple Sheets.xlsx 16.0 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/02 - Walk through all six joins.srt 15.8 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_01_Pivot.xlsx 15.2 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/02_01_Data Types.xlsx 15.0 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_06_Approximate Match by Binning.xlsx 14.3 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/03_06_Merging Columns.xlsx 14.3 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/06_01_Grouping.xlsx 14.2 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_01_Fill Up Fill Down.xlsx 14.1 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/01_02_Excel vs Power Query.xlsx 13.9 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.8 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_07_Sort and Filter.xlsx 13.7 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_05_Unpivot - Warning.xlsx 13.4 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_02_Split by Delimiter.xlsx 13.3 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_04_Conditional and Custom Columns.xlsx 12.8 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_05_Column by Example.xlsx 12.7 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_03_PQ Challenge - Donors.xlsx 12.6 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_02_Joins.xlsx 12.6 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/02_02_Query from a Table or Range.xlsx 12.5 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_03_Pivot - Dont Aggregate.xlsx 12.4 KB
~Get Your Files Here !/02 - 1. What Is Power Query (Get & Transform)/01 - Power Query example.srt 12.3 KB
~Get Your Files Here !/04 - 3. Working with Columns/05 - Add column by example.srt 11.7 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_02_Import Survey Data.xlsx 11.6 KB
~Get Your Files Here !/02 - 1. What Is Power Query (Get & Transform)/02 - Differences between Excel and Power Query.srt 11.1 KB
~Get Your Files Here !/08 - 7. Appending Queries/03 - Query data from a folder and import multiple files.srt 11.1 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/02_04_Connection Only.xlsx 10.3 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_03_Magician Conference/Mentalism.xlsx 9.8 KB
~Get Your Files Here !/12 - 11. Fuzzy Matching/01 - Fuzzy matching by percentage.srt 9.5 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_03_Magician Conference/Magic as a Business.xlsx 9.1 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_03_Magician Conference/Levitation.xlsx 9.0 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_03_Magician Conference/Working in Las Vegas.xlsx 9.0 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_03_Magician Conference/Street Magic.xlsx 9.0 KB
~Get Your Files Here !/03 - 2. Working with Queries/01 - Data types explained.srt 8.5 KB
~Get Your Files Here !/09 - 8. Midterm Challenge/01 - Midterm challenge Get a count of all colors.srt 8.5 KB
~Get Your Files Here !/11 - 10. Drill Down to Create Variables/01 - Drill down to create a variable in Power Query.srt 8.4 KB
~Get Your Files Here !/08 - 7. Appending Queries/02 - Multiple tables.srt 7.8 KB
~Get Your Files Here !/12 - 11. Fuzzy Matching/02 - Merging inconsistent data with a transformation table.srt 7.6 KB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/04 - Real-world challenge 3 Soccer team.srt 7.6 KB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/03 - Real-world challenge 2 Donors.srt 7.5 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/01 - Overview of joins in Power Query.srt 7.5 KB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/04 - Unpivot data in Power Query.srt 7.3 KB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/02 - Real-world challenge 1 Projects.srt 7.2 KB
~Get Your Files Here !/04 - 3. Working with Columns/02 - Split column by delimiter.srt 7.0 KB
~Get Your Files Here !/07 - 6. Grouping/01 - Group By feature.srt 6.2 KB
~Get Your Files Here !/04 - 3. Working with Columns/04 - Add conditional and custom columns.srt 6.2 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/06 - Approximate match equivalent of VLOOKUP Binning.srt 6.1 KB
~Get Your Files Here !/08 - 7. Appending Queries/04 - Append multiple sheets.srt 5.9 KB
~Get Your Files Here !/03 - 2. Working with Queries/04 - Load data only as a connection.srt 5.7 KB
~Get Your Files Here !/04 - 3. Working with Columns/07 - Sort and filter data in Power Query.srt 5.7 KB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/02 - Pivot and append data.srt 5.6 KB
~Get Your Files Here !/04 - 3. Working with Columns/03 - Split into rows.srt 5.5 KB
~Get Your Files Here !/04 - 3. Working with Columns/01 - Fill up and fill down.srt 5.4 KB
~Get Your Files Here !/04 - 3. Working with Columns/06 - Merge columns.srt 5.1 KB
~Get Your Files Here !/03 - 2. Working with Queries/02 - Query data from a table or range.srt 4.7 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/05 - Merge with multiple fields.srt 4.5 KB
~Get Your Files Here !/05 - 4. Working with Formulas/03 - AddDays to determine the deadline.srt 4.3 KB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/03 - Pivot and don't aggregate.srt 4.2 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/08 - Cross Join.srt 4.2 KB
~Get Your Files Here !/03 - 2. Working with Queries/03 - Query data from another Excel file.srt 4.2 KB
~Get Your Files Here !/05 - 4. Working with Formulas/02 - Nest IF and AND.srt 4.1 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/07 - Approximate match equivalent of VLOOKUP Conditional column.srt 3.7 KB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/05 - Unpivot warnings.srt 3.7 KB
~Get Your Files Here !/05 - 4. Working with Formulas/01 - Use IF formulas.srt 3.6 KB
~Get Your Files Here !/08 - 7. Appending Queries/01 - Two data sets.srt 3.6 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/04 - Outer join versus XLOOKUP.srt 3.4 KB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/01 - Pivot data in Power Query.srt 3.3 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/03 - Joins Left or right.srt 2.7 KB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/01 - Challenge setup.srt 1.3 KB
~Get Your Files Here !/14 - Conclusion/01 - Next steps.srt 1.3 KB
~Get Your Files Here !/01 - Introduction/01 - Make your data useful with Power Query.srt 1008 bytes
~Get Your Files Here !/Bonus Resources.txt 386 bytes
Get Bonus Downloads Here.url 181 bytes

[ CourseWikia.com ] Excel - Power Query (Get and Transform)

File List

Download Torrent

Related Resources

Copyright Infringement