Other
[ CourseWikia com ] Excel - Power Query (Get and Transform)
-
-
- Rate this torrent + | -
Download Anonymously! Get Protected Today And Get your 70% discount
Torrent info
Torrent Files List
Get Bonus Downloads Here.url (Size: 585.77 MB) (Files: 136)
Get Bonus Downloads Here.url
~Get Your Files Here !
01 - Introduction
01 - Make your data useful with Power Query.mp4
01 - Make your data useful with Power Query.srt
02 - 1. What Is Power Query (Get & Transform)
01 - Power Query example.mp4
01 - Power Query example.srt
02 - Differences between Excel and Power Query.mp4
02 - Differences between Excel and Power Query.srt
03 - 2. Working with Queries
01 - Data types explained.mp4
01 - Data types explained.srt
02 - Query data from a table or range.mp4
02 - Query data from a table or range.srt
03 - Query data from another Excel file.mp4
03 - Query data from another Excel file.srt
04 - Load data only as a connection.mp4
04 - Load data only as a connection.srt
04 - 3. Working with Columns
01 - Fill up and fill down.mp4
01 - Fill up and fill down.srt
02 - Split column by delimiter.mp4
02 - Split column by delimiter.srt
03 - Split into rows.mp4
03 - Split into rows.srt
04 - Add conditional and custom columns.mp4
04 - Add conditional and custom columns.srt
05 - Add column by example.mp4
05 - Add column by example.srt
06 - Merge columns.mp4
06 - Merge columns.srt
07 - Sort and filter data in Power Query.mp4
07 - Sort and filter data in Power Query.srt
05 - 4. Working with Formulas
01 - Use IF formulas.mp4
01 - Use IF formulas.srt
02 - Nest IF and AND.mp4
02 - Nest IF and AND.srt
03 - AddDays to determine the deadline.mp4
03 - AddDays to determine the deadline.srt
06 - 5. Pivoting and Unpivoting Data
01 - Pivot data in Power Query.mp4
01 - Pivot data in Power Query.srt
02 - Pivot and append data.mp4
02 - Pivot and append data.srt
03 - Pivot and don't aggregate.mp4
03 - Pivot and don't aggregate.srt
04 - Unpivot data in Power Query.mp4
04 - Unpivot data in Power Query.srt
05 - Unpivot warnings.mp4
05 - Unpivot warnings.srt
07 - 6. Grouping
01 - Group By feature.mp4
01 - Group By feature.srt
08 - 7. Appending Queries
01 - Two data sets.mp4
01 - Two data sets.srt
02 - Multiple tables.mp4
02 - Multiple tables.srt
03 - Query data from a folder and import multiple files.mp4
03 - Query data from a folder and import multiple files.srt
04 - Append multiple sheets.mp4
04 - Append multiple sheets.srt
09 - 8. Midterm Challenge
01 - Midterm challenge Get a count of all colors.mp4
01 - Midterm challenge Get a count of all colors.srt
10 - 9. Merging Data with Joins
01 - Overview of joins in Power Query.mp4
01 - Overview of joins in Power Query.srt
02 - Walk through all six joins.mp4
02 - Walk through all six joins.srt
03 - Joins Left or right.mp4
03 - Joins Left or right.srt
04 - Outer join versus XLOOKUP.mp4
04 - Outer join versus XLOOKUP.srt
05 - Merge with multiple fields.mp4
05 - Merge with multiple fields.srt
06 - Approximate match equivalent of VLOOKUP Binning.mp4
06 - Approximate match equivalent of VLOOKUP Binning.srt
07 - Approximate match equivalent of VLOOKUP Conditional column.mp4
07 - Approximate match equivalent of VLOOKUP Conditional column.srt
08 - Cross Join.mp4
08 - Cross Join.srt
11 - 10. Drill Down to Create Variables
01 - Drill down to create a variable in Power Query.mp4
01 - Drill down to create a variable in Power Query.srt
12 - 11. Fuzzy Matching
01 - Fuzzy matching by percentage.mp4
01 - Fuzzy matching by percentage.srt
02 - Merging inconsistent data with a transformation table.mp4
02 - Merging inconsistent data with a transformation table.srt
13 - 12. Apply Your Learning with Real-World Challenges
01 - Challenge setup.mp4
01 - Challenge setup.srt
02 - Real-world challenge 1 Projects.mp4
02 - Real-world challenge 1 Projects.srt
03 - Real-world challenge 2 Donors.mp4
03 - Real-world challenge 2 Donors.srt
04 - Real-world challenge 3 Soccer team.mp4
04 - Real-world challenge 3 Soccer team.srt
14 - Conclusion
01 - Next steps.mp4
01 - Next steps.srt
Bonus Resources.txt
Ex_Files_Excel_Power_Query_Get_Transform
Exercise Files
01_02_Excel vs Power Query.xlsx
02_01_Data Types.xlsx
02_02_Query from a Table or Range.xlsx
02_04_Connection Only.xlsx
03_01_Fill Up Fill Down.xlsx
03_02_Import Survey Data.xlsx
03_02_Split by Delimiter.xlsx
03_03_Split into Rows.xlsx
03_04_Conditional and Custom Columns.xlsx
03_05_Column by Example.xlsx
03_06_Merging Columns.xlsx
03_07_Sort and Filter.xlsx
04_01_IF Formula.xlsx
04_02_Nested IF AND.xlsx
04_03_AddDays Function.xlsx
05_01_Pivot.xlsx
05_02_Pivot and Append.xlsx
05_03_Pivot - Dont Aggregate.xlsx
05_04_Unpivot.xlsx
05_05_Unpivot - Warning.xlsx
06_01_Grouping.xlsx
07_01_Append.xlsx
07_02_Append Multiple Datasets.xlsx
07_03_Magician Conference
Levitation.xlsx
Magic as a Business.xlsx
Mentalism.xlsx
Street Magic.xlsx
Working in Las Vegas.xlsx
07_04_Append Multiple Sheets.xlsx
08_01_MidTerm Challenge.xlsx
09_02_Joins.xlsx
09_03_Joins - Left Right.xlsx
09_04_OuterJoin XLOOKUP.xlsx
09_05_Merge Multiple Fields.xlsx
09_06_Approximate Match by Binning.xlsx
09_07_Approximate Match by Conditional Formatting.xlsx
09_08_Cross Join.xlsx
10_01_Drill Down.xlsx
11_01_Fuzzy Matching.xlsx
11_02_Transformation Table.xlsx
12_02_PQ Challenge - Projects - Solution.xlsx
12_02_PQ Challenge - Projects.xlsx
12_03_PQ Challenge - Donors - Solution.xlsx
12_03_PQ Challenge - Donors.xlsx
12_04_PQ Challenge Soccer Team - Solution.xlsx
12_04_PQ Challenge Soccer Team.xlsx
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [ CourseWikia com ] Excel - Power Query (Get and Transform) Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
