Power Query
£275.00 Plus VAT
Have more than 2 delegates? Talk to us about our closed group courses.
Delivery Methods
​ Open Public Courses – Virtual Delivery Only Closed Group Courses – Face To Face and Virtual Delivery
Business Benefit
Learning Power Query will speed up data manipulation moving away from the ‘manual’ way or the ‘complex’ formula way and streamline data manipulation.
Who Should Attend
This course is valuable for anyone new to Power Query in Excel or someone who deals with large dataset from different data sources.
Learning Outcomes
Understand Power Query
Import your Data from numerous sources
Combine data sources
Use Basic Transformation features
Use advanced Transformation features
Course Content
Power Query Overview
Power Query Editor & Basic Transformation
Refresh Data and Options
Merge Data
Data Types, Formatting and Null Values
Correcting Errors in Data
Working with Query dependencies
Basic Power Query Transformations
Filters
Merge
Remove Duplicates
Advanced Power Query Transformation
Unpivot Columns
Group By
Split columns
Working with date / Time transformation
Custom Columns
Combining / Appending Data
Working with Lists & Table Functions
Power Query Workshop
Course Benefits
Fully led tutor instructionComprehensive courseware for all delegatesCertificates of attendanceCourse GuaranteeEmergency trainerContextualisation and customisation for Closed group coursesEvaluation FeedbackAccess to Customer Portal (course bookers) for oversight of past and future training events and attendance details
How to Book
Dates below represent open public courses only. To book this course, please select an available date and click the book now button below to complete the booking by Credit Card or via Invoice. Have two or more people to train – you may consider a closed group course. Contact us on [email protected] to discuss specific date and delivery requirements.
Payment available via all major credit cards or Invoice. All options available during the online booking process.
The purpose of your training is learning new skills and/or changing behaviour. We can help you measure this!
Post-course, to evaluate how successfully the attendees are doing this, delegates can attend a Workplace Implementation session during the skills transfer period. This additional session lasts for 2.5 hours.
During the Workplace Implementation session the individuals will either on a 1-2-1 basis or as a group discuss the challenges and successes they have experienced during their skills transfer period.
This will include what they are doing differently as a direct result of the training and how this has positively impacted the organisation.
This is an excellent way to encourage the learning, support the skills transfer into the workplace and act as a measure to evaluate the training.
We compile this information into a report so that you have evidence of your return on investment.