
Combine and join tables in Power Query using the advanced editor and blank queries to create a unified table with year, course, new students, and sales.
Learn to build and call M functions in Power Query, defining parameters, types, and optional arguments, and see how to return results in a worksheet.
Learn to build a list using the each keyword in power query editor, creating a function that multiplies elements by ten and applying it with list transform.
Practice building functions in M and Power Query to calculate affiliate revenue in Excel, using variables and optional user input for sales and rate.
Explore variable types in M: regular identifiers, quoted identifiers, and generalized identifiers, learn immutability, lexical rules, and how to reference workbook tables in Power Query.
Explore variable scope in M language, demonstrating how nested expressions access parent variables while outer terms remain inaccessible, and use records and properties like sales and tax.
In power query m, the order of evaluation follows dependency ordering, executing only what is needed and skipping unused variables, as shown with list transform and multiply by two.
Learn to group similar rows in Power Query by using global versus local group kinds, counting rows per course in a sample Excel table and comparing consecutive vs global groups.
Learn to use M in Power Query to find which courses meet a sales quota by filtering a table where sales exceed a given value, with a reusable function.
Explore text manipulation in M with Power Query: create strings and booleans, compare text with case-insensitive equality, concatenate with spaces, format numbers, and handle nulls.
Explore date, time, and duration in Power Query M by creating date, time, duration, and date time objects in Excel, then concatenate and adjust them with duration and time zone.
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.