fbpx
Microsoft Excel Public Courses in London, Onsite Courses Nationwide, Virtual courses Globally

Call us on 020 7183 7740

Lines open 9am to 6pm

Email us [email protected]

Microsoft Excel PowerQuery Training

With Power Query, you can

  • Find and connect data across a wide variety of sources.
  • Merge and shape data sources to match your data analysis requirements or prepare it for further analysis and modeling with tools such as PowerPivot and PowerView.
  • Perform data cleansing operations.
  • Import data from multiple log files.
  • Pull data into Power Pivot from new data sources, such as XML, and File Folders as refreshable connections.

Public PowerQuery / PowerPivot Courses in London.

Chris James delivering Excel PowerQuery training in London

Our Approach with Excel PowerQuery training

Microsoft Excel PowerQuery and PowerPivot training is a specialty of ours. We pride ourselves on covering these Business Intelligence topics in Excel very well. Our PowerQuery/ PowerPivot trainers will not let the subject go over anyone’s head (we feel strongly about this); so a potentially complex subject is always broken down into understandable sections which each build on one another as the training course unfolds.

  • Small group sizes – max 8 users
  • 1 Day private group courses on your site
  • Public course scheduled each month at our training centre in Bishopsgate London

Upcoming public Excel PowerQuery courses in Bishopsgate, London:

Excel PowerQuery 1 day course

NEXT DATE:- tbc

TO BOOK or to discuss our PowerQuery training in more detail, please call 020 7183 7740 or email [email protected]

Excel PowerQuery Introduction Course

Course Aims

To import, tidy up, transform data and output a workable clean dataset for analysing

Course Objectives

By the end of the session you will be able to:

  • Understand what Power Query and PowerPivot is
  • Identify where in the data analysis process Power Query sits
  • Import data from various sources
  • Restructure and transform data ready for output
  • Loading data to a Table Query, Create a Connection only and add to the Data Model

Course Outline

Power Query Introduction

  • What is it?
  • The Interface
  • Data Sources
  • Overview of Process (Txt Import to Load and Refresh)

Importing Data

  • Excel Tables
  • Excel Workbook
  • CSV and Txt Files
  • Web Sites
  • From Folder

Restructure and Transform Data

  • Remove Columns/Rows
  • Add Columns
  • Format Columns

Load Data & Refresh

  • Table
  • Connection Only
  • Data Model
  • Refresh

Additional Transformations

  • Merge and Append
  • UnPivot

 

Onsite / Corporate PowerQuery Training

We can also provide corporate Excel PowerQuery courses nationwide.  Delivered in the familiarity of your business setting, all levels of experience are catered for. Choose from pre-designed training courses – for beginners to advanced power-users.

This approach to PowerQuery training offers improved value for money when you have more than two users needing this training.

Click links below for external PowerQuery and PowerPivot references

What is the difference between PowerQuery and PowerPivot

Microsoft PowerQuery

Microsoft PowerPivot

Why us?

Value for Money

Training can be booked with us at your site in London or across the UK from as little as £86 per user per training day or send individuals to our training centre from as low as £200 per training day. We also offer Virtual training courses starting at £80.

First Class Service 

We pride ourselves on the quality of our trainers. As a preferred training supplier to many of the Uk's top companies, you can be sure of our commitment to quality. Our trainers are TPMA accredited and we have extensive experince with Microsoft office applications.

 

Proven track record

All our feedback given is available online to view, please click the Coursecheck link on most of our pages to see what people are saying about our training!