Power Query and Get & Transform: Getting Started

(31 reviews)

by Paula Guilfoyle

If you are a novice Get & Transform Data user, this course will help you to navigate your way comfortably around the user interface. Learn the basics of using Power Query to connect, combine and transform your data, so that it meets your analysis needs.

price £100+vat
cpd hours 4 CPD hours
access 120 days' access

This course will enable you to

  • Understand the basics and confidently navigate the Get & Transform Data features
  • Connect different data sources and load them into Power Pivot, Excel or Power Query
  • Append and merge queries for easier analysis and combine Excel files from a folder
  • Use the column and row transformation options in Power Query
  • Change the structure and layout of tables into a format you can work with

About the course

Get & Transform Data, also known as Power Query, enables you to get data from any source and transform it into a usable format. As an accountant, you know that organisations often have a vast quantity of data, often be in many different forms. Using Get & Transform you can connect, combine and transform your data, so that it meets your analysis needs.

If you are a novice Get & Transform Data user, this course will take you to a level where you are comfortable navigating and using the features of this user interface. Learn how to connect to different sources, including CSV files and web data, as well as understanding the different data transformations, such as appending queries, and merging join types. Discover how to make the most of column and row transformation options in Power Query and use table transformations to create a table format that you can actually work with.

Look inside

imac
slide-1
slide-1-thumbnail
slide-2-thumbnail
slide-3-thumbnail
slide-4-thumbnail
slide-5-thumbnail

Contents

  • Learning the basics
    • Welcome
    • Connecting to an Excel workbook
    • Navigating Power Query
    • Connecting to a CSV/text file
    • Connecting to web data
  • Data transformations
    • Welcome
    • Applied steps and properties
    • Appending queries
    • Merging queries
    • The impact of merge types
    • Combining files and folders
    • Connecting to folders: The solution
  • Column and Row Transformations
    • Welcome
    • Working with columns in a table
    • Replacing values and filling data
    • Changing data types
    • Reducing rows
  • Table transformations
    • Welcome
    • Working with text columns
    • Grouping data
    • Transposing data
    • Transformations
    • Working with bad data: the solution

How it works

Author

Paula Guilfoyle

Paula practiced in Industry for over 15 years, working with both small and large private companies, before moving on to teach Excel and Power BI to accountants and professionals.

Reviews

4.4
(31 reviews)
5
4
3
2
1
 
 
 
 
    SS
    Stephen S
    02 Mar 2025
    02 Mar 2025
    ok but quite basic. They should provide the excel files to download so you can practice the instructions/learnings on unit 4 - Tables and Charts etc. It would make it much easier to follow. At the moment it is an abstract concept without information to illustrate the instructions. You only get example excel files to download when you are given a question which is too late.
    GS
    Geoff S
    21 Jan 2025
    21 Jan 2025
    Super useful table and fast chart functions enabled in 1 day a possible savings opportunity of $100k .
    GS
    Gillian S
    28 Dec 2024
    28 Dec 2024
    Particularly liked learning about shortcuts and different ways of achieving the same outcome eg how to insert headers/footers in different ways. Data Tables, Charts and Slicers really useful to learn about. Lots to use going forward.
Recommended

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?

Pick n Mix

All you need for this year's CPD.

Licence

All you need for this year and more.

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours4 unitshourshours21 units20 hours21 hours1,500+ unitshourshours1,500+ unitshourshours
Access period120 days120 days12 months12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Monthly webinars, 15-minute CPD Bites, video interviews with industry leaders, and more!
Account manager on hand to support your team’s needs
Learn moreLearn moreLearn more

Why not upgrade?

Find the best way to complete your CPD

You might also like

Take a look at some of our bestselling courses