Using basic functions with Excel 2010

Overview

One of the great features of Excel 2010 is its ability to apply a wide variety of functions to make using Excel 2010 easier and more fun for you. Functions are built-in time-saving formulas that allow you to choose one that suits your needs, instead of having to create a complex formula from scratch. This course introduces changes to functions in Excel 2010, including improved accuracy and consistency of functions, and changes to function names that make them more intuitive. Describes the useful feature of the Excel status bar, which automatically displays basic calculations, and the Function Library, which groups useful functions. It also covers the most common use of functions, the calculation of basic financial data, logic and date and time type.

Target Audience

People and professionals with basic computer skills.

Objectives

• Using functions with Excel 2010 data
• Identify the features of Excel functions
• Perform basic calculations using the most commonly used Excel functions
• Use financial functions
• Use date-type functions and time
• use logical functions to help you perform calculations with workbook data
• perform basic calculations
• use a financial function to determine the monthly payment of a loan
• use a date function and a logical function