Get & Transform data in Excel Webcast | 4203298A

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. 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 to streamline workflows as you master the Get & Transform query.

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.