Online or at your own premises
1/2 day course
£150.00 (ex. VAT)

This fast paced 1/2 day Microsoft Excel Power Query course is designed for those looking to extend their Excel knowledge and add Power Queries to their skillset. This course will introduce how to clean messy data (removing errors, spaces, wrong formats), shape and analyse in preparation for reporting in Excel or Power BI.

Attendees ideally should have an intermediate/advanced working knowledge of Excel.

By the end of this course, you will be able to use the Power Query tools to retrieve, transform, and analyse Excel data.

Course Outline

What is Power Query?

 

Importing Data into Excel & the Model

  • From Text/CSV Files
  • From Excel

Understanding Power Query

  • Understanding the Power Query interface
  • Renaming and deleting steps
  • Cleaning messy data example
  • Refreshing a query

Common Power Query Features

  • Data Transformation
  • Setting Data Types
  • Append Queries
  • Merge Queries

Book This Course

Public Course Dates

This course is taught online or at your site.  Check our current available dates for this course below and register your place. Please note that payment is not made by the booking form below – Instead, you will be sent an invoice with instructions on how to pay and confirm your place shortly afterwards.

Company Group Training

We also provide group training for companies on dates that work for them. This can be delivered on-site at your premises or virtually. Please submit your details here for more information.

Online Training

This course is also taught virtually. To enquire about virtual remote training please submit your details here.

Related Courses

Canva Introduction

Canva Introduction

Adobe Acrobat

Adobe Illustrator

Adobe InDesign

Adobe Photoshop

Microsoft Visio

Microsoft Excel Power Pivot and Power Query

Personal Development Training