Excel 2000 Module 1





  • Mouse Clicks, Typing on the Keyboard, Editing Skills, Desktop Windows

(1) Use the Mouse to click :


(2) Short-cut Menu:

  1. Mouse right-click (Select Short-cut Menu)


(3) Typing on the Keyboard :

The proper typing skills -
2-hand fingers layout on the Keyboard


(4) Editing Skills : The proper correcting skills - <Backspace> or <Delete>


(5) The proper inserting and typeover skills -

<Insert> (default)
The existing text moves to the right.
<Insert> (
The existing text is deleted and replaced by the next text you type, including spaces.

Majority prefers Insert mode.


(6) Desktop Windows :

The Start button <Start> from which you display the Windows 2000 Start Menu (you can start any Windows program).

The Taskbar is the Windows bar at the bottom of your screen that displays all programs currently running.

  • Starting Excel

(7) How to start or launch Excel 2000 :

Point and click (Select) <Start>, <Programs>,
<Microsoft Excel>


Point and click (Select) <Start>, <Programs>,
<Microsoft Office Tools>
to create a Microsoft Office Shortcut Bar.


Point and click (Select)

<Microsoft Excel> icon to start quickly.

  • Creating Workbooks
    When you start Excel, a
    blankbook, titled Book1, opens by default. A workbook is a file that can contain multiple worksheets.

(8) Working with documents - Templates and Wizards :

  1. Template is a preset document layout, so that you can modify to create a particular kind of document.

    Menu, Point and click <File>: click New

    Excel's Templates :
    Template's toolbar such as invoices, purchase orders at <File>, <New>, <Spreadsheet Solutions>. Customise a template, e.g. add a company logo or address.
  3. To save a custom template, <Lock/Save Sheet>, <Lock And Save Template>.

  6. Wizard is a step-by-step set of dialog box that guide you through the creation of a woksheet.

  • Understanding Microsoft Excel Window Elements
    Many elements in the Excel window are similar to those in windows of other Windows porgrams.

    A ScreenTip appears to explain each button

    Menus display commands that you can click to perform an action in the active window or object. To display a menu, on the menu bar, click the name of the menu.

(9) Menu bar Commands and Toolbars :

  1. Menu with corresponding toolbars icons
    Point and click
    <View><Toolbars> :
    Standard, Formatting
  2. Standard, Formatting Toolbars


(10) Drawing Tools :

Menu, Point and click <View><Toolbars> : click Drawing


(11) Internet Explorer Interface :

Menu, Point and click <View><Toolbars> : click Web



(12) Microsoft Outlook Interface :

Menu, Point and click <View><Toolbars> :
click Reviewing

Send e-mail with attached file

  • Selecting Cells
    Before you can enter data into a worksheet, you must identify the cell in which you want to put the data -
    selecting the cell. You can select a single cell, a row, a column, and groups of adjacent and non-adjacent cells.

  • Selecting a Range of Cells
    A range is normally identified by the references for its first and last cells with a colon between.

(13) Basic Mouse Skills for the Range of Cell Selection :

Point and click (select)
Drag-and-drop (highlight)
Shift+click (select till the end and click)

Ctrl+click (random selection)
Ctrl+A (entire workbook)

  • Closing Workbooks and Closing Excel
    You can
    remove a workbook from the window by closing the workbook or by quitting Excel. Closing the current workbook leaves Excel running, while closing quits the Excel program. If the workbook has not been saved, Excel prompts you to save the file before closing the window.
    <File> <Close>

    Click <File> <Exit>




Edwin Koh : We completed on the New Knowledge and Skills in
Excel 2000 Module 1.






Next Modules

2 : Excel Basic
3 : Formulas & Functions

4 : Formatting Spreadsheet

5 : Charts
6 : Printing
7 : Data Management

8 : Optional (Others)



Return to Excel 2000 Learning



Edwin Koh InfoTech Learning