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

Supercharge Data Transformation | What Are Power Query And M | 1.1

40 Views 0 Likes 0 Comments

Comment
Leave a comment (supports markdown format)