Decision-Making Functions in Excel (CPE Course)
CPE Credit: 2.5 hours
Course Type: Downloaded PDF materials with online test
Price (with PDF Textbook): $25
This course overviews a number of logical functions in Excel and then covers other decision-making functions such as SumIF, SUMIFs and IFERROR. The reader will find these functions useful when engaged in budgeting and analysis work. The course is based upon Excel 2007 through 2016 and includes exercise files.
Author: Mill Creek Publishing
Course Number: SP1014
- Identify different decision making functions and their purpose so the correct one can be selected
- Recognize the components of the Logic functions
- Understand and recognize the syntax of different decision making functions
- Be able to differentiate and use nested and embedded functions within an IF statement
Instructional Method: QAS Self-Study
NASBA Category: Specialized Knowledge
Prerequisites: This course is considered a basic to intermediate level course. It is expected that participants know basic file management skills such as opening and closing files as well as how to do simple calculations in a spreadsheet. It is also assumed that participants understand how to create and use a basic function.
Advance Preparation: None
Program Registration Requirements: Click on "Purchase Course" near the top of this page to pay for and access the course. You will then be able to download the course as a PDF file, then take an on-line examination, and then download a certificate of completion if you pass the examination.
Program Refund Policy: For more information regarding administrative policies concerning complaints, refunds, and other matters, see our policies page.
AccountingTools, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
The NASBA sponsor identification number for Accountingtools, Inc. is 115881.
AccountingTools is an IRS Approved Continuing Education Provider. We are compliant with the requirements for continuing education providers (as described in sections 10.6 and 10.9 of the Department of Treasury’s Circular No. 230 and in other IRS guidance, forms, and instructions). Our IRS Approved Continuing Education Provider number is 72821.