Udemy – Master Excel Power Query Beginner to Advanced (including M) 2020-12/2021-1

Description

Master Excel Power Query: Beginner to Advanced is the name of a training course from the Udemy site that teaches you how to use Power Query in Excel to solve complex data analysis problems. Power Query is an add-on for Excel software that has been part of this software since 2016 and comes with it. With this plugin you can quickly integrate and integrate big data from different sources, convert data downloaded from the ERP system into usable information, and run complex Excel formulas with one click.

This course will teach 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 clear big data from various sources such as the web and csv, easily integrate the data in files and folders, learn how to write M functions Learn how to use Data Model and Power Pivot to build relationships between your data, and create a dynamic dashboard with Power Query.

Items that are taught in this course

Introduction to Power Query in Excel

Build modern dashboards with Power Query

Automate the process of entering and clearing data

Familiarity with the M language and writing its functions

Use complex Excel formulas

Master Excel Power Query course specifications: Beginner to Advanced

English language

Duration: 16 hours and 36 minutes

Number of lessons: 180

Level of education: Intermediate

Instructor: Leila Gharani

File format: mp4

Prerequisite

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

Installation

After Extract, watch with your favorite Player.

English subtitle

Quality: 720p

This tutorial was purchased by Downloadli with the participation of one of the users.

Changes:

Version 2020/12 has not changed in number of courses and total time compared to 2020/6, but it has been updated due to the passage of more than 6 months from the previous update.

Version 2021/1 has not changed in number of courses and total time compared to 2020/12.