Professional Training

Excel Power Query

STL, In London (+21 locations)
Length
1 day
Price
495 GBP excl. VAT
Next course start
28 August, 2024 (+51 start dates)
Course delivery
Classroom, Virtual Classroom
Length
1 day
Price
495 GBP excl. VAT
Next course start
28 August, 2024 (+51 start dates)
Course delivery
Classroom, Virtual Classroom
Leave your details so the provider can get in touch

Excel Power Query

STL courses


  • 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.

What to expect

  • Courses never cancelled .
  • Restaurant lunch .
  • Last minute rescheduling .
  • 24 month delegate support forum .
  • Face-to-Face and Virtual Instructor led .
  • And more... .

Upcoming start dates

Choose between 51 start dates

28 August, 2024

  • Classroom
  • London
  • English

6 September, 2024

  • Virtual Classroom
  • Online
  • English

27 September, 2024

  • Classroom
  • London
  • English

8 October, 2024

  • Virtual Classroom
  • Online
  • English

29 October, 2024

  • Classroom
  • London
  • English

7 November, 2024

  • Virtual Classroom
  • Online
  • English

28 November, 2024

  • Classroom
  • London
  • English

10 December, 2024

  • Virtual Classroom
  • Online
  • English

20 December, 2024

  • Virtual Classroom
  • Online
  • English

23 December, 2024

  • Classroom
  • London
  • English

20 January, 2025

  • Virtual Classroom
  • Online
  • English

23 January, 2025

  • Classroom
  • London
  • English

18 February, 2025

  • Virtual Classroom
  • Online
  • English

21 February, 2025

  • Classroom
  • London
  • English

20 March, 2025

  • Virtual Classroom
  • Online
  • English

24 March, 2025

  • Classroom
  • London
  • English

16 April, 2025

  • Virtual Classroom
  • Online
  • English

23 April, 2025

  • Classroom
  • London
  • English

15 May, 2025

  • Virtual Classroom
  • Online
  • English

23 May, 2025

  • Classroom
  • London
  • English

13 June, 2025

  • Virtual Classroom
  • Online
  • English

23 June, 2025

  • Classroom
  • London
  • English

14 July, 2025

  • Virtual Classroom
  • Online
  • English

23 July, 2025

  • Classroom
  • London
  • English

13 August, 2025

  • Virtual Classroom
  • Online
  • English

22 August, 2025

  • Classroom
  • London
  • English

11 September, 2025

  • Virtual Classroom
  • Online
  • English

22 September, 2025

  • Classroom
  • London
  • English

Enquire for more information

  • Classroom
  • Aberdeen
  • English

Enquire for more information

  • Classroom
  • Bedford
  • English

Enquire for more information

  • Classroom
  • Belfast
  • English

Enquire for more information

  • Classroom
  • Birmingham
  • English

Enquire for more information

  • Classroom
  • Bristol
  • English

Enquire for more information

  • Classroom
  • Burnley
  • English

Enquire for more information

  • Classroom
  • Cardiff
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Glasgow
  • English

Enquire for more information

  • Classroom
  • Leeds
  • English

Enquire for more information

  • Classroom
  • Leicester
  • English

Enquire for more information

  • Classroom
  • Liverpool
  • English

Enquire for more information

  • Classroom
  • London
  • English

Enquire for more information

  • Classroom
  • Manchester
  • English

Enquire for more information

  • Classroom
  • Newport
  • English

Enquire for more information

  • Classroom
  • Nottingham
  • English

Enquire for more information

  • Classroom
  • Portsmouth
  • English

Enquire for more information

  • Classroom
  • Sheffield
  • English

Enquire for more information

  • Classroom
  • Southampton
  • English

Enquire for more information

  • Classroom
  • Sunderland
  • English

Enquire for more information

  • Classroom
  • Wolverhampton
  • English

Enquire for more information

  • Virtual Classroom
  • Online
  • English

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

Expenses



List price £650, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.

Request information - obligation free

Contact course provider

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

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Customer Outreach Award

customer-outreach-badge-2019

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.

STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London

STL

Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...

Read more and show all courses with this provider

Ads