This Excel course overviews several Logical functions and then covers other decision-making functions such as AVERAGEIF, SUMIF, SUMIFs, COUNTIFs and IFERROR. You will find these functions useful in your budgeting and analysis work. This EBook is based upon 2016 and includes exercise files. but users of earlier Excel versions (2007-2013) should have no difficulties. Table of Contents
Delivery Method: Online QAS Self Study.
Version: This EBook is designed for professionals using Excel 2007 through and including Excel 2016.
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