Using Basic Functions with Excel 2010


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number



Overview/Description
One of the great features of Excel 2010 is its ability to perform a wide variety of functions to make your use of Excel 2010 easier and more fun. Functions are inbuilt formulas that save you time by allowing you to choose one that suits your needs rather than having to create a complex formula from scratch. This course introduces you to the changes made to functions in Excel 2010, including improved function accuracy and consistency as well as the changes made to some function names that make them more intuitive. It describes the useful feature of Excel's status bar that automatically displays basic calculations as well as the Function Library, which groups useful functions. The most common use of functions, calculating basic financial, logical, date and time data is also covered.

Target Audience
Individuals and business users with basic computer literacy

Expected Duration (hours)
1.0

Lesson Objectives

Using Basic Functions with Excel 2010

  • identify the characteristics of functions in Excel
  • perform basic calculations using Excel's most commonly used functions
  • use financial functions
  • use date and time functions
  • use logical functions to help perform calculations on worksheet data
  • perform basic calculations
  • use a financial function to determine the monthly repayment of a loan
  • use a date function and a logical function
  • Course Number:
    mo_bexl_a09_dt_enus