Excel 2010 Functions & Formulas

Objective

Learn the fundamentals of creating and working with formulas and functions. Start by building and copying simple formulas. Then learn to use functions such as SUM, AVERAGE, PMT, ROUND, TODAY, and NETWORKDAYS. Also understand the difference between relative and absolute cell references, create grand totals, and work with formulas that contain 3-D references.

Prerequisite Skills

Comfortable with basic Excel capabilities.

(Suggested course: Excel 2010 Getting Started)

Course Description

Do you want to perform calculations in your Excel spreadsheets? Do you want to use any of the 300+ built-in Excel functions? Do you want to learn how to efficiently create worksheets that update automatically?

Attend this course if you want to:

Understand the difference between functions and formulas.
Understand formula operators and order of operation.
Learn how to use cell references.
Create and edit formulas.
Use a built-in function.
Use AutoSum to automatically sum data.
Sum subtotals to create a grand total.
Access other functions from the Function dialog box or the Formulas tab.
Understand the difference between and implications of relative and absolute references.
Round values for calculations.
Use date and time functions.
Create formulas that span across multiple workbook pages.

Class Length

90 minutes

Delivery Options

Virtual classroom - public
($70 per student; check times and register here)
Virtual classroom - dedicated (up to ten people from the same organization)
($480 per class; contact us for more details)
Virtual classroom - one on one
(Register for a 45-minute 1-on-1 Application Support session. Cost is $70 per student per session.)
On-site instructor-led
(Contact us for details)