Telephone: 01942 738303 / 494333     Fax: 01942 738303

Excel 95 Foundation

A first look at Excel 95
· The advantages of using Excel 95
· What are workbooks and worksheets?
· Creating and opening workbooks
· Entering data
· Further data entry techniques
· Autocorrect
· Navigating in the worksheet
· Naming cells and ranges
· Selecting items within Excel 95
· Inserting and deleting cells, rows and columns
· Saving workbooks
· Moving between worksheets
· Using the spelling checker
· Closing an Excel 95 workbook
· Exiting Excel 95

The Excel 95 screen
· The standard toolbar
· The formatting toolbar
· Selecting worksheet views
· The view manager
· Undo and repeat
· Using help

Formatting and customizing data
· Formatting options within Excel 95
· Alignment
· 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
· Copying data using drag and drop
· Copying columns and rows




Formulas and functions
· Formulas
· Operator evaluation order within Excel 95
· Functions
· Using the sum function
· Other commonly used functions
· Using function wizard

Introducing charts
· How to create a chart
· Manipulating charts
· Formatting charts
· Chart types
· Creating 3-d charts

Printing
· Page setup
· Margins
· Centering a report on a page
· Headers and footers
· Sheet printing options
· Choosing a printer and changing settings
· Printing a worksheet
· Printing multiple files