Goal abandoned

The author does not write in the goal 10 months 28 days

General

Пройти курс Master Excel Power Query

Купила курс на новогодней распродаже Master Excel power query

Посмотрела превью к курсу, обещает быть интересно. Преподаватель: Leila Gharani, безумно очаровательная женщина, есть свой канал на youtube.

В курсе 23 раздела. В начале курса предлагают скачать архив всех материалов курса, включая и готовые решения.

Просматривая видео уже понятно, что освоив надстройку Power query можно в разы облегчить себе работу и сэкономить кучу времени, если правильно автоматизировать этот процесс. Я уже вижу некоторые решения при формировании своих ежемесячных отчётов для руководителей.

Всего 180 лекций. Общее время прохождения: 16:36:21

Goal Accomplishment Criteria

Получен диплом о прохождении курса на Udemy

Section 1: Introduction

4 lectures 10:42
******* POWER QUERY ESSENTIALS *******

3 lectures 06:32
The Power of Power Query

11 lectures 01:10:35
Important Power Query Tips & Tricks

12 lectures 56:16
Helpful Power Query Transformations

10 lectures 58:20
Powerful Power Query Transformations

12 lectures 01:11:41
Date & Time Transformations

6 lectures 36:11
Custom Column & Basic M Manipulation

9 lectures 42:24
Power Query Online Data Sources (Online)

9 lectures 37:28
Combining / Appending Data

11 lectures 01:13:18
PROJECT Report on HR Data

5 lectures 20:52
Merge Options – Join Kind Options Explained

12 lectures 01:03:15
When to Use Power Pivot & Load to Data Model

7 lectures 37:18
******* POWER QUERY ADVANCED TO PRO *******

2 lectures 02:05
Solving Complex Data Analysis Problems with Merge

7 lectures 36:44
Advanced Problem Solving using the Power Query Interface

6 lectures 36:46
PROJECT – Create a Modern Excel Dashboard with Power Query & Pivot Tables

14 lectures 01:19:11
Understanding The M Formula Language (Let, Lists, Records & Improving Performance)

13 lectures 01:43:37
Working With List & Table Functions

5 lectures 39:18
Creating & Invoking Custom Functions

5 lectures 27:03
Flexible Importing of Data with the Help of M Functions

7 lectures 47:48
PROJECT – Power Query and Power BI

7 lectures 35:19
Final Words

3 lectures 03:32

1167
03 January 2021, 13:49

The goal is in the group

Тренинги

3157
members
5688
goals

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 10

Step 11

Step 12

Step 13

Step 14

Step 15

Step 16

Step 17

Step 18

Step 19

Step 20

Step 21

Step 22

Step 23

Aracari

Пройти курс Master Excel Power Query

Goal Accomplishment Criteria

Section 1: Introduction

******* POWER QUERY ESSENTIALS *******

The Power of Power Query

Important Power Query Tips & Tricks

Helpful Power Query Transformations

Powerful Power Query Transformations

Date & Time Transformations

Custom Column & Basic M Manipulation

Power Query Online Data Sources (Online)

Combining / Appending Data

PROJECT Report on HR Data

Merge Options – Join Kind Options Explained

When to Use Power Pivot & Load to Data Model

******* POWER QUERY ADVANCED TO PRO *******

Solving Complex Data Analysis Problems with Merge

Advanced Problem Solving using the Power Query Interface

PROJECT – Create a Modern Excel Dashboard with Power Query & Pivot Tables

Understanding The M Formula Language (Let, Lists, Records & Improving Performance)

Working With List & Table Functions

Creating & Invoking Custom Functions

Flexible Importing of Data with the Help of M Functions

PROJECT – Power Query and Power BI

Final Words

Don't miss new posts!

Signup

Sign in.Allowed.

Widget for your goal

Big (450×150 px)

Small (250×100 px)

For PRO only

[email protected]

Maxim Malikov

Sergey Zakharov

* POWER QUERY ESSENTIALS *

* POWER QUERY ADVANCED TO PRO *

Sign in.
Allowed.