Power Query and Get & Transform: Intermediate

As an accountant, organising and analysing data are important skills that you need to get jobs done. Organisations often have a vast quantity of data that comes in different forms, so it can be difficult to effectively organise data and analyse it. Using Get & Transform you can connect, combine and transform your data, so it's easier and faster to analyse.

If you're looking to take your knowledge and application of Power Query to the next level, this course will enable you to do just that. You will look at adding custom, index and conditional columns, as well as using the Column from Examples feature. This course also covers the basics of JSON, working with records and lists, duplicating queries, and changing the source file. It explores the uses of parameters and custom functions.