Using Basic Functions with Excel 2010

Individuals and business users with basic computer literacy

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
60 minutes

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.

Objective

Using Functions with Excel 2010 Data

  • 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
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.