PDF Version
Excel 2003: Introduction
Duration: 1 Day
Method: Hands-on, Instructor-led
XL2K3INT

Excel Introduction
What is Microsoft Excel?
Starting Excel
The Excel Screen
Excel Menus
Excel Toolbars
Keyboard Shortcuts
Using Help

Workbooks and Worksheets
The Structure of Excel Files
Opening an Existing Workbook
Saving a Workbook
Starting a New Workbook
Navigating a Workbook
Managing Worksheets

Entering Information
Spreadsheet Information
Formatting Cells for Specific Contents
Entering Labels
Using Numbers as Labels
Using Spellcheck
Using AutoComplete
Entering Numbers
Using Currency
Accountancy
Date and Time
Using Percentages
Using Fractions
Selecting a Range
Using Autofill

Entering Formulas
Basic Formulas
Order of Operations (BODMAS)
Basic Mathematical Functions
Using SUM
Using AVERAGE
Using COUNT
Using MAX
Using MIN
Using AutoSum
Referencing Other Cells in Formulas

Formatting Workbooks
Editing Cell Contents
Selecting Cells
Copying Cells
Moving Cells
The Clipboard
Inserting and Deleting Cells, Rows and Columns
Using Undo and Redo
Using Find and Replace
Cell Comments
Formatting Cells
Formatting Values
Advanced Cell Formatting
AutoFormat
Using Format Painter
Row Height and Column Width

Charts
Chart Types
Creating a Chart
Formatting and Editing Chart Objects
Changing the Source Data of a Chart
Charging a Charts Type
Annotating Charts

Sorting data
Sorting Data
Multilevel Sorting
Filtering a List With AutoFilter

Printing a Worksheet
Using Print Preview
Printing a Large WorkSheet
Printing a Chart
Additional Print Options

Course Overview
Delegates will gain an introductory level of understanding of the Microsoft Excel 2003 application.
Course Aims
Delegates will be able to identify the disadvantages of paper spreadsheets and the advantages of electronic spreadsheets, create a basic worksheet by entering text, values, and formulas, create formulas by using Excel’s built-in functions, move and copy data by using shortcut menus, drag-and-drop editing, and toolbar buttons, change the appearance of worksheet data by using a variety of formatting techniques, prepare a document for printing by using the spell checking feature and a variety of printing options, produce charts from the data.
Course Pre-requisites
Delegates should be comfortable working in a Windows environment. No prior knowledge of Excel is assumed.
Qualification Map
None.
NEOS IT Training Limited
Suite 3, 3rd Floor, Marmion House
Copenhagen Street
Worcester
WR1 2HB

tel: 01905 726222
fax: 01905 613001
info@neos-it-training.com