Microsoft Excel 97 - Beginners Course

What is a Spreadsheet Programme?
A spreadsheet is a large grid of rows and columns into which you can enter numbers or formulae to perform calculations. Spreadsheets are used extensively in business planning, but are in no way limited to that area, or to professionals doing complicated calculations. The best thing about a spreadsheet is that you only have to enter the correct figures and formulae - you don't have to perform the calculations yourself!

You will learn about:

Getting Started

using the menu system
using the mouse
using the toolbar buttons
using the keyboard
A Simple Worksheet

adding a title and headings
entering some figures/formulaes
using the currency button
Open, Close, New & Save As

opening and closing a workbook
closing without saving
starting a new workbook
Copying & Moving

cut, copy and paste
copying a range of cells
moving cells
Number Format & Format Painter

number types
percentage/comma style
currency style and decimal places
Rows & Columns

inserting rows and columns
deleting a row and columns
hiding rows and columns

Building Formulae

spreadsheet mathematics
typing simple addition formulae
building a formulae in stages
typing a formulae
calculating rows
Formatting Cells & AutoFormat

font and font size
bold, italics and underline
left, centre, right & justify alignment
borders and colours
Number Format & Format Painter

number types
percentage/comma style
currency style and decimal places
Print & Print Preview

print preview -
- showing the margins
- using magnifying glass
- closing the print preview
printing multiple copies
displaying multiple pages in print preview
Views, Toolbars & Options

customising toolbars
scrolling a worksheet
the different views

By The End Of This Course You Will Be Able To:

Start and exit Excel
Use the menus, toolbar buttons and some shortcut key combinations.
Hide and show the Office Assistant; reset the Office assistant tips.
Change and zoom the view; hide and show toolbars.
Navigate the worksheet using the mouse and keyboard.
Create new workbooks; enter numbers, text and formulae.
Open, close, save and print worksheets.
Use Page Break Preview
Use Print Preview to view a worksheet as it would be printed.
Select cells and cell ranges.
Apply various fonts, font sizes and styles.
Align text within and across cells.
Copy and move formulae, numbers and text within a worksheet, and between worksheets in the same workbook.

The Trainer/Tutor

Our trainers are all "Quality Assured" to have a wealth of practical experience in the field of computer applications to match. We are using the latest in purpose written Information Technology courseware.

Having learnt all of the above, you will be able to produce professional looking spreadsheets and save them for future use.

GOOD LUCK!