Don't like banners? Log in and we will make sure you see no banners. For free.
[ CourseWikia.com ] Excel - Power Query (Get and Transform)

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

Other
Size
586 MB
Seeders
2
Leechers
2
Files
98
Category
Other
Added
at 5:25pm GMT+1
Infohash
d92b2bf736a9b676b59ae8636dc7c3c5af963c5d
Direct linkTorrent fileDownload now
Don't like banners? Log in and we will make sure you see no banners. For free.

Description
[ CourseWikia.com ] Excel: Power Query (Get & Transform)



If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com







Released 4/2024

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch

Skill Level: Intermediate | Genre: eLearning | Language: English + srt | Duration: 3h 43m | Size: 585 MB



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...



Image error



Image error

File list
  • [ CourseWikia.com ] Excel - Power Query (Get and Transform)
  • ~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 12.8 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
14 MB110
14 MB10
8 MB10
37 MB00
1.5 GB03
329 MB01
490 MB02
3 GB00
2.9 GB00
707 MB00
3.4 GB00
2.2 GB00
1.1 GB00
1.1 GB02
1.2 GB00