The New Power Query: Get and Transform your data in Excel 2016

Description

Excel 2016’s new “Get & Transform” feature is an incredibly powerful new toolset that can simplify your work. Combining features used in the Power BI and Power Query add-ins, Get & Transform enables you to easily connect to data from a variety of sources and then prepare it for use or analysis. These tools provide efficient new methods for accomplishing tasks that were previously manual and time-consuming. In this webcast, we’ll apply these tools in several typical scenarios, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several CSV exports. If you regularly import or export data from one system to another, you will definitely want to learn how to leverage a Get & Transform query to streamline your work.

Learning Objectives
  1. Recall the steps to create a new query
  2. Identify commands that transform data
  3. State the process to return the transformed data to Excel
Provider
AICPA
Course Level
Basic
CPE Field of Study
TBD
Who Should Attend
Accounting professionals in public practice or business and industry
Instructor(s)
Jeff Lenning
Location
Online Course
Register Now
When
Nov 2, 2016
1:00 pm - 3:00 pm
Total CPE Credits
2
Format
Webinar
Instructor
Jeff Lenning

MEMBER


$ (% off)
$99.00

NON-MEMBER


$ (% off)
$129.00
Become a Member

Register for this Event

The New Power Query: Get and Transform your data in Excel 2016


Loading