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. 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: May 21, 2019

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

Author:Mill Creek Publishing
Course No:COMP-EXCELDEC-2569
Recommended CPE:1.50
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
  
Add To Your Cart

Ready to take a course?

  • Includes all self study courses
  • Earn as many CPE credit as you need
  • 100% Guaranteed
Buy Self Study Membership

Learning Objectives
  • 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 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

 (840ms)
CPE-WEB02 3.231.229.89 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!