Microsoft® Office Excel 2003: Beginning Formulas

Course Length: ½ day

Prerequisites

To ensure your success, we recommend you first take the following PC University course or have equivalent knowledge: Microsoft Office Windows XP: Introduction. If you have taken an introductory course for an earlier version of the Windows operating system, this will also meet the prerequisite.

Course Content


Lesson 1: Creating Basic Formulas

Identifying elements of a formula

Using the formula bar

Using operators

Using Order of Operations

Lesson 2: Introducing Functions

SUM Function

AutoSUM

Average Function

AutoAverage

Lesson 3: Introducing the Insert Function Dialog Box

Average Function

MIN Function

MAX Function

COUNT Function

COUNTA Function

COUNTBLANK Function

TODAY Function

NOW Function


 

 Return to Table of Contents