This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.

Digital skills

Microsoft Power BI - Use Power Query to Transform Your Data Logo aicpa

  $59.00 - 69.00 |   CPE: 2.0 |   AICPA |   12 Feb 2020 |   AICPA Store
Who Will Benefit?
  • Anyone who uses or wants to use Excel for data analysis
Key Topics
  • File maintenance
  • Custom columns
  • Un-pivoting a table
  • Look-up tables
Learning Objectives
  • Use Power Query to solve your data clean-up issues.
  • Determine how Power Query allows you to get more data into Excel.
  • Apply a one-click step to refresh your data.
How will this product help you with the work on your desk?
  • This class focuses on using Power Query (Get and Transform) to clean, shape and transform your messy data while still allowing you a one-click refresh

Clean, shape, and transform your data.

This is the fifth course in the Microsoft Power BI series. This course focuses on using Power Query to clean, shape, and transform data while still allowing you a one-click refresh. The course will review various data issues including appending files, combining multiple files from a folder, adding custom columns, un-pivoting data, and creating a lookup table. The course is resented using Excel 2019, but most concepts covered in this course apply to all versions of Excel.

This self-study online course is part of the Microsoft Power BI: Power BI Series.

Topics covered:
  • Management accounting: Digital skills: Digital content creation, Foundational
  • Management accounting: Digital skills: Data visualisation, Foundational