What you will learn
- how to extract, transform and load data using Power Query from a range of sources
- how to merge and combine data to create integrated tables
- how to format and transform ’dirty’ data into a usable form to enable analysis
- an understanding of the Mashup (M) code behind Power Query.
About this course
Power Query will allow you to transform data into information using an intuitive interface which will record the steps taken so that they can be adapted and applied to new datasets. Learn how you can stop wasting time on repetitive data cleansing tasks. Using hands-on examples throughout, you will learn how to convert vast amounts of data into key business information efficiently.Please note, this is the same course featured in the Power Query, Power Pivot and Power BI pack.
Key information
- This course contains a collection of interactive slides and videos for you to follow, and exercises for you to complete within Excel.
- This course requires you to use (for Windows) Excel 2016 (or newer), Excel for the web or Excel 365; (for Mac) Excel 2021 (Excel 2019 for MAC support will end in October 2023).
- The recommended operating systems for Windows are Windows 10 or 11; for MacOS is Big Sur 11 or later.
- This course requires you to have a basic understanding of Microsoft Excel.
- CPD certificate is available upon successful completion of the course.
