[PDF]Excel 2007
Please sign in to contact this author
rpappsvo as anfla sAAnviKa
lac; un£p6£U£i n opoXoyia; Mnv avnouxdT£,
n£piypd(pouu£ m ndvra noXu anXd.
EuKoflo amv Kaiavonan
lacpric, o6nyi£c;, (3nua npoc; (3nua, oaq
6i£ukoXu vow va udGere.
EiKOvoYpacpn|j£vo
Aev oac; Xqi£ nooc; 0a to Kdvere, oac; 6dxvouu£
nooc 0a to Kdveie.
Eyxpcopo
To (3i(3Xio dvai £yxpoouo yia va 6i£UKoXuv£i
tov avayvobom Kai to nan.
To (3i(3Xio Excel 2007 napouoidc^i to v£0 n£pi(3dXXov epyaoiac; tou
Office 2007. Em ouvotaa oac; 6dxv£i nooc; va 6nuioupy£iT£ i
5a
aXXd n£pia
yia npoom cpopd U£ Ta unoXoyioriKd cpuXXa.
michael price
YuoXoyioiiKd (pvXXa & ygaq>h\iaia
Mia nana oro £oooT£pii
npoaap(Joo|j£vn TaJjivopnon
EKtuncoon flivaKa
T7r.z
;;;"; l ";; M l :.!; , " ,e Kzr.
.V *
T '
ZutifSourln ^
3 I r:=r
• ; — ~i
:tz^ ,E
=2™ ■
|V *_ .
»■'■■ ■» •j:.'j ,,|, ' a * i '" —
' ) '»','j'I,' S™
^~
5 I =j
r^-" a =
.,„■>„»,,.- „flo,»„» K
s
■-- — -
— - ;- -
Rpoooxn A
™r
,
. -
n.,f,.ioi.i(l|*-. in.ulio
£;;-::r
y _. l".iii...r..ii Tim- 72 " =±L-> „ ,1
r-r :■■ i
I
Ta eiKovi6ia auid oac;
6i£Ui
'Onou ouvavrdT£ £va and auTd Ta £ii
Ouun0dT£ KdTi n va npocpuXaxT£iT£ and mOavouc; kiv6uvouc;.
Oi anXec; e^nynoeic; Kai oi npaiaiKec;
xpnoeic; ac;i£puv xeipoKpompa.
Computer Active
AvcMpopd oe win in oeigd
AflAAEAAHNIKA
EYKOAOITHN KATANOHIH
ElKONOrPAOHMENO
AITAIKH EKAOZH
EXCEL 2007
by Michael Price
Copyright © 2010 by Computer Step
Reprinted under an exclusive licence agreement from the
Publisher: In Easy Steps, 5c Southfield Road, Southam,
Warwickshire, CV47 OFB United Kingdom
fflffl
steps
Notice of Liability
Every effort has been made to ensure that this book contains accurate and current information.
However, Computer Step and the author shall not be liable for any loss or damage suffered
by readers as a result of any information contained herein.
Trademarks
Microsoft® and Windows® are registered trademarks of Microsoft Corporation.
All other trademarks are acknowledged as belonging to their respective companies.
EAAHNIKH EKAOZH
Iuvioviouos: Adunpos Tafldvns
Mstacppaon: Wordshop (Mapicp lupsririn)
EmuErteia: Kcbatas ZacpsipaKonouflos
KaArlitExviKh EniusrlEia / npooapuoyh: Bap(3dpa Bsvtoupn, AwsfliKh TodyKapn
Screenshots: Avatar.gr
AiopOcoon keiuevcov: navaYicbtns rianaoriicbtns
© Copyright 2010, EKAOIEII E0NOI A.E.
ZnuEicoua EuOuvns
'Exei Kata|3fln6£[ koOe npoondBsia yia va 6iaocpafliot£[ on auto to piprlio nepiexei aKpifteis koi EnkaipES nflnpocpopiss.
Qotooo, n Computer Step koi o auYYpacpsas 6sv cpspouv suOuvn yia onoia6hnot£ ancbrlEia
h Cnuia unoatouv oi avayvcbatEs cos anotEfteaua oiov6hnot£ nflnpocpopicbv nou nepiexovtai oto f3i|3fl(o.
EunopiKd Ihuata
Ta ahuata Microsoft® koi Windows® efvai EunopiKd ahuata KataxoopnOsvta tns Microsoft Corporation.
Dria ta drlrla EunopiKd ahuata avhKouv otous vouiuous 6iKaiouxous.
AnavopsuEtai Katd tov N. 2121/1993 koi Katd tn Ais6vh Xuu|3aon tns Bspvns (nou exei KupcoGsf us tov N. 100/1975) n
ava6nuoa(£uan koi ysviKd n avanapayooYh -ofliKh, uspiKh, nspirlnntiKh- n Katd napdcppaan h 6iaaK£uh an66oon tou
nepiexouEvou tou |3i|3rliou us onoio6hnot£ ueao koi tpono, unxaviKo nflEKtpoviKo, cpcototuniKo, nxoypdcpnons h drlrlo, dvsu
nponyoupEvns syYpacpns d6£ias tou £K66tn.
nspi£x6|j£va
EiaaycoYn
H Evvoia tou unofioYioiiKou cpufifiou
Microsoft Excel
Microsoft Office 2007
Ti veo undpxsi oto Excel 2007
AnaithoEis ouoth|jatos
H Kop6£rla Office 2007
EKKivnon Excel u.£ XP
EKKfvnon Excel \je Vista
Evspyonofnon
AvacpopES Evtoflcbv Excel
8
10
11
12
13
14
15
16
17
19
rvcopijjia [is to Excel
To napdOupo Excel
Arpoupyfa BipAfou spyaofas
npooOhKn Ae6o|J£vcov oe Ouririo Epyaofas
A6u.non tou Ouririou Epyaofas
Xuu.nfihpojan Ksfiicbv
OrloKrihpcoon tou Ouririou Epyaofas
Mopcponofnan Ksiuivou
Mopcpss Api0u.dbv
EKtunooan tou cpufiriou spyaofas
Eioaycoyh, Avtiypacph Kai EniKofifinon
BohOsia tou Excel
9£U.atiKh BonQsia
Mopcpss Apxsfou Excel
22
24
25
26
28
29
30
31
32
34
35
36
37
AiaxEipian Ae6o|J£vcov
Xphan Ynapxovtoov Ae6o|J£vcov
Eioaycoyh A£6ou.evojv
nspihynan oto Oufifio Epyaofas
Kufiion |js tov Tpoxo tou llovtiKiou
nspihynan u.s Xuv6uaa|Jous nfihKtpcov
Ta£;iv6u.non rpau.u.cbv
Eupsan KataxcopfoECOV
nfinpocpopfES Offitpou
Katapynon Ainfiotunoov KataxcopfoECOV
OpOoypacpiKos sriEyxos
ItaOsponofnon EniKscparli6cov Kai EtiKEtcbv
AnoKpuipn XtnAcbv h rpa|j|jcbv
flpootaofa Ouririou Epyaofas
40
42
44
46
47
48
49
50
52
53
54
55
56
Tunoi kqi ZuvapthoEis
Mopcpss Api6(jcbv
MopCpES K£l|J£VOU
Ixeiikes Avacpopss
An6Aut£S Avacpopss
Avacpopss Ov6|jatos
TEfiEOtES
AKoftouOfa YnoAoYiG|Jcbv
luvapthoEis
AutoJoin A0poion
Icpafi|jQta Tunoov
ripoo0hKn Ixoflfoov
58
60
61
62
63
64
65
66
68
69
70
nivciKES iou Excel
ArpoupYia nfvaKa oio Excel
EnE^Epyaofa nfvaKa
Itufi nfvaKa
XuvoAa riivdKcov
Kata|j£tpnan Mova6iKcbv KataxcopfaECOV
Ao|jn|j£V£s Avacpopss
YnorloYi(6|j£V£S Xthftes
EiaaYcoyn rpa(j|jcbv
npoaap|Joa|j£vn Ta^ivopnan
EKiuncoan nfvaKa
luvoipn nfvaKa
M£tatponh nfvaKa a£ n£pioxh
72
74
75
76
77
78
79
80
82
83
84
86
EuvapihoEis yia npoxcopn|j£vous
Bi|3rlio9hKn ouvaptha£cov
AoyiK£s Iuvaptha£is
Iuvaptha£is AvaCntnons koi Avacpopds
Oikovoijikes Iuvaptha£is
Iuvaptha£is H(j£po|jnvfas koi Dpas
Iuvaptha£is K£i|j£vou
Iuvaptho£is Ma6n|jatiKcbv koi TpiY00vo|j£tpfas
Tuxafoi Api6|Jof
n£piaaot£p£s Iuvaptha£is: IxaiioiiKES
n£piaaot£p£s Iuvaptha£is: MnxavofioYfas
np6a6£ia Excel
'EfiEyxos Tunou
89
90
92
94
96
98
100
101
102
103
104
'Erteyxos Excel
'EfiEyxos Tun gov
npootaofa Tun gov
'EfiEyxos yia Zcparl(jaia
Avifypacpa aocpaflEias
AutoJoin Ano0hK£uon koi AutoJoin AvdKtnon
AioKontss EKKfvnons
AnpioupYia Iuvio|j£uons
BaaiKEs Xu|j(3oufl£s Kop6£fias
Xphon BaoiKdbvXu|j|3ouAcbv
Efiaxiotonofnon Kop6£fias
rpa|j|jh Epyafisicov rphyopns npoo|3aons
MiKph rpapph Epyafisicov
EKiuncoon (DuAflcov Epyaofas
106
108
109
111
112
113
114
115
116
118
119
120
121
rpcKphnaia
AniJioupyia rpacph|jatos
ripo£nifi£YM£vos Tunos rpacph|jatos
ArlfiaYn Aidta^ns rpacph|jatos
Yn6|jvn|ja koi riivoKas As6o|j£vcov
AfifiaYn Tunou rpacph|jatos
rpdcpn|ja niia
rpacpn|ja niia 3-A
rpacpn|ja Ithfin 3-A
Koivh Xphon AE&ouivcov
rpacpn|ja rpa|j(jcbv
rpacpn|ja Meioxojv
Mikioi tunoi
EKiuncoon fpacpn|jatcov
124
126
127
128
129
130
132
133
134
135
136
137
138
MaKpoEvioflss aio Excel
MOKpOEVtoflES
AnpioupYia MaKpoEvtoficbv
KataYpacph MaKpoEvtoAhs
EcpappoYh MaKpoEvtorihs
npo|3orlh MaKpoEvtoAhs
AnpioupYia nivaKa
EnE^EpYaofa MaKpoEvtorlhs
Xphon MoKposvtofihs
Arpoupyici MaKpoEvtorlcbv |je tn VBA
npoo0hKn MaKpoEvtoflcbv otn rpa|j|jh EpYarisicov
Evtonio|j6s IcpafiiJdtcov oe MaKposvtorlES
149
150
152
154
npoiuna kqi Zsvapia
npotuna
npotuna oto Aia6(Ktuo
ri£pioo6t£poi nopoi yia to Excel
Avdfiuon rii0avothtcov
ZuvoniiKss AvacpopES
AvaCntnon Xtoxou
Bsrltiotonoinan
Ourlrlo EpYCiofas'EpYOOV
Enffiuon
156
158
160
162
164
166
167
168
169
EUV6£0|J0I KQI EUV6£0£IS
Iuv6£on oe Biprlia Epyaofas
AnpioupYia E&DtepiKcbv Avacpopcbv
Iturl Avacpopcbv
AfifiaYss oto Bi|3rlio npoEflEuons
EcpapiJoyn Evnu.£pcbo£0ov
AnEvspYonofnon Epcbtnons
To Excel oio Word
An|jooi£uon cos PDF
AvtarirlaYh Ae6o|J£vcov otov lato
EYKatdotaon kch Xphon Tiu.cbv Meioxcov
YnorioYioths No|jio|jatiKhs lootpas
172
174
176
177
178
179
180
182
183
184
186
Eupstnpio 187
EioaYcoyn
To KecpdXaw avid
napovoid&iTKbqio
vnoXoyioiiKO (pvXXo, TO
nAeKipoviKO avcioioixo
io)v /3z/3Afa)v XoyioiiKhc;,
e&XixQriKe ow Excel,
afyonoiwiac; nc; Xenovgyiec;
lov ovv8e8qi£vov
ovoihuaioc; Microsoft
Office kcli xa vnooinpiKiiKd
8 H svvoia iou unofloYiaiiKou cpuflflou
10 Microsoft Excel
11 Microsoft Office 2007
12 Ti veo unapxEi aio Excel 2007
13 Anaitnasis auaih|jaios
14 H Kop6£fla Office 2007
15 EKKfvnon Excel \xe XP
16 EKKivnan Excel \\e Vista
17 EvEpYonofnon
19 Avacpopss Evioflcbv Excel
ovoinnam rcov Windows
(Vista miXP)
>■
3
>-
D
D
Mnv ^ExvatE
Ta ftoyiaiiKa cpurlrla npon-
youviai xpoviKa tcov uno
ftoyioiobv koi icov unoflo-
YiaicbvxEipos koi xpnoipo-
noiouviai yia KupiorlEKtiKa
£Katovta6£Sxp6via.
H svvoia
iou unofloYioiiKOu cpuflflou
Ta unoXoyioriKd cpuXXa U£ m uopcpn XoyioriKoov (3i(3Xioov xpnoiuonoiouvrai
£600 i
Snuioupyia npounoXoyiouoov Kai oikovouikoov ekGeoeoov. Kd0£ ypauun avn ~
npoooonEUE £va SiacpopETiKO avriKduEvo i
uia npopXaJm yia 3 0% nEpiGoopio KEpSouc; i
'Opio% 30
AvaiUTU^n^ iO
np6phEi|ir| KEpSwv
lavouapioi;
Oeppouapioc,
Mapxioc,
ArcpiXiQ^
Mdioq
Ko
6.000
6.600
7.260
7.936
8.785
nw^n ff£l< ;
7.300
S.530
9.433
10.332
11.420
KEp5o<;
1.800
1.980
2.173
2.396
2.635
IuvoAiko KEpSot;
1.800
3. 780
5.353
3.354
10.939
Tuxov aXXavEc; ora (3aoiKd vouuEpa oriuaivE nooc; oXec; 01 tiuec; £np£n£ va unoXo-
yiorouv £avd i
Mnv ^ExvatE
H npaxn Ecpappoyh uno-
ftoyioiiKOu cpurlrlou sivai to
VisiCalc (opatos unortoyi-
oihs)insVisiCorp. Epcpavi-
atriKE nflhOos aviayoovioii-
Kcbv npoypa|j|jaiCjOv, Q AAa
o npcbtos nyEins tns ayopas
htavio Lotus 1 23, koi tcopa
to Microsoft Excel.
'Opio% 20
Avanru^n% 60
np6p\E«|)l] KEpfiwV
lavouapio<; (DEppouctpio*; Mapxio<;
ArcpiAio<; Maio<;
Kooto<; EnTtopEunaT«v
6.000 9.600 15.360
24.576 39.322
naAna£i<;
7.200 11.520 18.432
29.491 47.136
KEp6o<;
1.200 1.920 3.072
4.915 7.864
IuvoXiko KEp6o<;
1.200 3.120 6.192
11.107 IS. 972
Ha mv Kaiaxoopion uiac; Tpimc; aXXaync;, ue 1 0% nEpiGoopio KEpSouc; Kai
200% avdmu^n yia napdSEiyua, 0a EnpEnE va yivouv veoi unoXoyiouoi. Kai
Kd0£ cpopd, unnpx£ n niOavomia va yiva Kdnoioc; Xd0oc; unoXoyiouoc; n va
undp^a uia XdGoc; Kaiaxoopion.
Me mv EXajon tou npooooniKou unoXoyiorn, uia vm npoo£yyion £yiv£ Ecpnan.
AvaniuxGnKav EcpapuoyEc; yia m PEXiiooon mc; XEiioupyiac; tou Xoyiotikou
cpuXXou, aXXd Ta KOUTid (yvooord ooc; K£Xid) nou oxnudTic^av tic; ypauuEc; Kai tic;
ottiXec; unopouoav va anoGnxEuouv keiuevo, apiGuouc; n Kdnoio Tuno unoXo-
yiouou (3aoi(6u£vo ora n£pi£xou£va toov dXXoov keXioov. H oijm tou Xoyiotikou
cpuXXou EUOiac^E i6ia, KaGooc; Eucpavicpvrav Ta anoTEXEouaia Kai oxi oi 16101
01 Tunoi. Diav ouooc; Ta n£pi£xou£va evoc; keXiou dXXa^av oro unoXoyioriKO
cpuXXo, 6Xa Ta K£Xid 01 tiuec; toov onoioov E^apTiovrav ano auTO to keXi unoXo-
yicpvrav ek veou auTouaia.
...ouvsxeia
Aum n TeXajiaia npoo£yyion ecpepe uia Tepdaiia PeXiicoon mc; napayooyiKOTn-
Tac; via Spaompiomrcx; onooc; 01 npopXdJfac;. Ito napaKdioo napd6£iyua puG-
uic£T£ to apxiKO unoXoyioriKO cpuXXo u£ m xpnon uaGnuauKoov Tunoov, avri
va unoXoyi<£T£ tic; u£uovoou£V£c; npic; toov keXioov. To unoXoyioriKO oac; cpuXXo
unopd va n£pi£xa uia oapd nuoov kqi uaGnuauKoov Tunoov, via napdSayua:
/rT^'H "? T f- - Bq : J 'loL.xIsx - Microsoft Excel _ n X
" v — * KwTpLKrj Eiootyuvn Aiorro^ri o^.iSac. Tunoi Ae5oh^o Avh8ew priori npopoArj W - a
Al w £ 'Opio°o ?f
ABC Dk
1
'Op io% |30
2
Avanru^n % 10
3
4
favouapio*; (Deppouapiot;
5
K6
6
naAriffEic; =C5*(100+$B$1)/1Q0 =D5*(1004-SBS1)/100
7
KEpSoi; =C6-C5 =D6-D5
■5
IuvoAiko KEp6o<; =C7 =CS+D7
9
10
«
Bromo IIHOHI 100% ^-) m ft^H
Qorooo, auTO nou aneiKovi^erai KavoviKd dvai 01 npayuanKic; xipec; tic; onofec;
unoXoyicpuv 01 Tunoi (taoa tou n£pi£xou£vou toov dXXoov keXioov:
'Eh'
y 4 „ p-
Bij3 >■. lo 1. xl s x - M i c io s oft E xc el _ n X
&)
K^TpiKri Eiaoyuvn
Aioro^n (TEAiSac Tunoi AeSopeuoi Ava6£w priori npopoAri @ - O X
|
Al
Jt | 'OplQ %
A 1 . 1
C D E F G H 1 J
i fa
pio % 1 30
AvajtTuf,ir| ?! 10 | I
np6pAEi|iq KEpfiuv
lctvouapio<; tfJEppouctpio^ Mapxioq AnpiAitx; Maioc.
K6(TTO<;EnKOpEU|.i 6.000 6.600 7.260 7.986 S.7S5
_nc«*ncTEi(; 7.S00 3.580 9.43S 10.3S2 11.420
KEpfioc. 1.S00 1.9S0 2.17S 2.396 2.635
ZuvoAiko KEpSo<; 1.S00 3.780 5.358 8.354 10.989
Uhmbi
'Onoie GeXere va deiie to anoT£X£oua toov aXXayoov, n.x. 5iacpop£riK£c; uuic; yia
nepiGoopio Kai avdnru^n, unopdT£ va aXXd£;£T£ amd Ta oroixda i
Tunoov.
Oi 6uvaTOTnT£(; toov apapuoyoov toov unoXoyioriKoov cpuXXoov dtouv e^eXixGd
Kai n xpnon toov unoXoyioriKoov cpuXXoov n£piXau(3dv£i noXXd n£pioooT£pa
ano tov apxn<6 oikovouiko npoypauuanouo Kai £i
6£U£V£c; ue uaGnuaTiKouc; Tunouc;, yia napd6£iyua unoXoyiouo (3aGuoXoyiac;
£^£Tdo£oov, u£rd(ppaon napauauKoov 6£6ou£voov n napai
£(papuoy£(; unoXoyioriKoov cpuXXoov cpaivaai nooc; unoornpic^ouv ox£56v 6X£c;
tic; anaimo£ic; nou unopd va £X£T£.
Mnv ^exvaiE
To ou|j|3orlo = uno6£iKvu£i
aio Excel on auio nou oko-
AouOei £ivai |ja9n|jaiiK6s
lunos kqi npsriEi va unorlo-
Yiotei.
Mnv ^EXvdiE
npoaisBriKav 0|ja6£s
npoKa9opio|j£vcjov ouvap-
ihOEOOV kqi unooinpiKiiKES
flsiioupYiss yia mv £YYP Q( P^
IJiKpcov npoYpa|J|JQ lCj0V
h |jaKpo£viorl(jbv yia mv
£n£c;£pYaoia icov 6e6o|J£-
vcov. n£paii£pco£c;£rlic;£is
nEpiflapPavavypacphijaia,
EIKOVES KQI hXQ.
>■
3
>-
D
D
Microsoft Excel
Mnv ^Exvdte
To Microsoft Multiplan, o
npoyovostou Excel, ntav
£va npoYpappa MS-DOS.
Ynhpxav snions £k66o£is
tou Excel tns Apple Mac,
^£Kivcbvias |j£to Excel 1 .0.
Mnv ^£xvat£
ApxiKa to npoYpappa
ava(p£p6tav |j£ to nflhp£s
ovopa Microsoft Excel, ko-
9cbs to ovopa Excel avf)K£
0£ £va oiKovopiKO AoYiopi-
k6. Ihp£pa opoos auto to
£pnopiKO ohpa avhK£i otn
Microsoft, onot£ o 6iaxoopi-
opos 6£V£ivai anapaitntos.
To VisiCalc Kai to Lotus 123 ntav npoypduuaTa MS-DOS, nou unomvro orn
6iaouv6£on Ypauunc; £vroXoov tou MS-DOS, to Microsoft Excel ouooc; avanru-
x0nK£ Y ia ia Windows. 'Htav to npooTO npoYpauua unoXoYioriKoov cpuXXoov to
onoio napdxe orouc; xpnotec; eXeyxo toov onuKoov ntuxoov tou unoXoYioriKou
cpuXXou (Ypauuatooeipec;, i6iomT£c; xapaianpoov Kai qicpdvion KeXioov). Ei-
orryaYe tov aiavunoXoYiouo e^unvoov KeXioov, onou uovo ta K£Xid ta onoia
e^apTcoviai ano to Kzki nou tpononoioutav £vnu£poovoTav (ta nponyoupxva
npoYpduuata unoXoYioriKoov cpuXXoov unoXoYi^av ek v£ou ta ndvia 6X£c; tic;
cpopa;, n nepiuevav tnv aoaYooYn Kdnoiac; ouYK£i
Oi ueuenena £i<;66o£ic; tou Excel n£piXau(3dvovrav orn oouita apapuoYoov tou
Microsoft Office, n onoia nepidxe npoYpduuata onooc; to Microsoft Word kcu
to Microsoft PowerPoint.
Oi £k66o£1c; tou Excel Yia Ta Microsoft Windows Kai to Office n£piXau(3dvouv
tic; ei,hq:
1987
Excel 2.0
Windows
1990
Excel 3.0
Windows
1992
Excel 4.0
Windows
1993
Excel 5.0
Windows
1995
Excel 7.0
Office 95
1997
Excel 8.0
Office 97
1999
Excel 9.0
Office 2000
2001
Excel 10.0
Office XP
2003
Excel 11.0
Office 2003
2007
Excel 12.0
Office 2007
Oi v£OT£p£(; £k66o£k; tou Excel napdtouv noXXex; (3£Xuooo£ic; oto n£pi(3dXXov
£pYaoia<; xpnorn Kai £vooouaToovouv ouvSdjqc; U£ to Microsoft Office Kai
dXX£c; £cpapuoY£<;. H (3don tou npoYpduuaToc; ouooc; napapiva n iSia. E^ai
Kai ornX£c; i
tic; t£xvik£c; Kai ouoTdoac; tou (3i(3Xiou 0a ioxuouv oe onoia6nnoT£ d<8oon tou
Excel xpnoiuonoidT£, n ai<6ua Kai oe n£pinTooon nou xpnoiuonoi£iT£ to uno-
Xoyiotiko cpuXXo Kdnoiac; dXXnc; oapdc; npoiovroov, uoXovon Ta oroixda toov
o6nYioov ioooc; xpeiaarei va npenei va npooapuoorouv.
Microsoft Office 2007
To Microsoft Office 2007 dvai lunua tou 2007 Microsoft Office System, to
>>>