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.
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.
This is included in the online course:
Do you need to install Excel on your computer? You can buy Excel here at Microsoft