Short Course
Power Query/Get & Transform
Transform data, save time: Gain expertise in Power Query.
Course Overview
Are you spending hours each week cleaning up your data, copying and pasting from one source to another and performing one mind-numbing activity after another? Surely there is a better way.
In April 2018, we showed an accountant how to reduce a task from five and a half hours a week to just eight seconds using Power Query. The key was not a faster computer – it was leveraging the efficiency of intelligent data automation. Discover how to significantly enhance your workflow and reclaim your time.

What you will learn
This course develops practical case studies utilising many of the powerful tools and functionalities of Excel’s Power Query / Get & Transform. Using hands-on examples throughout, you will learn how to convert vast amounts of unprocessed data into key business information, reported efficiently and effectively.
Course Structure
Delivered: Online, enrolment for 12 months.
Course prerequisites: While there are no entry requirements, a basic understanding of Microsoft Excel is recommended.
Assessment: Yes (Quizzes)
Outcome: A completion certificate is issued by SumProduct upon successful completion of the course.
Digital badge: You’ll be eligible for a digital badge, issued by FINSIA and Credly, available upon request.
Enrolment information: Your details will be shared with SumProduct within 1 business day of enrolment.
SumProduct will process your enrolment within 2 business days of receiving this information and will provide login details to access your learning via email. For any assistance, please contact our team at [email protected].
FINSIA member exclusive
FINSIA members enjoy a 10% discount on SumProduct’s suite of online courses.*
*This discount has been applied to the member pricing displayed.
Related Courses
View allExcel Tips and Tricks
Boost your productivity with Excel proficiency.
Financial Modelling in Power BI
Elevate your financial models with Power BI.
Power BI Introduction
Build interactive dashboards with ease.
Power Pivot
Turn data overload into clear business performance matrix.
Excel Tips and Tricks
Boost your productivity with Excel proficiency.
Financial Modelling in Power BI
Elevate your financial models with Power BI.
Power BI Introduction
Build interactive dashboards with ease.
Power Pivot
Turn data overload into clear business performance matrix.