Get & Transform Data in Excel

Course Details

Date

Monday, August 26, 2019

5:00am – 7:00am
(Registration: 4:30am)

Field of Study

Technology

Course Number

4193298B

CPE Credit

2.0 hours CPE credit

Level of Knowledge

Beginning

Vendor

CalCPA Education Foundation

Prerequisites

None.

Description

Formerly available as the Power Query add-in, the Get & Transform tools built into Excel 2016 for Windows are incredibly powerful. At a high level, users can retrieve data from a variety of sources and prepare it for use as needed.

These tools provide new ways to approach previously manual and time-consuming tasks. In this session, apply these tools to several everyday tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several .csv exports. If you frequently export/import data from one system to another, learn how to streamline workflows and gain a solid understanding of the Get & Transform query.

Materials are provided as an ebook for this course.

Highlights

  • Get & Transform Query
  • Flattening data
  • Splitting and combining columns
  • Formatting data
  • Unpivoting summarized data

Objectives

  • Recall the steps to create a new query.
  • Identify commands that transform data.
  • State the process to return the transformed data to Excel.

Designed For

Accountants and financial professionals.

Course Pricing

Member Fee

Applicable if you are a HSCPA member in good standing.

$60.00
Non-Member Fee

Applicable if you are not a HSCPA member.

$94.00
Your Price $94.00

CPE Choice

Learn more about CPE Choice.
This course does not qualify for CPE Choice.

View All Webcasts