Excel Power Query Beginner to Advanced (including M)

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

  • Excel Power Query has been a part of Excel since Excel 2016! It’s in the Data tab under Get and Transform.Unfortunately many people haven’t explored what it has to offer!

    They continue doing things the old “manual” way, Or the “complex” way with difficult formulas.

    Power Query is like an Instant Miracle Cure to your difficult data analysis problems:

    • You can quickly combine and consolidate large data from different sources like Excel, text files, the web, online services, databases, even your Outlook! (Plus many more).
    • You can convert downloads from your ERP system into information you can use.
    • Replace complex Excel formulas with a click of a button.
    • Turn complex data transformations that took forever to do (such as unpivoting data), to just a few clicks.

    And these are just a few examples of what it can do!

    On top, your actions are recorded so whenever you get new data, all you have to do is click Refresh!

    Guess what? You can apply ALL the knowledge you learn in this course to Power BI as well!

    You might be thinking…

Here are some the things you’ll accomplish:

  • Import, transform and clean large data from different sources (Excel, csv, web, sharepoint etc.)
  • Combine data from multiple Excel workbooks into a single Table (or Pivot Table)
  • Consolidate data from all files in a folder (and make exceptions as you need)
  • Understand and write your own Custom Power Query M functions to do tasks you can’t easily do with the interface
  • Use Excel’s Data Model and Power Pivot to Create Relationships between your data
  • Understand when to use Excel Power Query and when to Load data to Excel’s Data Model
  • Create an interactive Excel Dashboard with Power Query, Data Model, Pivot Tables and slicers
  • Use Power Query in Power BI and create a dashboard you share online
Show More

What Will You Learn?

  • What you'll learn
  • Master Power Query in Excel (& Power BI)
  • Create Modern Excel Dashboards with Power Query and Excel's Data Model
  • Reduce Hours of Work to One Click (Simply press Refresh)
  • Automate the process of Importing, Cleaning, and Combining data
  • Learn Power Query M language and create your own M Functions
  • Load data into Excel from Multiple Sources such as SharePoint, csv, Web, and even Email
  • Learn how to Avoid future errors by creating Robust Solutions
  • Apply new concepts to real-life examples and solve complex data analysis challenges