Master Excel Power Query: Beginner to Advanced (including M)
Master Excel Power Query: Beginner to Advanced (including M)
Use Excel Power Query like an Expert from the Start! Solve Difficult Data Analysis Problems // 200+ workbooks included
Created by Leila Gharani | 16 hours on-demand video course
The course is split in 2 parts: Essentials and Advanced. Just from the Power Query Essentials you’ll be able to solve many problems and make a meaningful impact in your work. In the Excel Advanced Power Query section you’ll tackle more complex scenarios. The real world comes with messy data. You might need to write custom M functions to transform the data to the way you need. In this section you will also learn how Power Query M thinks and works.
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
Recommeded Course
Complete 2-in-1 Python for Business and Finance Bootcamp
Python Data Science with Pandas: Master 12 Advanced Projects
