Beginners Excel Power Query and M Masterclass - Supercharge Data Transformation

46 casts | 5:05:39 for the total course

Power Query Excel

Description

Buff your skills to keep your job and get a raise in ANY economic climate. This course BUNDLE keeps your skills sharp and your paycheque up!

  • Supercharge Data Transformation
  • Use Power Query to format data

This masterclass is without a doubt the most comprehensive course available anywhere online. Even if you have zero experience, this course will take you from beginner to professional.

Frequently Asked Questions

  • How do I obtain a certificate?

Each certificate in this bundle is only awarded after you have completed every lecture of the course. Many of our students post their Mammoth Interactive certifications on LinkedIn. Not only that, but you will have projects to show employers on top of the certification.

  • Is this an eBook or videos?

The majority of this course bundle will be video tutorials (screencasts of practical coding projects step by step.) We will also have several PDFs and all source code. Can’t I just learn via Google or YouTube? This bundle is much more streamlined and efficient than learning via Google or YouTube. We have curated a massive 5-course curriculum to take you from absolute beginner to starting a high-paying career.

  • How will I practice to ensure I’m learning?

With each section there will be a project, so if you can build the project along with us you are succeeding. There is also a challenge at the end of each section that you can take on to add more features to the project and advance the project in your own time.

Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more.

Founder and CEO John Bura has been programming since 1997 and teaching since 2002. John has created top-selling applications for iOS, Xbox and more. John also runs SaaS company Devonian Apps, building efficiency-minded software for technology workers like you.

Try a course today.

  • 1. 1 - Course Overview - Rendered
    • Supercharge Data Transformation | What Are Power Query And M | 1.1

      8:17

    • Supercharge Data Transformation | Course Overview | 1.2

      6:17

  • 2. 2 - Build Your First M Queries
    • Supercharge Data Transformation | Capitalize A Table Column | 2.1

      6:39

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

      17:10

  • 3. 3 - Join Tables With M
    • Supercharge Data Transformation | Build and Reference Tables | 3.1

      8:09

    • Supercharge Data Transformation | Append and Combine Tables | 3.2

      5:33

    • Supercharge Data Transformation | Inner Join Tables | 3.3

      5:33

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

      8:14

    • Supercharge Data Transformation | Call Functions | 4.2

      5:10

    • Supercharge Data Transformation | Use the Each Keyword | 4.3

      2:34

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

      7:31

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

      8:03

    • Supercharge Data Transformation | Calculate Price After Discount | 4.6

      6:09

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

      5:14

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

      2:09

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

      12:21

  • 5. 5 - Work With Lists in M
    • Supercharge Data Transformation | Build a List with Each | 5.1

      5:17

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

      5:02

    • Supercharge Data Transformation | Iterate Over a List | 5.3

      4:18

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

      3:27

  • 6. 6 - Build M Variables to Store Data
    • Supercharge Data Transformation | Calculate Affiliate Revenue | 6.1

      4:38

    • Supercharge Data Transformation | Variable Types | 6.2

      5:49

    • Supercharge Data Transformation | Where Can You Use Variables? | 6.3

      8:58

    • Supercharge Data Transformation | Order of Evaluation | 6.4

      5:18

  • 7. 7 - Aggregate Table Data With M
    • Supercharge Data Transformation | Count Rows | 7.1

      7:33

    • Supercharge Data Transformation | Calculate Profits Per Quarter | 7.2

      5:55

    • Supercharge Data Transformation | Group Similar Rows | 7.3

      6:00

    • Supercharge Data Transformation | Sort a Tables | 7.4

      5:28

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

      7:18

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

      2:55

  • 8. 8 - Work With Tables in M
    • Supercharge Data Transformation | Build Tables | 8.1

      6:55

    • Supercharge Data Transformation | Work With Tables | 8.2

      5:37

    • Supercharge Data Transformation | Fill in a Table | 8.3

      3:27

  • 9. 9 - Build Conditions With M if Expressions
    • Supercharge Data Transformation | Build Conditions With if Expressions | 9.1

      8:14

  • 10. 10 - Work With M Data Types
    • Supercharge Data Transformation | Manipulate Text | 10.1

      11:34

    • Supercharge Data Transformation | Work With Numbers | 10.2

      3:01

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

      7:52

  • 11. 11 - Build Queries For Tables With M
    • Supercharge Data Transformation | Filter a Table by Row | 11.1

      6:59

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

      7:57

  • 12. 12 - Build Calculations For Tables With M
    • Supercharge Data Transformation | Build Address Labels | 12.1

      8:27

    • Supercharge Data Transformation | Calculate Percentage of Total | 12.2

      6:45

    • Supercharge Data Transformation | Calculate Sales Rank | 12.3

      7:05

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

      6:59

  • 13. 13 - Fetch Data From The Web With M
    • Supercharge Data Transformation | Query Tables from the Web | 13.1

      7:15

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

      8:09

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

      6:24

Created By

Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more. Over 11 years, Mammoth Interactive has built a global student community with 3.3 million

US$19.98

  US$199.00

Buy Now (US$19.98) ➔

Lifetime Access
30-Day Money-Back Guarantee.

Reviews
No reviews yet