Get & Transform" in Excel: A Powerful Tool for Importing and Manipulating Data

The "Get & Transform" tool in Excel 2016 for Windows is a real game-changer. It enables data imports from a wide variety of systems and software—Access, ERP solutions, accounting software—and moves it into a worksheet that transforms the original information into a new format of choice, which Excel remembers for next time. Even better, it's all done with a point-and-click wizard-like interface. Practical applications for Get & Transform will be covered in this session: as an alternative to VLOOKUP list comparisons, an automated way to flatten and format data, a method for un-pivoting summarized data, an easy solution for merging several CSV export files into one, and more. Learn to move past copy/paste and time-consuming manual data manipulation with this powerful tool.

You can listen to Get & Transform" in Excel: A Powerful Tool for Importing and Manipulating Data online on Radio and Podcast. Open the player on this page to stream the available audio.

Get & Transform" in Excel: A Powerful Tool for Importing and Manipulating Data is an episode from Accountex Podcast's by Accountex USA.

This episode is 10:41 long.

This episode was published on Feb 12, 2018.

Yes. Use the heart button on the episode page to add it to your favorite episodes list.

Yes. This page shows related episodes from Accountex Podcast's when more episodes are available from the podcast feed.