- Discuss the difference between formulas and functions (using the SUM, TRIM, COUNT, AVERAGE and the POWER functions)
- The Function Library
- The 10 Golden Rules
- All formulas must start with an equal sign
- Followed by the function name
- Followed By an open bracket
- Follow Excel's instructions
- Separate all components using commas
- Close all brackets
- Follow BODMAS rules
- Understand the use and order of these operators (^, <>, >=,<=)
- All unkown texts used in a formula must be in double quotation marks or else the name must be defined.
- Functions can be nested