Starting Microsoft Excel
1. Click
start
2. Point
all programs
3. Point
Microsoft Office; and then click Microsoft Office Excel 2007
4. The following window appeared.
Creating new
work book
1. Click
Office Button
2. Click
new
3.
Save with password 1.
Click tools 2.
Click general option 3.
Enter password on either password to open or password to modify 4.
Click ok
Click create.
Save a work book
1. Click
office button.
2. Click
save as
3. Select
where to save and then type a file name.
Add new sheet
4. Right
click on a sheet tab.
5. Click
new sheet
6. Select
a work sheet and then click ok
Delete a sheet
1. From
the home menu click delete
2. 
Delete sheet
NB: - if sheet contains some data click delete
from the message, and data will be deleted permanent.
Add new column/ row
1. Select
on the row/ column to where you want to add new row/ column (s).
2. From
the home menu click insert
3.
Click on either insert sheet
rows or insert sheet columns
Delete column or row (s)
1. From
the home menu click insert
2. Click
delete
3. Click
either delete row or delete column (s).
Hide/ unhide row/ column
1. From
the home menu click format
2. Point
visibility
3. Click
hide/unhide row or column
Renaming a Worksheet
You can change the name of a sheet to a name of up to 31
characters, including spaces. Once you rename a sheet, the tab for that sheet
contains the new name. To rename;
1.
Double click the tab of the sheet you want
to rename
2.
Type a new name to replace the previous
name
You can also choose the Sheet command from the Format menu,
then click rename, then type the new name to replace the previous name. You can
also use the shortcut i.e. right clicking method.
Moving and copying
sheets
You can rearrange sheets in a workbook by moving them. You
can also move sheets into another workbook of their own.
You can also easily copy sheets within a workbook, or copy
them into another workbook or a new workbook.
Note:
You cannot use Cut, Copy and Paste commands to move or copy sheets
Moving sheets within a
workbook
1. When you select a
sheet tab and then drag it along the row of tabs, a black triangle indicates
where the sheet will be inserted.
2. Release the mouse
button and the sheet moves to the new location.
You can
also move more than one sheet by selecting several sheets and then dragging
them. If the selected sheets are non-adjacent, the moved sheets are inserted
together.
Moving
sheets into another or New workbook
1.
Select the sheet(s) you want to move
2.
Choose move or copy sheet command from the Edit
menu. Select the destination workbook (either “New workbook” or any of the
other listed workbook names) and where you want your sheets placed (“Before
sheet”).
3.
Click OK. The sheet(s) is/are moved to the selected workbooks
Copying
sheets within a workbook
1. Select a sheet, press CTRL
and drag the sheet along the row of tabs. A black triangle indicates where a
copy of the sheet will be inserted.
2. Alternatively, right
click a sheet
3. Click “Move or
copy.”
4. Select before a
certain sheet then you may click “create a copy”.
5. Click ok.
AUTOFILL
FEATURE
The Auto-fill feature is used to create a series of
incremental or fixed values on a worksheet by dragging the fill handle with the
mouse. For example, you can copy the value from one cell into the five cells
below it. In this instance, Auto-fill works in the same way as the Fill
commands on the Edit menu.
For example, if you type Monday and
Tuesday in consecutive columns, and then drag the fill handle to the right,
Microsoft Excel fills Wednesday, Thursday and so on into the selected cells.
You can also use the Auto-fill shortcut menu command to copy formatting
formulas, or cell contents or to perform different types of series extensions.
Window view display mode
1. Click
view
2.
Click a view you want from worksheet
views
Hide/ display gridlines
1. Click
view
2. Click
grid line check box.
Format number
1. Select
a range of cells to be formatted.
2. Click
a format cell
3. Click
number
4. Select
a number format you want
5. To
define your own number click custom
-
“Tshs” 0 or “Tshs” E = Tshs 500
-
[color name] 0 = 500
example [red]#
-
00000 = 000500
-
“Tshs” #,###”/=” = Tshs 5,500 /=
Format
character
1. Select
a range of cell (s)
2.
Click
format cell group
3. Click
font
4. Select
a font type, tyle, sice, color, underline etc.
5.
Click ok.
Inset table border
1. Select
a range of cells
2. Click
border button
3.
Click on the border style you
want
or
Ø
Click format cell
Ø
Click border
Ø
Select line style, color, and then click outline
& inside
Ø
Click ok.
Fill cell
1. Select
a cell (s).
2.
Click
format cell
3. Click
on fill and then select a color or pattern.
4. Click
ok.
Comment
a)
Select a cell
b) Click
on review
c) 
Click comment, and then type
your comment
Edit comment
a) Select
a cell which contain a comment
b)
Click review
c) 
Click edit comment and then
modify your comment
Remove comment
a) Select
a cell which contain a comment
b) Click
review
c) Click
delete comment.
Hide display grid lines
a) Click
view
b) Click
on grid line check box to hide/ unhide
Change
the display view
a) Click
on view
b) Click
either print layout , page break preview or normal
Insert picture/ shape/ clipart
a) Click
on insert
b) Click
one (picture, shape or clipart).
c) Select
the available picture, shape or clip art.
CREATING AND WORKING WITH CHARTS
To Create a chart
1.
Select the cells that contain the data that you
want to appear in the chart.
2.
Click insert
3.
Click on Chart Type you want.
4.
Click the sub type you want.
CHART TYPES
1.
Area chart: An area chart emphasizes the
magnitude of change over time. By displaying the sum of the plotted values, an
area chart also shows the relationship of parts to a whole.
2.
Column chart: A column chart shows data changes
over a period of time or illustrates comparisons among items. Categories are
organized horizontally, values vertically, to emphasize variation over time.
3.
Bar chart: A bar chart illustrates
comparisons among individual items. Categories are organized vertically, values
horizontally, to focus on comparing values and to place less emphasis on time.
4.
Line chart: A line chart shows trends in data
at equal intervals.
5.
Pie chart: A pie chart shows the proportional
size of items that make up a data series to the sum of the items. It always
shows only one data series and is useful when you want to emphasize a
significant element.
6.
Doughnut chart: Like a pie chart, a doughnut chart
shows the relationship of parts to a whole, but it can contain more than one
data series. Each ring of the doughnut chart represents a data series.
7.
XY scatter: An xy (scatter) chart
either shows the relationships among the numeric values in several data series
or plots two groups of numbers as one series of xy coordinates. This
chart shows uneven intervals — or clusters — of data and is commonly
used for scientific data.
When you
arrange your data, place x values in one row or column, and then enter
corresponding y values in the adjacent rows or columns.
8.
Cone, cylinder and pyramid: The cone,
cylinder, and pyramid data markers can lend a dramatic effect to 3-D column and
bar charts.
9.
Radar: In a radar chart, each category
has its own value axis radiating from the center point. Lines connect all the
values in the same series.
10.
A radar chart compares the aggregate values of a
number of data series. In this chart, the data series that covers the most
area, Brand A, represents the brand with the highest vitamin content. Etc.
FORMATTING CHART ELEMENTS
The
following are the chart objects and they can be formatted by changing their
properties and other formats like color, shading, and font faces, etc.
-
Chart title
-
Chart Area
-
Plot Area
-
Value axis and titles
-
Category axis and titles
-
Legend
-
Series Etc.
The formatting can be done by either:
Right clicking the chart object and choosing it format command
from the pop-up or shortcut menu
OR
- Select the chart object
- Use the formatting command from the chart menu
Notes:
·
The Chart menu only after a chart object
has been selected. This menu alternate with the Data menu, which appears
when worksheet cell(s) are/is selected.
·
Formatting can also be done using the Chart
toolbar
CALCULATION OPERATORS IN
FORMULAS
Operators specify the type of calculation that you
want to perform on the elements of a formula. Microsoft Excel includes four
different types of calculation operators: arithmetic, comparison, text, and
reference.
For each calculation you should start with equal sign
(=) then formula, last click green tick sign R or press
enter key.
Arithmetic operators
To perform basic
mathematical operations such as addition, subtraction, or multiplication;
combine numbers; and produce numeric results, use the following arithmetic
operators.
Arithmetic
operator: Meaning: Example:
+
(Plus sign)............................. Addition.................................. 3+3
–
(Minus sign).......................... Subtraction.............................. 3–1
Negation................................. –1
*
(Asterisk)............................. Multiplication........................... 3*3
/
(Forward slash)..................... Division.................................... 3/3
%
(Percent sign)...................... Percent................................... 20%
Comparison
operators
You can
compare two values with the following operators. When two values are compared
by using these operators, the result is a logical value, either TRUE or FALSE.
Comparison operator: Meaning: Example:
= (Equal sign).......................................... Equal
to................................... A1=B1
> (Greater
than sign)............................... Greater
than............................ A1>B1
< (Less than
sign).................................... Less
than................................. A1<B1
>= (Greater
than or equal to sign)............ Greater
than or equal to........... A1>=B1
<= (Less than
or equal to sign)................. Less
than or equal to................ A1<=B1
<>
(Not equal to sign)............................. Not
equal to............................. A1<>B1
Some common function
Ø
Sum = S click sum then select a range of cells
Ø
Average = S click average then select a range of cells
Ø
Max = S click max then select a range of cells
Ø
Min = S click min then select a range of cells
Ø
Mode = click fx
then select mode, click ok then select a range of cells – ok.
Ø
Median = click fx then select median, click ok then select a range of cells – ok.
Ø
Count = click fx then select count, click ok then select a range of cells – ok.
Ø
Range = max-min
Ø
25% of sum = 25% x sum or 25/100 x sum
Logical formula.
1.
Click formulas
2.
Click logical then click if
3.
Define the formula
Ø Remarks
= click
fx then select if, click ok then define the function
if(average>number,”true”, "false”) – ok.
Ø Grade
= click fx then select if, click ok
then define the function
if(average>number,”A”,if(average>number,”B”,if(average>number,”C”,if(average>number,”D”))))
Sort column (s)
a) Click
sort & Filter.
b) Click
either sort A to Z or sort Z to A.
c) Click
custom sort, and then select column & order
d)
Click ok.
Filter data
a) Click
sort/ filter from the home group
b) Click
filter
c) Select
a column to run a filter
i)
On the column list click text filter
ii)
Click custom filter
iii)
Select a filter condition
iv)
Select a data to identify the filter.
v)
Click ok.
Group
column/ row
a) Select
a data from the row or column
b) Click
data menu
c) 
Click group and then click group
again.
d)
Click on row or column
e) Click
ok.
Ungroup column/ row
a)
Click on the grouped data
b) Click
data menu
c)
Click ungroup and then ungroup again
d) Click
on row or column
e)
Click ok.
Repeat title row/ column
a) Click
page layout
b) Click
print title
c) Click
on either Collapse
Dialog button rows to repeat at top or
columns to repeat at left.
d) Select
a row to repeat or column to repeat, and then click on
collapse dialog button.
e) Click
ok.
Protect sheet
1) Click
on review
2) Click
protect sheet
3) Type
your password, and then click ok
4) Retype
the same password again
5)
Click ok
Unprotect a sheet
a)
Click on review
b) Click
unprotect sheet
c) Enter
your password
d) Click
ok.
Protect workbook
a) Click
on review
b) Click
protect work book
c) Click
on protect structure and window
d) Type
your password
e) Click
ok and then retype the same password again.
f)
Click ok.
Remove workbook protection
a) Click
on review
b) Click
protect workbook
c) Click
on protect structure and window
d) Type
your password
e)
Click ok.
Running spelling check/ Thesaurus/
Translate
a) After
typing click review
b) Click
spelling/ Thesaurus or translate
c) Select
the necessary option as required
d) Click
ok.
Page
orientation
a) Click
on page layout
b) Click
on orientation
c) 
Click either portrait or
landscape
Set a margin of page
a) Click
on page layout
b) Click
on margin
c) Select
the best margin.
Insert background
a)
Remove background a) Click
on page layout b) Click
remove background
Click
on page layout
b) Click
background
c) Select
picture
d) Click
insert
Header and footer
a) Click
on insert
b) Click
Header & Footer button
c) Write
your header to the position of the header, and then write to the position of
the footer
d)
After finish you may switch your view to a
normal view (click view→ click normal)
Track Change
a)
First save your workbook.
b) Click
on review and then click track change.
c) Highlight
changes
d) Click
track changes while edited, and then click ok
Remove track changes
a)
Click on review
b) Click
track changes, and then click highlight changes.
c) Click
track changes while edited