Power Query
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
This course is valuable for anyone new to Power Query in Excel or someone who deals with large dataset from different data sources.
Have two or more people to train? you may consider a closed group course.
Benefits include:
- Cost effective
- Choose a date to suit you
- Customise content and timings
- No minimum delegate
- Choose how the course is delivered – In person face-to-face at your location or virtual
Contact us on [email protected] to discuss specific date and delivery requirements.
We can deliver our training sessions in several ways, these being:
- Open public course (Contact us if you can’t see a suitable date listed)
Please enquire about the following methods
- Closed group
- In person face to face
- virtual
- One to one coaching
Course Benefits
- Fully led tutor instruction
- Comprehensive courseware for all delegates
- Certificates of attendance
- Course Guarantee
- Emergency trainer
- Contextualisation and customisation for Closed group courses
- Evaluation Feedback
- Access to Customer Portal (course bookers) for oversight of past and future training events and attendance details
Key Features
Engaging & interactive tutor led session
Comprehensive course materials
£295.00 Plus VAT
Can’t see a suitable date? Please request a date here
Payment available via all major credit cards or Invoice. All options available during the online booking process.