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 Power Query Training

About Power Query;

  • Introduction/about Power Query
  • 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 modelling with tools such as Power Pivot and Power View
  • 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

Power Query Courses in London.

Chris James delivering Excel PowerQuery training in London

Our Approach with Excel Power Query training

Microsoft Excel Power Query training is a specialty of ours. Subsequently, we pride ourselves on covering these Business Intelligence topics in Excel very well. Furthermore, we will not let the subject go over anyone’s head (we feel strongly about this); therefore a potentially complex subject is always broken down into understandable sections which each build on one another as the training course unfolds.

  • In-person at our training centre in Liverpool Street, London
  • Onsite (in-person) private group courses at customers office
  • Virtual/online training via Zoom or MS Teams

Public Excel Power Query courses in Liverpool Street, London:

Excel Power Query 1 day course

NEXT DATE:- tbc

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

Excel Power Query Introduction Course

Course Aims

Overall, this 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 Power Pivot 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

Cost

PowerQuery Price (1 day)
Private 1:1 - £350 + VAT
2 to 3 users - £700 + VAT
4 to 6 users - £800 + VAT
7 to 8 users - £900 + VAT

Onsite / Corporate Power Query Training

About

In addition to our public course, we also provide on-site Excel Power Query courses nationwide.  The training delivered in the familiarity of your business setting. Also, all levels of experience are catered for.

Topics

Choose from pre-designed training courses – for less experienced users through to advanced power-users. Alternatively, tailored courses can be developed to meet the specific needs of your business. Tailored course can be particularly effective with the trainer aiming the overall theme towards the nature of your particular business.

 We deliver:

          • Agreed customised topics to suit your group’s learning requirements
          • Group sizes to suit your team’s needs
          • A qualified instructor who will be flexible in her/his approach and will engage well with your team
          • Post Course help and support

Equipment

We specialise in on-site training and are geared-up to bring the classroom to your site. Either your users can use their own laptops or we can bring along a suit of training laptops for your users to use.

Virtual 

We are also geared up to bring the training remotely to your workspace worldwide. These group training events are done online via Zoom or MS teams. They are particularly effective for companies working from home or individuals working in different locations.

Cost

This approach to Excel training offers exceptional value for money when you have more than two users needing training.

PowerQuery Price (1 day)
Private 1:1 - £350 + VAT
2 to 3 users - £700 + VAT
4 to 6 users - £800 + VAT
7 to 8 users - £900 + VAT

Timings

In-Person: 09:30 – 16:30

Virtual: 09:00 – 15:30 OR 5 hours learning split over 2 days e.g. 2x morning sessions of 9:00 – 11:30

 

Finally, please click links below for external Power Query and Power Pivot 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!