Excel 2000 Module 1
Introduction
- Mouse
Clicks, Typing on the Keyboard, Editing Skills, Desktop Windows
(1)
Use
the Mouse to click :
(2)
Short-cut
Menu:
- 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> (overtype)
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.
(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 :
- 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.
-
- To
save a custom template, <Lock/Save Sheet>, <Lock And
Save Template>.
-
-
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 :
- Menu
with
corresponding toolbars icons
Point and click <View><Toolbars>
:
click Standard, Formatting
- 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.
Click <File>
<Close>
Click
<File>
<Exit>
Edwin
Koh : We
completed on the New
Knowledge and Skills in
Excel
2000 Module 1.
|