EVENT DESCRIPTION

Learn to be efficient and effective with data and differentiate your skillset.This course explores the uses of Power Query, Excel’s robust query tool focusing on features most useful to accountants. Explore the basics of extracting, transforming and loading data—the first steps in preparing for data analysis and reporting. Excel workbooks will be made available for all participants to use at their leisure and further explore the topics discussed.

LEARNING OBJECTIVES:

By the end of this course, you will be able to:

  • import and transform basic data into Excel using Power Query
  • apply the data load capabilities of loading into Excel versus loading into the “data model”
  • explain why the data load capabilities matter
  • add extra fields to a data set to drive increased flexibility for analysis purposes
  • identify the top six features most important to accountants, including data source flexibility, appending queries, and unpivot
  • analyze actual Power Query use cases and start implementing them
  • summarize the top resources and experts related to Power Query

Who will Benefit:

Business professionals responsible for managing and working with data.