Excel Series 4 - Transform Data Without Formulas or Macros Webinar

  • 25 Jan 2018
  • 12:00 PM - 1:30 PM
  • Webinar
Transform Data Without Formulas or Macros

Program Objective: If you haven’t played with the Get & Transform commands in Excel 2016 for Windows, they are probably worth checking out. Formerly available as the Power Query add-in, the Get & Transform tools built-in to Excel 2016 for Windows are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. These tools provide new ways to approach tasks that were previously manual and time-consuming. In this session, we’ll 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, you will want to understand how to use a Get & Transform query to streamline your work.

Click below for registration link:
Powered by Wild Apricot Membership Software