Introduction to Power Query

Introduction to Power Query
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.

KE22230271

Power Query is an Excel data extraction and transformation tool integrated in all versions of Excel 2016, but is available as a free add-in for those using Excel 2013. Power Query allows users to combine data from multiple, disparate data sources, such as relational databases, OData feeds, web pages, Azure, SharePoint lists, Hadoop HDFS, and Excel, text, and XML files, etc. The Query Editor allows users to transform and cleanup data with the "M" query language using an intuitive query-by-example interface. The code created by the Editor can be fine tuned or modified to meet any need. Queries and data transformations can be saved, shared, and reused across an enterprise. Don't miss this opportunity to explore the power and time-saving functionality of Power Query.

CONTENT 

  • Connecting to external data sources
  • Using the Query Editor to transform and cleanup data
  • Modifying and fine tuning query code

LEARNING OBJECTIVES
Upon completing this session, you should be able to:

  • Identify five common data sources that can accessed by Power Query
  • Describe the process of extracting data from an external data source
  • Use the Query Editor to transform and cleanup data
  • List three data transformations that can be accomplished with the Query Editor
  • Explain the process of saving queries for future use

PREREQUISITE
Good working knowledge of Excel
Program Level: Intermediate 
Advance Preparation: None

WHO WILL BENEFIT
Accountants and finance professionals who want to use Power Query to access, import, and transform external data for analysis and reporting

CPD: 2 Hours

When
4/1/2022 - 3/31/2023 11:59 PM
Where
On-demand