Power Query
£525.00 Plus VAT
Delivery Method
Face To Face Delivery Virtual Delivery One To One Coaching Closed Group Course Public Course
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
How to Book
If you are interested in booking this course, then please select an available date and then click book now to complete the booking. Can’t see a suitable date contact us on [email protected] and we can discuss specific date requirements.
Embedding
These follow up coaching sessions help support your colleagues to embed their learning during their skills transfer period. Applying new skills and changing behaviour takes effort and practice. After attending a training course many colleagues will find they need support through this transition. EQV can provide that support with follow up coaching sessions to help embed the learning.
Embedding coaching sessions can be delivered in 90 minute and half day durations. The facilitator will work with the group to capture feedback about challenges and how to overcome them ensuring success going forward.
Having a formal embedding coaching session will not only increase the success of the skills transfer period but helps create a platform of motivation, inclusivity and commitment within the group.