NOTE: Course login details are normally sent to registrants within one week from date of registration.
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.
Upon completing this session, you should be able to:
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