Guides on how to become professional using Microsoft Excel
Recently, I posted on how to become a professional
using Microsoft word and shortcut keys. Have taken time to work on another
package.Before I go into what spreadsheet is all about some people heard of it
but don’t really know how it works and what is used for. Example of spreadsheet
are many the most recognised one is Microsoft Excel we have other spreadsheet
like supercalc, lotus 123, Quartro,MultiPlan,Visicalc. Well am going to talk
on MicrosoftExcel.Most people are familiar with spreadsheet but they don’t know
how it been used.
Spreadsheet are used in various places like Schools,
Banks, Governments offices.etc
·
In primary school it is used for calling
the students attendance i.e (Class Register)
·
In offices its used as Payroll
·
In tertiary institutions it is use in
preparation of results.
·
Its also use for budget analysis.
·
Tax calculation and projection
·
Income statement and
·
Balance Sheet.
Haven’t know
its uses now lets look at how it works.
Spreadsheet is a table of rows columns of ruled on
paper where data are entered to be manipulated processed. Spreadsheet packages
are also called spreadsheet application. In
spreadsheet each data are entered in a cell. You can define the type
of information is in each cell and how
different cell depends on one another.the relationship between cell are called
formulas. And the names of the cell
Spreadsheet features and and Terminologies
1 WorkSheet: is a set of role columns and cells in
which data are store and manipulate
|
A
|
B
|
C
|
D
|
E
|
|
1
|
|
|
|
|
|
2
|
|
|
|
|
|
3
|
|
|
|
|
2. Rows:the rows represent horizontal lines or
rulings and are labels from the top to the bottom of the worksheet with numbers
i.e 1234 etc, about 18 rows are display
on the screen at a time in ms excel.
3. Columns the columns are the vertical rulings and
are label in across the worksheet in letter A-Z
4 Cell it is the smallest or basic unit of a table
or worksheet. A cell is interception of column or for example a place mark with
* below
|
|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
|
1
|
|
|
|
|
|
|
|
|
|
J1
|
|
2
|
|
|
C2
|
|
*
|
|
|
|
|
|
|
3
|
|
|
|
|
|
F3
|
|
|
|
|
|
4
|
|
B4
|
|
|
|
|
|
|
|
|
|
5
|
|
|
|
|
|
|
|
|
|
|
5.Cell reference
A cell reference identifies the location of a cell that is given an
identity to a cell for example a cell where column B and row 4 intercepts.
6. Range it
refers to a group of cell all touching one another to form a rectangle.for
example Ms Excel will show highlighted cell as C5:E4 as shown .
A range could also be on a single row or on single column
range 1is B2:B4and range 2 is E4:G4
Cell Pointer it is the highlighted rectangle
displayed in a cell A1 when spreadsheet is opened move the cell pointer to the
cell in which you want to enter data, make calculation or begin a command.
Cell
To load existing Microsoft Excel
Click on start
Click All programs
Locate Microsoft office folder and click it
Locate Microsoft Excel 2007 and click it .
Simple way to open excel is by double clicking on
the shortcut icon on the desktop.
Closing ms excel
Click the close button at the top right part of the
title bar.
Click office button and then click exit button.
Some useful function keys in Ms.Excel
Keys Functions
F1 Display the help menu
F2
Activates cell and formula Bar
F4 Repeats the last action perform
F5 Go
to a specified cell
F7 Checks spelling in current sheet
F7 Checks spelling in current sheet
COMMENTS