This course is a three-lesson intermediate level course. This course guides you through creating, copying and pasting, reviewing, and correcting basic and complex formulas in Excel using step-by-step hands-on activities. This course emphasizes using a standard keyboard and mouse actions to perform tasks in Excel.
Learning Objectives
- Describe formula and function syntax and create basic formulas
- Copy/paste and fill formulas
- Enter formulas on grouped worksheets
- Use multiple methods to build formulas
- Apply conditional formatting to formulas’ results
- Find and correct formula errors using a variety of tools, such as the Error Checking feature and Trace Error icon, the Formula Auditing tools, and the Watch Window
Major Topics
- Basic formula and function syntax
- Formulas pasted with relative references
- Status bar options and Sum (AutoSum) for quick calculations
- Formulas pasted with mixed or absolute references
- Formula results pasted as values
- Worksheets for grouping, entering formulas, and formatting
- Ways to link worksheets and workbooks with 3-D formulas
- The Insert Function button or Buttons from the Function Library to insert functions in formulas
- Defined names as function arguments
- Conditional formatting for formulas’ results
- Common errors using the Trace Error icon and the Formula Auditing tools
- A circular reference
- Color-coded cell borders to correct a cell reference error in a formula
- How to step through a nested formula
- How to use the Watch Window and other tools to analyze, protect, and hide formulas
