Advanced Excel course

Advanced Excel course

3 reviews Write a review
Product Code: Office Productivity

  • 450.00€

  • Ex Tax: 450.00€
lessons
Power Query is an MS Excel add-in that can retrieve data from more than 40 different sources, transform it into the required structure and keep the data up-to-date.

Power Pivot is an Excel add-in that extends the functionality of summary tables and allows you to work with files larger than 1,048,576 rows.

By learning to use these 2 add-ins, you will reduce the time of routine tasks by several times.

Who this course is for:
economist
top manager
financier
analyst

What you will learn
Power Query basics
Power Pivot basics

Course content 7 sections - 10 lectures - Total duration 36 min.

Introduction to Power Query
Unstructured Data
Connecting to a file folder and loading it into a data model
Creating Relationships
Creating a calculated column
Creating measures
Test your knowledge

1 lesson - 4 min
1 lesson - 3 min
1 lesson - 5 min
1 lesson - 3 min
1 lecture - 2 min
1 lecture - 7 min
4 lectures - 12 min

 

Write a review

Note: HTML is not translated!
    Bad           Good