Power Query Fundamentals

CPA Members only

CPA Australia has partnered with the Corporate Finance Institute (CFI) to curate a collection of data and digital courses exclusively for CPA members. CFI courses have an emphasis on hands-on, practical learning and skills acquisition. They teach in-demand industry practices, tools and techniques that help accounting and finance professionals build confidence, stand out from the competition, and make a positive impact on their careers.

Stop wasting your time manipulating data
If youve ever worked with data extracts or regular reports in Excel, youll know how time consuming it is to change the layout, extract information and lookup values from other tables. Not only that, but you repeat these tasks every week or month, each time you receive a new report.

Stop. Power Query is about to revolutionise your work.

In this online Power Query Fundamentals course, well explore the world of data transformation and automation. Youll learn to extract data from multiple different sources, and transform it into layouts more suited to analysis. We will show you how to automate data connections and transformations, as well as how to extract and consolidate data from multiple files. Finally, well end by looking at how to deal with common errors.

Power Query is absolutely essential for any Excel focused analyst, and is a powerful asset to any Business Intelligence analyst. These skills will help you spend less time on data manipulation, and more time on your analysis projects.

CPA Australia handles your personal information in accordance with the CPA Australia Privacy Policy. By proceeding you may be redirected to an external website to access the course.

Our Privacy Policy includes the following statement under the subsection 'Links to external websites':  
   We may provide links to websites operated by third parties. 
   We are not responsible for the privacy practices or the content of such websites which will be governed by their own privacy policies to which you are advised to refer. 
   Your satisfactory completion of the course may be recorded in your CPD Diary.

CFI programs will be supplied to CPA Australia members as standalone courses for 12 months from the date of purchase and as such, any associated CFI certifications are not able to be supplied. Refunds or extensions for purchases of CFI courses will only be available in exceptional circumstances and will be based on CPA Australia and CFIs cancellation terms.