Format: Audio MP3 Download
Presenter: Jeff Lenning, CPA
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.
|