Formulas and Functions in Excel

Lessons in this section

1. Creating Formulas

   Write formulas with arithmetic operators, follow the order of operations, and add, subtract, multiply, and divide with cell addresses.

2. Cell References

   Relative, absolute, and mixed references, copying formulas, and how references update when the sheet changes.

3. AutoFill

   Fill number series, copy patterns, create date series, and use AutoFill Options with the fill handle.

4. Essential Functions

   Use SUM, AVERAGE, MIN, MAX, and COUNT, enter functions three ways, and give them the right arguments.

5. Logical Functions

   Make decisions with IF, nested IFs, AND, OR, and NOT, and summarize with COUNTIF and SUMIF. Then build a commission sheet in the Chapter 4 project.