This Quickstart guide will give you the skills you need to get started with these powerful features.
Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features.
The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data.
The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis.
If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own.
Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI.
Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.
2 activities • 9 videos • duration: 2h 31m
Business author and consultant, specialising in performance measurement and improvement
I am a Fellow of the Chartered Institute of Management Accountants in the UK and work as an author of business courses and a process improvement consultant. I have over 30 years' experience and live near Stirling in Scotland, with my wife, daughter and Cocker Spaniel. I aim to make my courses accessible and understandable. My courses focus on business topics including KPIs, performance measurement, approaches to business improvement, Agile and Lean. I hope you enjoy my courses.
Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.
Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.
Wish the image could actually be made full screen instead of having a wasted black area around and most of the values in the window be almost unreadable, (e.g. ([ together)
Easy to learn, must have for analyst.
Very helpful with the assignment that I have been given in my job.
