Audit Command Language for Beginners

Import an Excel file into a cell environment by creating a project, accessing external data from disk, selecting the correct worksheet, and choosing to import with or without headers.

Learn to import a comma-delimited file into the ACL environment, let the tool auto-detect the delimiter, correct column placement, name the import, and import Active Directory users.

Learn to import data from an Oracle database into ACL by connecting via ODBC, selecting the HR schema tables, and downloading the employee table.

Learn to build expressions and apply filters in audit command language, using logical and arithmetic expressions to query data, with practical examples of between, greater than, and date ranges.

Learn to create and validate computed fields in audit command language using expressions and operators to calculate net pay and variances.

Learn to perform data integrity checks in audit command language by validating data, using the verifier command, and verifying control totals, duplicates, missing values, and thresholds.

Open the ACL environment and use the verify command to check data integrity, revealing field errors like missing extended price amounts and invalid product numbers with special characters.

Learn to count records and compute totals in audit command language by using analyze, count with criteria, verify expressions, and summarize field totals like payroll and taxable amounts.

Analyze payroll data with statistics and between commands to validate salaries. Identify top and lowest salaries, calculate totals, and count staff between two thousand and five thousand dollars.

Learn to verify data integrity using gaps, is blank, and duplicates commands in audit command language, identifying missing values and duplicate records in large employee datasets.

Master the fundamentals of data analysis with audit command language, applying profiling with classify and summarize, isolating data via filter and export, and joining and combining tables.

Using the classified command, profile the work department data to reveal department-level gross pay and taxable amounts, and output results to screen, file, or graph for analysis.

Master the summarize command in Audit Command Language to profile data, create multi-field subtotals by department, job, or date, and visualize results with graphs, differentiating it from the classify command.

Use cross tabulate to visualize data by department and job descriptions, with salary subtotals; stratify by salary ranges to analyze bonuses, and age invoices with each command.

Discover data isolation with the FUTA and extract commands, using quick filter to select dates and amounts, such as January to March 2000 and five hundred to five thousand dollars.

Learn to use the sort and quicksort commands to sort data in ascending or descending order, including multi-field sorts and directing results to another table.

Learn how to use extract and append to combine January and February transactions in ACL, ensuring tables share the same structure before appending.

Learn to use the join command to merge payroll and work departments tables by matching the employee number and department keys. Reveal department names for payroll analysis.

Learn to report findings in audit command language by turning payroll data into department-level summaries and graphs. Export results to Excel and view reports from views.