Beginners Excel Automation with Power Query and M Query Language

Learn how to use Power Query and code in the M formula language in Excel.

Power Query

  • Free tool part of Excel and Power BI

What is it for?

  • Automate manual and repetitive tasks
  • Solve data analysis problems that require complex formulas
  • Easy to import and transform data in ways Excel finds hard
  • Designed to pull data from a source
  • Modify it
  • Return the modified version

What you can do with Power Query?

  • Import data from different sources
  • Transform and clean data
  • Load data as a basis for reports

Import data from different sources

  • Another workbook
  • Text file
  • Folder
  • Sharepoint drive
  • Databases
  • ...

Example

  • Can make a PivotTable from 50 million records

Power Query Editor

  • Graphical script editor
  • Part of Excel and Power BI

Course Curriculum

  • 01 Overview
  • 02 Build your first M queries
  • 03 Join tables with M
  • 04 Build M functions to perform tasks
  • 05 Work with lists in M
  • 06 Build M variables to store data
  • 07 Aggregate table data with M
  • 08 Work with tables in M
  • 09 Build conditions with M if expressions
  • 10 Work with M data types
  • 11 Build queries for tables with M
  • 12 Build calculations for tables with M
  • 13 Fetch data from the web with M

Experience

  • Excel experience recommended
  • No Power Query or programming experience required
  • Programming experience will help

What You’ll Need

  • A PC computer
    • Power Query isn’t available on Excel for Mac

What You’ll Need


Your Instructor


Alexandra Kropf
Alexandra Kropf

Alexandra Kropf is Mammoth Interactive's CLO and a software developer with extensive experience in full-stack web development, app development and game development. She has helped produce courses for Mammoth Interactive since 2016, including the Coding Interview series in Java, JavaScript, C++, C#, Python and Swift.

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 12 years, Mammoth Interactive has built a global student community with 4 million courses sold. Mammoth Interactive has released over 350 courses and 3,500 hours of video content.

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.


Course Curriculum



Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!