Excel 2010 Power Functions

Objective

Learn to use some of Excel's power functions, including SUMPRODUCT, array formulas, statistical functions, financial functions, and cube functions.

Prerequisite Skills

Comfortable with basic, intermediate, and advanced Excel capabilities.
(Suggested courses: Excel 2010 Getting Started, Excel 2010 Functions & Formulas, Excel 2010 Working with Workbooks, and Excel 2010 More Functions & Formulas)

Course Description

Do you need to calculate multiple ranges of cells? Do you want to use some of Excel's statistical and financial functions? Do you need to retrieve data from OLAP data sources?

Attend this course if you want to:

• Use the SUMPRODUCT function to calculate grand totals.

• Use array formulas to perform calculations on one or more ranges.

• Find the median or mode within a set of numbers.

• Rank items within a list.

• Find large or small values within a list.

• Calculate a payment.

• Calculate principal and interest amounts.

• Calculate present or future values.

• Calculate the depreciation of an asset.

• Work with cube functions.

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)

 

   

Related Information Register Now Excel 2010 Course List Delivery Methods