| On this page: Download | Upgrade | Buy |
Screenshot | View help file |
This popular and powerful add-in gives you many more tools with which to manipulate and analyse data in Microsoft® Excel® 97 software onwards.
- Find almost any selection of cells on a sheet (by their appearance, contents or location), and carry out some selected function on them, such as change the appearance, the contents or the location automatically and in the way you specify
- Work easily with duplicates, links, errors, colours, formats, hyperlinks etc etc
- Convert numbers or formulae easily
- Tidy up text and to convert numbers which have been input as text (aren’t they annoying?!!!)
- Find missing items from lists of data, or compare two sets of data and line them up with each other
- Add a clickable index page to your workbook
- Convert digits into words
- Swap instantly a block of data with the block adjacent (instead of having to insert, cut and paste and delete)
- PLUS much, much more ...
Click to see full size screenshot
There is also the PATools Statistics module where you can …
- see instantly the sum, average, sum of positives and negatives separately (useful for accountants to see Debits & Credits), maximum and minimum values of your selected area even if it contains error cells.
- see instantly an analysis of your selected cells in terms of the number of cells, and the number that contain formulae, values, positive values, negative values, zeros, errors, text, blank and non-blank cells.
The screen pops up in a flash, even if you select the whole page (over 16 million cells). The reason this is so useful is that (unlike the bar at the bottom of the normal screen) it shows you all the figures in one go, and it copes with error cells (see how the normal bar becomes blank as soon as you shade over an error cell?).
By installing and using this software you affirm your complete and unreserved acceptance of the PATools
End User License Agreement
For new users, the software will run on an evaluation basis, which means that you can use it for as long as you wish but only run the main tools 30 times.
You can purchase a license 24/7 using our secure automated service from this webpage below.
Changes since last release
Upgrade
No need to uninstall your current version - simply download as above.
Contact us if you have problems.
Buy
BUY NOW from the secure ordering site of our payment partner share-it! where you can pay in various currencies
Licenses expire after 1 year.
SAVE MONEY by buying an extended license (lasting more than 1 year) - see here
SAVE MONEY by buying several PATools Excel products - see here