Using Basic Functions with Excel 2010

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 chose 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