PowerQuery (also known as Get Data and Transform) is a little known part of Excel that in our experience can make a huge difference to the efficiency and accuracy of a Finance Team’s repetitive processes. PowerQuery connects Excel workbooks to datasets (including Excel files), then gathers all the information in those datasets together, and then cleans it and transforms it into a useable shape. PowerQuery remembers the steps of to connect to, clean and transform the data so once you’ve performed the transformation once, you’ll never have to do it again. Excel will take care of it quickly and accurately.
If you think about it, almost everything that a Finance Department does is repetitive, and most of it uses data that needs cleaning, transforming, joining with other datasets and so on before it can become useful. Now imagine that you don’t need to do any of that transforming, other than saving information in a certain place and clicking a refresh button. Sound good?
Welcome to PowerQuery.
This free 6 lesson course gives a Finance Team an understanding of how PowerQuery works, the components of the PowerQuery editor, will guide you through how to connect PowerQuery to data in the current Excel workbook and perform basic transformations.
Course Created by the FDTC founder Alex Wilson
Last Updated 09/2020
English
Free
2 hr completion time
By the end of the course you'll understand...
What is PowerQuery?
Why PowerQuery is one of the cheapest and fastest ways to make Finance Teams more efficient and productive
The components of the PowerQuery Editor
How to create queries by connecting data in the current workbook to PowerQuery
How to re-enter the PowerQuery editor to amend preexisting queries
Perform data queries and basic transformations
How to duplicate preexisting queries
How to append queries (no more copying and pasting!!)
Got a question about the course? Send us a message!