Power Query Essentials - online

Nyhet

This online course in Power Query is for anyone who wants to further increase their knowledge and skills within Excel. If you want to learn how to handle large databases like a professional, then this is the course for you! Save time by learning how to organize and analyse data at a rapid pace. 

Pris 1 495 kr
Typ Onlinekurs
Platser kvar Ja
Fler kurstillfällen

Course description

Power Query or "get data and transform" is a self-service business intelligence for Excel which is used for discovering, combining, and refining data.

Power Query gives us access data from several different data sources. In this course, we will go through the basic functions of Power Query, and how we can apply them in different situations.

At this time, Power Query only exists on the Windows version of Excel.

Information about the course

  • Full access to the course for 12 months
  • 24 lessons
  • Total video time: 42 minutes
  • Average lesson duration: 1 min 45 sec

Expenditure of time

The online course consists of 24 short lessons, in total 42 minutes of  video time. You will have access to the course for 12 months so you can go back and repeat whenever needed.

The purpose of the online course is to quickly become an advanced user of Excel. The course will make the program an important tool in your work that helps you save time and increase

After the course, Excel will be a more natural tool in your work. Among other things, you will have learned how to manage a database and analyse them by using Power Query. See the course chapters for further information.

The online course is a collaboration between FAR and Learnesy.

Chapters

  1. Get Data
  2. Data handling
  3. Functions
  4. Grouping
  5. Combine Queries
  6. Joining

Video example


Requirements

Basic skills in Excel is required.