Fleetwood Onsite Conference Recording - Conference presentation capture Contact  |  My Account  |  Cart Contents  |  Checkout   
  Home »

Previous Product  Product 110 of 110  Next Product   Manafacturer

 
 29419 - "Get & Transform" in Excel: A Powerful Tool for Implementing and Manipulating Data $25.00   
Select Format:

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.

 






 Copyright © 2024 Fleetwood Onsite Conference Recording


Fleetwood Facebook Page Follow us on Twitter Fleetwood on YouTube