5 Free Excel 2003 Training Documents Free Downloads—pdf from Villanova University—online office course

Here are five great free Excel 2003 Training Documents, hosted by Villanova University. These will help you become a better Excel user and more proficient at using many Excel features, such as previewing and printing spreadsheets, entering formulas and functions, and creating and formatting charts.


Excel 2003: Creating & Formatting Spreadsheets
Learn how to use ranges, copy and move data, and format text, numbers, cells, columns, and rows in Excel. (41 pages, 199kb, pdf)

Table of Contents:
- Lesson 1: Exploring Excel
- Lesson 2: Using Basic Workbook Skills
- Lesson 3: Working with Ranges
- Lesson 4: Formatting Numbers
- Lesson 5: Formatting Text
- Lesson 6: Formatting Cells
- Lesson 7: Formatting Columns and Rows
- Lesson 8: Copying and Moving Data


Excel 2003: Previewing & Printing Spreadsheets
Before printing, you can preview a worksheet. The Print Preview feature displays the worksheet as it will appear when printed, including all aspects of the layout. You can use print preview to check the appearance of your printed worksheet before printing it, and if needed, make any additional changes. You can increase the magnification of the worksheet by zooming print preview, which makes the data easier to read. (23 pages, 94kb, pdf)

Table of Contents:
- Lesson 1: Printing
- Lesson 2: Using Page Setup
- Lesson 3: Using Large Worksheets
- Lesson 4: Working with Views


Excel 2003: Creating Simple Formulas
Formulas are used to perform calculations on values entered into the cells of a worksheet. They consist of the addresses of the cells containing the values and the appropriate mathematical operators. Formulas always begin with an equal sign (=) because they contain cell addresses. (12 pages, 63kb, pdf)

Table of Contents:
- Lesson 1: Creating Simple Formulas
- Using Formulas
- Entering Formulas
- Using Functions
- Using the AutoSum Button
- Entering Basic Functions
- Inserting Functions into Formulas
- Editing Functions
- Using the AutoCalculate Feature
- Using Range Borders to Modify Formulas
- Checking Errors


Excel 2003: Creating and Editing Excel Charts
A chart uses values in a worksheet to create a graphic representation of their relationship to one another. You can use charts to make it easier to spot trends, highlight important changes, and compare individual figures. Using charts in reports and presentations displays numbers in a format that is easy to understand. When you create a chart, each row or column of data on the worksheet becomes a data series. Each individual value within the row or column is called a data point.
(27 pages, 176kb, pdf)

Table of Contents:
- Lesson 1: Creating Charts
- Lesson 2: Formatting Charts
- Lesson 3: Advanced Charting


Excel 2003: Tips for Working with Data in Excel
(2 pages, 31kb, pdf)

Table of Contents:
- Selecting Data
- Edting Data
- Formatting Data
- Functions and Formulas