Power Query Fundamentals (On-Demand - CFI)
Overview
Master the art of efficient data handling with Power Query, a vital tool for modern data professionals. This course guides you through the essentials of data extraction and transformation, teaching you to seamlessly integrate data from multiple sources. You’ll learn common techniques for cleaning and restructuring datasets, ensuring they are analysis-ready. By mastering these skills, you’ll transform time-consuming data preparation into an efficient, automated process.
Dive into the practical applications of Power Query in real-world scenarios. We’ll cover automation of data connections, consolidation of data from multiple files, and effective troubleshooting of common issues. Designed for both Excel-focused analysts and Business Intelligence professionals, this course equips you with the expertise to spend less time on data manipulation and more on delivering impactful insights. To find out if it is specifically available in your version, follow this link: https://learn.microsoft.com/en-us/power-query/power-query-what-is-power-query#where-can-you-use-power-query
Access expires 180 days from purchase date |
Applicable for
Learning Objectives
By the end of this course, you will be able to:
- identify the characteristics of good and bad data using the principles of data normalization
- extract data from CSV and Excel files and automate basic transformations such as Pivot and Unpivot
- extract information from fields that combine two or more values
- transform datasets by grouping or combining data from different tables or even multiple files from the same folder
- avoid, interpret, and fix errors and exceptions that you experience in Power Query
- load transformed data into Excel for use as automated data feeds
Content
Course Content Created: July 2020
The information is current as of the creation or last updated date. While we strive to keep our inventory updated and periodically remove outdated titles, changes in accounting, tax, legislation and technology may occur. Purchasers should note the date and verify for themselves if the course is still relevant to their needs.About This Product
On-Demand Courses by CFI. Corporate Finance Institute (CFI) courses are designed for finance professionals and industry practitioners who want to master the art of corporate finance. The instructions on how to access this course will be included on your registration confirmation.
Please note that not all on-demand courses include downloadable materials such as course notes or slides.
How to get started
Upon completion of purchase, go to mylms.bccpa.ca and log in using your CPABC Online Services credentials. Click “Go to your Courses and Materials” to go to your Learning Center, then find and click on your course title.
Course Dates & Registration
- 6
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 5
- Credits
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.
Power Query Fundamentals (On-Demand - CFI)
- 6
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 5
- Credits
Overview
Master the art of efficient data handling with Power Query, a vital tool for modern data professionals. This course guides you through the essentials of data extraction and transformation, teaching you to seamlessly integrate data from multiple sources. You’ll learn common techniques for cleaning and restructuring datasets, ensuring they are analysis-ready. By mastering these skills, you’ll transform time-consuming data preparation into an efficient, automated process.
Dive into the practical applications of Power Query in real-world scenarios. We’ll cover automation of data connections, consolidation of data from multiple files, and effective troubleshooting of common issues. Designed for both Excel-focused analysts and Business Intelligence professionals, this course equips you with the expertise to spend less time on data manipulation and more on delivering impactful insights. To find out if it is specifically available in your version, follow this link: https://learn.microsoft.com/en-us/power-query/power-query-what-is-power-query#where-can-you-use-power-query
Access expires 180 days from purchase date |
Applicable for
Learning Objectives
By the end of this course, you will be able to:
- identify the characteristics of good and bad data using the principles of data normalization
- extract data from CSV and Excel files and automate basic transformations such as Pivot and Unpivot
- extract information from fields that combine two or more values
- transform datasets by grouping or combining data from different tables or even multiple files from the same folder
- avoid, interpret, and fix errors and exceptions that you experience in Power Query
- load transformed data into Excel for use as automated data feeds
Content
Course Content Created: July 2020
The information is current as of the creation or last updated date. While we strive to keep our inventory updated and periodically remove outdated titles, changes in accounting, tax, legislation and technology may occur. Purchasers should note the date and verify for themselves if the course is still relevant to their needs.About This Product
On-Demand Courses by CFI. Corporate Finance Institute (CFI) courses are designed for finance professionals and industry practitioners who want to master the art of corporate finance. The instructions on how to access this course will be included on your registration confirmation.
Please note that not all on-demand courses include downloadable materials such as course notes or slides.
How to get started
Upon completion of purchase, go to mylms.bccpa.ca and log in using your CPABC Online Services credentials. Click “Go to your Courses and Materials” to go to your Learning Center, then find and click on your course title.
Course Dates & Registration
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.