Outline subject to change without notice.
Please contact us with any questions.

EXCEL CALCULATIONS  

Upcoming Classes
  • January 13, 2012
  • February 1, 2012
  • March 8, 2012
  • April 17, 2012

COURSE DESCRIPTION
If you’ve ever looked through the long list of built-in Excel functions and
wondered what they do, and how they might help you, then Excel
Calculations is for you!  Topics covered offer an in-depth view of both
simple and advanced formulas, built-in functions, and special
calculating features.  Excel’s Goal Seek and Solver tools are explored
as well.  Be prepared to crunch some numbers during this session!

Pre-requisite: Excel Basics and Intermediate or equivalent experience  

Full Day Class Only $195.00 (Unless otherwise specified full-day
classes are weekdays from 9am to 4pm)

COURSE HIGHLIGHTS
  • Relative and absolute cell references
  • Creating linked formulas
  • 3-D References
  • Creating and using named references
  • Nested functions
  • Array formulas
  • Financial formulas, including:
    - Running balances and running totals
    - Payment and depreciation functions
    - Amortization schedule template
  • Date & Time formulas, including:
  - TODAY and NOW functions
  - The DAYS360 function
  - NETWORKDAYS function
  - Using the WEEKNUM function
  • Math and statistical formulas, including:
  -  The ABS function
  -  Using Excel’s rounding functions
  -  Using SUMIF and COUNTIF
  -  Calculating percentages and averages
  -  MIN, MAX, MEDIAN and MODE functions
  • Database formulas, including:
  -  The DAVERAGE and DCOUNT functions
  -  DGET, DMAX, and DMIN functions
  • Text formulas, including:
  -  Using the TRIM function
  -  UPPER, LOWER, and PROPER functions
  -  The CONCATENATE function
  • Using IF and VLOOKUP
  • Goal Seek and Solver
CALL
(330) 262-2343
or
CLICK HERE TO
REGISTER NOW!
Copyright 2012
Computer Sense, LLC