17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
[ CourseWikia.com ] Excel - Power Query (Get And Transform)
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
Power Query is a feature in Excel that allows you to quickly import data from multiple sources and easily clean, transform, and reshape it to suit your needs. Follow along with Excel MVP Oz du Soleil as he shows you how to use this powerful, time-saving tool. Oz nstrates how to import, merge, rearrange, and clean data, as well as how to repeat the process with one click if the data changes. Discover how to split columns, unpivot data, and use joins to merge, segment, and compare datasets. Oz offers dozens of techniques and tips in this comprehensive training.
If You Need More Stuff, kindly Visit and Support Us -->> https://FreeCourseWeb.com
Get More Tutorials and Support Us -->> https://DevCourseWeb.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/01 - Introduction/01 - Make your data useful with Power Query.mp4
3.4 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.9 MB
~Get Your Files Here !/02 - 1. What Is Power Query (Get & Transform)/01 - Power Query example.srt
12.3 KB
~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 !/02 - 1. What Is Power Query (Get & Transform)/02 - Differences between Excel and Power Query.srt
11.1 KB
~Get Your Files Here !/03 - 2. Working with Queries/01 - Data types explained.mp4
17.9 MB
~Get Your Files Here !/03 - 2. Working with Queries/01 - Data types explained.srt
8.5 KB
~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 !/03 - 2. Working with Queries/02 - Query data from a table or range.srt
4.7 KB
~Get Your Files Here !/03 - 2. Working with Queries/03 - Query data from another Excel file.mp4
7.9 MB
~Get Your Files Here !/03 - 2. Working with Queries/03 - Query data from another Excel file.srt
4.2 KB
~Get Your Files Here !/03 - 2. Working with Queries/04 - Load data only as a connection.mp4
10.7 MB
~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/01 - Fill up and fill down.mp4
11.1 MB
~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/02 - Split column by delimiter.mp4
16.2 MB
~Get Your Files Here !/04 - 3. Working with Columns/02 - Split column by delimiter.srt
7 KB
~Get Your Files Here !/04 - 3. Working with Columns/03 - Split into rows.mp4
11.9 MB
~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/04 - Add conditional and custom columns.mp4
13.4 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.9 MB
~Get Your Files Here !/04 - 3. Working with Columns/05 - Add column by example.srt
11.7 KB
~Get Your Files Here !/04 - 3. Working with Columns/06 - Merge columns.mp4
8.8 MB
~Get Your Files Here !/04 - 3. Working with Columns/06 - Merge columns.srt
5.1 KB
~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/07 - Sort and filter data in Power Query.srt
5.7 KB
~Get Your Files Here !/05 - 4. Working with Formulas/01 - Use IF formulas.mp4
7.1 MB
~Get Your Files Here !/05 - 4. Working with Formulas/01 - Use IF formulas.srt
3.6 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.1 KB
~Get Your Files Here !/05 - 4. Working with Formulas/03 - AddDays to determine the deadline.mp4
9.5 MB
~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/01 - Pivot data in Power Query.mp4
7.2 MB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/01 - Pivot data in Power Query.srt
3.3 KB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/02 - Pivot and append data.mp4
11.6 MB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/02 - Pivot and append data.srt
5.6 KB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/03 - Pivot and don't aggregate.mp4
8.4 MB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/03 - Pivot and don't aggregate.srt
4.2 KB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/04 - Unpivot data in Power Query.mp4
16.5 MB
~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/04 - Unpivot data in Power Query.srt
7.3 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.7 KB
~Get Your Files Here !/07 - 6. Grouping/01 - Group By feature.mp4
14.4 MB
~Get Your Files Here !/07 - 6. Grouping/01 - Group By feature.srt
6.2 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.6 KB
~Get Your Files Here !/08 - 7. Appending Queries/02 - Multiple tables.mp4
17.6 MB
~Get Your Files Here !/08 - 7. Appending Queries/02 - Multiple tables.srt
7.8 KB
~Get Your Files Here !/08 - 7. Appending Queries/03 - Query data from a folder and import multiple files.mp4
21 MB
~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 !/08 - 7. Appending Queries/04 - Append multiple sheets.mp4
14 MB
~Get Your Files Here !/08 - 7. Appending Queries/04 - Append multiple sheets.srt
5.9 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.5 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.5 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/02 - Walk through all six joins.mp4
35.9 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/02 - Walk through all six joins.srt
15.8 KB
~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/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.5 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/04 - Outer join versus XLOOKUP.srt
3.4 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/05 - Merge with multiple fields.mp4
9.6 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/05 - Merge with multiple fields.srt
4.5 KB
~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 !/10 - 9. Merging Data with Joins/06 - Approximate match equivalent of VLOOKUP Binning.srt
6.1 KB
~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 !/10 - 9. Merging Data with Joins/07 - Approximate match equivalent of VLOOKUP Conditional column.srt
3.7 KB
~Get Your Files Here !/10 - 9. Merging Data with Joins/08 - Cross Join.mp4
8.6 MB
~Get Your Files Here !/10 - 9. Merging Data with Joins/08 - Cross Join.srt
4.2 KB
~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 !/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 !/12 - 11. Fuzzy Matching/01 - Fuzzy matching by percentage.mp4
24.5 MB
~Get Your Files Here !/12 - 11. Fuzzy Matching/01 - Fuzzy matching by percentage.srt
9.5 KB
~Get Your Files Here !/12 - 11. Fuzzy Matching/02 - Merging inconsistent data with a transformation table.mp4
16.5 MB
~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/01 - Challenge setup.mp4
4.5 MB
~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/01 - Challenge setup.srt
1.3 KB
~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 !/13 - 12. Apply Your Learning with Real-World Challenges/02 - Real-world challenge 1 Projects.srt
7.2 KB
~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 !/13 - 12. Apply Your Learning with Real-World Challenges/03 - Real-world challenge 2 Donors.srt
7.5 KB
~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 !/13 - 12. Apply Your Learning with Real-World Challenges/04 - Real-world challenge 3 Soccer team.srt
7.6 KB
~Get Your Files Here !/14 - Conclusion/01 - Next steps.mp4
4.1 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.9 KB
~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/02_01_Data Types.xlsx
15 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/02_04_Connection Only.xlsx
10.3 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.6 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_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