Power Query Course
Duration : 1 DayCost: from £295
Venues :Manchester | Online | Private Courses UK Wide
Power Query with Excel
Learn to confidently use Power Query in Excel to automate data tasks, enhance reporting accuracy & efficiency on this 1 day course.
-
6 Small Class Sizes
-
5 star rated courses
-
Practice led learning
-
3 month online support
-
Classroom & Online
Select from the tabs below to find out more:
Power Query Course Dates
Browse all public Power Query training dates below or use the filter to show only dates in specific locations.
Private Power Query courses can be held at your offices, at our Manchester office, or at a venue to suit you or Online via Zoom or Teams.
The course content can be adapted to suit your requirements. Our trainer will contact you to discuss what you are looking to achieve and the level of prior knowledge the delegates have.
Private Power Query courses are ideal if you have a number of people to train, or you want a different course outline; or simply can't make the dates of the public scheduled courses.
Private Course Costs:
The cost of any private courses is dependent on the number of delegates, the location, the length of the course and the degree of adaption of the course. The following are for guidance only:
Private one to one classroom-based courses are available from £690 plus VAT
Private Group Courses in Excel are available from £750 plus VAT
Online Private Advanced Excel Courses are available from £590 + VAT (6 hours).
To get a quote please complete the form below or call us on 0161 226 6032.
Private Power Query Enquiry
-
Introduction
- What is Power Query?
- Why use Power Query?
-
Importing Data
- Where to find Power Query in Excel
- Import Data from an Excel Workbook
- Import Data from other common places
- Appending Data
- Import Data from a Folder
- Import data directly within Editor
-
Power Query Editor
- Queries Pane
- Data View
- Ribbon
- Applied Steps
-
Data Preview
- Column Distribution
- Column Profile
- Column Quality
-
Cleaning Data
- Remove/Rename columns
- Dealing with Null Data
- Data Types
- Dealing with Duplicates
- Replace Values
- Use first row as headers
- Fill down
-
Date Functions
- Date/Time Data types
- Extracting parts of a date
- Converting Date Formats
-
Bespoke Columns
- Conditional Columns
- Custom Columns
- From Number
- From Examples
-
Merge Queries
- What is Merge Queries
- How to Merge Queries
-
Group By
- What is Group By?
- How does Group By work?
-
Statistics
- What are the Statistics Functions?
- How to use the Statistics Functions?
-
Pivot/Unpivot
- Pivot
- Unpivot
- Transpose
-
Fuzzy Matching
- What is Fuzzy Matching?
- How to use Fuzzy Matching
- Join Types
-
Refresh
- Manual Refresh
- Automatic Refresh
Power Query Training Manchester
Our Manchester Venue:
Our POwer Query courses in Manchester are run from 9.30am to 4.30pm at our head office:
Base,
Greenheys Lane,
Manchester Science Park,
M15 6LR
By Car
The closest public parks are:
- MSP Visitor Car Park on Denmark Road - 5 min walk
- Cecil Street Car Park - 5 min walk
Train Stations
- Manchester Oxford Road Train Station - 15 min walk
- Manchester Piccadilly Train Station - 30 min walk
Access
Please let us know in advance if you have any mobility issues and will need any assistance. Disabled parking is provided.
More Information about our Manchester training courses, along with a map, can be found on our Manchester Training Page
Online Power Query Course
The Online Power Query courses are run on Zoom.
You will be sent a link to join the training session the day before the course along with any course materials needed.
The courses run from 9:30 am to 4:30 pm.
Because we limit the number of delegates to a maximum of 6 on our public courses specific timings are flexible, but generally, the day will run as follows:
- 9.20 am | Sign in
- 9.30 am | Start - First session
- 11.00 am | 15 min break
- 11.15 am | Second session
- 12.30 pm | 30 min break
- 1.00 pm | Third session
- 2.15 pm | 15 min break
- 2.30 pm | Fourth session
- 3.50 pm | Finish & Q&A
- 4.30pm | End
Find out more about how our online courses work on the Online Courses Page
Course Reviews
-
Find out more
Advanced Excel Course
This is a one day training course that takes you through some of the more advanced features of Excel. It is designed for people who know the basics but want to extend their knowledge/skills in using Excel. -
Find out more
SharePoint for Administrators Course
This is a 1 day Training Course for Administrators to learn the skills to Design, Create and Manage their own SharePoint sites -
Find out more
2 Day Power BI Course
Learn how to use Power BI to create dynamic, interactive visualisations of your business data on this 2-day course.
Nicola W, Expert Complete Property Maintenance Ltd