Self-Study
Microsoftr Excelr 2019: Working with Formulas and Functions
-
Wednesday, May 1, 2024 – Wednesday, April 30, 2025
-
-
4.00CREDITSComputer Software and Applications
This course guides you through creating, copying and pasting, reviewing, and correcting basic and complex formulas in Excel 2019 using step-by-step, hands-on activities.
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
Highlights
- Identify basic formula and function syntax
- Recognize formulas pasted with relative references
- Select status bar options and sum (AutoSum) for quick calculations
- Recognize formulas pasted with mixed or absolute references
- Identify formula results pasted as values
- Select worksheets for grouping and entering formulas
- Identify ways to link worksheets and workbooks with 3D formulas
- Select the insert function button or buttons from the function library to insert functions in formulas
- Recognize defined names as function arguments
- Apply conditional formatting to formulas’ results
- Identify and correct common errors using the trace error icon and the formula auditing tools
- Identify and correct circular references
- Select color-coded cell borders to correct a cell reference error in a formula
- Identify how to step through a nested formula
- Identify how to use the Watch Window and other tools to analyze, protect, and hide formulas