The basics… Entering formulas in Excel
Using the Formula Builder to access an extensive library of predefined functions
Utilizing absolute and relative references and partial absolute references
Understanding named ranges and creating them to make spreadsheets more efficient
Applying one or multiple conditions to some common functions