request@systematix.co.uk
supermarketBasket
Call Us On:
0118 324 3000

Exciting News! Systematix is rebranding to Future Savvy. Same great services, with a fresh new look. Learn More

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

Download PDF 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.

Delivery Options:
On-Site At Your Offices
Virtual Online Virtual Online
Training Centres Training Centres

What Our Clients Think

Very good, trainer was excellent.

Mike Hartley-Bingle - XPS Pensions Group

The trainer was a really good instructor, he took the time to help us with individual issues and also tried to cater the course to meet our collective needs.

Ben Knight - Atlas Copco Ltd

This course was excellent and I am delighted with how much I have achieved. The trainer was very friendly and approachable.

Rosie Heath - Licensed Trade Charity

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

Trainer was very engaging, spent time explaining topics clearly.

Laura Choake - Desoutter Industrial Tools

Related Courses

Next on Tue 3 Dec

Excel Introduction

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 Mon 9 Dec

Excel Intermediate

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 Wed 11 Dec

Excel Advanced

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 25 Nov

Excel VBA Introduction

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

Excel Dashboards

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

Excel Pivot Tables

Format:
Virtual or Classroom
Length:
1 Day
  • Prepare data for PivotTables
  • Create PivotTables from various data sources
  • Analyse data using PivotTables
  • Work with PivotCharts

Excel PowerPivot

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

Excel Power Query Introduction

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.