Skip to Main Content
FVTC Logo

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
Business and Industry Services

Fox Valley Technical College
Business & Industry Services (BIS)
D. J. Bordini Center
1825 N. Bluemound Road
P.O. Box 2277
Appleton, WI 54912-2277

bi.services@fvtc.edu
www.fvtc.edu/bis
View BIS Calendar

P: 888-458-0449
P: 920-735-2525
F: 920-735-4771


Join us on LinkedIn