WHAT YOU WILL LEARN

Learn how to use Power Query (Get & Transform) to consolidate workbooks & worksheets, clean up your dirty data and transform your data into easy to read reports!
Automate your data imports with Power Query Steps, transform your data with Power Query calculations and create Data Connections from various external sources like Excel, PDF, SQL, Access and many more!
The skills that you need to INCREASE YOUR EXCEL LEVEL, save hours from your busy schedule, take your career to a new level and get the confidence to go for a promotion or land your dream job!
Learn Power Query M, the functional programming language used in Power Query to mashup your data!

THIS COURSE INCLUDES:

Teacher with solid fill 3 hours on-demand videos

Play with solid fill   50 bite sized video training

Download with solid fill  Downloadable practice workbooks & resources

 

Smart Phone with solid fill   Lifetime Access on any device

Trophy outline  Certificate of Completion

Call center with solid fill  24x7 support

 

    WHO THIS COURSE IS FOR

    • You're starting to learn Microsoft Excel late in life or you've been using it for decades, you're a manager, accountant, finance analyst, administrator, CFO or any other corporate professional, and have wondered how to ADVANCE your Excel skills and level so you can get an advantage over your colleagues or peers.
    • You're preparing for job interviews, wishing for a quicker way to become confident at Excel, so you’ll have a greater chance of landing a job!
    • You often search on Google and YouTube to find answers to your Excel problems. Wishing for a more comprehensive, reliable, and up-to-date source of answers with quick support whenever you get stuck.
    • You spend hours each month running reports and analyzing data. Wondering if there’s a better, more efficient way of doing things, so you can save hours from your busy schedule and go home early to your loved ones.
    • You’ve been given new data handling, analysis, and reporting responsibilities with little or no Excel training.
    • If you want to dramatically reduce repetition, stress, and overtime and exponentially increase your chances of a promotion, pay raise or new job!
    • This course is compatible with Microsoft Excel 2007, 2010, 2013, 2016, 2019, 2022 or Microsoft 365

    COURSE CURRICULUM

    57
    Download Workbooks
    Power Query Cheat Sheet - Getting Started with Power Query
    Power Query Cheat Sheet - M Functions
    Introduction
    Query Editor Overview
    Installing Power Query in Excel 2010
    Installing Power Query in Excel 2013
    Excel 2010 & 2013 Add-In Download Link
    Trim
    Format Dates and Values
    Parsing URLs (Split Columns by Delimiter)
    Split Text Fields (Split Columns by Delimiter & Number of Characters)
    Group By
    Unpivot Columns
    Pivot Columns
    Split Columns into Other Columns with Delimiters
    Filter Your Data & Add a "Year" Column
    Sort Your Data
    Transform v Add Column
    Add Column From Examples
    Group and Rank Items
    Modulo
    FROM FOLDER: Consolidate Workbooks - Part 1
    FROM FOLDER: Consolidate Workbooks - Part 2
    FROM FOLDER: Extract Data from Forms
    FROM WORKBOOK: Extract & Consolidate Data Based on Multiple Criteria
    FROM WORKBOOK: Extract & Consolidate Data from Multiple Worksheets
    Append Worksheets to Consolidate Data
    Merge - Joins Introduction
    Merge - Full Outer Join (all rows from both)
    Merge - Left Outer Join (all from first, matching from second)
    Merge - Right Outer Join (all from second, matching from first)
    Merge - Inner Join (only matching rows)
    Merge - Left Anti Join (rows only in first)
    Merge - Right Anti Join (rows only in second)
    BONUS EXAMPLE: Merge - Left Outer
    BONUS EXAMPLE: Merge - Full Outer Join
    BONUS EXAMPLE: Merge - Right Anti Join
    Convert Reports into Pivot Tables
    Get a List of File Names
    Get File Names Based on User Selection
    M Overview
    M Functions Cheat Sheet
    M Function List using #Shared
    Using M Functions
    Your Assignment - Create Custom Columns Using M Functions!
    Viewing M Code
    Simple M Expressions
    Simple M Expressions - Nested Expressions
    M Variables
    M Functions
    M Functions - Reusable Functions
    M Functions - Invoking
    Passing M Functions
    Passing M Functions - Using the "each" keyword
    [Quiz] - Advanced - Power Query (Get & Transform)
    Unlock your Certificate of Completion

    SALE PRICE: $97

    WHAT'S INCLUDED:
    • Lifetime Access on any device
    • 30 Days Money Back Guarantee
    • Beginners, Intermediate & Advanced levels
    • 3 hours on-demand videos
    • 50 bite sized video training
    • Downloadable practice workbooks & resources
    • Certificate of Completion
    • 24x7 Support
      Order Now

      But Don’t Just Take Our Word For It

      Thousands of managers, accountants, finance analysts, administrators, CFOs and other corporate professionals, trust MyExcelOnline to enhance their professional development and every day.

      Some of our course students work at...

      Save with our Courses Bundles!

      Intro to Excel Bundle

      An introduction to Microsoft Excel to get you up to speed and confident using the most common features!

      • Introduction to Excel
      • Formulas
      • Formatting
      • Charts
      • Printing
      • 5 Hours | 56 Lectures | Beginner Level | Certificate of Completion | 24x7 Support | Lifetime Access

      Learn More

      Intermediate Excel Bundle

      Learn the must know Microsoft Excel features to elevate your Excel level!

      • Formulas
      • Pivot Tables
      • Macros & VBA
      • Data & Analysis
      • Charts
      • 11 Hours | 216 Lectures | Intermediate Level | Certificate of Completion | 24x7 Support | Lifetime Access

      Learn More

      Advanced Excel Bundle

      Learn the must know Microsoft Excel features to advance your Excel level!

      • Formulas
      • Pivot Tables
      • Macros & VBA
      • Power Query
      • Power Pivot
      • Power BI
      • Excel Dashboards
      • Financial Modeling
      • Charts
      • 40 Hours | 569 Lectures | All Levels | Certificate of Completion | 24x7 Support | Lifetime Access

      Learn More

      Microsoft Office Bundle

      Learn the must know Microsoft Office applications to make you more productive at work!

      • Outlook
      • PowerPoint
      • Word
      • Teams
      • OneNote
      • Access
      • Power Automate
      • Power Apps
      • Project
      • SharePoint
      • Visio
      • Forms
      • 14 Hours | 50 Lectures | All Levels | Certificate of Completion | 24x7 Support | Lifetime Access

      Learn More

      Frequently Asked Questions

      • You're starting to learn Microsoft Excel late in life or you've been using it for decades, you're a manager, accountant, finance analyst, administrator, CFO or any other corporate professional, and have wondered how to get an advantage over your colleagues or peers.
      • You're preparing for job interviews, wishing for a quicker way to become confident at Excel, so you’ll have a greater chance of landing a job!
      • You often search on Google and YouTube to find answers to your Excel problems. Wishing for a more comprehensive, reliable, and up-to-date source of answers with quick support whenever you get stuck.
      • You spend hours each month running reports and analyzing data. Wondering if there’s a better, more efficient way of doing things, so you can save hours from your busy schedule and go home early to your loved ones.
      • You’ve been given new data handling, analysis, and reporting responsibilities with little or no Excel training.

      Anyone who wants to elevate their Excel knowledge & skills, including…

      • New users, beginners, intermediates and advanced Excel users.
      • Professionals working in the corporate world or government sectors who want to leverage Excel for increased productivity, accurate data management and reporting.
      • People who want to change careers and apply for a new job that requires knowledge of Microsoft Excel
      • If you want to dramatically reduce repetition, stress, and overtime and exponentially increase your chances of a promotion, pay raise or new job!
      • It doesn’t matter if you are completely new to Excel. No prior Excel knowledge is necessary to participate in this course.


      The tutorials were recorded using Excel 2010, 2013, 2016, 2019, 2022 and Microsoft 365.

      Most of the concepts taught are compatible with:

      • Excel for Windows: 2007, 2010, 2013, 2016, 2019, 2022 & Microsoft 365
      • Excel for Mac: 2011, 2016, 2019, 2022 & Microsoft 365

      No - this isn’t like school - this is self-paced learning - you decide when you start and when you finish.

      You get access to all the training materials for life. 

      You can access the course site from your work computer, home computer, tablet, smartphone or any other device with an internet connection.

      The course site remembers your progress, so you can pick-up right where you left off on any device. That means you can watch a few videos at work, then continue right where you left off on your home computer.

      Yes! You will be able to download and keep all the excercise files in each of the courses as well as our PDF Cheat Sheets.

      This makes it easy to follow along and practice with our data, whether you are online or offline.

      Yes, this course and all the training materials can be accessed on any tablet or smartphone, and it looks beautiful. 

      You can watch the course on your iPad, Tablet or mobile phone anywhere and anytime!

      Each video has a discussion section. You can use this section to ask questions and see what questions other students have. We will be there helping to answer your questions.


      You can also send an email to our dedicated email support if you cannot find your answer.

      Yes, you can use your company's credit card to pay for the course. A receipt will also be emailed to you that you can submit for reimbursement to your employer. 

      Most companies are willing to invest in making their employees even more awesome at Excel!

      We accept all major credit cards like Visa, MasterCard, American Express, Apple Pay and PayPal.

      Through our partners like Klarna, Afterpay, and Affirm, we can give you the flexibility of breaking up your purchase into easy installments.

      The course fees are shown in USD $

      Get in contact with us if you want to pay via bank transfer or check at support@myexcelonline.com

      If you need a Tax Invoice for your records, then this can be emailed to you. We are happy to complete any paperwork your company or government may require.

      Yes! Each course comes with lifetime access to all course materials.

      There are team packages available at a discounted price!

      Each team member will have their own account and be able to track their progress in the course. 

      Get a quote by filling in this form here: https://www.myexcelonline.com/corporate-academy-team-packages

      Yes! You will receive a Completion Certificate at the end of each course.

      You can cancel at any time within the first 30 days and receive a full refund.


      Plus, you get to keep all our downloadable course Cheat Sheets and Workbooks!