banner image

Excel Power Query Introduction

1 Day Instructor-led
course icon

Course Information

Course Requirements
  • You should have a reasonable knowledge of using Excel.
  • Familiarity with Excel pivot tables would be an advantage.
  • You should be aware of the Table feature in Excel.
  • You should have Excel 2010 or a later version installed on your PC.
What will you learn 
  • Filtering out data you don't need.
  • Deleting/sorting rows, columns, or blanks
  • Transforming text, numeric, and date columns.
  • Removing spaces and special characters from your data.
  • Renaming, adding/removing, Splitting/joining, and reordering columns.
  • Creating calculating columns/fields which never existed in the source data.
  • Merging / consolidating / appending data from Text files, CSV files or database tables.

Course Outline

1. Topics
  • Power Query Introduction
  • Import Data to Power Query
  • Load & Refresh Data
  • Data Transformation
  • Using the Merge & the Append query features
  • Understanding the basics of the M Language
  • Aggregating Excel Worksheets
  • Introduction to Power Query Formulas

Dates & Availability

We currently don’t have any dates scheduled for this training course but offer it as a corporate, private course for your own team.

Please use the enquire button below.

Private Courses

We can arrange your own private Excel course.

Tailored

Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

What Our Clients Think

The course was fantastic - I couldn't recommend it enough!

Bonnie Donaghue - IRI

Very good, trainer was excellent.

Mike Hartley-Bingle - XPS Pensions Group

The trainer was very through and very helpful. The course was delivered superbly and I'm very pleased.

David O'Hara - Multibrands UK

The trainer was an amazing lecturer and the vba course was very usefull and well structured. Thank you.

Veronika Panton - Haven Power

Really good trainer. He made the training interesting and fun.

Wendy Sipson - Hampshire Constabulary

The pace he delivered the course was perfect and he explained everything so clearly and in a way I could understand.

Jessica Homer - All About Food

Related Courses

Next on Mon 5 Aug
Format:
Virtual or Classroom
Length:
1 Day
This introductory Microsoft Excel course is ideal for beginners who want to learn how to:
  • Produce spreadsheets
  • Work with data
  • Perform basic calculations
Next on Wed 7 Aug
Format:
Virtual or Classroom
Length:
1 Day

This course has been developed for people wanting to use Excel to perform calculations with a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, and conditionally format cells.

Next on Mon 12 Aug
Format:
Virtual or Classroom
Length:
1 Day
  • Work with multiple workbooks and worksheets at the same time
  • Share and protect workbooks
  • Automate workbook functionality
  • Apply conditional logic
  • Audit worksheets
  • Present your data visually effectively
Next on Mon 29 Jul
Format:
Virtual or Classroom
Length:
2 Days
  • Understand the functions of Excel VBA
  • Understand applications of Excel VBA to improve efficiency
  • Use Excel VBA to enhance efficiency of the software
  • Investigate and solve problems related to Excel VBA
Format:
Virtual or Classroom
Length:
1 Day
  • Create advanced formulas
  • Automate workbook functionality
  • Apply conditional logic
  • Visualise data using basic charts
  • Implement advanced charting techniques
  • Use PivotTables, slicers and PivotCharts to analyse data
Format:
Virtual or Classroom
Length:
1 Day
  • Prepare data for PivotTables
  • Create PivotTables from various data sources
  • Analyse data using PivotTables
  • Work with PivotCharts
Format:
Virtual or Classroom
Length:
1 Day
  • Utilise Power Pivot in your data analysis
  • Visualise Power Pivot data
  • Apply the advanced functions to your data
Format:
Virtual or Classroom
Length:
1 Day

Learn the basics of the M language and how to use Power Query to organise and query your data inside Excel.