Using Basic Functions with Excel 2010

Course details

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.

• 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