16 Corporate Woods Boulevard | Albany, New York 12211 | Tel: 518.437.1600

Excel Formulas and Functions

Available Dates: Call for Dates
Class Length: 1/2 day
Cost: $109

Class Outline:

This three hour course teaches students about the different formulas and functions in Excel 2010 that are available to make spreadsheets more powerful and functional.

Table of Contents:
Unit 1: Logical and statistical functions
Topic A: Logical functions
Topic B: Math and statistical functions

Unit 2: Financial and date functions
Topic A: Financial functions
Topic B: Date and time functions
Topic C: Array formulas
Topic D: Displaying and printing formulas

Unit 3: Lookups and data tables
Topic A: Using lookup functions
Topic B: Using MATCH and INDEX
Topic C: Creating data tables

Unit 4: Advanced data management
Topic A: Validating cell entries
Topic B: Exploring database functions