Skip to main content

Welcome to the all-new FICPA.org. If you have not logged into our new site (launched Sept. 24), you will need to reset and create a new password.

We are transitioning to a new phone system on Friday afternoon, but please send any questions or concerns to msc@ficpa.org, and we will respond to your message as soon as possible.

Microsoft Power BI - Use Power Query to Transform Your Data

Available Until

**Online**

2.0 Credits

Member Price $59.00

Non-Member Price $69.00

Overview

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.

Highlights

Key Topics

  • File maintenance
  • Custom columns
  • Un-pivoting a table
  • Look-up tables

Prerequisites

Attended the Prepare Your Data Efficiently for Excel Analysis course or equivalent

Objectives

Learning Outcomes

  • 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.

Non-Member Price $69.00

Member Price $59.00

Add to Cart