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

File Name

Size

Get Bonus Downloads Here.url

181 B

~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

25 MB

~Get Your Files Here !/02 - 1. What Is Power Query (Get & Transform)/01 - Power Query example.srt

12 kB

~Get Your Files Here !/02 - 1. What Is Power Query (Get & Transform)/02 - Differences between Excel and Power Query.mp4

24 MB

~Get Your Files Here !/02 - 1. What Is Power Query (Get & Transform)/02 - Differences between Excel and Power Query.srt

11 kB

~Get Your Files Here !/03 - 2. Working with Queries/01 - Data types explained.mp4

18 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

11 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 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 MB

~Get Your Files Here !/04 - 3. Working with Columns/02 - Split column by delimiter.srt

7.0 kB

~Get Your Files Here !/04 - 3. Working with Columns/03 - Split into rows.mp4

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

25 MB

~Get Your Files Here !/04 - 3. Working with Columns/05 - Add column by example.srt

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

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

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

36 MB

~Get Your Files Here !/10 - 9. Merging Data with Joins/02 - Walk through all six joins.srt

16 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

15 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

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

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

14 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 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/02_04_Connection Only.xlsx

10 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_01_Fill Up Fill Down.xlsx

14 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_02_Import Survey Data.xlsx

12 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_02_Split by Delimiter.xlsx

13 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_03_Split into Rows.xlsx

14 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_04_Conditional and Custom Columns.xlsx

13 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_05_Column by Example.xlsx

13 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_06_Merging Columns.xlsx

14 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_07_Sort and Filter.xlsx

14 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/04_01_IF Formula.xlsx

14 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/04_02_Nested IF AND.xlsx

14 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/04_03_AddDays Function.xlsx

14 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_01_Pivot.xlsx

15 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_02_Pivot and Append.xlsx

20 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_03_Pivot - Dont Aggregate.xlsx

12 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_04_Unpivot.xlsx

16 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_05_Unpivot - Warning.xlsx

13 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/06_01_Grouping.xlsx

14 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_01_Append.xlsx

20 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_02_Append Multiple Datasets.xlsx

20 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/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/Mentalism.xlsx

9.8 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 !/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_04_Append Multiple Sheets.xlsx

16 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/08_01_MidTerm Challenge.xlsx

21 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_02_Joins.xlsx

13 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_03_Joins - Left Right.xlsx

16 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_04_OuterJoin XLOOKUP.xlsx

17 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_05_Merge Multiple Fields.xlsx

45 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_06_Approximate Match by Binning.xlsx

14 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_07_Approximate Match by Conditional Formatting.xlsx

14 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_08_Cross Join.xlsx

19 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/10_01_Drill Down.xlsx

28 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/11_01_Fuzzy Matching.xlsx

29 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/11_02_Transformation Table.xlsx

19 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_02_PQ Challenge - Projects - Solution.xlsx

35 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_02_PQ Challenge - Projects.xlsx

17 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_03_PQ Challenge - Donors - Solution.xlsx

35 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_03_PQ Challenge - Donors.xlsx

13 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_04_PQ Challenge Soccer Team - Solution.xlsx

126 kB

~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_04_PQ Challenge Soccer Team.xlsx

102 kB