{"product_id":"accounts-payable-specialist-certification-with-microsoft-excel","title":"Accounts Payable Specialist Certification with Microsoft Excel","description":"\u003cp class=\"course-intro\"\u003ePrepare for Accounts Payable Specialist (APS) certification, offered by the Institute of Finance  Management and the Microsoft Office Specialist certification for Microsoft Excel. APS certification is included upon successful course completion.\u003c\/p\u003e\u003cul class=\"course-facts\"\u003e\n\u003cli\u003e100 course hrs\u003c\/li\u003e\n\u003cli\u003eCode GES2090\u003c\/li\u003e\n\u003cli\u003eOpen enrollment\u003c\/li\u003e\n\u003cli\u003eSelf paced\u003c\/li\u003e\n\u003c\/ul\u003e\u003cnav class=\"course-nav\"\u003e\u003ca href=\"#overview\"\u003eOverview\u003c\/a\u003e\u003ca href=\"#objective\"\u003eObjective\u003c\/a\u003e\u003ca href=\"#outline\"\u003eOutline\u003c\/a\u003e\u003ca href=\"#requirements\"\u003eRequirements\u003c\/a\u003e\u003ca href=\"#prerequisites\"\u003ePrerequisites\u003c\/a\u003e\u003ca href=\"#instructor\"\u003eInstructor\u003c\/a\u003e\u003ca href=\"#faqs\"\u003eFAQs\u003c\/a\u003e\u003c\/nav\u003e\u003ch3 id=\"overview\"\u003eOverview\u003c\/h3\u003e\u003cdiv class=\"course-sec\"\u003e\u003cp\u003eAccounts 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 \u0026amp; Management (IOFM), which demonstrate your understanding of invoices, payments, T\u0026amp;E, Automation and other key financial functions.\u003c\/p\u003e\u003c\/div\u003e\u003ch3 id=\"objective\"\u003eObjective\u003c\/h3\u003e\u003cdiv class=\"course-sec\"\u003e\n\u003cp\u003e\u003cstrong\u003eWhat you will learn\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e \u003cli\u003eTo create, modify, and manage Excel workbooks\u003c\/li\u003e \u003cli\u003eTo use formulas, functions and work with tables\u003c\/li\u003e \u003cli\u003eTo convert, sort, filter, and manage lists\u003c\/li\u003e \u003cli\u003eTo use conditional formatting and styles\u003c\/li\u003e \u003cli\u003eTo create pivot tables and charts\u003c\/li\u003e \u003cli\u003eTo import and export data\u003c\/li\u003e \u003cli\u003eFoundations of accounts payable best practices, specifically internal controls and tax and regulatory matters\u003c\/li\u003e \u003cli\u003eTo identify process improvements in the accounts payable function\u003c\/li\u003e \u003cli\u003eAutomation technology terminology of and how it affects your profession\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eHow you will benefit\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e \u003cli\u003ePrepared for the Microsoft Office Specialist (MOS) Expert in Excel Certification Exam\u003c\/li\u003e \u003cli\u003eUse these skills in most workplace situations\u003c\/li\u003e \u003cli\u003eManipulate data faster by learning helpful formulas and tricks\u003c\/li\u003e \u003cli\u003eHigher earning power – certified AP professionals earn more than their non-certified peers.\u003c\/li\u003e \u003cli\u003eSharper skills – certification builds skills – from fundamentals to advanced AP practices.\u003c\/li\u003e \u003cli\u003eMore respect – certification places you in an exclusive group of AP professionals whose skills are proven to meet a global standard of excellence.\u003c\/li\u003e \u003cli\u003eA stronger resume – certification demonstrates that you've gone above and beyond to develop your skills and that you meet a rigorous training standard.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003ch3 id=\"outline\"\u003eOutline\u003c\/h3\u003e\u003cdiv class=\"course-sec\"\u003e\u003col style=\"list-style-type: upper-roman;\"\u003e \u003cli\u003eMicrosoft Excel Certification Training \u003col style=\"list-style-type: upper-alpha;\"\u003e \u003cli\u003eIntroduction to Excel \u003col\u003e \u003cli\u003e Microsoft Office Basics\u003c\/li\u003e \u003cli\u003e Creating a Microsoft Excel Workbook\u003c\/li\u003e \u003cli\u003e The Ribbon\u003c\/li\u003e \u003cli\u003e The Backstage View (The File Menu)\u003c\/li\u003e \u003cli\u003e The Quick Access Toolbar\u003c\/li\u003e \u003cli\u003e Entering Data in Microsoft Excel Worksheets\u003c\/li\u003e \u003cli\u003e Formatting Microsoft Excel Worksheets\u003c\/li\u003e \u003cli\u003e Editing Worksheets\u003c\/li\u003e \u003cli\u003e Working with Rows and Columns\u003c\/li\u003e \u003cli\u003eUsing Formulas in Microsoft Excel\u003c\/li\u003e \u003cli\u003eFinalizing Microsoft Excel Worksheets\u003c\/li\u003e \u003cli\u003eIntroduction to Excel Exam\u003c\/li\u003e \u003c\/ol\u003e \u003c\/li\u003e \u003cli\u003eIntermediate Excel \u003col\u003e \u003cli\u003e Common Functions\u003c\/li\u003e \u003cli\u003e Working with Lists\u003c\/li\u003e \u003cli\u003e Visualizing Your Data\u003c\/li\u003e \u003cli\u003e Working with Tables\u003c\/li\u003e \u003cli\u003e Advanced Formatting\u003c\/li\u003e \u003cli\u003e Intermediate Excel Exam\u003c\/li\u003e \u003c\/ol\u003e \u003c\/li\u003e \u003cli\u003eAdvanced Excel \u003col\u003e \u003cli\u003e Using PivotTables\u003c\/li\u003e \u003cli\u003e Advanced Functions\u003c\/li\u003e \u003cli\u003e Auditing Workbooks\u003c\/li\u003e \u003cli\u003e Data Tools\u003c\/li\u003e \u003cli\u003e Working with Others\u003c\/li\u003e \u003cli\u003e Recording and Using Macros\u003c\/li\u003e \u003cli\u003e Advanced Excel Exam\u003c\/li\u003e \u003c\/ol\u003e \u003c\/li\u003e \u003cli\u003eMicrosoft Excel Final Exam\u003c\/li\u003e \u003c\/ol\u003e \u003c\/li\u003e \u003cli\u003eAccounts Payable Specialist Certification Introduction \u003col style=\"list-style-type: upper-alpha;\"\u003e \u003cli\u003eOverview\u003c\/li\u003e \u003cli\u003eInternal Controls\u003c\/li\u003e \u003cli\u003eTax and Regulatory\u003c\/li\u003e \u003cli\u003eVendor Master File\u003c\/li\u003e \u003cli\u003eInvoices\u003c\/li\u003e \u003cli\u003ePayments\u003c\/li\u003e \u003cli\u003eTravel and Entertainment (T\u0026amp;E)\u003c\/li\u003e \u003cli\u003eTechnology and Automation\u003c\/li\u003e \u003c\/ol\u003e \u003c\/li\u003e\n\u003c\/ol\u003e\u003c\/div\u003e\u003ch3 id=\"requirements\"\u003eRequirements\u003c\/h3\u003e\u003cdiv class=\"course-sec\"\u003e\n\u003cp\u003e\u003cstrong\u003eRequirements:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eHardware Requirements:\u003c\/p\u003e\n\u003cul\u003e \u003cli\u003eThis course must be taken on a PC. Macs are not compatible.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSoftware Requirements:\u003c\/p\u003e\n\u003cul\u003e \u003cli\u003ePC: Windows 10 or later.\u003c\/li\u003e \u003cli\u003eBrowser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.\u003c\/li\u003e \u003cli\u003eMicrosoft 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.\u003c\/li\u003e \u003cli\u003e Adobe Acrobat Reader .\u003c\/li\u003e \u003cli\u003eSoftware must be installed and fully operational before the course begins.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eOther:\u003c\/p\u003e\n\u003cul\u003e \u003cli\u003eEmail capabilities and access to a personal email account.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eInstructional Material Requirements:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eThe instructional materials required for this course are included in enrollment and will be available online.\u003c\/p\u003e\n\u003c\/div\u003e\u003ch3 id=\"prerequisites\"\u003ePrerequisites\u003c\/h3\u003e\u003cdiv class=\"course-sec\"\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eWhile there are no prerequisites to take this course, you should be comfortable using a personal computer and be familiar with operating Microsoft Office software.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eCertification Requirements:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eIOFM recommends that you meet one of the following for the (APS) certification:\u003c\/p\u003e\n\u003cul\u003e \u003cli\u003eNo degree = 3 yrs. AP experience\u003c\/li\u003e \u003cli\u003e2-year degree = 2 yrs. AP experience\u003c\/li\u003e \u003cli\u003e4-year degree = 1 yr. AP experience\u003c\/li\u003e\n\u003c\/ul\u003e You've got questions.\u003cbr\u003e We're here to help.\u003c\/div\u003e\u003ch3 id=\"instructor\"\u003eInstructor\u003c\/h3\u003e\u003cdiv class=\"course-sec\"\u003e\n\u003cp\u003e\u003cstrong\u003ePam Miller\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003ePam Miller, Senior Trainer, IOFM, was the first candidate to earn AP certification as an Accredited Payables Manager (APM) with distinction. Her professional background includes 15 years as Director of AP at BMC Select. She is recognized in the accounts payable industry as an innovator and an early adopter of AP related technologies. Before working in AP, she spent six years in the IT industry, implementing point of sale software.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eJudy Bicking\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eJudy Bicking, APM, is a Senior Trainer for IOFM and a 27-year veteran of Johnson \u0026amp; Johnson. She is a recognized pioneer and leader in Procure-to-Pay and Credit Management. After a career in AR and AP management, Judy leads the development and implementation of J\u0026amp;J's two Shared Service Centers, located in the U.S and Europe. These shared services handle over 2.5 million invoices across 200 decentralized companies.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eTracy Berry\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eTracy 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.\u003c\/p\u003e\n\u003c\/div\u003e\u003ch3 id=\"faqs\"\u003eFAQs\u003c\/h3\u003e\u003cdiv class=\"course-sec\"\u003e\n\u003cp\u003e\u003cstrong\u003eDoes this course prepare you for a certification?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eYes, IOFM Accounts Payable Specialist (APS) Certification Exam (final exam of course). You will also be prepared for the Microsoft Office Specialist (MOS) Excel Expert Certification exams.\u003c\/p\u003e \u003cp\u003e\u003cstrong\u003eWhen can I start this course?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eThis course is open enrollment, so you can register and start the course whenever you are ready. Access to your course can take 24-48 business hours.\u003c\/p\u003e \u003cp\u003e\u003cstrong\u003eHow long does it take to complete this course?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eAfter you register, you will receive 9 months to complete the course. The time allotted for completion has been calculated based on the number of course hours.\u003c\/p\u003e \u003cp\u003e\u003cstrong\u003eWhat if I don't have enough time to complete the course within the time frame provided?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eIf you are unable to complete the course, contact your Student Advisor to help you work out a suitable completion date. Please note that an extension fee will be charged. If you are funded through a third-party organization, approval may also be required.\u003c\/p\u003e \u003cp\u003e\u003cstrong\u003eWhat kind of support will I receive?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eOur courses are designed to accommodate various learning preferences. Depending on the course structure, you may get different forms of support. Self-paced courses are designed to be user-friendly and independent, minimizing the need for external support. In courses with instructors, our direct platform support feature includes opportunities for questions, discussions, and remediation, with email and phone support available for select courses. Our student advising team is available to guide you on program requirements and administrative requests, but they do not provide assistance with course content. Our goal is to provide you with the necessary support for success, whether it's through self-paced exploration, direct communication, or guidance from our advising team.\u003c\/p\u003e \u003cp\u003e\u003cstrong\u003eWhat happens when I complete the course?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eUpon successfully passing the final exam, you will be awarded a certificate of completion from the school or organization that you registered through.\u003c\/p\u003e \u003cp\u003e\u003cstrong\u003eAm I guaranteed a job?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eed2go courses will help you gain the skills you need to obtain an entry-level position in most cases. However, you should always research the job market in your area before enrolling.\u003c\/p\u003e \u003cp\u003e\u003cstrong\u003eCan I get financial assistance?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eed2go courses are non-credit, so they do not qualify for federal aid, FAFSA, and Pell Grant. In some states, vocational rehab or workforce development boards may provide funding to take our courses. Additionally, you may qualify for financial assistance if you meet certain requirements. Learn more about financial assistance. \u003c\/p\u003e \u003cp\u003e\u003cstrong\u003eHow can I get more information about this course?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eIf you have questions that are not answered on our website, representatives are available via LIVE chat. You can also call us at 1-877-221-5151 during regular business hours to have your questions promptly answered. If you are visiting us during non-business hours, please send us a question using the \"Contact Us.\"\u003c\/p\u003e Related Courses Microsoft Office Specialist (MOS) Associate Certification Training (Vouchers Included) \u003cbr\u003e CAREER TRAINING PROGRAM $2295.00 USD https:\/\/careertraining.ed2go.com\/1111\/training-programs\/microsoft-office-specialist-associate-certification-training-vouchers\/ LEARN MORE \u003ci class=\"fa fa-check-square ed-cat-week\" aria-hidden=\"true\"\u003e\u003c\/i\u003eVoucher Included \u003ci class=\"fa fa-calendar ed-cat-week\" aria-hidden=\"true\"\u003e\u003c\/i\u003e6 Months \u003ci class=\"fa fa-clock-o ed-cat-week\" aria-hidden=\"true\"\u003e\u003c\/i\u003e245 Course Hours Microsoft Office Specialist (MOS) Expert Certification Training (Vouchers Included) \u003cbr\u003e CAREER TRAINING PROGRAM $2995.00 USD https:\/\/careertraining.ed2go.com\/1111\/training-programs\/microsoft-office-specialist-expert-certification-training-vouchers-included\/ LEARN MORE \u003ci class=\"fa fa-check-square ed-cat-week\" aria-hidden=\"true\"\u003e\u003c\/i\u003eVoucher Included \u003ci class=\"fa fa-calendar ed-cat-week\" aria-hidden=\"true\"\u003e\u003c\/i\u003e6 Months \u003ci class=\"fa fa-clock-o ed-cat-week\" aria-hidden=\"true\"\u003e\u003c\/i\u003e335 Course Hours Certified Administrative Professional (Voucher Included) \u003cbr\u003e CAREER TRAINING PROGRAM $2064.00 USD https:\/\/careertraining.ed2go.com\/1111\/training-programs\/certified-administrative-professional\/ LEARN MORE \u003ci class=\"fa fa-check-square ed-cat-week\" aria-hidden=\"true\"\u003e\u003c\/i\u003eVoucher Included \u003ci class=\"fa fa-calendar ed-cat-week\" aria-hidden=\"true\"\u003e\u003c\/i\u003e6 Months \u003ci class=\"fa fa-clock-o ed-cat-week\" aria-hidden=\"true\"\u003e\u003c\/i\u003e100 Course Hours You've got questions.\u003cbr\u003e We're here to help.\u003c\/div\u003e","brand":"Hope Training Academy","offers":[{"title":"Default Title","offer_id":47318452371644,"sku":"_GES2090","price":3495.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0742\/1391\/6860\/files\/GES2090.jpg?v=1787604178","url":"https:\/\/shop.videogamepalooza.org\/products\/accounts-payable-specialist-certification-with-microsoft-excel","provider":"Video Game Palooza","version":"1.0","type":"link"}