< Beginners Excel Power Query and M Masterclass - Supercharge Data Transformation

45 casts | 4:56:41 for the total course

created by Mammoth Interactive INC

• 1. 1- Course Overview - Rendered
  • Supercharge Data Transformation | What Are Power Query And M | 1.1
  • Supercharge Data Transformation | Course Overview | 1.2
• 2. 2 - Build your first M queries

  • Supercharge Data Transformation | Capitalize A Table Column | 2.1

  • Supercharge Data Transformation | Build an Expression With Let | 2.2

• 3. 3 - Join tables with M

  • Supercharge Data Transformation | Build and Reference Tables | 3.1

  • Supercharge Data Transformation | Append and Combine Tables | 3.2

  • Supercharge Data Transformation | Inner Join Tables | 3.3

• 4. 4 - Build M functions to perform tasks

  • Supercharge Data Transformation | Build M Functions to Perform Tasks | 4.1

  • Supercharge Data Transformation | Call Functions | 4.2

  • Supercharge Data Transformation | Use the Each Keyword | 4.3

  • Supercharge Data Transformation | Change A Table With A Function | 4.4

  • Supercharge Data Transformation | Loop an Action With a Recursive Function | 4.5

  • Supercharge Data Transformation | Calculate Price After Discount | 4.6

  • Supercharge Data Transformation | Use Optional Parameters to Combine Test | 4.7

  • Supercharge Data Transformation | Transform A List With A Function | 4.8

  • Supercharge Data Transformation | Calculate Number of Working Days | 4.9

• 5. 5 - Work with lists in M

  • Supercharge Data Transformation | Build a List with Each | 5.1

  • Supercharge Data Transformation | Concatenate Items in a List | 5.2

  • Supercharge Data Transformation | Iterate Over a List | 5.3

  • Supercharge Data Transformation | Iterate Over a List with Recursion | 5.4

• 6. 6 - Build M variables to store data

  • Supercharge Data Transformation | Calculate Affiliate Revenue | 6.1

  • Supercharge Data Transformation | Variable Types | 6.2

  • Supercharge Data Transformation | Order of Evaluation | 6.4

• 7. 7 - Aggregate table data with M

  • Supercharge Data Transformation | Count Rows | 7.1

  • Supercharge Data Transformation | Calculate Profits Per Quarter | 7.2

  • Supercharge Data Transformation | Group Similar Rows | 7.3

  • Supercharge Data Transformation | Sort a Tables | 7.4

  • Supercharge Data Transformation | Query Data From Another Spreadsheet | 7.5

  • Supercharge Data Transformation | Find Where Sales Met Quota | 7.6

• 8. 8 - Work with tables in M

  • Supercharge Data Transformation | Build Tables | 8.1

  • Supercharge Data Transformation | Work With Tables | 8.2

  • Supercharge Data Transformation | Fill in a Table | 8.3

• 9. 9 - Build conditions with M if expressions

  • Supercharge Data Transformation | Build Conditions With if Expressions | 9.1

• 10. 10 - Work with M data types

  • Supercharge Data Transformation | Manipulate Text | 10.1

  • Supercharge Data Transformation | Work With Numbers | 10.2

  • Supercharge Data Transformation | Work with date, Time and Duration | 10.3

• 11. 11 - Build queries for tables with M

  • Supercharge Data Transformation | Filter a Table by Row | 11.1

  • Supercharge Data Transformation | Format a List of Values into a Table | 11.2

• 12. 12 - Build calculations for tables with M

  • Supercharge Data Transformation | Build Address Labels | 12.1

  • Supercharge Data Transformation | Calculate Percentage of Total | 12.2

  • Supercharge Data Transformation | Calculate Sales Rank | 12.3

  • Supercharge Data Transformation | Count Number of Distinct Rows | 12.4

• 13. 13 - Fetch data from the web with M

  • Supercharge Data Transformation | Query Tables from the Web | 13.1

  • Supercharge Data Transformation | Search for Links on the Web | 13.2

  • Supercharge Data Transformation | Check if a Webpage Exists | 13.3