Automated Audit Services - Calgary
Automated Audit Services - Calgary
Links to Audit Software and Auditing Sites:
Great New Analysis and CAAT Tool: ActiveData (from InformationActive Inc.)
ActiveData for Excel is an affordable, easy to use solution for advanced data manipulation and analysis within the Excel enviroment. See also ActiveData for Office or SQL for similar products that can analyze much larger data files using database features, beyond the Excel 2003 limit of 64k rows. (Excel 2007 onwards can handle 1 million rows.)
ActiveData for Excel adds over 100 powerful features to Excel in one easy to use tool:
- Organize and index all of your workbooks
- Find and Replace data across all of your workbooks
- Navigate through sheets and workbooks with the Workbook Navigator
- Manipulate selections with ease and pinpoint control with the Selection Navigator
- Merge, match, query, extract, sample from and compare sheets
- Tag & manipulate rows
- Split sheets by day, week, month, year or group (key) value
- Sort sheets by double-clicking
- Sort sheets to a new sheet on up to 6 columns
- Split and combine columns in a variety of ways
- Manage columns within a sheet
- Apply stratified analysis to your sheets
- Summarize your sheets
- Create top/bottom items analysis for data within your sheets
- Produce detailed age (date analysis) reports
- Look for and eliminate gaps and duplicates
- Convert cells to and from a variety of data formats
- Fill cells with random, fixed and incrementing date, text and numeric values
- Populate columns of data by randomly selecting data from existing cells
- Format ranges of cells with your own customized cell properties using our simple format painter
- Import file and folder listings
See their Website for details, a 30 day trial copy or to order
Go to the CaseWare Website for full details on WinIDEA
Go to ACL Website for details of their audit software
Link to AuditNet - Audit Resources available on the Net
