Excel Power Query
£525.00 Plus VAT
Learning Power Query will speed up data manipulation moving away from the ‘manual’ way or the ‘complex’ formula way and streamline data manipulation.
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.
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.
Understand Power Query
Import your Data from numerous sources
Combine data sources
Use Basic Transformation features
Use advanced Transformation features
Power Query Overview
Power Query Editor & Basic Transformation
Refresh Data and Options
Data Types, Formatting and Null Values
Correcting Errors in Data
Working with Query dependencies
Basic Power Query Transformations
Advanced Power Query Transformation
Working with date / Time transformation
Combining / Appending Data
Working with Lists & Table Functions
Power Query Workshop