Decision-Making Functions in Excel

Course Description:

This course overviews a number of Logical functions in Excel 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.

This eBook is designed for professionals using Excel 2019 and Microsoft 365. If you have an earlier Excel version, you should have no difficulty however you will not have access to all of the functions covered here.

Learning Objectives:

Upon successful completion of this course, participants will be able to:

• 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