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 this course in a manual style format click here

Discuss in forum (0)

Popularity: 100%

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, as there are many in-built calculations (or functions) which can be used to speed up the calculation process.

There are four main objects that can be inserted into a spreadsheet, to find out what these are click here

Discuss in forum (0)

Popularity: 83%

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 cell. Each cell has a unique identifier, or reference.

To see a labeled diagram click here

Discuss in forum (0)

Popularity: 85%

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 Formatting Toolbars by default. If not, click on the View menu and select read more

Discuss in forum (0)

Popularity: 83%

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: 83%

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, while the inactive sheets are shown in grey.

The arrows to the left of Sheet 1 enable you to move quickly through the tabs in a Workbook that contains many sheets, i.e. in Workbooks where there are more sheets than can be seen on the screen at the same time.

To find out how to change the number of default worksheets within a workbook click here 

Discuss in forum (0)

Popularity: 79%

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: 78%

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 Save button.

The easiest way to save subsequent changes to your Workbook is to… read more

Discuss in forum (0)

Popularity: 79%

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: 77%

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: 74%