Excel 2003: Basic Calculations

This document gives you the basic information you need to do simple calculations using formulas in Excel.  It also introduces you to Excel's auto features.

Excel 2003: Functions and References

Learn how to do more complicated calculations using built in functions.  This document also explains the different types of cell references when working with formulas.

Excel 2003: Charts

This document gives you the information that you need to create charts from data within an Excel spreadsheet.

Excel 2003: Custom Charts

This document explains how to customize charts in Excel.

Excel 2003: Basic

This document explains the basic parts of the spreadsheet and how to navigate around Excel.

Excel 2003: Convert Number Grades to Letter Grades

This document explains how convert your number grades to letter grades in Excel 2003.

Excel 2003: Sorting and Filtering Data

This document explains how to sort and filter your data so it is easier to view.

Excel 2003: Common Chart Types

This document explains how Excel's  common charts.

Excel 2003: Working With Large Data Sets

This document shows how to freeze panes and use the keyboard to help you navigate in Excel when working with large data sets.

Excel 2003: Formatting Data

This document explains how to format your data.

Excel 2003: Printing

This document shows the different ways to print your worksheets or parts of your data.

Excel 2003: Advanced Calculations

Learn how to use some of Excel's built in Functions to perform advanced calculations.

Excel 2003:  Use Excel as a Grade Book

Calculate students grades with ease by using Excel as your grade book.  This document will guide you through the process

Excel 2003: Using the Excel Grade Book Template

The Excel Grade Book is a FREE tool offered to you by OTS Training.  The Grade Book is designed to help you list and calculate your students' grades for each class for which you are responsible.  The Grade book calculates grades based on percentages and lets you enter up to 100 students and 50 assignments.

The free Grade Book template can be downloaded here:

Undergraduate Degree Program

Masters Degree Program

Excel 2003: Common Errors

Learn about and how to correct the more commonly displayed errors in Excel.

Excel 2003: Macros

By definition, a Macro is a series of key strokes, mouse clicks and other commands that you record and then reuse later to save time and, perhaps, ensure consistency.  A Macro is a huge time saving feature that enables you record common tasks and then you can replay these tasks by “running” the macro.  This d ocument discusses how to record a macro, modify a macro, create a custom macro toolbar icon, and a worksheet macro icon.

Excel 2003: Convert Data from Columns to Rows

This document describes how to swap data from columns to rows in Excel.

Excel 2003: Concatenating Text Strings

This document demostrates how to combine data such as First Name and Last Name into a new Full Name cell using an operator and the Concatenate function.