Excel 2010 - Worksheet Functions
EXL-10-08
Duration
2 hours
Who should attend?
The module will suit all users who need to work with advanced Excel functions to perform calculations.
Pre-requisites
Attendees should be familiar with the concepts of creating simple calculations. They should also have experience of inputting, amending, copying and moving data. Familiarity with topics covered in modules:
Objectives
You will learn how to: Use advanced functions to perform calculations.
Course Content
Overview
What is a Function?
Insert Function
Explore the function feature in order to use functions such as IF, AND, OR, NOT, VLOOKUP.
String Functions
Use different text functions such as LEFT, RIGHT, MID, SEARCH, LEN.
Financial Functions
Use the financial functions: NPV, PMT, RATE.
User defined Functions
* Time permitting: Use a function that has been written in Visual Basic. View the underlying VB code. Create a simple user defined function.