Microsoft Excel is an electronic worksheet program with which you can create charts, graphs, and worksheets, for financial and other data. After you enter your financial data, you can analyse it for forecasts and generate numerous what-if scenarios.
(1) How to use the Mouse to click :
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.
(2) How to start or launch Excel 2000 :
Point and click (Select) <Start>, <Programs>, <Microsoft Office>, <Microsoft Excel>
and click (Select)
<Microsoft Excel> icon to start quickly.
(3) Basic Editing Skills :
proper typing skills -
proper correcting skills -
proper inserting and typeover skills -
(4) Menu Commands and Toolbars :
(5) Short-cut Menu:
(6) Internet Explorer Interface :
Menu, Point and click <View><Toolbars> : click Web
(7) Working with documents - Open Document, Templates and Wizards :
(8) Moving within Worksheets in Workbook : Sheet Tabs.
(9) Basic Mouse Skills for the Range of Cell Selection : Cost Analysis
and click (select)
a Table : collection of data organised in rows and columns for
the entry of Numerical Values, Character Text, or Formulae .
The cell is the value at a Table's row and column intersection.
Moving around a Table :
(11) Formating Data or Character or Tables on the workbook - add style and flair to your presentation.. remember to type your data or text or table before formatting.
(12) Copying, Cutting, Pasting:
(13) Perform Calculation : At the Formular Bar, Click <+> button.
(14) Excel Chart using chart wizard - a step-by-step set of dialog box that guide you through the creation of a chart.
Step 1 :
Step 2 :
Step 3 :
Step 4 :
(15) Printer subsystem is the Windows printer interface for direct printed output for all your Windows programs. You can decide on the print sheet order.
Menu, Point and click <File>, <Page Setup> : click Sheet
and click <File>:
(16) Print Preview for previewing any Windows 2000 document using the WYSIWYG (pronounced wizzy-wig) as an acronym for What You See Is What You Get, the concept that your screen shows your output as it will look on paper : Set Margins, Print Area and Print Order, Headers and Footers, etc.
and click <File>:
Are you ready for MOUS Certification?
Edwin Koh : Congratulations in Your New Knowledge and Skills.
|Edwin Koh Infotech Learning|