Microsoft Excel Functions & Formulas
Hours: 3.00 | Estimated Cost: $99.00
An Excel formula is an expression which calculates the value of a cell. Functions are predefined formulas which are already available for use. Learn more about using functions and formulas to create a dynamic, time-saving worksheet.
Additional Information
-
Learn About
- Excel formulas and functions
- Entering formulas and functions
- Reference operators
- AutoSum
- Cell references
- Order of operations
- Using names in formulas
- Troubleshooting
-
Benefits & Outcomes
- Save time by utilizing Excel's library of functions
- Make computations easier to perform
-
Training Outline
**Introduction to Functions & Formulas**
- Glossary
- Controlling Order of Precedence
- Conditionally Summing/Counting Data (SUMIF, COUNTIF)
- Being Precise (Rounding Functions)
- Absolute vs. Relative References
- Improving Clarity with Range Names
- Merging Text & Numbers (CONCATENATE, LEFT, RIGHT, MID & SUBSTITUTE Functions and using Text to Columns)
- Changing Results (IF, AND & OR Functions)
- Nesting Functions
- Table Functions (VLOOKUP Function)
- Dates & Times (TODAY, WEEKDAY & NETWORKDAYS Functions)
**Troubleshooting**
- Automatic Error Checking
- Using the Error Checker