Microsoft Excel 2003 Introduction Online

Course Overview

This course aims to develop skills using Microsoft Excel to produce and spreadsheets to an Introductory level.

Prerequisites

Basic Mathematic concepts

Objectives

Section A: Introduction & Simple Lists

• Introduction
• Cell Reference
• Creating Lists
• Simple Formatting
• AutoFill Values
• Format Painter

Section B: Workbooks & Worksheets

• Save a Workbook
• File Properties
• Rename & Delete Worksheets
• Move & Copy Worksheet
• Printing a Workbook

Section C: Manipulating Values

• Editing Values
• Insert, Delete & Move Cells
• Copy Cells
• Comments
• AutoFilter
• Find & Replace

Section D: Charts

• Create a Chart
• Chart Options
• Manipulate Values
• Chart Type
• Secondary Axis
• Add Values

Section E: Summarising Values

• New Worksheet
• Add Values
• AutoSum
• AutoFormat
• Modifying Format Styles

Section F: Formatting & Graphics

• Create a Grid
• Create a Border
• WordArt
• Add Text
• Merge & Center
• Insert Clip Art
• Drawing Object
• Rotated Text
• Print Preview

Section G: Using Help

• Tool Tips
• Office Assistant
• Ask a Question Box
• Context Sensitive Help
• Comprehensive Help