Office 2010 - Excel Intermediate - Using Functions

Learning Objectives

• Identify function components
• Use the now function
• Use the average function
• Use the maxand min function
• Use the count function
• Apply the if function
• Work with the pmt function
• Edit functions

Course Overview

• Functions perform various calculations by using specific values, known as arguments.
• To quickly display a list of functions, and their respective descriptions, use the Insert Function button.
• To be able to use the current date and time in calculations, use the NOW function.
• The IF function, which enables you to evaluate if a condition in a worksheet is true or false, produces different results depending upon the true/false value of the condition.
• The PMT function enables you to work out any periodic payments, such as a loan or mortgage repayment.