Who’s this course for?
The online course in Power Pivot & DAX is for anyone who wants to further increase their knowledge within Excel. If you work with large volumes of data, then this is a course perfect for you.

This online course is included in our course package Power Bundle. With Power Bundle, you will become an expert in data modeling technology. Our online courses in Power BI and Power Query are included. Read more about Power BI and Power Query

We recommend you to take the online courses in following order:

  1. Power Query
  2. Power Pivot & DAX
  3. Power BI

What will I learn?
Power Pivot is a powerful add on for Excel and DAX (Data Analysis Expressions) includes additional functions to use when you work with relational data and dynamic aggregation. With Power Pivot & DAX you can create data models, data analysis and import data from different various sources.

In this course we’ll start with go through Power Pivot’s basic functions, and how we can apply them to different situations. We’ll then move forward and learn about relational data, DAX and KPI. Further down in this page you can see which chapters and lessons are included in the course.

If you have any questions, visit our FAQ page or feel free to contact us

This is included in the online course:

Do you need to install Excel on your computer? You can buy Excel here at Microsoft

Who is this course for?

This online course in Power BI is meant for anyone who wants to familiarize themselves with Power BI, Microsoft’s program that visualizes large amounts of data and provides tools for quickly making well-informed decisions. For this course, no previous knowledge is required!

Power BI online course is included in our course package Power Bundle. With Power Bundle, you will become an expert in data modelling technology. Our online courses in Power Pivot & DAX and Power Query are included. Read more about Power Pivot & DAX and Power Query

We recommend you take the online courses in following order:

  1. Power Query
  2. Power Pivot & DAX
  3. Power BI

What will I learn?

Power BI is Microsoft’s business intelligence service. Business Intelligence is all about analysing and processing data in order to create a better understanding of an organization. In the course, you will learn Power BI’s basic features as well as how the service works in general. You will learn, among other things, how to get, visualize, transform and share data and build reports.

The course is made up of short lessons and chapters. If you were to access this course, you will soon have made your investment back in the currency of time.

This is included in the online course:

Do you need to install Excel on your computer? You can buy Excel here at Microsoft

Who’s this course for?

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. At this time, Power Query only exists on the Windows version of Excel.

What will I learn?

Power Query, or “Get and Transform”, is Excel’s data management tool used, among other things, to import, process and combine data. Power Query gives us access to data from several different data sources. In this course we go through Power Query’s basic functions, and how we can apply them to different situations. After each lesson you’ll be asked to take a quiz to test your knowledge. Navigate further down to see which chapters and lessons are included in the course.

Our pedagogy is based on Nano-learning means that the lessons are short –  average 2 minutes. After completing a course, you will be awarded a personal course certificate, and you can at any time log in and repeat any parts of the course you are unsure of or have forgotten.

If you have any questions, visit our FAQ page or feel free to contact us

This is included in the online course:

Do you need to install Excel on your computer? You can buy Excel here at Microsoft

Who’s this course for?

This online course in Excel PivotTables will take you step by step through the powerful tool which is the PivotTable. If you spend a lot of time in Excel without using PivotTables, chances are that you spend a lot of time calculating, summarizing and analysing things that Excel can do for you. By creating a PivotTable it is easier to see comparison, patterns and trend in your data.

What will I learn?

The online course in Excel PivotTables is made up of short lessons and chapters. If you were to access this course, you will soon have made your investment back in the currency of time.

The course will teach you how to arrange, group, filter and sort your PivotTables in new, more effective ways. After each chapter you’ll be asked to participate in a quiz to test your knowledge. Go to the course to see which chapters and lessons are included in the course.

Our pedagogy is based on Nano-learning means that the lessons are short – average 2 minutes. After completing a course, you will be awarded a personal course certificate, and you can at any time log in and repeat any parts of the course you are unsure of or have forgotten.

If you have any questions, visit our FAQ page or feel free to contact us

This is included in the online course:

Do you need to install Excel on your computer? You can buy Excel here at Microsoft

Who’s this course for?

This online course in Excel Functions will teach you the logic behind functions at the same time as it’s your very own online-library filled to the brim with functions. All available to watch and repeat whenever you need. With increased knowledge in Excel you can save time in your work, there may be elements in your work that can easily be bypassed with a function.

The online course in Excel functions is aimed at those who have basic knowledge of Excel and have an understanding of how Excel functions are used but want to learn many more useful functions.

What will I learn?

Some of the functions that you will learn to use are  IF, VLOOKUP,  COUNT and INDEX.

The course consists of 12 chapters with short 1-minute lessons, all with the same structure. Teaching you 95 different functions. The final goal of The Excel Function Guide is to increase your knowledge which will save you time. Navigate further down to see which chapters and lessons are included in the course.

Our pedagogy is based on Nano-learning means that the lessons are short –  average 2 minutes. After completing a course, you will be awarded a personal course certificate, and you can at any time log in and repeat any parts of the course you are unsure of or have forgotten.

If you have any questions, visit our FAQ page or feel free to contact us

This is included in the online course:

Do you need to install Excel on your computer? You can buy Excel here at Microsoft

Who’s this course for?

Excel Essentials English is an online course in Microsoft Excel, perfect for anyone who is self-taught or a beginner in Excel and wishes to master the software.

With Excel you can easily turn data into insights. In Excel you can use functions to calculate, create diagrams and tables. Another great feature with the software is that you can work with your colleagues on the latest version for real-time collaboration. 

What will I learn?

The online course in Excel will start off by teaching you the basics in Excel, how to line up your data to look professional and other basic functionalities. We then move on to more advanced areas like Pivot tables, how to perform certain functions such as “Vlookup and “IFerror” as well as how to save time using macros.

Our pedagogy is based on Nano-learning means that the lessons are short –  average 2 minutes. After completing a course, you will be awarded a personal course certificate, and you can at any time log in and repeat any parts of the course you are unsure of or have forgotten.

If you have any questions, visit our FAQ page or feel free to contact us

Excel version:
The lessons are based on Excel 2019 and will work well for all users with Office 2007/2010/2013/2016/365.

This is included in the online course:

Do you need to install Excel on your computer? You can buy Excel here at Microsoft