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.
