Excel Basic Formulas
Course Description: This class will acquaint the user with an overview of Excel formulas where cell addresses are featured for effective formula copying. Relative vs. absolute referencing is discussed and demonstrated as well as exposure to general formula functions such as SUM, AVERAGE, MAX, MIN, and COUNT. The user will also be shown various Date functions such as TODAY, NOW, MONTH, YEAR, and DAY.
Objective: Upon completion of this course the novice Excel user will be able to complete spreadsheets by using a variety of formulas featuring basic computation along with using built-in Excel Functions.
- Copying formulas using the Fill Handle
- Relative vs. Absolute References
- Using AUTOSUM
- Basic Functions
- Date Functions
- TODAY & NOW
- MONTH, YEAR, and DAY
- The DATE Function
- Conditional Formatting