|
|
|
|
EXC122: Excel Formulas and Functions
|
|
|
|
|
Tuition:
$150.00 per student |
Length: 1/2 day |
|
|
Synopsis:
Microsoft Excel class with focus on student selected formulas and functions. Possible topics include: cell and range references, advanced Excel statistical, lookup and financial functions, text functions, named ranges, and decision making.
|
|
Formats:
On-site at your facility or San Juan Capistrano classroom. Your choice. This class is most often run in a 1/2 day format but full days are possible, too.
|
|
Scheduling:
Classes flexibly scheduled by arrangement.
|
|
Group
Discounts:
Yes - see FAQ's.
|
|
|
|
| Topics 1 | Selected Topics | 3.0 Hours | | |
- Cell and Range references - Absolute and relative, A1, 3-D, R1C1 styles
- Calculating with Advanced Formulas - Date and Time, Financial, Lookup, Statistical, Logical
- Sorting and Filtering
| | | Topics 2 | Selected Topics | 3.0 Hours | | |
- Text Functions
- Information Functions
- Using Names
- Decision-making functions - IF, SUMIF
| |
|
|
Materials:
Custom manual prepared specifically for this course.
|
|
Location:
Classes can be taught on-site at your facilities
or at our location in San Juan Capistrano, Orange
County. We also travel beyond Southern California.
|
|
|
|
