Excel 2003 Video Training Tutorials from BSU.edu

Here are some excellent Excel 2003 Video Training Tutorials from Ball State University. These Excel video tutorials demonstrate many of the important features and functionality of Excel, including: Formulas and Cell References; Formatting Cells and Data (column width, row height, text alignment, font size and color, formatting a range, merge and center columns, freezing a row or column); Modifying a Worksheet ( inserting columns and rows, copying and pasting cells); Functions (autosum, max, min, average); and Working with Multiple Worksheets.


Getting Started

Microsoft Excel 2003 Introduction
Learn the basics of using Microsoft Excel 2003. The layout of an Excel worksheet is explained.

Simple formulas and cell references
Learn how to use Excel cell references and create simple formulas.

Create Basic Excel Spreadsheet
View a demo of creating a basic spreadsheet. Active cells and data entry are explained.  

Using “Save” and “Save As” Option
Using the “Save As” option can save the original spreadsheet while creating a new spreadsheet with a new name.

 
Formatting Cells and Data

Column Width 
Change the width of a single column or a group of columns within your Excel spreadsheet.

Row Height
Easily change the height of a single row or multiple rows in your Excel spreadsheet.

Text Alignment 
Change the alignment of text in a single cell or a series of cells.

Format Font, Size and Color
Format text in a cell by changing the font, the size, or the color. Learn to apply Bold, Italic, or Underline characteristics to text in a cell.

Formatting a Range of Cells in Excel
Select a cell or range of cells and format the contents of those cells.

Format Percentages
Use the percent style to format percentages in an Excel spreadsheet.

Use Merge and Center Columns
Use the “Merge and Center” command to center a title across several columns in your spreadsheet.

Word Wrap Alignment In Excel
To keep text within the cell it was typed in, the word wrap alignment feature can be used. It changes the height of the cell so that all the text fits without changing the width of the cell.

Freeze a Row or Column to Control Display
Use the Freeze Pane feature to lock either columns or rows so they stay displayed as you scroll thru your spreadsheet.

Modifying a Worksheet

Insert columns and rows in Excel
Insert columns and rows into an existing spreadsheet.  Format cells to change the way the data in that cell is displayed.  

Copy and Paste Between Cells
Copy and paste the contents of existing cells to other cells. Learn to use the Fill Handle to copy formulas and values to other cells.

Other Ways to Copy and Paste
Learn different methods for copying and pasting information within Excel.

Functions

AutoSum Feature 
Use the AutoSum feature to quickly total a column or row. 

Use Max and Min or Avg on a Range
Use functions to determine the maximum (MAX), the minimum (MIN), or the average (AVG) for a range or cells.

Working with Multiple Sheets

Manage Sheets in an Excel Workbook
Manage the sheets that make up your Excel 2003 workbook.

Popularity: 21% [?]