Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0


This course looks at a variety of Excel functions. Two widely used functions are covered in detail (If and Vlookup), other functions covered are: statistical, math and trig, date and time, text, logical, information, and financial.


 
Course Outline

This course is designed for Excel users who would like to learn more using the various functions available in Excel. 

This course is classroom style instruction: Instructor-led, hands-on training.

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

 


Prerequisites & Certificates
Pre-Requisites

Course Prerequisite: Required: Solid understanding of Excel Introduction and Formulas topics. Recommended: Knowledge of Excel Intermediate Level I topics.

Certificates offered

Participants receive with this course: * courseware (notes on all topics covered, along with exercises used during course). * a certificate of completion


Cancellation Policy

Map & Reviews
Computer Help
[ View Provider's Profile ]

Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 805 times.