Decision-Making Functions in Excel
This course overviews several Excel Logical functions, such as IF, IFS, AND, OR and then covers other decision-making functions such as AVERAGEIF, SUMIF, SUMIFs, COUNTIFs and MAXIFS. IFERROR and IFNA are also covered. You will find these functions useful in your budgeting and analysis work. This eBook includes exercise files.

Course Publication Date: September 09, 2020

This course is available with NO ADDITIONAL FEE if you have an active self study membership or all access membership or can be purchased for $30.00!

Author:Mill Creek Publishing
Course No:COMP-EXCELDEC-2560
Recommended CPE:3.00
Delivery Method:QAS Self Study
Level of Knowledge:Overview
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.
Advanced Preparation:None
Recommended Field of Study:Computer Software and Applications
  
Learning Objectives
  • Identify different decision making functions and their purpose so the correct one can be selected.
  • Recognize the components of the Logic Functions.
  • Recognize and apply the syntax of different decision making functions.
  • Be able to differentiate and use nested and embedded IF functions.

CPE Depot 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 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.

Sponsor Number: 109423

 (646ms)
CPE-WEB02 3.238.173.209 url(WWW.CPEDEPOT.COM)-domain(WWW.CPEDEPOT.COM)-anon

Search Courses

Group Plan

Group plans are convenient and cost effective!

Authors Wanted

We are looking for authors!