Mobile Edition


The New Power Query: Get and Transform Your Data in Excel 2016 (AINPQG04)

 
Date:Monday, December 18, 2017
Time:1:00 PM - 3:00 PM
(Registration at 12:30PM)
Facility:Webcast or Webinar, Online
CPE Credit:2.0 Technical Business
Instructor: Jeff S. Lenning
Vendor:AICPA
Course Level:Basic
Early Bird Price:$99.00 FICPA Members, $129.00 Non-Members

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.

Objectives:
Participants of this webcast will be able to:  Recall the steps to create a new query  Identify commands that transform data  State the process to return the transformed data to Excel

Who Should Attend:
Any Excel user

Prerequisite:
Experience in Excel

Session/Options

If listed below, select the appropriate sessions or options to continue with your purchase.

Registration Status: CLOSED - Online registration for this course is now closed. Please contact the Member Service Center at (800) 342-3197 if you wish to inquire about registering.