Ability Software Consultants +44 (0)1531 828366
info@officecourseware.com
Instructor with Microsoft Office, OpenOffice and StarOffice training coursewareOfficecourseware.com

Home Titles Costs Contact Us Links

Table of contents from instructor-led training courseware notes. Page numbers are for guidance only and may vary. Courseware notes are formatted for double-sided printing.

Microsoft Excel 2003 Introduction

  Page

Introduction to Excel

 1
The Spreadsheet Concept 1
Introduction to Excel 1
Excel Screen Layout 2
Getting Help 5
Task Panes 6

Cell Ranges

 7
Introduction 7
Moving the Active Cell with the Keyboard 7
Moving the Active Cell with the Mouse 7
Selecting a Range with the Mouse 8
Selecting a Range with the Keyboard 8
Specific Selections 9
Cell Range Names 10

Entering Data

 13
Introduction 13
Constants 13
Automatic Features 14
Data Entry in a Range 16
Extended Formats and Formulae 17
Editing Data 17

Formulae

 19
Formulae 19
Cell References 20
Formula Error Checker 21
Functions 23
Conditional Function 26

File Operations

 27
File Shortcut Keys (and Buttons) 27
Saving Workbooks 27
Closing Workbooks 29
Opening Workbook Files 30
My Places Bar 30
Finding Files 32
Starting a New Workbook 33
File Management 33

Editing

 35
Editing Shortcut Keys (and Buttons) 35
The Office and Windows Clipboards 35
Office Clipboard Task Pane 37
Paste Options 38
Filling 38
Moving 39
Clearing Ranges 41
AutoFill Feature 43
The Selection Border and the Right Mouse Button 45

Inserting, Moving & Deleting

 47
Inserting 47
Deleting 47

Formatting

 49
AutoFormat 49
Cell Formatting 50
Format Painter 54
Column Widths 55
Row Heights 55

Printing

 57
Print What 57
Print Preview 57
Page Setup 59

Charts

 65
Introduction 65
Creating a Chart 65
Chart Sheets 66
Embedded Charts 66
Printing an Embedded Chart 68

Workbook Sheets

 69
Introduction 69
Working with Sheets 69
Sheet Groups 71
3-D Printing 73

Linking

 75
Introduction 75
File Links 75
Linking between Office Applications 76

Lists

 79
Introduction 79
Creating a List 79
Insert Row 80
Total Row 80
Sorting Lists 80
Filtering Lists 80
Print a List 82
Data Validation 82

Document Protection

 85
Introduction 85
Worksheet Protection 85
Workbook Protection 87
Passwords 88

Templates

 89
Introduction 89
Standard Templates 89
Custom Templates 90

Toolbars

 91
Personalised Menus and Toolbars 91
Showing Toolbars 92
Placing Toolbars 92
Customising Toolbars 92

Panes

 93
Freeze 93
Split 93

Appendix

 95
Enter Data Using Shortcut Keys 95
Work in Cells or the Formula Bar Using Shortcut Keys 96
Format Data Using Shortcut Keys 97
  Word 2003 Intro
Word 2003 Adv
Word 2003 Dev
Excel 2003 Intro
Excel 2003 Adv
Excel 2003 Dev
PowerPoint 2003
Outlook 2003
Visio 2003
Access 2003 Intro
Access 2003 Adv
FrontPage 2003		  


All trademarks and product names used on this web page are for identification purposes only and are acknowledged as the registered trademarks of their respective owners. Officecourseware.com and Ability Software Consultants do not claim the endorsement of, or to represent, any of the companies whose names or products are presented on this page.