Excel Power Query

Course summary
1 day
Corporate Training for Teams
STL courses

Excel Power Query

Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... Learn to use Power Query to create queries, data connections to a large number of data sources and reports which will update when new data are added to the data source. Save hours of work converting, cleaning, formatting, deleting, changing structure in source data. Save hours of work updating data analysis worksheets. Save time changing source data to flat lists.

Suitability - Who should attend?

This course will benefit:
People who work with reports, dashboards, and analysis in Excel and spending hours converting, cleaning, formatting, deleting, changing structure in source data from other Excel worksheets, financial systems, databases, websites, SharePoint, and many other sources.
Those using Vlookup and other lookup and reference function to merge data.
All, who want to automate the process working with external data in Excel.
Everybody, who need to combine data to use in Excel.
All, who get data from CSV files, text files, XML files, or other excel workbooks.
Everyone, who would like to drop source data files into a folder and get the Excel report/dashboard updated automatically from the data in the new files, added to the folder.
Everybody working with data models in Excel can use Power Query to extract, clean, combine, merge, and aggregate data before adding the data to a data model.

Training Course Content

Getting started

Use Power Query in different versions of Excel
Navigate and get a basic understanding of Power Query
Understand Applied Steps in Query Settings

Extract Data

Extract data from excel table
Extract data from excel external workbooks
Extract data from databases
Extract data from web
Extract data from other sources
From folder (multiple files)

Transform Columns and Add Columns

Use Group By to group source data
Use first row as headers
Aggregate columns
Calculate columns
Use text functions in columns

Clean Data

Change text to columns
Remove unwanted columns and rows from data source
Cope with formatting issues
Manage are source data cleaning issues
Unpivot data
Replace errors or values in columns

Merge and Append

Merge data from an Excel workbook
Merge data from multiple Excel workbooks
Merge data from multiple data sources
Append data from Excel worksheets and multiple data sources

Automate Queries

Understand Power Query technics to automate queries
Understand how to create simple functions in Power Query
Create Dashboard/Report from Power Query data


Prices from £748. Promotional rates often available the further ahead you book. Contact us for quote.

Provider: STL

STL - Microsoft Training

STL - Helping businesses deliver productivity and efficiency gains

Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....

Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Excel Power Query.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award


We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL


Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number

Similar Courses

Request information

Find out more about this Excel Power Query course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

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

Find more courses here