This course is designed for Excel users who would like to learn more about creating formulas, as well as brushing up on math skills.
This course is classroom style instruction: Instructor-led, hands-on training.
Review of Basic Formulas
Using Operators
Order of Calculation
Formulas that Reference One Cell
Copying and Filling Formulas
Absolute Formulas
Partial Absolute Formulas
Formulas And Range Names
Using Range Names in Formulas
Using Range Names For Values
Column/Row Headings in Formulas
Manipulating Formulas
Editing Formulas
Converting Formulas to Values
Printing Formulas in Place of Results
Manual Calculation
Combining/Splitting Cell Contents
Concatenating Formulas
Text To Columns
Text Formulas
Adding Text to Value Cells
Date and Time Formulas
Calculating Days Between Dates
Calculating Years Between Dates
Calculating Time Differences
Referencing Cells Not On Sheet
Multiple Sheet Formulas
Multiple File Formulas
Linking Formulas
Auditing
Tracing Formulas
The Auditing Toolbar
Tracing Dependents and Precedents
Displaying Formulas
Goal Seek
Have Excel Change Cell Value To Arrive At Desired Result
Formulas That Cannot Be Edited
Creating Array Formulas
Editing Array Formulas
