This course overviews several Excel Logical functions, such as IF, IFs, AND, OR an 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.
Delivery Method: Online QAS Self Study.
Version: This EBook is designed for professionals using Excel 2013 through and including Excel 2019. If you have an earlier version, there may be a few functions covered that you will not be able to try.
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