• No products in the basket.


Power Query and Power Pivot, the two most popular Excel functions, complement each other by working hand in hand. Import data, model the imported data, and discover many more elements of query and pivot with our exclusive Excel : Power Query and Power Pivot course.

The Excel : Power Query and Power Pivot course is a professionally designed course developed to offer the learner a basic understanding of Excel Power Query and Power Pivot function. Excel has many excellent features that can make our data-related and information-based work truly easy. Query and pivot could be practical examples of those fantastic features. With our highly-crafted course materials, gain the expertise of using query and pivot by discovering their up-to-date formulas and techniques.

The Excel : Power Query and Power Pivot course are divided into 26 modules with short to medium length of video lectures. You can expect to complete the course in 1 hour and 50 minutes and gain formal recognition of your skill. 

Register now and boost your career with exceptional skill!

Aims & Goals Of Excel : Power Query and Power Pivot Course

From the Excel : Power Query and Power Pivot course, you will learn :

  • Learn about the pivot table formulas
  • Be able to do conditional formatting in the pivot table
  • Be able to calculate age in the PowerQuery
  • Be able to import data from Excel into PowerQue
  • Learn how to Merge Queries
  • Discover the PowerPivot menu

What Inside?

Who is this course for?

  • Students
  • Corporate Personnel
  • Business Owner
  • Data Analyst

Career possibilities

By doing this course, you will gain the most in-demand skills for a successful career in any field. The course will sharpen your technical skill by providing all the essentials of mastering Excel Power Query and Power Pivot fictions, enabling you to boost your CV and become a qualified and advantageous candidate for any relevant job!


The Excel : Power Query and Power Pivot course is open to all. There are no specific requirements and you can take the course from anywhere in the world. The course is accessible via any modern device with an internet connection and you can study at your own pace.


After successfully completing the course by passing the assessment, you will be qualified to get a CPD accredited certificate. We provide both PDF and hardcopy certificates.

You can get a PDF certificate for £4.99, hardcopy certificate for £9.99 and both for only £11.99.



Course Reviews


5 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

This course includes

  • 365 Days
  • Course Certificate
  • 1 hour, 50 minutes

We provide courses to enhance intellectual curiosity and deepen the learning process. We aim to prepare learners to discover opportunities, generate new paradigms and make a difference in their profession, career and society.

Certificate Code

© iAccountancy | All rights reserved
Select your currency