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