[Solution] GoSkills Excel Challenge 2 - October 2020: Clean and Transform Data with Power Query

preview_player
Показать описание
Have you completed this week’s Excel Power Query challenge?

Pretty easy, right?

Check out Excel MVP Alan Murray (aka. Computergaga)’s step-by-step instructions on how he solved the problem!

Did you get the same results?

——

#MicrosoftExcel #PowerQuery #DataAnalysis #ExcelChallenge
——

For more career-boosting updates follow us on:

  1. GoSkills.com
  2. microsoft excel
  3. how to use excel
  4. excel challenge
  5. excel practice
  6. spreasheets
Рекомендации по теме
[Solution] GoSkills Excel 0:12:54

[Solution] GoSkills Excel Challenge 2 - October 2020: Clean and Transform Data with Power Query

GoSkills Excel Challenge 0:02:19

GoSkills Excel Challenge 2 - October 2020: Clean and Transform Data with Power Query

[Solution] GoSkills Excel 0:13:24

[Solution] GoSkills Excel Challenge 14 - March 2022: Using Multiple Sources for a Dropdown List

[Solution] GoSkills Excel 0:07:09

[Solution] GoSkills Excel Challenge 26 - March 2023: VLOOKUP With Duplicates

[Solution] GoSkills Excel 0:11:03

[Solution] GoSkills Excel Challenge 45 - October 2024: Create an Interactive Sales Chart

[Solution] GoSkills Excel 0:15:19

[Solution] GoSkills Excel Challenge 3 - November 2020: Power Query and PivotTables

[Solution] GoSkills Excel 0:06:34

[Solution] GoSkills Excel Challenge 24 - January 2023: Extract Unique Values From a Dataset

[Solution] GoSkills Excel 0:09:34

[Solution] GoSkills Excel Challenge 12 - January 2022: Methods for Splitting Cell Values

[Solution] GoSkills Excel 0:11:53

[Solution] GoSkills Excel Challenge - September 2020 - with Computergaga

[Solution] GoSkills Excel 0:06:38

[Solution] GoSkills Excel Challenge 20 - September 2022: Calculate Years Between Two Dates

[Solution] GoSkills Excel 0:13:33

[Solution] GoSkills Excel Challenge 19 - August 2022: Use Advanced Logic to Return Different Results

[Solution] GoSkills Excel 0:08:37

[Solution] GoSkills Excel Challenge 42 - July 2024: Prepare an Excel Worksheet for Printing

[Solution] GoSkills Excel 0:06:27

[Solution] GoSkills Excel Challenge 37 - February 2024: Keeping Track of Inventory

GoSkills Excel Challenge 0:02:36

GoSkills Excel Challenge 26 - March 2023: VLOOKUP With Duplicates

GoSkills Excel Challenge 0:01:32

GoSkills Excel Challenge 13 - February 2022: Use Partial Match to Find Multiple Criteria

GoSkills Excel Challenge 0:01:48

GoSkills Excel Challenge 14 - March 2022: Using Multiple Sources for a Dropdown List

[Solution] GoSkills Excel 0:09:58

[Solution] GoSkills Excel Challenge 8 - June 2021: Create a Performance Incentive Worksheet

[Solution] GoSkills Excel 0:10:21

[Solution] GoSkills Excel Challenge 15 - April 2022: Track Expenses with Data Visualization

[Solution] GoSkills Excel 0:14:23

[Solution] GoSkills Excel Challenge 4 - December 2020: Analyze Data With Power Query

[Solution] GoSkills Excel 0:08:26

[Solution] GoSkills Excel Challenge 25 - February 2023: Convert Dates Stored as Text

[Solution] GoSkills Excel 0:07:11

[Solution] GoSkills Excel Challenge 9 - August 2021: Making Use of Advanced Sorting Techniques

[Solution] GoSkills Excel 0:11:34

[Solution] GoSkills Excel Challenge 11 - November 2021: Create an Interactive Worksheet

[Solution] GoSkills Excel 0:07:52

[Solution] GoSkills Excel Challenge 21 - October 2022: Unpivoting Data Within a Table

GoSkills Excel Challenge 0:02:00

GoSkills Excel Challenge 24 - January 2023: Extract Unique Values From a Dataset

Комментарии
Автор

Exceptional explanation. Thank you very much Alan!!!

IvanCortinas_ES
Автор

Excellent! I love to see some advanced topics so well explained

cogwheelLearning