Power Query - Tips, Tricks and Advanced Techniques

Power Query - Tips, Tricks and Advanced Techniques
K2E Canada Inc. presents a broad curriculum of technology-focused on-demand webinars. Participants who take these webinars will have the opportunity to learn from an award-winning team of instructors with literally hundreds of years of experience in helping professionals identify, address, and solve issues through the practical application of technology. Webinars address a variety of topics, including Excel, QuickBooks, PDFs, accounting solutions, and Microsoft Office.

NOTE: Course login details are normally sent to registrants within one week from date of registration.


Microsoft has updated Power Query, known as Get & Transform in Excel 2016/2019, with many new features. Power Query allows users to access, link, and clean data in preparation for analysis or reporting. In this webinar, you will learn powerful tips and tricks that every Power Query user should know for making it easier to create powerful reports from any data source in less time and with less effort. What previously required specialized knowledge and skill can now be done by any user with Power Query. The tips in this webinar will dramatically improve your productivity and reporting effectiveness.


  • Pivoting and unpivoting data before importing
  • Adding custom columns with formulas or by example
  • Removing errors, splitting columns, and extracting values
  • Combining data from multiple data sources 
  • Loading data directly to the Data Model

Upon completing this course, you should be able to:

  • Describe the process of accessing and updating data from external data sources
  • List several available data transformations and data types
  • Differentiate between appending and merging tables 
  • Use Power Query to add or remove columns or rows

Program Level: Intermediate 
Advance Preparation: None 

Accounting and financial professionals who want to improve their personal productivity using Power Query to access and transform data for analysis and reporting

CPD: 2 Hours

4/1/2022 - 3/31/2023 11:59 PM