Bryan Smith; CPA Crossings


    Credit Info
  • NASBA Field of Study

  • Format

    On demand

  • Level

  • CPE Credit


  • Course acronym

  • Prerequisites

  • Course duration

    2 Hours

Microsoft Power BI – Prepare Your Data Efficiently for Excel Analysis

This course focuses on getting data from different sources into Excel. Tools like Power Query (now known as "Get & Transform") can make transforming data from those sources quick and easy. Whether you are importing data or cleaning it, learn how to make it happen!
Hurry up, special offer for a limited time only.
Topics discussed

Various forms of data sources
Accessing data sources
Working with multiple tables/sources
Importing data for analysis
Introduction to Get & Transform (formerly Power Query)

Learning objectives

Differentiate between proper and improper data structure.
Select the best way to import data into Excel.
Identify ways to use Get & Transform/Power Query to clean your data.

Who will it benefit?

Business analysts and data scientists
Anyone who needs to analyze data