58026 3
Course Description: 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. Learning Objectives: By the end of this course, participants should be able to: 1. Identify different decision-making functions and their purpose so the correct one can be selected. 2. Recognize the components of the Logic Functions . 3. Recognize and apply the syntax of different decision-making functions 4. Be able to differentiate and use nested and embedded IF functions. 
 
Version: This EBook is designed for professionals using Microsoft 365. If you have an earlier Excel version, you should have no difficulty however you may not have access to all of the functions covered here.

Additional Course Details

  • Filed of Study: Computer Software & Applications
  • Author: Joseph P. Helstrom
  • Course Level: Intermediate
  • Pre-Requisites: None
  • Interactive: Yes
   0 Review  |  Write a review

Available Options

* Course Format:
 

Write a review

Your Name:


Your Review: Note: HTML is not translated!

Rating: Bad           Good

Enter the code in the box below: