| Create
Basic Formulas
Order of Precedence Rules
Calculate with Simple Functions
Copying Formulas and Functions
Creating Absolute & Relative References
Multisheet and Multi-workbook Formulas |
Explore Selected Advanced Date
& Time Functions from the Standard and Analysis Tool Pack
Add-in Libraries |
Trace
Cell Precedents
Trace Cell Dependents
Locate Errors in Formulas
Set Data Validation Properties
Locate Invalid Data and Formulas
Watch and Evaluate Formulas |
| Activating
the Tool Pack Add-in
Create and Apply a Name for a Range of Cells
Calculate with Basic Date/Time Functions
Calculate with Basic Financial Functions
Calculate with Basic Statistical Functions
Calculate with Basic Lookup/Reference Functions
Calculate with Basic Logical Functions
Calculate with Basic Database Functions |
Explore Selected Advanced Engineering
Functions from the Standard and Analysis Tool Pack Add-in Libraries |
Introducing
Fundamental Concepts of Visual Basic Programming
Identify and Declare Variables and Constants
Controlling Program Logic
Distinguish Between Functions and Procedures
Creating Simple Custom Functions
Using Custom Functions Within a Worksheet Formula
Analytic Functions from the Standard and Analysis Tool Pack
Add-in Libraries |
