Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

We’ll start with three easy IF statements, then move on to nested IF statements and multi-function IF statements. At the end we’ll get fancy with COUNTIF, SUMIF, AVERAGEIF, and IF with wildcards.

Using Excel as a scheduling tool is a great skill to have under your belt. Learn how to use SUM, DATE, WEEKDAY, IF, Nested IF, and IF/OR functions.