microsoft for dummies

Learning is FUN mistakes are OK

excel for dummies

excel for dummies

excel for dummies online training will introduce the user to MS Excel 2000, the spreadsheet application within the MS Office 2000 suite of products.
Course Objective
By the end of the course, the user will be able to:

Create a simple spreadsheet
Format the spreadsheet
Add basic formelae and functions
Create a chart
Print the spreadhseet and chart

To see the contents of […]

Popularity: 100%


what is a spreadsheet?

A spreadsheet is principally designed to hold and work with large volumes of numbers (or values) and consists of rows going across the screen and columns going down the screen, so that a grid is formed.
If calculations are required, it would be sensible to use a spreadsheet, as opposed to a Word document, for example, […]

Popularity: 84%


starting ms excel 2000

Click on the MS Excel icon on the MS Office 2000 Toolbar OR Click on the Start button, then select Programs, then click on MS Excel from the menu. A new spreadsheet will be displayed.
The rows are numbered and the columns are lettered. The point at which a row and column intersect is called a […]

Popularity: 86%


toolbars

Toolbars consist of groups of icons (pictures) that represent their function. For example, the Print icon displays a picture of a printer.
To find out what a button does, simple hover the mouse over it and a screen tip will appear, explaining its function.
It is likely that the screen will be displaying the Standard and the […]

Popularity: 79%


workbooks and worksheets

In MS Excel, Workbooks contains Worksheets. This allows you to store and organise data relating to a particular subject within the various Worksheets of a single Workbook.
To see an example click here
Discuss in forum (0) Popularity: 84%

Popularity: 84%


worksheet options

By default, one Workbook contains three Worksheets, which are referee to as Sheet 1, Sheet 2 and Sheet 3 and are shown at the bottom of the screen as sheet tabs:

The active sheet (i.e. the sheet on which you are currently working) is shown with a white tab and its name appears in bold text, […]

Popularity: 76%


creating a new workbook

To create a new Workbook, EITHER click on the File menu then New. Select the Workbook option from the New dialogue box then click on OK, OR
Click on the New icon on the standard toolbar  To find out more click here
Discuss in forum (0) Popularity: 76%

Popularity: 76%


saving workbooks

To save a workbook, EITHER click on the File menu then Save, OR
Click on the Save icon on the standard toolbar
When the Workbook is saved initially, the Save As dialogue box will be displayed. Enter a suitable filename in the File name box, change to a different folder if necessary then click on the […]

Popularity: 76%


closing workbooks

To close a Workbook, EITHER click on the File menu then Close, OR
Click on the Close Window button on the top right of the screen (the top cross Excel itself plus any files that are still open):

To find out more click here
Discuss in forum (0) Popularity: 75%

Popularity: 75%


opening workbooks

To open a Workbook, EITHER click on the File menu then Open. Select the file fro the Open dialogue box then click on the Open button, OR
Click on the…read more
Discuss in forum (0) Popularity: 71%

Popularity: 71%