Internal auditors have a complex job, but tools like Microsoft's Excel program make managing data easy. This online course will train you in the IIA's International Standards for the Professional Practice of Internal Auditing and teach you advance techniques for using Microsoft Excel. You will be fully prepared to pass the IIA's Certified Internal Auditor exam and the Microsoft Office Specialist (MOS) Expert exam for Microsoft Excel. Key topics include mandatory guidance under the IPPF, managing an internal audit project and concepts of internal control, risk, governance, and technology.
Completion Time
370 hours
Access Time
548 Days
Outcome
Industry Certification
Language
English
Training Level
Advanced
Delivery Information:
Online
Asynchronous
Self-paced
Description
Learning Outcomes
What you will learn:
- To create, modify, and manage Excel workbooks
- To use formulas, functions and work with tables
- To use conditional formatting and styles
- To create pivot tables and charts
- To convert, sort, filter, and manage lists
- To import and export data
- Master the foundations of an internal auditor
- Apply internal audit best practices to your daily work routine
- Reduce financial risk for employers
- Develop exam time management and pacing
- Become a certified Microsoft Office Specialist (MOS) Expert in Excel
- Use these skills in most workplace situations
- Manipulate data faster by learning helpful formulas and tricks
- Prepare yourself to work as an internal auditor or risk manager
- Develop the skills needed to pass various CIA exams, including parts 1, 2, and 3
- Become an asset to your employer by reducing your organization's chance of financial risks
- Demonstrate your proficiency with internal staff and external clients
Additional Information
This course offers enrollment with a voucher. The voucher is prepaid access to sit for the Microsoft Office Specialist (MOS) Expert Excel certifying exam upon eligibility. Proctor fees may apply, which are not included.
Requirements
Technology Requirements
Hardware Requirements: This course can be taken on either a PC, Mac, or Chromebook.
Software Requirements: Software must be installed and fully operational before the course begins.
- PC: Windows 8 or later.
- Mac: macOS 10.6 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible. Cookies and JavaScript must be enabled
- The latest Adobe Reader/Acrobat Reader ( free download available at https://get.adobe.com/reader/ )
- Any modern Office suite: Microsoft Office, Apple iWork, OpenOffice, or LibreOffice
- Reliable internet connection. Broadband cable or highspeed DSL is recommended for optimal experience.
- E-mail account (to be able to register and to receive e-mail from the course system regarding registration, course status, etc.)
Prerequisites
This Certified Internal Auditor course is specifically designed to help individuals with prior internal auditing knowledge prepare for the CIA exam. CIA candidates must meet the eligibility requirements for education, character, work experience, and identification. Before a candidate application can be approved, ALL documentation (proof of education, character reference, and identification) must be received and approved by The IIAs Certification staff. Learn more about the eligibility requirements.
Enroll My Team
Are you looking to enroll your team in this training Course? You Can: