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