Manipulating formulas and functions

• Use of Relative, Absolute, and Mixed Cell References
• Calculating percentages
• The function wizard in detail: How to find and use a function
• Nesting Functions: A function within another function

Use of complex standard functions

• The power of logical functions (If, SumIf, CountIf, AND, OR)
• Text-related functions (left part of a text cell, right part, ...)
• Statistical functions (median, minimum, maximum, ...)
• Date and time functions (splitting the year from a date)
• Search functions on a data list (vertical lookup, xlookup)

Checking the function (results)

• Verifying that a function is correct: function audit
• Visualizing the function instead of the result
• Using a spy window to keep an eye on the end result of a function