Excel for Auditors will empower you to save valuable time by using this powerful tool more effectively when working with audit information, such as fixed assets. Unlike most advanced Excel courses, the Excel for Auditors programme is not a tour of functionality, but focuses on developing advanced understanding and practical know-how that will result in significant time-saving each month. The learning is experiential; therefore, all exercises and examples use auditing data that relates to practical situations.
These workshops are available in Microsoft Excel 2010.
Next available course
Currently none
Course Duration
Full day (9:00 – 4:30) available for groups of 6 – 8 people
Who will benefit by attending this course?
Excel for Auditors aims to save auditors clerks and internal auditors, valuable time by providing specialised training on how to use this powerful tool more effectively and efficiently when working with audit information. By the end of the workshop delegates will have an excellent knowledge of the audit related functions within Excel.
Please note: Intermediate Excel skills are required.
Cost
$350 (plus) GST
Sample of Workshop Content
- Working with Multiple Sheets
- Sheet Protection and Grouping Sheets
- Paste Special
- Nesting Functions and Absolute Referencing
- Logical, Lookup, Mathematical and financial Functions
- Named Ranges
- Conditional Formatting
- Auditing a Formula
- PivotTables
- Linking of Sheets
- Hyperlinks
- Importing a Text File
- Text and Subtotal Functions
- Duplication
- Group and Outline
- Using Subtotaling
- Filtering Data
- Charts and Pivot Charts
- Macros
Enroll now by submitting the form on the left or call us on (08) 9277 2226.