Byron Employment

Byron Employment. Over 71,438 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $335.00

Do you need to

• Use more complex functions such as IF Functions or Financial Functions

At the end of this course:

You should be able to
• Use Advanced Excel functions such as IF and VLOOKUP to reduce the chance of data error
• Use Excel’s Financial Functions such as the Payment Function to calculate loan payments

Course Content:

Advanced Functions
• Entering worksheet functions
• Using the Insert Function dialog box
• Using the IF Function
• Nesting IF Functions
• The AND Function
• The IS Function
• The VLOOKUP Function
Financial Functions
• The Payment Function (PMT)
• The Absolute Function (ABS)
• The Future Value Function (FV)
Array Formulas
• Building and editing an Array Formula
• Two dimensional array

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 6162 2929
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 6162 2929 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search