LAC Session Type
Learning Lab
Name
Powering up your data work with Excel's PowerQuery
Description

Learning Outcomes

  • Articulate the benefits of reproducible data work
  • Find PowerQuery in modern versions of Excel
  • Connect to a data file in PowerQuery
  • Understand different types of PowerQuery data transformations
  • Build a query with a multi-step data transformation sequence
  • Push transformed data back to Excel for summaries and visualizations