CREATING AND

USING
SPREADSHEET

By depute Inspector
Mustefa Hebo
Mail filenber2009@gmail.com
THIS MODULE INCLUDES THE FOLLOWING LEARNING GUIDES

c es
o ur
res e t s
ar e he
re p d s
p r e a
n d s p
c t a l e ar ts
e le m p c h
S s i l e t s
33 : a t e m p e e
G r e si s h
•L 4 : C u c e
e a d
G 3 r o d p r
•L P e s
3 5 : l i z
G i n a
•L 6 : F
G 3
•L
 Ergonomic requirement may include but
not limited to:
  avoiding radiation from
computer screens
  chair height, seat and back
adjustment
  document holder
  footrest
  keyboard and mouse position
ADJUSTING WORK PLACE TO SUIT
  lighting
WORK PLACE ERGONOMIC
REQUIREMENT   noise minimization
  posture
  screen position
  workstation height and layout
 o ffi c ially
g o n o mics' n ame
' E r e
e n a me 1 9 5 0. Th m the
th r o
in ved f
IS IC e p t e d d e ri omos
acc w a s rk ; N
o n omics o n - wo w ord
T E rg E r g h e
M ords : e of t
s ies
A
H NO
Gr e
- na
e
t
k
u r
w
al law. F
b
i
e
rs
t
t
ra
u
c e d to
b
a
y
s e r
Prof.
ly can es written
W O ? a ct u a l
arti c l
ski i n P o lan d

R G of f
Wojcin
o u
e
r
c h
r
J
o
astrz ly
u gh
e b o w
b e
E o mics in
c
1 a8 5 7 .
y of
d
p e op le
t.
Ergon a s t h e s t u
v i ro n m e n
e d e n st
defin wo rk i n g
r go n o m i
h e i r a n e t)
in t e c ifi c a l l y ,
c on o m i s
s p e to
More e d like w o r k
o u n c s th e
(pr o n
m o d i fi e
h e r w ay
i g n s or t th e ot te
des o rk e r , n o
el i m i n a
h e w l i s t o ury
fit t Th e g o a
o f i n j
u n d . r i s k
aro rt a nd
s c o m fo
d i .
Goal

• The goal of ergonomics is to make work more comfortable

and to improve both health and productivity. Many
ergonomic problems can be fixed by rearranging, adjusting
or modifying existing furniture and tools, so don't be in too
much of a rush to go out and purchase the next great
ergonomic "THING".
 o f
a y y
w
5S IN a t i c
c e s te,
b
m a s
ERGONOMICS? s y s t e
o rk p l w a
a n d
a w f
i s in g , o
5S aniz g fl o w b e r
. I t
n
org inati g n u m
s s i b l e
e s :
l
elim rovin the re po incip er
m p n g h e p r o r d
i u ci s w 5s
e d s e i n
r c e s fi v e e t )
ro s S i s o
p l i e i r i ) ( s e
p
a t (p s e n e
S h i
S o r )
i ton
(se
BACK CARE AND CHAIR SETUP

• We know that sitting for long periods can have

negative consequences for our health, and
that regular breaks along with standing for part
of your day can help to prevent and relieve
aches and pains when they occur. However,
often sitting cannot be avoided, at which times it
is important to ensure that your office chair is
set-up to provide optimal support for your back.

• To set-up your office chair correctly, follow these

simple steps:
• Adjusting the Chair Height • Other Chair Adjustments
• Sit up straight on your chair, roll your shoulders up • Adjust the back in or out, up or down, or if the seat has a
and back and allow your arms to hang loosely by sliding seat mechanism slide it in or
your sides. Make a right angle at your elbow and
keep your wrist straight. • out so that you can feel the lumbar support in the lower
curve of your back. It should be both
• The underside of your hand should now sit
naturally on top of your keyboard. If it is not then • firm and comfortable, while providing support for the
natural curve of your back. Ensure the
• adjust your chair up or down to enable your hand
to rest on the keyboard. (do not adjust your • angle of base of the seat is either neutral or tilting slightly
forward so as to make sure the
• arms or hands!)
• front of the chair is not pushing into your thighs.And
remember, no chair, no matter how well it’s set-up can
prevent you from slouching
• unless you proactively sit with correct posture. The key is
to be mindful of your posture at all
• times, making sure that your spine remains lifted, with
your shoulders rounded back.
STEPS FOR SETTING UP YOUR WORKSPACE

• Adjust the chair height so that your elbows are at desktop level (roll your
shoulders back and relax them first). Sit fully back into your chair, adjust the
seat back for good lower back support, use a lumbar roll if the back of the chair
does not support your lower back. If your chair seat has a tilt feature, set it so
that you are comfortably supported.

• If your feet don't comfortably reach the floor or there is pressure on the backs
of your legs, use a footrest. Locate your monitor so the top third of the viewing
area is at or below eye level. Use monitor stand if required. As long as you can
clearly view the screen contents

• there is no specific distance that you need to be from the monitor.

SEGUE BLUE
 USING ENERGY AND RESOURCE CONSERVATION TECHNIQUES
WE ALL NEED TO CARE FOR OUR ENVIRONMENT, AND
THERE ARE MANY WAYS YOU CAN HELP, INCLUDING THE
a n fi n d pens FOLLOWING.
c
d esk so you on’t have to
r ga n i ze your easily and d aving paper
O ionery lacements. S
an d st a t
ep i v e w ays to Switch off lights in storerooms, stationery rooms
r effec t
etting and toilets when they’re not in use
keep g of the most
is one e resources.
conserv
o u s h o u l d:
Y
 reduce paper use by using
• Make sure your computer switches to standby
alternative ways to when not in use.
communicate (such as email)
 reuse paper (such as by turning
it over and printing on the other
side)
Make sure the photocopier switches to standby when not in use.
• recycle used paper so it can be
• Re label cardboard files and folders so you can use them again
turned into new products
HERE ARE 10 TIPS THAT DON’T TAKE MUCH EFFORT TO FOLLOW BUT CAN MAKE A
BIG DIFFERENCE
 Only print a document when it’s really necessary.
 Only use good quality paper when it’s really necessary.
 Reuse paper that has only been used once (unless it contains confidential information).
 Put paper that can be used again ready for use by the printer, or save it for rough notes.
 Print on recycled paper whenever possible.
 Where possible, print two pages side by side.
 Use a circulation slip and send a single document around to everyone, rather than printing one copy each.
 Use the Print Preview function to avoid making printing mistakes.
 Carefully proofread your work, correcting it and only reprinting the page(s) necessary.
 Put waste paper in a separate bin or bag so that it can be collected by a recycling company
 IDENTIFYING AND
CLARIFYING SPREAD
SHEET TASK
REQUIREMENTS

Microsoft Office Excel

 WHAT IS EXCEL?
Excel definition: a software program created by
Microsoft that uses spreadsheets to organize numbers and data
with formulas and functions. Excel analysis is ubiquitous around
the world and used by businesses of all sizes to perform financial
analysis.
Excel is a spreadsheet program from Microsoft and a
component of its Office product group for business
applications. Microsoft Excel enables users to format,
organize and calculate data in a spreadsheet.
 Insert Image

WORKSHEET AND WORKBOOK

SPECIFICATIONS
Feature AND LIMITS
Maximum limit
• Total number of rows and columns on a
worksheet
• 1,048,576 rows
• 16,384 columns
• Column width 255 characters
• Row height 409 points
• Page breaks 1,026 horizontal and vertical
COMMON EXCEL USE CASES
Excel is most commonly used in business settings. For example, it is used in
business analysis, human resource management, operations management
and performance reporting. Excel uses a large collection of cells formatted to
organize and manipulate data and solve mathematical functions. Users can
arrange data in the spreadsheet using graphing tools, pivot tables and
formulas. The spreadsheet application also has a macro programming
language called Visual Basic for Applications.
ORGANIZATIONS USE MICROSOFT EXCEL FOR THE FOLLOWING

 collection and verification of business  strategic analysis;

data;  accounting and budgeting;
 business analysis;  administrative and managerial
 data entry and storage; management;
 data analysis;  account management;

 performance reporting;  project management; and

 office administration.
EXCEL TERMINOLOGY AND
COMPONENTS
Excel has its own terminology for its components, which new users may not immediately find understandable.
Some of these terms and components include the following:
 Cell. A user enters data into a cell, which is the intersection of a column and row.
 Cell reference. This is the set of coordinates where a cell is located. Rows are horizontal and numbered
whereas columns are vertical and assigned a letter.
 Active cell. This is the currently selected cell, outlined by a green box.
 Workbook. This is an Excel file that contains one or more worksheets.
 Worksheet. These are the different documents nested within a Workbook.
 Worksheet tab. These are the tabs at the bottom left of the spreadsheet.
 Column and row headings. These are the numbered and lettered cells located just outside of the
columns and rows. Selecting a header highlights the entire row or column.
CONT...
 Formula. Formulas are mathematical equations, cell references or functions
that can be placed inside a cell to produce a value. Formulas must start with
an equal "=" sign.
 Formula bar. This is the long input bar that is used to enter values or
formulas in cells. It is located at the top of the worksheet, next to the "fx" label.
 Address bar. This bar located to the left of the formula bar shows the number
and letter coordinates of an active cell.
 Filter. These are rules a user can employ to select what rows in a worksheet
to display. This option is located on the top right of the home bar under "Sort &
Filter." An auto filter option can be selected to show rows that match specific
values.