Udemy – Master Excel Power Query Beginner to Advanced (including M) 2021-10/2021-11 – Downloadly
Description
Master Excel Power Query: Beginner to Advanced – the name of a course on the website Udemy – describes how to use Power Query in Excel to solve complex data analysis problems. Power Query is a plugin for Excel software that has been part of and featured with this software since 2016. This plugin allows you to quickly combine and integrate large amounts of data from different sources, convert data downloaded from the ERP system into actionable information, and execute complex Excel formulas with one click.
This course consists of two parts, essential topics and the advanced work with Power Query in which you will be trained. You during this period, how you enter, etc. By converting and cleaning data from various sources such as the web and CSV, you will learn what data is available in the easily integrated files and folders. You can see how to write functions that M can learn from the data model and Power Pivot, create relationships between your data, and create a dynamic dashboard using Power Query.
Cases in which the course is taught:
- Familiar with Power Query in Excel
- Create a modern dashboard with Power query
- Automate the process of entering and deleting data
- Familiarity with the M language and writing its functions
- The use of complex formulas stands out
Profile course Master Excel Power Query: Beginner to advanced:
- Language: English
- Duration: 16 hours and 47 minutes
- Number of courses: 182
- Education level: intermediate
- Lecturer: Leila Gharani
- File format: mp4
This course
Prerequisite course
- This course is aimed at Windows users – Power Query is NOT currently available on native Mac
- Microsoft Excel 2016, Excel 2019 or Excel for Microsoft 365 (recommended version is Excel 365)
- Basic knowledge of Excel pivot tables and Excel formulas and functions is an advantage
- Willingness to learn a new skill
Pictures
Example film
installation Guide
After extracting with the player you will get your custom view.
Subtitles: English`
Quality: 720p
Changes:
Version 2020/12 has no changes in the number of courses and total time compared to 2020/6, but due to the passage of 6 months since the previous update, etc. is updated.
The 2021/10 version has increased by 2 lessons and 11 minutes compared to 2021/3.
Download link
Password file(s): free software
File size
6.9GB