Office 2013 - Excel Intermediate - Using Functions
Interactive

Office 2013 - Excel Intermediate - Using Functions

Jenison ELearning
Updated Nov 09, 2018

Learning Objectives

  • Identify function components
  • Use the now function
  • Use the average function
  • Use the max and 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.