Get & Transform" in Excel: A Powerful Tool for Importing and Manipulating Data
Archived series ("Inactive feed" status)
When? This feed was archived on June 29, 2021 01:07 (). Last successful fetch was on May 12, 2020 20:08 ()
Why? Inactive feed status. Our servers were unable to retrieve a valid podcast feed for a sustained period.
What now? You might be able to find a more up-to-date version using the search function. This series will no longer be checked for updates. If you believe this to be in error, please check if the publisher's feed link below is valid and contact support to request the feed be restored or if you have any other concerns about this.
Manage episode 199399306 series 2092630
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.
11 episodes