Data Assistant for Microsoft Excel
Easily convert text reports into databases for Microsoft Excel Pivot Tables.
English
Supported Technologies
Windows 95/98/ME,
Windows XP/2000/NT
Software
Click on a technology to view similar products within this category.
Pricing
Users (# of seats)
$29.95
Buy Now
Additional Product Information
The Data Assistant easily convert text reports into databases for Microsoft Excel Pivot Tables.
Typically reports loaded into Excel have columns of data, where the columns represent time periods, such as months, and the rows contain descriptions of the data in the rows. Unfortunately, such a data layout is very difficult to use in pivot tables. You end up having to put many individual data fields into the pivot table, and can not work with them as a group. And, you can not use some of the powerful features of pivot tables.
The Data Assistant is a menu driven add-in that converts the data into the form best used by pivot tables. For example, if you have many columns of monthly data, this is converted into just two columns, one containing the month name and one containing the data. If rows contain different types of data, such as sales dollars and sales quantity, the data is placed into separate columns, which is the best way to arrange pivot table data. And, there are many more options to make the data conversion easy and painless!
Buy individually or as part of the Analysis Collection for Microsoft Excel. The Analysis Collection gives you downloadable books on Excel macros, this add-in, and over 30 other time saving add-ins. Save over 70% off of individual prices with the Analysis Collection