START HERE  
PRICES
SAMPLES
CONTACT US

Microsoft Excel 2003 Basics
Courseware Training Materials
Part of the Computer Basics Series

Foundation / Intermediate level computer training materials for delivering training to your students, staff or clients.  A courseware site licence allows you to train an unlimited number of people, at your training center using these teaching resources.

Training Course Outlines 

USING EXCEL 2003

• Starting Excel using the Windows Start menu
• Closing Excel
• Opening and closing an existing workbook
• Selecting and opening a continuous block of files
• Selecting and opening multiple files which are not in a continuous block
• Creating a new default workbook
• Saving a workbook
• Saving a workbook (using a different name)
• Saving a file in a format other than Excel format, such as Lotus 123
• Saving an Excel file as a Text Only file
• Saving a file in an earlier Excel format
• Saving a workbook as a template file
• Setting the User Name.
• Setting the default folder.
• Today's Tip
• Displaying the Office Assistant
• Hiding the Office Assistant
• Using "Type in a question for help"
• Using "F1 Help" within Excel
• Help drop down menu options
• Zooming the view
• Displaying or hiding the toolbars.

SELECTION TECHNIQUES

• Selecting a cell
• Selecting non-adjacent cells
• Selecting a range of cells by dragging the mouse
• Selecting a range of adjacent cells, making up a rectangular block
• Selecting an entire worksheet
• Selecting several worksheets
• Selecting all worksheets
• Selecting a row
• Selecting a range of adjacent rows
• Selecting a range of non-adjacent rows
• Selecting a column
• Selecting a range of adjacent columns
• Selecting a range of non-adjacent columns

INSERTING AND EDITING DATA

• Entering numbers.
• Entering today's date.
• Entering text into a cell.
• Recommended techniques when creating or editing lists
• Inserting additional cell contents, or modifying existing cell content.
• Replacing existing cell contents
• Using the Undo button
• Using the Redo button

FINDING AND REPLACING TEXT

• Finding text in a worksheet
• Finding and replacing text within a worksheet

SORTING DATA

• Sorting a list in ascending alphabetic order
• Sorting a list in descending alphabetic order
• Sorting a list in ascending numeric order
• Sorting a list in descending numeric order

COPYING, MOVING AND DELETING

• Copying a cell range within a worksheet
• Copying a row or column within a worksheet
• Copying a cell range between worksheets
• Copying a row or column between worksheets
• Copying a cell range from one workbook, to a different workbook
• Copying a row or column from one workbook, to a different workbook
• Using AutoFill
• AutoFill options
• Moving a cell range within a worksheet
• Moving a row or column within a worksheet
• Moving a cell range between worksheets
• Moving a row or column between worksheets
• Moving a cell range from one workbook, to another workbook
• Moving a row or column from one workbook, to another workbook
• Deleting the contents of a cell or range

ROWS AND COLUMNS

• Inserting a row into a worksheet
• Inserting a column into a worksheet
• Deleting a row.
• Deleting a column.
• Changing the width of a column using drag and drop techniques
• Changing the width of a column to a specific value
• Setting the column width to the optimal width
• Setting new default column widths
• Changing the height of a row to a specific value
• Setting the row height to the optimal height
• Freezing and unfreezing column titles
• Freezing and unfreezing row titles
• Freezing and unfreezing row titles and column titles

MANIPULATING WORKSHEETS

• Switching between worksheets within a workbook
• Switching between open workbooks using the Windows Status bar
• Switching between open workbooks using the Window drop down menu
• Switching between open workbooks using a keyboard shortcut
• Inserting a worksheet tab
• Renaming a worksheet tab.
• Recommended techniques with naming worksheets
• Deleting a worksheet (by right-clicking)
• Copying a worksheet within a workbook (the quick way)
• Copying a worksheet to another workbook
• Moving a worksheet within a workbook (the quick way)
• Moving a worksheet to another workbook

FORMULAS

• Entering formulas into the worksheet cell
• Entering a cell or range reference using the mouse.
• Using divide within a formula
• Using subtraction within a formula
• Using multiply within a formula
• Named cell ranges
• Formula error messages
• Getting help with formula error messages
• Using relative addressing
• Using absolute addressing
• Taking advantage of relative addressing when using AutoFill.

FUNCTIONS

• Common functions
• SUM function
• Average function
• MAX function
• MIN function
• COUNT function
• Counta function
• Countblank function
• IF function
• Using comparison operators such as =, >, and <.

NUMBER AND DATE FORMATTING

• Formatting cells to display a fixed number of decimal places
• Applying comma separators
• Removing comma separators.
• Formatting date styles
• Formatting cells using currency symbols
• Formatting numbers as percentages

TEXT FORMATTING

• Font size
• Font type
• Bold
• Italic
• Underlining
• Double underlining
• Changing the color used by the text
• Changing the background color of a cell range
• Applying formatting using the Format Painter
• Wrapping text within selected cells

ALIGNMENT AND BORDER EFFECTS

• Aligning data within a cell range, to the left, to the right or centre
• Aligning data between the top and bottom of a cell
• Merging and centering over a range
• Rotating text to any angle
• Applying a border to a cell range (using the Border button)
• Applying a border to a cell range (using the Format Cells/Border dialog box)
• Removing a border from cells or ranges

CHARTS

• Using the Chart Wizard
• Creating a column chart
• Creating a bar chart
• Creating a line chart
• Creating a pie chart
• Changing the Chart Type
• Selecting a chart
• Moving a chart within a worksheet
• Moving a chart to a different worksheet within a workbook
• Moving a chart to a worksheet within a different workbook
• Copying a chart within a worksheet
• Copying a chart to a different worksheet within a workbook
• Copying a chart to a worksheet within a different workbook
• Re-sizing a chart
• Deleting a chart
• Adding a title to a chart
• Removing titles from a chart
• Editing a chart title
• Changing the font size of the chart title text
• Changing the color of the chart title text
• Changing the font size of the chart axes text
• Changing the color of the chart axes text
• Inserting a chart legend
• Changing the color of the chart legend text
• Changing the legend font size
• Changing the background color of the chart legend
• Changing the background color of a chart
• Changing the color of a column within a chart
• Changing the color of a bar within a chart
• Changing the color of a line within a chart
• Changing the color of a pie slice within a chart

PRINTING ISSUES

• Modifying margin values
• Setting orientation and page size
• Forcing a worksheet to print on a single page
• Using standard headers and footers
• Creating custom headers and footers
• Inserting fields into a header or footer
• Always check your work prior to sending it to someone else!
• Spell checking a workbook.
• Checking calculations within a worksheet
• Previewing a worksheet
• Turning on (or off) the printing of gridlines
• Controlling the printing of row and column headings
• Forcing the title row(s) to print on every page of a multi-page worksheet.
• Printing a cell range from a worksheet
• Printing the entire active worksheet
• Setting the number of copies to print
• Printing a selected area of data within a worksheet
• Printing the entire workbook (including all the worksheets within it)
• Printing a selected chart
• Printing a workbook to a file