User Tools

Access to each of these functions is available via the Audit Tools Menu. The most commonly used function are also available from the Shortcut Tool Bar.

The primary role of these tools is to analyse and extract information from lists of data in Excel spreadsheets.

So far as the ACBA Tools software is concerned a list is


Remarks: The characteristics of a list are particularly important because Excel offers freedom to the user to 'improve' the presentation of data by adding in rows and columns to create the impression of space. But so far as the spreadsheets analytical functions are concerned this has the effect of splitting up a list into to two or more lists.

For more details about ACBA Analytical and Audit Tools our website contains general descriptions and additional information about it.

See also:
List Analysis | List Comparison | Spreadsheet Data | Numbers inside Strings - Form Based | Number Arrays in Strings - Form Based | Random Sampling | Data Cleansing

  Last Updated: 03/09/2009 | © ACBA (UK) LTD, 2009