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

파일 형식 창조 시간 파일 크기 Seeders Leechers 업데이트 된 시간
비디오 2024-04-25 585.77MB 8 0 4 hours ago
다운로드
자석 링크   or   Save Instantly without Torrenting   또는   토런트 다운로드

이 다운로드를 시작하려면, 당신은 qBittorrent 같은 무료 비트 토런트 클라이언트가 필요합니다.

Report Abuse
태그들
CourseWikia  com  Excel  Power  Query  Get  and  Transform  
관련 링크
  1. [ CourseWikia.com ] Udemy - Automate Data Processing and Transformations with Excel VBA 1.16GB
  2. [ CourseWikia.com ] Mastering Prior Art Search and Patent Analytics 2.55GB
  3. [ CourseWikia.com ] Udemy - Cross-Cultural Communication And Cultural Intelligence 2.0 1.14GB
  4. [ CourseWikia.com ] Udemy - Voice-Over Performance and Script Interpretation Masterclass 2.23GB
  5. [ CourseWikia.com ] Quantum leap - From Dirac and Feynman, across the Universe, to human body and mind 5.09MB
  6. [ CourseWikia.com ] Cips L5M1 Managing Teams And Individuals 1.07GB
  7. [ CourseWikia.com ] Udemy - Professional Diploma - Government and Public Sector Technology 997.44MB
  8. [ CourseWikia.com ] The Grief - Brain, Face and the Emotion 4.99MB
  9. [ CourseWikia.com ] Land in Conflict - Managing and Resolving Land Use Disputes 11.20MB
  10. [ CourseWikia.com ] Udemy - Learn Conjunctions (Complex And Compound Sentences) 1.16GB
파일 리스트
  1. Get Bonus Downloads Here.url 181B
  2. ~Get Your Files Here !/01 - Introduction/01 - Make your data useful with Power Query.mp4 3.38MB
  3. ~Get Your Files Here !/01 - Introduction/01 - Make your data useful with Power Query.srt 1008B
  4. ~Get Your Files Here !/02 - 1. What Is Power Query (Get & Transform)/01 - Power Query example.mp4 24.89MB
  5. ~Get Your Files Here !/02 - 1. What Is Power Query (Get & Transform)/01 - Power Query example.srt 12.32KB
  6. ~Get Your Files Here !/02 - 1. What Is Power Query (Get & Transform)/02 - Differences between Excel and Power Query.mp4 23.55MB
  7. ~Get Your Files Here !/02 - 1. What Is Power Query (Get & Transform)/02 - Differences between Excel and Power Query.srt 11.13KB
  8. ~Get Your Files Here !/03 - 2. Working with Queries/01 - Data types explained.mp4 17.93MB
  9. ~Get Your Files Here !/03 - 2. Working with Queries/01 - Data types explained.srt 8.53KB
  10. ~Get Your Files Here !/03 - 2. Working with Queries/02 - Query data from a table or range.mp4 9.28MB
  11. ~Get Your Files Here !/03 - 2. Working with Queries/02 - Query data from a table or range.srt 4.73KB
  12. ~Get Your Files Here !/03 - 2. Working with Queries/03 - Query data from another Excel file.mp4 7.87MB
  13. ~Get Your Files Here !/03 - 2. Working with Queries/03 - Query data from another Excel file.srt 4.21KB
  14. ~Get Your Files Here !/03 - 2. Working with Queries/04 - Load data only as a connection.mp4 10.75MB
  15. ~Get Your Files Here !/03 - 2. Working with Queries/04 - Load data only as a connection.srt 5.73KB
  16. ~Get Your Files Here !/04 - 3. Working with Columns/01 - Fill up and fill down.mp4 11.06MB
  17. ~Get Your Files Here !/04 - 3. Working with Columns/01 - Fill up and fill down.srt 5.39KB
  18. ~Get Your Files Here !/04 - 3. Working with Columns/02 - Split column by delimiter.mp4 16.17MB
  19. ~Get Your Files Here !/04 - 3. Working with Columns/02 - Split column by delimiter.srt 6.98KB
  20. ~Get Your Files Here !/04 - 3. Working with Columns/03 - Split into rows.mp4 11.87MB
  21. ~Get Your Files Here !/04 - 3. Working with Columns/03 - Split into rows.srt 5.55KB
  22. ~Get Your Files Here !/04 - 3. Working with Columns/04 - Add conditional and custom columns.mp4 13.42MB
  23. ~Get Your Files Here !/04 - 3. Working with Columns/04 - Add conditional and custom columns.srt 6.20KB
  24. ~Get Your Files Here !/04 - 3. Working with Columns/05 - Add column by example.mp4 24.94MB
  25. ~Get Your Files Here !/04 - 3. Working with Columns/05 - Add column by example.srt 11.66KB
  26. ~Get Your Files Here !/04 - 3. Working with Columns/06 - Merge columns.mp4 8.82MB
  27. ~Get Your Files Here !/04 - 3. Working with Columns/06 - Merge columns.srt 5.09KB
  28. ~Get Your Files Here !/04 - 3. Working with Columns/07 - Sort and filter data in Power Query.mp4 12.35MB
  29. ~Get Your Files Here !/04 - 3. Working with Columns/07 - Sort and filter data in Power Query.srt 5.66KB
  30. ~Get Your Files Here !/05 - 4. Working with Formulas/01 - Use IF formulas.mp4 7.06MB
  31. ~Get Your Files Here !/05 - 4. Working with Formulas/01 - Use IF formulas.srt 3.63KB
  32. ~Get Your Files Here !/05 - 4. Working with Formulas/02 - Nest IF and AND.mp4 8.70MB
  33. ~Get Your Files Here !/05 - 4. Working with Formulas/02 - Nest IF and AND.srt 4.07KB
  34. ~Get Your Files Here !/05 - 4. Working with Formulas/03 - AddDays to determine the deadline.mp4 9.55MB
  35. ~Get Your Files Here !/05 - 4. Working with Formulas/03 - AddDays to determine the deadline.srt 4.32KB
  36. ~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/01 - Pivot data in Power Query.mp4 7.16MB
  37. ~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/01 - Pivot data in Power Query.srt 3.28KB
  38. ~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/02 - Pivot and append data.mp4 11.57MB
  39. ~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/02 - Pivot and append data.srt 5.64KB
  40. ~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/03 - Pivot and don't aggregate.mp4 8.36MB
  41. ~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/03 - Pivot and don't aggregate.srt 4.25KB
  42. ~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/04 - Unpivot data in Power Query.mp4 16.46MB
  43. ~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/04 - Unpivot data in Power Query.srt 7.32KB
  44. ~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/05 - Unpivot warnings.mp4 7.40MB
  45. ~Get Your Files Here !/06 - 5. Pivoting and Unpivoting Data/05 - Unpivot warnings.srt 3.67KB
  46. ~Get Your Files Here !/07 - 6. Grouping/01 - Group By feature.mp4 14.43MB
  47. ~Get Your Files Here !/07 - 6. Grouping/01 - Group By feature.srt 6.24KB
  48. ~Get Your Files Here !/08 - 7. Appending Queries/01 - Two data sets.mp4 7.90MB
  49. ~Get Your Files Here !/08 - 7. Appending Queries/01 - Two data sets.srt 3.63KB
  50. ~Get Your Files Here !/08 - 7. Appending Queries/02 - Multiple tables.mp4 17.58MB
  51. ~Get Your Files Here !/08 - 7. Appending Queries/02 - Multiple tables.srt 7.82KB
  52. ~Get Your Files Here !/08 - 7. Appending Queries/03 - Query data from a folder and import multiple files.mp4 21.01MB
  53. ~Get Your Files Here !/08 - 7. Appending Queries/03 - Query data from a folder and import multiple files.srt 11.11KB
  54. ~Get Your Files Here !/08 - 7. Appending Queries/04 - Append multiple sheets.mp4 14.03MB
  55. ~Get Your Files Here !/08 - 7. Appending Queries/04 - Append multiple sheets.srt 5.86KB
  56. ~Get Your Files Here !/09 - 8. Midterm Challenge/01 - Midterm challenge Get a count of all colors.mp4 19.00MB
  57. ~Get Your Files Here !/09 - 8. Midterm Challenge/01 - Midterm challenge Get a count of all colors.srt 8.51KB
  58. ~Get Your Files Here !/10 - 9. Merging Data with Joins/01 - Overview of joins in Power Query.mp4 9.50MB
  59. ~Get Your Files Here !/10 - 9. Merging Data with Joins/01 - Overview of joins in Power Query.srt 7.48KB
  60. ~Get Your Files Here !/10 - 9. Merging Data with Joins/02 - Walk through all six joins.mp4 35.86MB
  61. ~Get Your Files Here !/10 - 9. Merging Data with Joins/02 - Walk through all six joins.srt 15.82KB
  62. ~Get Your Files Here !/10 - 9. Merging Data with Joins/03 - Joins Left or right.mp4 6.77MB
  63. ~Get Your Files Here !/10 - 9. Merging Data with Joins/03 - Joins Left or right.srt 2.70KB
  64. ~Get Your Files Here !/10 - 9. Merging Data with Joins/04 - Outer join versus XLOOKUP.mp4 6.46MB
  65. ~Get Your Files Here !/10 - 9. Merging Data with Joins/04 - Outer join versus XLOOKUP.srt 3.41KB
  66. ~Get Your Files Here !/10 - 9. Merging Data with Joins/05 - Merge with multiple fields.mp4 9.58MB
  67. ~Get Your Files Here !/10 - 9. Merging Data with Joins/05 - Merge with multiple fields.srt 4.52KB
  68. ~Get Your Files Here !/10 - 9. Merging Data with Joins/06 - Approximate match equivalent of VLOOKUP Binning.mp4 14.57MB
  69. ~Get Your Files Here !/10 - 9. Merging Data with Joins/06 - Approximate match equivalent of VLOOKUP Binning.srt 6.07KB
  70. ~Get Your Files Here !/10 - 9. Merging Data with Joins/07 - Approximate match equivalent of VLOOKUP Conditional column.mp4 7.23MB
  71. ~Get Your Files Here !/10 - 9. Merging Data with Joins/07 - Approximate match equivalent of VLOOKUP Conditional column.srt 3.72KB
  72. ~Get Your Files Here !/10 - 9. Merging Data with Joins/08 - Cross Join.mp4 8.57MB
  73. ~Get Your Files Here !/10 - 9. Merging Data with Joins/08 - Cross Join.srt 4.23KB
  74. ~Get Your Files Here !/11 - 10. Drill Down to Create Variables/01 - Drill down to create a variable in Power Query.mp4 18.82MB
  75. ~Get Your Files Here !/11 - 10. Drill Down to Create Variables/01 - Drill down to create a variable in Power Query.srt 8.38KB
  76. ~Get Your Files Here !/12 - 11. Fuzzy Matching/01 - Fuzzy matching by percentage.mp4 24.48MB
  77. ~Get Your Files Here !/12 - 11. Fuzzy Matching/01 - Fuzzy matching by percentage.srt 9.55KB
  78. ~Get Your Files Here !/12 - 11. Fuzzy Matching/02 - Merging inconsistent data with a transformation table.mp4 16.46MB
  79. ~Get Your Files Here !/12 - 11. Fuzzy Matching/02 - Merging inconsistent data with a transformation table.srt 7.61KB
  80. ~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/01 - Challenge setup.mp4 4.46MB
  81. ~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/01 - Challenge setup.srt 1.32KB
  82. ~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/02 - Real-world challenge 1 Projects.mp4 15.31MB
  83. ~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/02 - Real-world challenge 1 Projects.srt 7.24KB
  84. ~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/03 - Real-world challenge 2 Donors.mp4 16.73MB
  85. ~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/03 - Real-world challenge 2 Donors.srt 7.52KB
  86. ~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/04 - Real-world challenge 3 Soccer team.mp4 19.17MB
  87. ~Get Your Files Here !/13 - 12. Apply Your Learning with Real-World Challenges/04 - Real-world challenge 3 Soccer team.srt 7.56KB
  88. ~Get Your Files Here !/14 - Conclusion/01 - Next steps.mp4 4.14MB
  89. ~Get Your Files Here !/14 - Conclusion/01 - Next steps.srt 1.30KB
  90. ~Get Your Files Here !/Bonus Resources.txt 386B
  91. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/01_02_Excel vs Power Query.xlsx 13.94KB
  92. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/02_01_Data Types.xlsx 14.96KB
  93. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/02_02_Query from a Table or Range.xlsx 12.47KB
  94. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/02_04_Connection Only.xlsx 10.29KB
  95. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_01_Fill Up Fill Down.xlsx 14.10KB
  96. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_02_Import Survey Data.xlsx 11.56KB
  97. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_02_Split by Delimiter.xlsx 13.26KB
  98. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_03_Split into Rows.xlsx 14.20KB
  99. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_04_Conditional and Custom Columns.xlsx 12.77KB
  100. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_05_Column by Example.xlsx 12.73KB
  101. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_06_Merging Columns.xlsx 14.26KB
  102. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/03_07_Sort and Filter.xlsx 13.67KB
  103. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/04_01_IF Formula.xlsx 13.80KB
  104. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/04_02_Nested IF AND.xlsx 13.76KB
  105. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/04_03_AddDays Function.xlsx 13.60KB
  106. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_01_Pivot.xlsx 15.18KB
  107. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_02_Pivot and Append.xlsx 19.83KB
  108. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_03_Pivot - Dont Aggregate.xlsx 12.36KB
  109. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_04_Unpivot.xlsx 16.51KB
  110. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/05_05_Unpivot - Warning.xlsx 13.41KB
  111. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/06_01_Grouping.xlsx 14.21KB
  112. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_01_Append.xlsx 19.60KB
  113. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_02_Append Multiple Datasets.xlsx 19.64KB
  114. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_03_Magician Conference/Levitation.xlsx 9.02KB
  115. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_03_Magician Conference/Magic as a Business.xlsx 9.05KB
  116. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_03_Magician Conference/Mentalism.xlsx 9.77KB
  117. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_03_Magician Conference/Street Magic.xlsx 8.98KB
  118. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_03_Magician Conference/Working in Las Vegas.xlsx 8.98KB
  119. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/07_04_Append Multiple Sheets.xlsx 16.00KB
  120. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/08_01_MidTerm Challenge.xlsx 21.33KB
  121. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_02_Joins.xlsx 12.58KB
  122. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_03_Joins - Left Right.xlsx 16.20KB
  123. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_04_OuterJoin XLOOKUP.xlsx 16.57KB
  124. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_05_Merge Multiple Fields.xlsx 45.24KB
  125. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_06_Approximate Match by Binning.xlsx 14.34KB
  126. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_07_Approximate Match by Conditional Formatting.xlsx 14.30KB
  127. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/09_08_Cross Join.xlsx 19.17KB
  128. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/10_01_Drill Down.xlsx 28.39KB
  129. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/11_01_Fuzzy Matching.xlsx 29.30KB
  130. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/11_02_Transformation Table.xlsx 18.87KB
  131. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_02_PQ Challenge - Projects - Solution.xlsx 34.79KB
  132. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_02_PQ Challenge - Projects.xlsx 17.27KB
  133. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_03_PQ Challenge - Donors - Solution.xlsx 35.16KB
  134. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_03_PQ Challenge - Donors.xlsx 12.63KB
  135. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_04_PQ Challenge Soccer Team - Solution.xlsx 125.91KB
  136. ~Get Your Files Here !/Ex_Files_Excel_Power_Query_Get_Transform/Exercise Files/12_04_PQ Challenge Soccer Team.xlsx 101.97KB