Excel - Power Query (Get and Transform)

seeders: 37
leechers: 13
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 90
  • Language: English

Files

[ CourseWikia.com ] Excel - Power Query (Get and Transform)
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 01 - Introduction
    • 01 - Make your data useful with Power Query.mp4 (3.4 MB)
    • 01 - Make your data useful with Power Query.srt (1.0 KB)
    02 - 1. What Is Power Query (Get & Transform)
    • 01 - Power Query example.mp4 (24.9 MB)
    • 01 - Power Query example.srt (12.3 KB)
    • 02 - Differences between Excel and Power Query.mp4 (23.6 MB)
    • 02 - Differences between Excel and Power Query.srt (11.1 KB)
    03 - 2. Working with Queries
    • 01 - Data types explained.mp4 (17.9 MB)
    • 01 - Data types explained.srt (8.5 KB)
    • 02 - Query data from a table or range.mp4 (9.3 MB)
    • 02 - Query data from a table or range.srt (4.7 KB)
    • 03 - Query data from another Excel file.mp4 (7.9 MB)
    • 03 - Query data from another Excel file.srt (4.2 KB)
    • 04 - Load data only as a connection.mp4 (10.7 MB)
    • 04 - Load data only as a connection.srt (5.7 KB)
    04 - 3. Working with Columns
    • 01 - Fill up and fill down.mp4 (11.1 MB)
    • 01 - Fill up and fill down.srt (5.4 KB)
    • 02 - Split column by delimiter.mp4 (16.2 MB)
    • 02 - Split column by delimiter.srt (7.0 KB)
    • 03 - Split into rows.mp4 (11.9 MB)
    • 03 - Split into rows.srt (5.5 KB)
    • 04 - Add conditional and custom columns.mp4 (13.4 MB)
    • 04 - Add conditional and custom columns.srt (6.2 KB)
    • 05 - Add column by example.mp4 (24.9 MB)
    • 05 - Add column by example.srt (11.7 KB)
    • 06 - Merge columns.mp4 (8.8 MB)
    • 06 - Merge columns.srt (5.1 KB)
    • 07 - Sort and filter data in Power Query.mp4 (12.3 MB)
    • 07 - Sort and filter data in Power Query.srt (5.7 KB)
    05 - 4. Working with Formulas
    • 01 - Use IF formulas.mp4 (7.1 MB)
    • 01 - Use IF formulas.srt (3.6 KB)
    • 02 - Nest IF and AND.mp4 (8.7 MB)
    • 02 - Nest IF and AND.srt (4.1 KB)
    • 03 - AddDays to determine the deadline.mp4 (9.5 MB)
    • 03 - AddDays to determine the deadline.srt (4.3 KB)
    06 - 5. Pivoting and Unpivoting Data
    • 01 - Pivot data in Power Query.mp4 (7.2 MB)
    • 01 - Pivot data in Power Query.srt (3.3 KB)
    • 02 - Pivot and append data.mp4 (11.6 MB)
    • 02 - Pivot and append data.srt (5.6 KB)
    • 03 - Pivot and don't aggregate.mp4 (8.4 MB)
    • 03 - Pivot and don't aggregate.srt (4.2 KB)
    • 04 - Unpivot data in Power Query.mp4 (16.5 MB)
    • 04 - Unpivot data in Power Query.srt (7.3 KB)
    • 05 - Unpivot warnings.mp4 (7.4 MB)
    • 05 - Unpivot warnings.srt (3.7 KB)
    07 - 6. Grouping
    • 01 - Group By feature.mp4 (14.4 MB)
    • 01 - Group By feature.srt (6.2 KB)
    08 - 7. Appending Queries
    • 01 - Two data sets.mp4 (7.9 MB)
    • 01 - Two data sets.srt (3.6 KB)
    • 02 - Multiple tables.mp4 (17.6 MB)
    • 02 - Multiple tables.srt (7.8 KB)
    • 03 - Query data from a folder and import multiple files.mp4 (21.0 MB)
    • 03 - Query data from a folder and import multiple files.srt (11.1 KB)
    • 04 - Append multiple sheets.mp4 (14.0 MB)
    • 04 - Append multiple sheets.srt (5.9 KB)
    09 - 8. Midterm Challenge
    • 01 - Midterm challenge Get a count of all colors.mp4 (19.0 MB)
    • 01 - Midterm challenge Get a count of all colors.srt (8.5 KB)
    10 - 9. Merging Data with Joins
    • 01 - Overview of joins in Power Query.mp4 (9.5 MB)
    • 01 - Overview of joins in Power Query.srt (7.5 KB)
    • 02 - Walk through all six joins.mp4 (35.9 MB)
    • 02 - Walk through all six joins.srt (15.8 KB)
    • 03 - Joins Left or right.mp4 (6.8 MB)
    • 03 - Joins Left or right.srt (2.7 KB)
    • 04 - Outer join versus XLOOKUP.mp4 (6.5 MB)
    • 04 - Outer join versus XLOOKUP.srt (3.4 KB)
    • 05 - Merge with multiple fields.mp4 (9.6 MB)
    • 05 - Merge with multiple fields.srt (4.5 KB)
    • 06 - Approximate match equivalent of VLOOKUP Binning.mp4 (14.6 MB)
    • 06 - Approximate match equivalent of VLOOKUP Binning.srt (6.1 KB)
    • 07 - Approximate match equivalent of VLOOKUP Conditional column.mp4 (7.2 MB)
    • 07 - Approximate match equivalent of VLOOKUP Conditional column.srt (3.7 KB)
    • 08 - Cross Join.mp4 (8.6 MB)
    • 08 - Cross Join.srt (4.2 KB)
    11 - 10. Drill Down to Create Variables
    • 01 - Drill down to create a variable in Power Query.mp4 (18.8 MB)
    • 01 - Drill down to create a variable in Power Query.srt (8.4 KB)
    12 - 11. Fuzzy Matching
    • 01 - Fuzzy matching by percentage.mp4 (24.5 MB)
    • 01 - Fuzzy matching by percentage.srt (9.5 KB)
    • 02 - Merging inconsistent data with a transformation table.mp4 (16.5 MB)
    • 02 - Merging inconsistent data with a transformation table.srt (7.6 KB)
    13 - 12. Apply Your Learning with Real-World Challenges
    • 01 - Challenge setup.mp4 (4.5 MB)
    • 01 - Challenge setup.srt (1.3 KB)
    • 02 - Real-world challenge 1 Projects.mp4 (15.3 MB)
    • 02 - Real-world challenge 1 Projects.srt (7.2 KB)
    • 03 - Real-world challenge 2 Donors.mp4 (16.7 MB)
    • 03 - Real-world challenge 2 Donors.srt (7.5 KB)
    • 04 - Real-world challenge 3 Soccer team.mp4 (19.2 MB)
    • 04 - Real-world challenge 3 Soccer team.srt (7.6 KB)
    14 - Conclusion
    • 01 - Next steps.mp4 (4.1 MB)
    • 01 - Next steps.srt (1.3 KB)
    • Bonus Resources.txt (0.4 KB)
      • Ex_Files_Excel_Power_Query_Get_Transform Exercise Files
      • 01_02_Excel vs Power Query.xlsx (13.9 KB)
      • 02_01_Data Types.xlsx (15.0 KB)
      • 02_02_Query from a Table or Range.xlsx (12.5 KB)
      • 02_04_Connection Only.xlsx (10.3 KB)
      • 03_01_Fill Up Fill Down.

Description

Excel: Power Query (Get & Transform)

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.



Download torrent
585.8 MB
seeders:37
leechers:13
Excel - Power Query (Get and Transform)

Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
585.8 MB
seeders:37
leechers:13
Excel - Power Query (Get and Transform)

Torrent hash: D92B2BF736A9B676B59AE8636DC7C3C5AF963C5D