Accounts payable specialists are key members of any organization, ensuring bills and commitments are paid on time, accurately and completely. Many AP specialists rely on software like Microsoft's Excel program to collect, track and update important financial data. This online course will prepare you for the Microsoft Office Specialist (MOS) Expert certification exam for Excel and award you an Accounts Payable Specialist (APS) certification upon successful course completion. APS is an associate-level certification offered Institute of the Finance & Management (IOFM), which demonstrate your understanding of invoices, payments, T&E, Automation and other key financial functions.
Completion Time
100 hours
Access Time
274 Days
Outcome
Industry Certification
Language
English
Training Level
Intermediate
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 convert, sort, filter, and manage lists
- To use conditional formatting and styles
- To create pivot tables and charts
- To import and export data
- Foundations of accounts payable best practices, specifically internal controls and tax and regulatory matters
- To identify process improvements in the accounts payable function
Automation technology terminology of and how it affects your profession
How you will benefit:- Prepared for the Microsoft Office Specialist (MOS) Expert in Excel Certification Exam
- Use these skills in most workplace situations
- Manipulate data faster by learning helpful formulas and tricks
- Higher earning power – certified AP professionals earn more than their non-certified peers.
- Sharper skills – certification builds skills – from fundamentals to advanced AP practices.
- More respect – certification places you in an exclusive group of AP professionals whose skills are proven to meet a global standard of excellence.
- A stronger resume – certification demonstrates that you've gone above and beyond to develop your skills and that you meet a rigorous training standard.
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
While there are no prerequisites to take this course, you should be comfortable using a personal computer and be familiar with operating Microsoft Office software.
Certification Requirements: IOFM recommends that you meet one of the following for the (APS) certification:- No degree = 3 yrs. AP experience
- 2-year degree = 2 yrs. AP experience
- 4-year degree = 1 yr. AP experience
Enroll My Team
Are you looking to enroll your team in this training Course? You Can: