Description
Master Excel Power Query: Beginner to Advanced the name of a Udemy website course is how to use Power Query in Excel to solve complex data analysis problems you can. Power Query is a plugin for excel software that since 2016 until now become part of this software and with it delivers. You use this plugin to quickly combine and integrate big data from different sources into… data downloaded from the ERP system into usable information, and complex Excel formulas, to be executed with a single click.
This course is in two parts, Essential Topics and Advanced Working with Power Query will get you trained. You during this period, how to enter, etc. converting, and cleaning data from various sources such as the web and csv you learn the… data available in files and folders simply integrated, you can see how to write functions that M can learn, from the data model and Power Pivot to create relationships between your data that you work with and a dynamic dashboard using Power Query that you create.
Cases in which the course is taught:
- Familiar with Power Query in Excel
- Build a modern dashboard with Power Request
- Automation of the data entry and deletion process
- Know the M language, and write its functions
- The use of complex formulas excels
Master Excel Power Query course profile: Beginner to Advanced:
- French language
- Duration Time: 16 hours and 47 minutes
- Number of courses: 182
- Level of training: Intermediate
- Instructor: Leila Gharani
- File format: mp4
This course
Prerequisite course
- This course is designed for Windows users – Power Query is currently NOT available on native Mac
- Microsoft Excel 2016, Excel, 2019, or Excel for Microsoft 365 (recommended version is Excel 365)
- A basic understanding of Excel pivot tables and Excel formulas and functions is an asset
- Willingness to learn a new skill
Pictures
sample movie
Installation guide
After extracting with the player, your custom view.
Subtitles: English
Quality: 720p
Changes:
Version 2020/12 compared to 2020/6, changes in the number of courses and total time have not, but due to the overrun 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
Any question and problem, Contact us
Password file(s): ngaur.com
File size
6.9 GB