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 & Industry Services (BIS)
5 N. Systems Drive
Appleton, WI 54914-1655

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