Description
This bite sized, 2 hour topic driven online course is designed for people who need to know how to use basic formulas and functions in Microsoft Excel. The following topics will be covered:
Formulas
- What is a formula
- BODMAS theory
- Creating a formula
- Copying formulas
- Absolute References in formulas
Linking Formulas
- Advantages of Linking
- Creating a Link
Functions
- What is a Function?
- Function syntax
- Using Paste Function
Date Functions
- The TODAY Function
- The NOW Function
Text Functions
- The UPPER Function
- The LOWER Function
- The PROPER Function
Math and Trig Functions
- The SUM function
- Using AUTOSUM
- The AVERAGE function
- The MIN function
- The MAX function
- The COUNT function
- The COUNTA function
- The COUNTBLANK function
- The INT function
- The ROUND function
- The ROUNDUP function
- The ROUNDOWN function