Certified Internal Auditor with Microsoft Excel (Voucher Included)
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,...
Bundle and save
for additional information
Certified Internal Auditor with Microsoft Excel (Voucher Included)
Details + Objectives
Course code: GES2089
What you will learn
- To create, modify, and manage Excel workbooks
- To use formulas, functions and work with tables
- To convert, sort, filter, and manage lists
- To use conditional formatting and styles
- To create pivot tables and charts
- 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
- Use AI and Microsoft Copilot in Excel to create columns, analyze data, and import or frame data more efficiently
How you will benefit
- 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
- Improve spreadsheet productivity by using AI and Microsoft Copilot to speed up data analysis, support content creation, and streamline common Excel tasks
How the course is taught
- Self-paced, online course
- 18 Months to complete
- Open enrollment, begin anytime
- 370 course hours
Instructors & Support
Tracy Berry
Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.
The Certified Internal Auditor is not an instructor facilitated course; however, support will be provided through email, online forms, and phone.
Instructor Interaction: The instructor looks forward to interacting with learners in the online moderated discussion area to share their expertise and answer any questions you may have on the course content.
Requirements
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.
Requirements:
Hardware Requirements:
- This course must be taken on a PC. Macs are not compatible.
Software Requirements:
- PC: Windows 10 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Office 365, 2021 or 2019 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version and what you see in the course.
- Microsoft Word or an equivalent word-processing program.
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for Microsoft Excel 2019 course are included in enrollment and will be available online. You will receive unlimited Practice Assessments and a PDF textbook when you begin the Certified Internal Auditor course.
More About
About Certification: Institute of Internal Auditors (IIA)
The Institute of Internal Auditors (IIA) was established in 1942 to serve as an international association for the profession. With more than 185,000 members around the world, IIA strives to promote the value of the industry, provide career development opportunities, and enhance the skills and knowledge of internal auditors. The IIA's certifications are one way the institute accomplishes these goals. Demonstrate your abilities and get ahead in your auditing career with a course certified by IIA.
Related Courses
Microsoft Access Certification Training (Voucher Included)Advanced Career TrainingMicrosoft Excel Certification Training (Voucher Included)Advanced Career TrainingMicrosoft Office Specialist (MOS) Associate Certification Training (Vouchers Included)Advanced Career TrainingMicrosoft Office Specialist (MOS) Expert Certification Training (Vouchers Included)Advanced Career Training