< Advanced Excel Power Query and M Masterclass - Clean and Transform Data

32 casts | 3:20:51 for the total course

created by Mammoth Interactive INC

• 1. 0 - Course Overview
  • Clean and Transform Data | Advanced Excel Power Query and M | 0.0

  • Clean and Transform Data | What are Power Query and M | 0.1

• 2. 1 - Build expressions with let

  • Clean and Transform Data | Build Nested Let Expressions | 1.1

  • Clean and Transform Data | Build a List with a Sequence | 1.2

  • Clean and Transform Data | Build an Unnamed Record | 1.3

• 3. 2 - Build expressions with each

  • Clean and Transform Data | Work with the Each Keyword | 2.1

  • Clean and Transform Data | Generate a List | 1.2

  • Clean and Transform Data | Find an Entry in a Record | 1.3

  • Clean and Transform Data | Select Items From a List | 1.4

  • Clean and Transform Data | Serialize a Column | 1.5

  • Clean and Transform Data | Find Best Match of Values | 1.6

• 4. 3 - Build M functions to perform tasks

  • Clean and Transform Data | Build a Function | 3.1

  • Clean and Transform Data | Build a Closure | 3.2

  • Clean and Transform Data | Build a Function in a Record | 3.3

  • Clean and Transform Data | Count Fibonacci Numbers With a Recursive Function | 3.4

  • Clean and Transform Data | Remove HTML Tags | 3.5

  • Clean and Transform Data | Build A For Each Loop | 3.6

• 5. 4 - Work with tables in M

  • Clean and Transform Data | Select a Column From a Table | 4.1

  • Clean and Transform Data | Select a Value at a Row and Column | 4.2

  • Clean and Transform Data | Select Row Where a Condition is Met | 4.3

  • Clean and Transform Data | Cross Join Tables | 4.4

  • Clean and Transform Data | Join Tables on a Key | 4.5

  • Clean and Transform Data | Change Column Types | 4.6

  • Clean and Transform Data | Fill a Table With Random Values | 4.7

• 6. 5 - Pivot a table

  • Clean and Transform Data | What is Pivoting | 5.0

  • Clean and Transform Data | Pivot a Table | 5.1

• 7. 6 - Build expressions with evaluate

  • Clean and Transform Data | Build an Expression with Evaluate | 6.1

  • Clean and Transform Data | Build a Nested Evaluate Expression | 6.2

  • Clean and Transform Data | Use Global Library Functions | 6.3

• 8. 7 - Work with matrices in M

  • Clean and Transform Data | How to Multiply Matrices | 7.0

  • Clean and Transform Data | Build Matrices in M | 7.1

  • Clean and Transform Data | Multiply Matrices | 7.2