img

Need Help? Call: +44 (0)151 650 6907

img

Excel: Power Query

About SquareOne

SquareOne is among the UK's leading providers of IT training to businesses of all shapes and sizes. Our company pledge is to deliver inspiring, motivational and cost effective training which brings about tangible improvements in productivity. Through our training solutions, individuals are able to gain lifelong skills and realise their full potential whilst clients achieve their corporate goals.

Who Should Attend?

Excel Power Query will allow you to transform the way you work with data. This will reduce the amount of Macros that need to be created and will show you how to shave hours off your day with practical examples, tips, and tricks. By the end of the course, you will be an expert at cleaning, transforming and reshaping your data so that it is ready to analyse.

Prerequisites

This course is perfect for existing users of Excel who spend a lot of time manually preparing data for analysis. Previous experience of Pivot Tables and Formulas would be needed

Training Locations

Our open classroom courses are held in Merseyside where we have state of the art training facilities. We also provide in-house training solutions at any office location in the UK or Europe. We frequently deliver training in Liverpool, Wirral, Blackpool, Manchester, London, Chester, Warrington, Leeds, Cardiff, Birmingham, Edinburgh, Bristol, Sheffield, Glasgow, Leatherhead, Aberdeen and Ireland.

Closed courses can also be delivered in European countries such as Austria, Belgium, Denmark, Greece, France, Finland, Hungary, Italy, Ireland, Netherlands, Norway, Portugal, Spain, Poland, Sweden, Switzerland and off shore.... Either in English or local languages

Software Versions

We offer training solutions for all versions of Excel - 2003, 2007, 2010, 2013, 2016 and Office 365.

Related Courses

Course Duration

Duration: 1 Day Classroom Training or Online

Timings: 09:30 - 16:30

Getting Started

  • Introduction to Power Query
  • Power Query User Interface – A Walkthrough
  • Importing Data Rules and Best Practice

Data Preparation - Part 1

  • Combine or Merge Multiple Files from a Folder
  • Importing Data from the Web
  • Merge Queries vs. Append Queries
  • JOIN Types for Beginners
  • Understanding JOIN Concept and its Types
  • JOINS in Action – Basic Example
  • Quick DOs and DONTs for Merge Queries
  • Merging Queries with more than 1 KeyID Column
  • Fuzzy Lookup

Data Preparation - Part 2

  • Using First Rows as Header
  • Cleaning Up Data with Case Change, TRIM, CLEAN
  • Working with Data Types
  • Removing Duplicates and Blank Rows, Split Column
  • Rectify Date Format using Data Type (Locale)
  • Adding a Conditional Column
  • Merge Columns (Concatenate)

Data Preparation (Re-Structuring) - Part 3

  • Unpivot Column
  • Group By
  • Transpose

Booking

Looking for in-house training that can be customised to you/your businesses exact needs? Contact us below for one of our team to contact you.

Upcoming Courses

Below are a list of upcoming dates and locations where this course is scheduled to take place.

Location Start Date Duration Cost

Related Courses

For more information about any of our courses

please call +44 (0)151 650 6907, email enquiries@squareonetraining.com or complete an enquiry form.