Advanced Microsoft Power Query and Power Pivot

Woodthorpe IT Solutions
Course summary
Length: 2 days
Price: 1,400 GBP excl. VAT
Language: English
Location: Nationwide
Next available date: Contact us to discuss dates (At your office) - Nationwide

Course Description

Power Pivot and Query

If you need to connect to multiple data sources of various types and then analyse the results, then Microsoft Power Query and Power Pivot are the tools of choice.

Power Query and Power Pivot are free add-ins for Microsoft Excel – they significantly extend the functionality of Excel. With these tools you are able to connect to a wide variety of data sources, such as; Excel workbook / worksheet, Access database, SQL, SSAS and more. Once the data source(s) is connected to Power Pivot, users can build simple or more complex data models for analysis purposes. Because Power Query and Power Pivot are built directly into the Excel platform, most users feel comfortable with them from day one as their interfaces both closely align with Excel’s look and feel. 

Why Woodthorpe IT Solutions?

  • Sessions can be delivered at your office for up to 8 people.
  • Questions encouraged.  Courses delivered by industry experts who do not read from a manual.
  • Notes provided in electronic format.
  • Attendees will be sent a tips email every 2 weeks.
  • Attend free webinar sessions after the course.
  • Post course support provided via email with no time limit.

Suitability - Who should attend?

Attendees should have experience within Microsoft Excel before they attend this course.

Our tutors are very patient and will ensure all attendees leave with increased confidence.

Outcome / Qualification etc.

Each attendee will be able to manipulate data quickly using Power Query and present it using Power Pivot.  They will receive an electronic attendance certificate. 

Training Course Content

During this 2 day training course you will learn:

  • About Power Query’s most popular built-in data transformation tools and its relationship with Power Pivot
  • How to connect Power Query to a range of data sources; Excel, CSV & Access
  • How to blend data from multiple sources into a single data stream for analysis
  • How to load data from Power Query directly into Power Pivot
  • How to load data directly into Power Pivot from other sources; Excel, CSV, Access and others
  • How to create a range of ‘measures’ and ‘calculated columns’ to manipulate data in the data model
  • How to use some of the most common DAX functions to extend the power of the Power Pivot data model


The cost for this in-house training is £700+VAT per day.

What is included?

  • Reasonable travel to your site on UK main land (Except to central London).
  • Provision of a projector.
  • Customisation of course content if required.

What is not included?

  • If the tutor has to travel more than 2 hours to the training site hotel costs may be applicable.
  • If the tutor has to travel to Central London train and taxi costs may be applicable.

Get Inspired! Watch the Video

Woodthorpe IT Solutions specialise in delivering onsite Microsoft Office training and providing consultancy support to businesses. We are a small and dedicated team who travel the length and breadth of the country providing our service. We have worked, and continue to work for companies such as Burberry, DeBeers, LVMH, John Lewis, Asics and many more.

Provider: Woodthorpe IT Solutions

Microsoft Office Training

Woodthorpe IT Solutions - Microsoft Office Training and Consultancy

We are here to help you get the most from Microsoft Office, our industry experts entertain and teach during any day we deliver for you.  No question is too small or problem too big for us to help you with, we...

Read more and show all courses with Provider: Woodthorpe IT Solutions

Request information - obligation free

Fill out your details to find out more about Advanced Microsoft Power Query and Power Pivot.

  Contact the provider

  Get more information

  Register your interest


Contact information for Woodthorpe IT Solutions

Woodthorpe IT Solutions

4 Haycroft Close, Great Sutton
CH66 2GY Ellesmere Port, Cheshire

 Show phone number
Enter & win £50 voucher


Take our survey and go in the draw to win a £50 Amazon Voucher

Take the survey

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Request information

Find out more about this Advanced Microsoft Power Query and Power Pivot course - simply fill out your details:

Similar courses

With Activia, IT User training comes the way you want it: at your place or ours; off-the-shelf or bespoke; scheduled public classes or closed private courses matched to your requirements.

Find more courses here