Microsoft Excel 97 Foundation
Training Course Outline

1-day course

This course includes the following topics:

1). A first look at Excel 97

The advantages of using Excel 97
What are workbooks and worksheets?
Creating and opening workbooks
Entering data
Further data entry techniques
Autocorrect, Autocomplete
Using the pick list
Navigating in the worksheet
Selecting items within Excel 97
Inserting and deleting cells, rows and columns
Saving workbooks
Moving between worksheets
Using the spelling checker
Closing an Excel 97 workbook
Exiting Excel 97

 

2). A closer look at the Excel 97 screen

The standard toolbar
The formatting toolbar
Selecting worksheet views
Undo and repeat
The office assistant

 

3). Formatting and customizing data

Formatting options within Excel 97
Alignment
Data indentation and rotation – introduced with Excel 97
To center items in a cell/cells
Using fonts
Formatting numbers,  Decimal places
Formatting columns and rows
Deleting cells, formats, objects and worksheets
Adding, editing and removing borders
Using Autoformat
Copying data using drag and drop
Copying columns and rows

 

4). Formulas, functions and named ranges

Formulas
Operator evaluation order within Excel
Functions,  Using the sum function
Other commonly used functions
Using paste function
Naming cells and ranges
Using named ranges with formulas

 

5). Introducing charts

Creating a chart
Moving, re-sizing and deleting charts
Changing the chart type

 

6). Printing

Page setup,  Margins
Centering printed output
Headers and footers
Sheet printing options
Choosing a printer & changing settings
Printing a worksheet
Printing multiple files 

 

For further details, or to book a course, please contact us:
email:        training@ictwizard.com
telephone:  01382 453447
 

Our Excel courses include:

Excel 2007 Foundation

Excel 2007 Intermediate

Excel 2007 Advanced

Excel 2007 Power User

Excel 2003 Foundation 

Excel 2003 Intermediate 

Excel 2003 Advanced

Excel VBA

Bespoke Excel Training
We can design an Excel course to suit your requirements. Contact us to arrange a tailored Excel course.

 

ICT Wizard courses:

• on your site or locations throughout the UK
• Computer training courses in Aberdeen, Dundee, Glasgow, Edinburgh and London
• delivered by Certified Master Instructors.