iCellini Computer Training

San Diego’s Onsite Computer Training Company

Microsoft Excel 2003 Class 2

Duration:	1 day
Prerequisite:	Excel Introduction or equivalent experience.
Course Materials:	Course manual with CD containing exercises, 144 pages
Prices:	$195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student
Description:	Students learn how to use templates, create and modify basic charts, and gain an solid understanding of the fundamentals of functions. Students will create a number of basic functions including Date and Time, Financial, and Logical functions. Students will also take a close look at the IF function (one of the most popular and most used functions by Excel gurus) and learn how to nest functions. This is a challenging class, so get a good night's rest!

Using and Understanding Templates

Using Excel’s Templates
Understanding Templates
Adding Data Using Templates

Creating and Modifying Charts

Charts in a Worksheet
Creating and Modifying Charts
Using the Chart Wizard
Using the Chart Toolbar
Customizing Charts
Editing the Data Used to Produce Charts

Understanding and Creating Functions in Excel

Basic Syntax
Function Descriptions
Working with Statistical Functions
Entering Statistical Functions Directly into Cells
Using the Insert Function Utility
Function Arguments Dialog Box
Working with Date and Time Functions
Date and Time Formats in Formulas
Calculating Dates and Times
Working with Financial Functions
Using the PMT Function
Using the FV Function
Working with Logical Functions
The Basic IF Statement
More Logical Functions
Printing Formulas

The Anatomy of an IF Statement

IF Function Description
Nesting an IF Function
Multiple Nested Conditions and Multiple Return Values
Nesting Other Functions in an IF Function

Subtotaling List Data

Using the Subtotal Function
Grouping and Subtotaling a List

Data Analysis and Sharing Workbooks

Troubleshooting Formula Errors
Locating Formula Errors
Evaluating and Correcting Formula Errors
Understanding What-If Analysis
Using Goal Seek and Trendlines
Using Scenarios to Compare Predictions
Excel’s Add-Ins
Sharing Data
Creating a Shared Workbook
Using a Shared Workbook

Microsoft Excel 2003, Class 3

Return to Microsoft Excel list of classes

Classes Taught by a Certified Microsoft Master Instructor

Our Microsoft Office Access classes are taught by a Certified Microsoft Office Specialist Master Instructor.

Choose Your Own Training Dates and Class Hours

You can suggest your own dates for training. If the date is available we will schedule it.

You can also choose your own start time. We have started as early as 6 a.m. Start times are your choice.

We are open to discuss whatever special needs you might have.

Customize Your Classes

One of the advantages of choosing iCellini for your training needs is that we can customize classes to meet your needs. Our customized classes are very popular! For more information, see our Microsoft Excel Custom Class page.