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.