* Version 2010 available for all course dates after Oct
1/10.
Course Prerequisites
Excel
Introduction and Formulas courses or equivalent knowledge. Excel
Intermediate Level 1 and Intermediate Level 2 courses are not required
before taking this course, although knowledge of the topics covered in
them is strongly recommended.
Course Description
This course
is designed for Excel users who would like to learn more using the
various functions available in Excel.
Detailed List of Topics
Review
of Using AutoSum
Typing
Functions
Using
Insert Function
Statistical Functions
Count
CountA
Large
Small
Rank
Max
Min
Average
Median
Mode
Logical
Functions
If
And
Or
Math
and Trig Functions
Product
Roman
Sum
SumIf
Round
RoundUp
RoundDown
Date
and Time Functions
Today
Now
Date
Value
Day
Month
Year
Weekday
Text
Functions
Left
Mid
Right
Len
Search
Trim
Lower
Upper
Proper
Information Functions
IsErr
NA
IsText
IsNumber
IsBlank
Info
Lookup
Functions
Vlookup
Choose
Transpose
Financial Functions
IRR
FV
PMT
PV
DB
Computer Training
Courses / SoftSkills Seminars / Access Database Development
Computer Help is a division of MPM
Skills Development Inc.
Toronto, Ontario, Canada.
