Excel Power Query and Pivot

From Zero to PRO

Dive into the world of data analytics with our course and become a confident expert!

In simple language about the complex clear and structured

Mentor support
no limit on answers

Up-to-date materials Regular updates every 3 months

Practical assignments We teach with real-life examples

The value of learning advanced Power BI and Excel functions

Mastering these skills will allow you to confidently solve complex problems and provide complex solutions without the need to call programmers, as well as create queries with multiple parameters, perform complex calculations and develop advanced formulas in DAX.

Who this course is suitable for

Big Data and Reporting Professionals:

You will learn how to automate data processing and reporting processes, which will significantly reduce the time spent on routine tasks and increase the accuracy of results.

Analysts:

You'll learn tools to process and analyze data, so you can more effectively extract valuable insights and make informed decisions.

Managers:

You'll develop skills in data integration and analysis that will simplify project management and improve team coordination.

Expected results from the course

No water: you'll be immersed in spreadsheet automation right from the start.

Practical assignments: you will have the opportunity to check your answers and correct mistakes.

Real-world examples: each topic of the course is based on real-world problems, which will allow you to speed up their solution significantly after the training.

What you will learn on the course

Data processing

You will learn how to work with large amounts of data from various sources and create complex queries with many parameters on your own without the help of programmers.

1

Advanced Computing

You will be able to develop computable tables, columns, and measures ranging from simple aggregates to formulas with moving periods.

2

Reporting automation

You will be able to create sophisticated interactive dashboards with advanced navigation, making it easier to find answers to business questions.

3

Effective data visualization

You'll learn how to create visualizations that help you better understand your data and make it more accessible for analysis.

4

Optimize workflows

You will be able to automate routine tasks, allowing you to focus on more important aspects of your work and increase your overall productivity.

5

Author and course expert

Certified Microsoft Excel Expert (MOS Expert)

Individual and group Excel trainer

Daily practicing Excel since 2012 in analytical positions - currently Expert in promotional analytics in the international company Unit Wrigley.

Successfully implemented information local systems-tools based on MS Excel in large companies PJSC ROSSETI and Unit Wrigley.

Mark Furman

Author and course expert

Module 1. Introduction

Module 2. Theory

Module 3. Getting Started: Fundamentals for a Quick Start

Module 3. Getting Started: Fundamentals for a Quick Start

Module 4. Power Query: Data Loading and Conversion

Module 5. Power Pivot: modeling - relationships between tables

Module 6. DAX in Power Pivot: Calculations for model calculation/enrichment

Module 7. Power BI basics in terms of data visualization in the report

After training you will receive a Certificate confirming the acquired skills.

O will be an additional argument for your employment.

Choose the appropriate tariff

Independent

$16

2

- Training program - 8 modules
- Lecture materials - 94
- Practical tasks
- Chat for students
- No feedback
- Access to the course - 1 month

Supportive

$25

3

- Training program - 8 modules
- Lecture materials - 94
- Practical tasks
- Chat for students
- Feedback from curators
- Access to the course - 6 months
- Certificate

Corporate

$320

- Groups of at least 5 people
- Training program - 8 modules
- All course materials
- Curator support
- Access for 24 months
- Add to group chat
- Certificate

5

Accompanying

$42

4

- Training program - 8 modules
- Lecture materials - 94
- Practical tasks
- Chat for students
- Curator support
- Feedback with the mentor
- Access to the course - 12 months
- Certificate

1

Introductory

$5

- Introduction to the course - 1 module
- Lecture materials - 3
- No feedback
- Access - unlimited
- Without certificate

We have already trained

What our alumni say about the course

Elena Menshenina, 28 years old

The course was great! I didn't know what Power Query and DAX were before, but here everything is explained in such a simple and accessible way that I quickly understood everything. Now I have automated many processes at work, my bosses are shocked at how much time we save. If I had known it was so easy to understand - I would have taken the course a long time ago.

Kseniya Morozova, 27 years old

I am very satisfied with the course! It was rich and informative. I especially liked the practical tasks, which helped to consolidate the knowledge. Now I can quickly process large amounts of data and do it with pleasure. Thank you for a great experience!

Anna Sidorova, 29 years old

The course exceeded all my expectations! I never thought that Excel could be such a powerful tool. The instructor explained everything clearly and easily. Now I confidently use Power Query to analyze data at work, and it has greatly simplified my life.

Denis Fedorov, 35 years old

The сourse was very useful! I learned not only how to work with Power Query, but also how to apply this knowledge in real projects. The instructor was always in touch and ready to help with any questions. Now I feel confident in working with data.

Victor Kovalyov, 31 years old

This course was a real breakthrough for me! I always thought Excel was complicated, but thanks to clear explanations and practical exercises I quickly mastered all the functions. Now I can create reports and visualizations on my own, which impresses my colleagues very much.

Tatiana Lebedeva, 26 years old

I am delighted with the course! The teacher emphasized on practical examples, which helped me to understand the material better. Now I use DAX to create complex formulas, and it has greatly improved the quality of my work. I recommend it to anyone who wants to improve their Excel skills!

Choose the appropriate tariff