Description
Master Excel Power Query Beginner to Advanced (including M) is the name of a course from Udemy that teaches you how to use Power Query in Excel to solve complex data analysis problems. Power Query is an extension for Excel software that has become a part of this software since 2016 and is provided with it. Using this plugin, you can quickly combine and integrate big data from different sources, convert data downloaded from the ERP system into usable information, and run complex Excel formulas in one click.
This course teaches you the essential and advanced topics of working with Power Query in two parts. During this course, you will learn how to import, convert, and clean large data from various sources such as the web and csv, easily integrate data in files and folders, how to write M functions. Learn how to use Data Model and Power Pivot to create relationships between your data, and create a dynamic dashboard using Power Query.
Items taught in this course:
- Getting to know Power Query in Excel
- Making modern dashboards with Power Query
- Automating the process of entering and cleaning data
- Getting to know the M language and writing its functions
- Using complex Excel formulas
Master Excel Power Query Beginner to Advanced course specifications (including M):
- English language
- Duration: 16 hours and 47 minutes
- Number of courses: 182
- Education level: Intermediate
- teacher : Leila Gharani
- File format: mp4
Course headings
Course prerequisites
- This course is designed for Windows users – Power Query is currently NOT available in native Mac
- Microsoft Excel 2016, Excel 2019 or Excel for Microsoft 365 (Recommended version is Excel 365)
- Basic understanding of Excel Pivot Tables and Excel Formulas & Functions is an asset
- Willingness to learn a new skill
Pictures
Sample video
Installation guide
After extracting, watch with your favorite player.
English subtitle
Quality: 720p
Changes:
The 2020/12 version has no changes in the number of lessons and total time compared to 2020/6, but it has been updated because more than 6 months have passed since the previous update.
The 2021/3 version has not changed in the number of courses and total time compared to 2020/12.
The 2021/10 version has increased the number of 2 lessons and 11 minutes compared to 2021/3.
The 2021/11 version has not changed in the number of courses and total time compared to 2021/10 and has not been updated.
download link
Password file(s): www.downloadly.ir
Size
6.9 GB
Be the first to comment