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
×

Share Your Needs



Information Request (check all that apply - your information is private)
Areas of Interest (check all that apply)

(e.g., MS Excel on-site)

loading
×
Business & Industry Services (BIS)
5 N. Systems Drive
Appleton, WI 54914-1655

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