Print Page   |   Contact Us   |   Your Cart   |   Sign In   |   Join
Get & Transform data in Excel 4173298B
Register View Registrations Tell a Friend About This EventTell a Friend
 

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.

 Export to Your Calendar 1/26/2018
When: 9:30 AM to 11:30 AM
Where: Webinar/Webcast
United States
Presenter: Jeff S. Lenning, CPA, CITP
Contact: April Deneault
801-466-10907


Online registration is available until: 1/26/2018
« Go to Upcoming Event List  

Curriculums:   Computers and Technology

NASBA Credit Category:  Computer Software and Applications

CPE Hours:  2

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 common 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.



Major Subjects

  • 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.

Level:  Beginning

Designed For

Accountants who use Excel 2016 for Windows.

Advanced Prep:

Optional: Please have Excel 2016 for Windows to work along.

Prerequisite

None.

Membership Management Software Powered by YourMembership  ::  Legal