Aaaaeaiea
*oi iiaeii neacaoue i nia?aiaiiuo i?ia?aiiao ia?aaioee
yeaeo?iiiuo oaaeeoe? Naaiaeiy yoi n?aaenoaa, iicaieythuea ia oieueei
auiieiyoue au/eneaiey, ii e oi?aaeyoue nieneaie e nicaeaaaoue
aeeaa?aiiu. Anee aea aiai?eoue ia EXCEL, eioi?ay yaeyaony iaeiie ec
iaeaieaa ecaanoiuo i?ia?aii ia?aaioee yeaeo?iiiuo oaaeeoe, oi aac
i?aoaaee/aiey iiaeii ooaa?aeaeaoue, /oi aa aiciiaeiinoe i?aeoe/anee
iaen/a?iaaiu. Ee/ii y n/eoath, /oi oaeea i?ia?aiiu ia naaiaeiyoiee
aeaiue i?aaenoaaeytho niaie iaeei ec iaeaieaa iiuiuo e aeaeeo
eino?oiaioia, nicaeaiiuo aeey eiiiuethoa?a.
EXCEL
Aiciiaeiinoe EXCEL i/aiue auniee. Ia?aaioea oaenoa ,
oi?aaeaiea aacaie aeaiiuo – i?ia?aiia ianoieueei iiuia , /oi ai iiiaeo
neo/ayo i?aainoiaeeo niaoeeaeece?iaaiiua i?ia?aiiu – ?aaeaeoi?u eee
i?ia?aiiu aac aeaiiuo. Oaeia iiiaiia?acea ooieoeee iiaeao iiia/aeo
caiooaoue , iaaeaee canoaaeoue i?eiaiyoue eo ia i?aeoeea. Ii ii ia?a
i?eia?aoaiey iiuoa ia/eiaaoue ii aeinoieinoao oeaieoue oi , /oi a?aieoe
aiciiaeiinoae EXCEL oyaeaei aeinoe/ue.
Ca anth enoi?eth oaaee/iuo ?an/aoia n i?eiaiaieai
ia?niiaeueiuo eiiiuethoa?ia o?aaiaaiey iieueciaaoaeae e iiaeiaiui
i?ia?aiiai nouanoaaiii eciaieeenue. A ia/aea iniiaiie aeoeaio a oaeie
i?ia?aiia, eae, iai?eia? , Vi s i C a l c, noaaeeny ia n/aoiua
ooieoeee. Naaiaeiy, iieiaeaiea ae?oaia. Ia?yaeo n eiaeaia?iuie e
aooaaeoa?neeie ?an/aoaie i?aaiecaoeey e a?aoe/aneia ecia?aaeaiea aeaiiuo
i?eia?aoatho ana aic?anoathuaa cia/aiea. E?iia oiai, iiiaiia?acea
ooieoeee, i?aaeeaaaaiia oaeie ?an/aoiie e a?aoe/aneie i?ia?aiiie, ia
aeieaeii ineiaeiyoue ?aaioo iieueciaaoaey. I?ia?aiiu aeey Windows
nicaeatho aeey yoiai eaeaaeueiua i?aaeiinueee.
A iineaaeiaa a?aiy iiiaea eae ?ac ia?aoee ia eniieueciaaiea
Windows a ea/anoaa naiae iieueciaaoaeueneie n?aaeu. Eae neaaenoaea,
iiiaea oe?iu, nicaeathuea i?ia?aiiiia iaania/aiea, ia/aee i?aaeeaaaoue
aieueoia eiee/anoai i?ia?aii aeey Windows.
NAIAeIUA OAAEEOeU
?ac?aaio/eee i?ia?aiiiiai iaania/aiey oe?iu Microsoft iacaaee
naiaeiie oaaeeoeae iiaia n?aaenoai ia?aaioee aeaiiuo, eioi?ia iie a
ia?aua ioaeaee ia noae iieueciaaoaeae a iyoie aa?nee i?ia?aiiu. A
iineaaeothueo aa?neyo Excel e?oa aiciiaeiinoae eniieueciaaiey naiaeiuo
oaaeeoe ?anoe?ai. Iniiaiia aieiaiea auei oaeaeaii iiauoaieth nei?inoe
ia?aaioee aeaiiuo a oaaeeoeao.
Naiaeiua oaaeeoeu – yoi oaaeeoeu, a eioi?uo aeaiiua
a?oiie?othony ii ?acee/iui e?eoa?eyi, /oi iicaieyao nyeiiiieoue neeu e
a?aiy, iaiaoiaeeiua aeey caaeaiey oi?ioe e ooieoeee, aiaeece?othueo
aeaiiua. I?e/eia oaeie yeiiiiee ninoieo a oii, /oi iiaeoeue naiaeiuo
oaaeeoe ?aniieaaaao ano?iaiiuie ooieoeeyie aeey iniiaiuo aeaeia
au/eneaiee e ioeaiee aeaiiuo.
Naiaeiay oaaeeoea yaeyaony niaoeeaeueiui oeiii oaaeeoeu,
eioi?ay noiie?oao eioi?iaoeeth ec eiie?aoiuo iieae nienea eee aacu
aeaiiuo. I?e nicaeaiee naiaeiie oaaeeoeu n iiiiuueth ianoa?a au iiaeaoa
caaeaoue ioaeiua iiey, i?aaiecaoeeth oaaeeoeu ( aa iaeao ) e oei
auiieiyaiuo au/eneaiee. Iinea iino?iaiey oaaeeoeu iiaeii eciaieoue aa
?aniieiaeaiea aeey i?iniio?a aeaiiuo iiae ae?oaei oaeii c?aiey. Eiaiii
aiciiaeiinoue eciaiaiey i?eaioaoeee oaaeeoeu, iai?eia? o?ainiiie?iaaiea
caaieiaeia noieaoeia a caaieiaee no?ie e iaiai?io, aeaea naiaeiie
oaaeeoea aa iacaaiea e aeaeaao aa iiuiui aiaeeoe/aneei eino?oiaioii.
Naiaeiay oaaeeoea – yoi oae aea aua iaeei eino?oiaio
ia?aaioee aieueoeo nieneia ( aac aeaiiuo ). Iineieueeo a yoii neo/aa
n?aco iiaeaiaeyony eoiae, auiieiyaony ni?oe?iaea e oeeueo?aoeey nieneia,
oi naiaeiay oaaeeoea yaeyaony aieaa iiuiui eino?oiaioii ia?aaioee
aeaiiuo, eioi?ue a EXCEL iacuaaaony ianoa? naiaeiuo oaaeeoe.
Ia?aae iino?iaieai naiaeiie oaaeeoeu ia iniiaa nienea
neaaeoao oa?aoue ec iaai i?iiaaeooi/iua eoiae e iaeiaeaiiua oeeueo?u.
Naiaeiua oaaeeoeu naie iaania/eaatho iiaeaaaeaiea eoiaia e oeeueo?aoeeth
aeaiiuo, ii iino?ieoue naiaeioth oaaeeoeo ii nieneo n oaea eiathueieny
i?iiaaeooi/iuie eoiaaie iaaiciiaeii.
Nicaeaiea naiaeiie oaaeeoeu
I?e nicaeaiee naiaeiie oaaeeoeu iiaeii eniieueciaaoue
iaeei ec /aou?ao oeiia enoi/ieeia aeaiiuo:
nienie Excel;
aiaoiee enoi/iee aeaiiuo, aeinooiiue /a?ac Microsoft Query;
ianeieueei aeeaiaciiia eiinieeaeaoeee ( ioaeaeueiuo nieneia Excel );
ae?oaoth naiaeioth oaaeeoeo.
Caione ianoa?a naiaeiuo oaaeeoe
*oiau i?enooieoue e nicaeaieth naiaeiie oaaeeoeu, auaa?eoa a
iaith Aeaiiua eiiaiaeo Naiaeiay oaaeeoea. Excel caionoeo ianoa? naiaeiuo
oaaeeoe , eioi?ue aoaeao nii?iaiaeaeaoue ian a i?ioeanna nicaeaiey
oaaeeoeu , aeeth/athuai a naay neaaeothuea oaae:
Caaeaiea oeia enoi/ieea aeaiiuo.
Oeacaiea ianoiiaoiaeaeaiey enoiaeiuo aeaiiuo eee iieo/aiea eo ec
aiaoiaai enoi/ieea n iiiiuueth Microsoft Query.
Caaeaiea iaeaoa oaaeeoeu e auai? eoiaiaie ooieoeee.
Oeacaiea ianoa aeey ?aciauaiey oaaeeoeu.
Oaa 1 : caaeaiea oeia enoi/ieea aeaiiuo
I?e onoaiiaea ia?aeeth/aoaey Ai aiaoiai enoi/ieea aeaiiuo
ia?aiai ieia aeeaeiaa ianoa?a naiaeiuo oaaeeoe iiyaeony ecia?aaeaiea YAI
, ia?aaeathuae aeaiiua ia oa?ieiae.
Oaa 2 : oeacaiea ianoiiaoiaeaeaiey enoiaeiuo aeaiiuo
Iinea caaeaiey oeia enoi/ieea aeaiiuo ioaeii iaaeaoue eiiieo
Aeaeaa. Ianoa? naiaeiuo oaaeeoe ioe?iao naia aoi?ia ieii aeeaeiaa ,
i?aaeeaaathuaa oeacaoue ianoi , aaea iaoiaeyony enoiaeiua aeaiiua. Anee
enoi/ieeii aeaiiuo yaeyaony nienie Excel e ia?aae auai?ii eiiaiaeu
Naiaeiay oaaeeoea auaeaeaia oieueei iaeia y/aeea a yoii nienea , oi
ianoa? naiaeiuo oaaeeoe i?aaeeueii caiieieo yoi ieii aeeaeiaa. Anee
enoiaeiue nienie iaoiaeeony a iaioe?uoie eieaa Excel , ioaeii iaaeaoue
eiiieo Iaci? a yoii ieia aeeaeiaa. Iinea iaoiaeaeaiey ioaeiiai oaeea
iaaei aaanoe eiy eee nnueeo ia aeeaiacii , aaea iaoiaeeony nienie.
Oaa 3 : caaeaiea iaeaoa oaaeeoeu
Iinea caaeaiey enoiaeiuo aeaiiuo ioaeii iaaeaoue eiiieo
Aeaeaa , /oiau ia?aeoe a ieii aeeaeiaa.
A yoii ieia aeeaeiaa iu iiaeai noi?ie?iaaoue iaeao ( no?oeoo?o )
naiaeiie oaaeeoeu e oeacaoue , eaeay eioi?iaoeey aeieaeia ioia?aaeaoueny
a oaea oaaeeoeu. Oi/iaa aiai?y , ?a/ue eaeao oieueei i ia/aeueiii iaeaoa
naiaeiie oaaeeoeu , iineieueeo iinea nicaeaiey oaaeeoeu aa iiaeii
?ai?aaieciaaoue a ethaia a?aiy.
A oeaio?a yoiai ieia iaoiaeeony aeeaa?aiia iaeaoa , ia eioi?ie iieacaiu
o?e ine oaaeeoeu ( no?ie , noieaoeia e no?aieoe ) e iaeanoue aeaiiuo. A
i?aaie /anoe ieia aeeaeiaa ioia?aaeathony eiiiee aeey eaaeaeiai iiey
enoi/ieea aeaiiuo. *oiau caaeaoue no?oeoo?o oaaeeoeu , iaiaoiaeeii
i?inoi ia?aoaueoue yoe eiiiee a ?acee/iua iaeanoe aeeaa?aiiu iaeaoa.
Anee ioaeii oaeaeeoue iiea ec naiaeiie oaaeeoeu , neaaeoao ia?aoaueoue
aai eiiieo ca i?aaeaeu yoie aeeaa?aiiu.
Ii oiie/aieth ianoa? naiaeiuo oaaeeoe i?eiaiyao ooieoeeth Noiia
e /eneiaui cia/aieyi a iaeanoe aeaiiuo e eniieuecoao ooieoeeth Eie-ai
cia/aiee aeey ia/eneiauo cia/aiee. *oiau eniieueciaaoue ae?oaoth
eoiaiaoth ooieoeeth , iai?eia? N?aaeiaa eee Iaeneioi , iaaei aeaaaeaeu
uaeeiooue ia caaieiaea iiey iinea aai ia?aoaneeaaiey a iaeanoue aeaiiuo
e caoai a ieia aeeaeiaa Au/eneaiea iiey naiaeiie oaaeeoeu aua?aoue
iaiaoiaeeioth ooieoeeth. Iiaeii eniieueciaaoue neaaeothuea ooieoeee :
NOII ( ) – noiia ;
N*AO ( ) – eiee/anoai
cia/aiee ;
N?CIA* ( ) – n?aaeiaa ;
IAEN ( ) – iaeneioi
IEI ( ) – ieieioi ;
I?IECAAAe ( ) – i?iecaaaeaiea;
NOAIAeIOEEII ( ) – ianiauaiiia ioeeiiaiea;
NOAIAeIOEEIII ( ) – niauaiiia ioeeiiaiea;
AeENI ( ) – ianiauaiiay
aeenia?ney;
AeENI? ( ) – niauaiiay
aeenia?ney.
Oaa 4 : oeacaiea ianoa aeey ?aciauaiey oaaeeoeu
A ieia aeeaeiaa , oeaaeai ianoi , aaea aoaeao ?aniieaaaoueny
naiaeiay oaaeeoea.
*oiau iiianoeoue oaaeeoeo ia iiaii ?aai/ai eenoa , onoaiiaei
ia?aeeth/aoaeue Iiaue eeno. A i?ioeaiii neo/aa onoaiiaei ia?aeeth/aoaeue
Nouanoaothuee eeno e aaaaeai eiy aeeaiaciia ia nnueeo.
Iinea iaaeaoey eiiiee Aioiai Excel ii/oe aac i?iiaaeeaiey nicaeaao
naiaeioth oaaeeoeo. Anee oaaeeoea iniiaaia ia aiaoieo aeaiiuo , Excel
nia/aea auiieieo cai?in , a caoai iino?ieo naiaeioth oaaeeoeo.
Eiaaea auaeaeaiea iaoiaeeony a i?aaeaeao naiaeiie oaaeeoeu , oi ii
oiie/aieth Excel auaiaeeo ia ye?ai iaiaeue eino?oiaioia Naiaeiua
oaaeeoeu. Anee iu ia aeaeei yoie iaiaee eino?oiaioia , a iaith Na?aen
auae?aai eiiaiaeo Iano?ieea e caoai onoaiaaeeaaai oeaaeie Naiaeiua
oaaeeoeu.
Excel oaeaea iicaieyao iai ainiieueciaaoueny iaeioi?uie
niaoeeaeece?iaaiiuie n?aaenoaaie eioi?ua iaoiaeyony ia iaiaee
eino?oiaioia naiaeiie oaaeeoeu.
Naiaeiay aaaeiiinoue ca?ieaou ca iieoaiaeea
?ai?aaiecaoeey naiaeiie oaaeeoeu
*oiau ?ai?aaieciaaoue naiaeioth oaaeeoeo , iaiaoiaeeii i?inoi
ia?aoaueoue iaeei eee ianeieueei caaieiaeia iieae. Iai?eia? , /oiau
ia?aianoeoue iiea n ine noieaoeia ia inue no?ie , aeinoaoi/ii
ia?aoaueoue aai caaieiaie ec iaeanoe noieaoeia a iaeanoue no?ie. E?iia
o?ainii?oe?iaaiey no?ie e noieaoeia iiaeii oaeaea eciaiyoue ii?yaeie
ioia?aaeaiey iieae ii ine noieaoeia eee no?ie naiaeiie oaaeeoeu.
?aciauaiea iieae ia ine no?aieoe
*oiau aieaa aieiaoaeueii i?iniio?aoue eioi?iaoeeth a iiea
naiaeiie oaaeeoeu , aai iiaeii ia?aianoeoue ia inue no?aieoe. Aeey yoiai
i?inoi ia?aoaueoue caaieiaie iiey auoa eaaiai aa?oiaai oaea naiaeiie
oaaeeoeu. I?e ia?aoaneeaaiee caaieiaea oeacaoaeue i?eiao aeae o?ao
iaaieueoeo no?aie/ae. Eiaaea aoaeao aeaeii eciaiaiea oeacaoaey , iaaei
ioionoeoue eiiieo iuoe , e caaieiaie iiey aoaeao iiiauai a iaeanoue
no?aieoe.
Oeeee ii yeaiaioai ia ine no?aieoe
Eiaaea auaiaeeony iiea ia ine no?ie eee noieaoeia, oi aeey
i?iniio?a anao yeaiaioia yoiai iiey aeinoaoi/ii i?ie?ooeoue oaaeeoeo. Ii
anee iiea iaoiaeeony ia ine no?aieoe , oi iiaeii oaeaeaoue oieueei iaeei
yeaiaio yoiai iiey. *oiau oaeaeaoue ae?oaie yeaiaio iiey , ioaeii
aua?aoue aai a ?ane?uaathuainy nienea yoiai iiey. Iineaaeiaaoaeueii
auae?ay yeaiaiou a nienea , iiaeii aeaeaoue aeaoia?iua «n?acu» aeaiiuo
aeey niioaaonoaothueo cia/aiee iiey , iiiauaiiiai a iaeanoue no?aieoe.
Auaiae eoiaia aeey iiey no?aieoeu
Aieco eaaeaeiai ?ane?uaathuaainy nienea iiey no?aieoeu
aeaeai yeaiaio ( Ana ). Auai? yoiai yeaiaioa nienea iicaieyao auaanoe ia
ye?ai eoiaiaua cia/aiey aeey eaaeaeiai iiey ia ine no?aieoe.
Ia?aiauaiea yeaiaioia iiey no?aieoeu ia
ioaeaeueiua eenou eieae
Aeaaea anee naiaeiay oaaeeoea niaea?aeeo inue no?aieoe , any
oaaeeoea o?aieony ia iaeiii eenoa eieae. N iiiiuueth eiiiee Ioia?aceoue
no?aieoeu ia iaiaee eino?oiaioia Naiaeiua oaaeeoeu iiaeii nicaeaoue ?yae
naycaiiuo naiaeiuo oaaeeoe , eaaeaeay ec eioi?uo aoaeao ioia?aaeaoue
iaeei yeaiaio iiey no?aieoeu.
Eciaiaiea ?aniieiaeaiey eiiiie iieae
no?aieoe
Iau/ii Excel auaiaeeo eiiiee iieae no?aieoe a iaeiii
noieaoea iaae eaaui aa?oiei oaeii oaaeeoeu. Anee iieae ia ine no?aieoe
aeinoaoi/ii iiiai , iiaeii ?acianoeoue eo eiiiee a ianeieueeeo
noieaoeao. Aeey yoiai iaaei auiieieoue neaaeothuea aeaenoaey:
Auaeaeeoue a naiaeiie oaaeeoea ethaoth y/aeeo.
Aua?aoue eiiaiaeo Ia?aiao?u a iaith Naiaeiay oaaeeoea ia iaiaee
eino?oiaioia Naiaeiua oaaeeoeu.
Eniieuecoy ?ane?uaoeeny nienie Iaeao no?aieoeu e iiea *enei iieae a
noieaoea ieia aeeaeiaa Ia?aiao?u naiaeiie oaaeeoeu caaeaai ioaeiia
?aniieiaeaiea eiiiie.
Iaiiaeaiea naiaeiie oaaeeoeu
Eae oaea ioia/aeinue , naiaeiay oaaeeoea naycaia n enoiaeiuie
aeaiiuie, ii iia ia iaiiaeyaony aaoiiaoe/anee i?e eciaiaiee enoiaeiuo
aeaiiuo. *oiau iaiiaeoue naiaeioth oaaeeoeo , iaaei auaeaeeoue a iae
ethaoth y/aeeo e caoai a iaith Aeaiiua aua?aoue eiiieo Iaiiaeoue aeaiiua
eee iaaeaoue iaeiieiaiioth eiiieo ia iaiaee eino?oiaioia Naiaeiua
oaaeeoeu.
Iaiiaeaiea oaaeeoeu i?e ioe?uoee
oaeea
*oiau Excel aaoiiaoe/anee iaiiaeye naiaeioth oaaeeoeo i?e
eaaeaeii ioe?uoea eieae, a eioi?ie iia iaoiaeeony, auaa?aoa eiiaiaeo
Ia?aiao?u a iaith Naiaeiay oaaeeoea ia iaiaee eino?oiaioia Naiaeiay
oaaeeoea. Caoai a ieia aeeaeiaa Ia?aiao?u naiaeiie oaaeeoeu
onoaiaaeeaaai oeaaeie Iaiiaeoue i?e ioe?uoee.
Anee aeey iieo/aiey aeaiiuo eniieuecoaony cai?in e aiaoiaio enoi/ieeo ,
caieiathuee aeinoaoi/ii iiiai a?aiaie , oi oeaaeie Iaiiaeoue i?e
ioe?uoee eo/oa niyoue.
Iaiiaeaiea naycaiiuo naiaeiuo
oaaeeoe
Anee iaeia naiaeiay oaaeeoea neoaeeo enoi/ieeii aeaiiuo
aeey ae?oaie , oi i?e iaiiaeaiee ethaie ec ieo ia?an/eouaathony iaa
oaaeeoeu.
Iaiiaeaiea naiaeiie oaaeeoeu , naycaiiie n aiaoieie aeaiiuie
Anee naiaeiay oaaeeoea iino?iaia ia iniiaa aiaoiaai
enoi/ieea aeaiiuo , oi Excel iiaeao auiieieoue cai?in e iaio a oiiiaii
?aaeeia, /oi iicaieyao ?aaioaoue n oaaeeoeae ai a?aiy aa iaiiaeaiey.
*oiau aeeth/eoue yoio ?aaeei iaiiaeaiey , ioaeii auaeaeeoue a oaaeeoea
ethaoth y/aeeo e aua?aoue eiiaiaeo Ia?aiao?u a iaith Naiaeiay oaaeeoea
ia iaiaee eino?oiaioia Naiaeiua oaaeeoeu. Caoai a ieia aeeaeiaa
Ia?aiao?u naiaeiie oaaeeoeu onoaiiaeoue oeaaeie Oiiiaue cai?in. A oii
neo/aa , eiaaea a naiaeiie oaaeeoea eniieuecothony iiey no?aieoe ,
iiaeii onoaiiaeoue oaeie ?aaeei auiieiaiey cai?ina , i?e eioi?ii Excel
cai?aoeaaao oieueei aeaiiua , iaiaoiaeeiua aeey oaeouae i?iniao?eaaaiie
no?aieoeu. Yoio ?aaeei i?aaeuyaeyao aieaa ne?iiiua o?aaiaaiey e ?ano?nai
eiiiuethoa?a , iineieueeo i?e auiieiaiee cai?ina ?anoiaeoaony iaiueoa
iia?aoeaiie iaiyoe , /oi iiaeao ieacaoueny iaiaeiaaaeiui i?e ?aaioa n
aieueoie aiaoiae aacie aeaiiuo. E?iia oiai , iiaeii i?aaeii/anoue yoio
?aaeei i?e ?aaeeii ia?aeeth/aiee no?aieoe.
*oiau cai?aoeaaoue aiaoiee enoi/iee aeaiiuo oieueei aeey iaeiie
no?aieoeu , ioaeii aeaaaeaeu uaeeiooue ia eiiiee ethaiai iiey no?aieoeu.
A ieia aeeaeiaa , eioi?ia iiyaeony , neaaeoao iaaeaoue eiiieo Aeaeaa.
Caoai a ieia aeeaeiaa Aeiiieieoaeueiua ia?aiao?u iiey naiaeiie oaaeeoeu
onoaiiaeoue ia?aeeth/aoaeue Iaiiaeyoue aiaoiea aeaiiua i?e auai?a
eaaeaeiai yeaiaioa.
Auaeaeaiea yeaiaioia naiaeiie
oaaeeoeu
I?e ?aaioa ni naiaeiuie oaaeeoeaie a Microsoft Excel 97 iu
iiaeai eniieueciaaoue iiaue ?aaeei auaeaeaiey , eioi?ue iacuaaaony
no?oeoo?iui auaeaeaieai. Anee yoio ?aaeei aeeth/ai , oi i?e auaeaeaiee
yeaiaioia a naiaeiie oaaeeoea Excel aaoiiaoe/anee ?anoe?yao auaeaeaiea ,
aeeth/ay a iaai ana inoaeueiua yecaiiey?u yoiai yeaiaioa.
No?oeoo?iia auaeaeaiea iaeaa/aao n?aaiaiea naycaiiuo yeaiaioia a
naiaeiie oaaeeoea. Ia iaiaa aaaeiui yaeyaony oi , /oi i?e aeeth/aiiii
no?oeoo?iii auaeaeaiee ana oi?iaou , i?eiaiaiiua e auaeaeaiiui y/aeeai ,
nio?aiythony aeaaea iinea iaiiaeaiey eee ?ai?aaiecaoeee naiaeiie
oaaeeoeu.
Oai ia iaiaa Excel iicaieyao ioeeth/aoue yoio ?aaeei , iineieueeo
no?oeoo?iia auaeaeaiea nouanoaaiii ioee/aaony io iau/iiai auaeaeaiey
y/aae a ?aai/eo eenoao.
Aeeth/aiea e aueeth/aiea no?oeoo?iiai auaeaeaiey
*oiau aeeth/eoue eee aueeth/eoue no?oeoo?iia auaeaeaiea ,
auaeaeei ethaoth /anoue naiaeiie oaaeeoeu. Caoai auaa?ai eiiaiaeo
Auaeaeeoue a iaith Naiaeiay oaaeeoea ia iaiaee eino?oiaioia Naiaeiua
oaaeeoeu.
Eiaaea no?oeoo?iia auaeaeaiea aeeth/aii , eiiiea neaaa io eiiaiaeu
?ac?aoeoue auaeaeaiea iaoiaeeony a iaaeaoii ninoiyiee , e o?e aa?oiea
eiiaiaeu yoiai iiae/eiaiiiai iaith noaiiayony aeinooiiuie.
Anee ?aaeei no?oeoo?iiai auaeaeaiey aueeth/ai , oi eiiiea auaeyaeeo ia
iaaeaoie , a o?e ia?aua eiiaiaeu ia aeinooiiu.
Auaeaeaiea oieueei caaieiaeia eee oieueei aeaiiuo
Eiiaiaeu ec iiae/eiaiiiai iaith Auaeaeeoue e
niioaaonoaothuae eiiiee ia iaiaee eino?oiaioia Naiaeiua oaaeeoeu
iicaieytho auaeaeeoue oieueei caaieiaea eee oieueei aeaiiua. Anee au iu
oioaee auaeaeeoue caaieiaee aac niioaaonoaothueo aeaiiuo , oi iaaei auei
au iaaeaoue eiiieo Oieueei caaieiaee. *oiau ainnoaiiaeoue iieiue ?aaeei
auaeaeaiey , iu aeieaeiu iaaeaoue eiiieo Caaieiaee e aeaiiua.
Auaeaeaiea anae naiaeiie oaaeeoeu
*oiau auaeaeeoue naiaeioth oaaeeoeo oeaeeeii ,iaiaoiaeeii
aua?aoue eiiaiaeo Auaeaeeoue a iaith Naiaeiay oaaeeoea ia iaiaee
eino?oiaioia Naiaeiua oaaeeoeu. Caoai a iiae/eiaiiii iaith Auaeaeeoue
aua?aoue eiiaiaeo Oaaeeoea oeaeeeii.
Oi?iaoe?iaaiea naiaeiie oaaeeoeu
Aeey eciaiaiey aiaoiaai aeaea y/aae naiaeiie oaaeeoeu
iiaeii eniieueciaaoue noaiaea?oioth oaoieeo oi?iaoe?iaaiey. Excel
nio?aieo oi?iaou e iinea iaiiaeaiey eee ?ai?aaiecaoeee oaaeeoeu i?e
oneiaee , /oi ia niyo oeaaeie Nio?aieoue oi?iaoe?iaaiea a ieia aeeaeiaa
Ia?aiao?u naiaeiie oaaeeoeu. *oiau i?eiaiaiiua oi?iaou ia oa?yeenue i?e
iaiiaeaiee eee ?ai?aaiecaoeee oaaeeoeu , iaaei auiieieoue neaaeothuea
aeaenoaey:
Auaeaeeoue a naiaeiie oaaeeoea ethaoth y/aeeo.
Aua?aoue eiiaiaeo Ia?aiao?u a iaith Naiaeiay oaaeeoea ia iaiaee
eino?oiaioia Naiaeiua oaaeeoeu.
A ieia aeeaeiaa Ia?aiao?u naiaeiie oaaeeoeu iaiaoiaeeii onoaiiaeoue
oeaaeie Nio?aieoue oi?iaoe?iaaiea.
I?eiaiaiea aaoioi?iaoa e naiaeiie
oaaeeoea
Iau/ii Excel i?eiaiyao e oieueei /oi nicaeaiiui naiaeiui
oaaeeoeai aaoioi?iao , eniieuecoaiue ii oiie/aieth. Ii iiaeii i?eiaieoue
ae?oaie aaoioi?iao. Aeey yoiai auaeaeei ethaoth y/aeeo naiaeiie oaaeeoeu
, a iaith Oi?iao auaa?ai eiiaiaeo Aaoioi?iao e caoai a iiyaeaoainy ieia
aeeaeiaa auaa?ai ioaeiue aaoioi?iao.
Ethaua oi?iaou , i?eiaiaiiua ae?oaeie niiniaaie aei eee iinea
eniieueciaaiey aaoioi?iaoa , eiatho i?aeiouanoaa iaae onoaiiaeaie
aaoioi?iaoa. Iai?eia? , iu iiaeai iooi?iaoe?iaaoue anth oaaeeoeo n
iiiiuueth aaoioi?iaoa e caoai eciaieoue oi?iaou ioaeaeueiuo y/aae. E aei
oao ii? , iiea aeeth/ai ?aaeei no?oeoo?iiai auaeaeaiey , Excel aoaeao
nio?aiyoue iacia/aiiua oi?iaou i?e iaiiaeaiee e ?ai?aaiecaoeee naiaeiie
oaaeeoeu.
*oiau nicaeaoue naiaeioth oaaeeoeo aac aaoioi?iaoe?iaaiey , iaaeiai
eiiieo Ia?aiao?u a /aoaa?oii ieia aeeaeiaa ianoa?a naiaeiuo oaaeeoe e
caoai nieiai oeaaeie Aaoioi?iao.
I?e oaeaeaiee aaoioi?iaoe?iaaiey ec nouanoaothuae oaaeeoeu , auaeaeei a
iae ethaoth y/aeeo , auaa?ai eiiaiaeo Ia?aiao?u a iaith Naiaeiay
oaaeeoea ia iaiaee eino?oiaioia Naiaeiua oaaeeoeu , nieiai oeaaeie
Aaoioi?iao e caoai iaaeiai eiiieo IE.
Iinea yoiai a iaith Naiaeiay oaaeeoea ia iaiaee eino?oiaioia Naiaeiua
oaaeeoeu auaa?ai eiiaiaeo Auaeaeeoue e caoai – Oaaeeoea oeaeeeii. E ia
eiiaoe , a iaith Oi?iao auaa?ai eiiaiaeo Noeeue e i?eiaiei noeeue
Iau/iue.
I?eiaiaiea /eneiauo oi?iaoia
Anee aeeth/ai ?aaeei no?oeoo?iiai auaeaeaiey , oi iiaeii
eciaiyoue /eneiaie oi?iao y/aae a naiaeiie oaaeeoea , auaeaeyy yoe
y/aeee e eniieuecoy noaiaea?oioth oaoieeo oi?iaoe?iaaiey. *oiau
i?eiaieoue /eneiaie oi?iao n?aco ei anai y/aeeai naiaeiie oaaeeoeu ,
ainiieuecoainy neaaeothuae i?ioeaaeo?ie:
Auaeaeei ethaoth y/aeeo a iaeanoe aeaiiuo oaaeeoeu ( ii oieueei ia
eiiieo iiey e ia caaieiaie yeaiaioa ).
Iaaeiai eiiieo Iiea naiaeiie oaaeeoeu ia iaiaee eino?oiaioia Naiaeiua
oaaeeoeu.
A ieia aeeaeiaa Au/eneaiea iiey naiaeiie oaaeeoeu iaaeiai eiiieo Oi?iao.
Iinea iaaeaoey eiiiee Oi?iao iu iiiaaeai a iau/iia ieii aeeaeiaa aeey
/eneiaiai oi?iaoe?iaaiey , eioi?ia ioe?uaaaony a ioaao ia auai? eiiaiaeu
ss/aeee a iaith Oi?iao.
Ioia?aaeaiea ionouo y/aae a
naiaeiie oaaeeoea
Iau/ii a y/aeeao naiaeiie oaaeeoeu , aeey eioi?uo ionoonoaotho
aeaiiua , ioia?aaeathony ionoua cia/aiey. I?e aeaeaiee iiaeii
ioia?aaeaoue 0 eee iaeioi?ia oaenoiaia cia/aiea a y/aeeao , eioi?ua
ieacuaathony ionouie. Aeey yoiai auiieiei neaaeothuea aeaenoaey:
Auaeaeei a naiaeiie oaaeeoea ethaoth y/aeeo.
Auaa?ai eiiaiaeo Ia?aiao?u a iaith Naiaeiay oaaeeoea ia iaiaee
eino?oiaioia Naiaeiua oaaeeoeu.
A ieia aeeaeiaa Ia?aiao?u naiaeiie oaaeeoeu i?iaa?ei /oiau oeaaeie Aeey
ionouo y/aae ioia?aaeaoue aue onoaiiaeai. Caoai a ninaaeiai iiea aaaaeai
0 eee ae?oaia cia/aiea.
Aeiaaaeaiea e oaeaeaiea iieae
*oiau aeiaaaeoue a naiaeioth oaaeeoeo iiaua iiey eee
oaeaeeoue nouanoaothuea , n ia/aei auaeaeei ethaoth y/aeeo a oaaeeoea.
Caoai
a iaith Aeaiiua eiiaiaeo Naiaeiay oaaeeoea eee iaaeiai eiiieo Ianoa?
naiaeiuo oaaeeoe ia iaiaee eino?oiaioia Naiaeiua oaaeeoeu. Excel
auaaaeao ia ye?ai ieii aeeaeiaa Ianoa? naiaeiuo oaaeeoe – oaa 3 ec 4 , a
eioi?ii caaeaaony ia?aiia/aeueiue iaeao oaaeeoe. *oiau aeiaaaeoue iiaia
iiea , i?inoi ia?aoauei aai eiiieo a ioaeioth iaeanoue aeeaa?aiiu iaeaoa
, a aeey oaeaeaiey iiey ia?aoauei aai eiiieo ca i?aaeaeu aeeaa?aiiu.
Eniieueciaaiea ianeieueeeo iieae
aeaiiuo
Anee a iaeanoue aeaiiuo naiaeiie oaaeeoeu aeiaaaeoue aoi?ia
iiea , oi Excel auaaaeao i?iiaaeooi/iua eoiae aeey eaaeaeiai iiey.
Ia?aeiaiiaaiea iieae e
yeaiaioia
Eniieueciaaiea eiai iieae e yeaiaioia , iacia/aiiuo ianoa?ii
naiaeiuo oaaeeoe iaiaycaoaeueii. Yoe eiaia iiaeii eciaieoue ,
io?aaeaeoe?iaaa caaieiaie iiey eee yeaiaioa a naiaeiie oaaeeoea. I?e
eciaiaiee eiaie yeaiaioa oaeei niiniaii iii eciaieony ai anao
yecaiiey?ao yoiai yeaiaioa , iiyaeythueony a oaaeeoea.
Ni?oe?iaea yeaiaioia
Microsoft Excel i?aaeeaaaao iiaia n?aaenoai , iacaaiiia
aaoini?oe?iaeie , eioi?ia i?aaeinoaaeyao aieueoie eiio?ieue iaae
ni?oe?iaeie aeaiiuo a naiaeiuo oaaeeoeao. Aaoini?oe?iaea iicaieyao
oii?yaei/eoue yeaiaiou iieae ia iniiaa niioaaonoaothueo cia/aiee
aeaiiuo.
Ii oiie/aieth aaoini?oe?iaea aueeth/aia aeey anao iieae naiaeiie
oaaeeoeu , e aeey oii?yaei/eaaiey yeaiaioia iieae iiaeii eniieueciaaoue
i?eau/ioth eiiaiaeo Ni?oe?iaea ec iaith Aeaiiua eee eiiiee Ni?oe?iaea ii
aic?anoaieth e Ni?oe?iaea ii oauaaieth ia noaiaea?oiie iaiaee
eino?oiaioia. Anee aaoini?oe?iaea aeeth/aia, oi aeey yoie oeaee
eniieuecoaony ieii aeeaeiaa naiaeiie oaaeeoeu.
Ni?oe?iaea yeaiaioia iiey n iiiiuueth cia/aiee aeaiiuo
*oiau ioni?oe?iaaoue yeaiaiou iiey n iiiiuueth
niioaaonoaothueo cia/aiee aeaiiuo , iaaei auiieieoue neaaeothuea
aeaenoaey:
Auaeaeeoue ethaie yeaiaio iiey eee eiiieo iiey , eioi?ia iaiaoiaeeii
ioni?oe?iaaoue.
Iaaeaoue eiiieo Iiea naiaeiie oaaeeoeu ia iaiaee eino?oiaioia Naiaeiua
oaaeeoeu ( eee aua?aoue eiiaiaeo Iiea a iaith Naiaeiay oaaeeoea ).
Iaaeaoue eiiieo Aeaeaa.
Yoe oaae i?eaaaeoo a ieii aeeaeiaa Aeiiieieoaeueiua ia?aiao?u iiey
naiaeiie oaaeeoeu.
Ni?oe?iaea yeaiaioia iiey ii
caaieiaeai
Anee aaoini?oe?iaea iiey ioeeth/aia , oi iiaeii eniieueciaaoue
iau/iua eiiaiaeu ni?oe?iaee Excel aei oii?yaei/eaaiey yeaiaioia yoiai
iiey ii eo caaieiaeai.
Ii anee aeey eioa?anothuaai iiey ioeeth/aia aaoini?oe?iaea ,
oi a oaeii neo/aa iaiaoiaeeii ioe?uoue ieii aeeaeiaa Aeiiieieoaeueiua
ia?aiao?u iiey naiaeiie oaaeeoeu aeey yoiai iiey n iiiiuueth i?ioeaaeo?u
, «Ni?oe?iaea yeaiaioia iiey n iiiiuueth cia/aiee aeaiiuo».
Caoai auiieiei iaeio ec i?eaaaeaiiuo ieaea eino?oeoeee:
A naeoeee Ia?aiao?u ni?oe?iaee yoiai ieia aeeaeiaa onoaiiaei
ia?aeeth/aoaeue A?o/ioth. Aeaaaeaeu iaaeiai eiiieo IE , /oiau aa?iooueny
a naiaeioth oaaeeoeo , e ca oai eniieuecoai iau/iua eiiaiaeu ni?oe?iaee
Excel.
A naeoeee Ia?aiao?u ni?oe?iaee onoaiiaei ia?aeeth/aoaeue Ii
aic?anoaieth eee Ii oauaaieth a caaeneiinoe io o?aaoaiiai ii?yaeea
ni?oe?iaee. Caoai a ?ane?uaoainy nienea N iiiiuueth iiey auaa?ai eiy
ni?oe?oaiiai iiey.
Eniieueciaaiea ianoaiaea?oiiai ii?yaeea ni?oe?iaee
Anee ni?oe?iaea ii aic?anoaieth eee ii oauaaieth ia ono?aeaaao
, iiaeii caaeaoue iieueciaaoaeueneee ii?yaeie ni?oe?iaee n iiiiuueth
aeeaaeee Nienee ieia aeeaeiaa Ia?aiao?u. Iieueciaaoaeueneee ii?yaeie
ni?oe?iaee iiaeii caaeaoue n iiiiuueth i?inoie caiaiu caaieiaeia
yeaiaioia iiey.
Eiaaea aianoi iaeiiai caaieiaea yeaiaioa aaiaeeony eiy ae?oaiai
nouanoaothuaai caaieiaea yeaiaioa , oi Excel ?anniao?eaaao yoi aeaenoaea
eae eiiaiaeo ia?anoaiiaee aeaoo caaieiaeia. Ianoaiaea?oiue ii?yaeie
ni?oe?iaee nio?aiyaony i?e iaiiaeaiee e ?ai?aaiecaoeee naiaeiie
oaaeeoeu.
A?oiie?iaea aeaiiuo
Ianoa? naiaeiuo oaaeeoe aaoiiaoe/anee a?oiie?oao yeaiaiou
aioo?aiiaai iiey aeey eaaeaeiai caaieiaea aiaoiaai iiey e , anee
o?aaoaony , nicaeaao i?iiaaeooi/iua eoiae aeey eaaeaeiai yeaiaioa
aioo?aiiaai iiey. Ii eiiaaea oaeiaiaa a?oiie?iaaoue yeaiaiou eiui
niiniaii , iai?eia? , nia?aoue iany/iua yeaiaiou a eaa?oaeueiua a?oiiu
eee iiiaeanoai /enae a aieueoea /eneiaua eaoaai?ee.
Excel i?aaeeaaaao ianeieueei aa?eaioia a?oiie?iaee yeaiaioia.
A?oiie?iaea /eneiauo yeaiaioia
*oiau n?aaieoue /eneiaua yeaiaiou iiey auaeaeei ethaie yeaiaio
iiey e iaaeiai eiiieo A?oiie?iaaoue ia iaiaee eino?oiaioia Naiaeiua
oaaeeoeu.
A ieia aeeaeiaa A?oiie?iaaoue aaaaeai iaiaoiaeeiua cia/aiey a iiey
Ia/aeueiay n , Ii e N oaaii .
A?oiie?iaea yeaiaioia ii a?aiaiiui aeeaiaciiai
*oiau na?oiie?iaaoue yeaiaiou iiey ii a?aiaiiui aeeaiaciiai ,
auaeaeei ethaie yeaiaio a iiea Aeaoa , iaaeiai eiiieo A?oiie?iaaoue ia
iaiaee eino?oiaioia Naiaeiua oaaeeoeu e caiieiei ieii aeeaeiaa.
Excel iaania/eaaao aeinoaoi/ioth aeaeinoue i?e a?oiie?iaea yeaiaioia
iiey aeao. A nienea N oaaii ieia aeeaeiaa A?oiie?iaaiea iiaeii caaeaoue
a?aiaiiie eioa?aae io naeoiaeu aei aiaea. Anee noaiaea?oiuo eioa?aaeia
ia aeinoaoi/ii , iiaeii oeacaoue ethaia eiee/anoai aeiae . E?iia oiai ,
iiaeii nicaeaoue aeaa e aieaa a?oiie?iaie iaeiia?aiaiii , auaeaeea
ianeieueei yeaiaioia a nienea N oaaii .
Eniieueciaaiea iaueo e
i?iiaaeooi/iuo eoiaia
Ii oiie/aieth Excel aaia?e?oao iauea eoiae aeey anao aiaoieo
iieae naiaeiie oaaeeoeu e i?iiaaeooi/iua eoiae aeey anao aioo?aiieo
iieae ca eneeth/aieai naiiai aioo?aiiaai iiey. Iiaeii eae oaeaeeoue
nicaeaaaaiua ii oiie/aieth eoiae , oae e naaia?e?iaaoue i?iiaaeooi/iua
eoiae aeey naiuo aioo?aiieo iieae.
Iauea eoiae
I?e eniieueciaaiee ianeieueeeo iieae aeaiiuo ianoa? naiaeiuo
oaaeeoe aaia?e?oao ioaeaeueiua iauea eoiae aeey eaaeaeiai ec yoeo iieae.
Iauea eoiae anaaaea eniieuecotho oo aea ooieoeeth , /oi e iiea aeaiiuo ,
aeey eioi?uo iie au/eneythony.
Iai?eia? , anee oaaeeoea eniieuecoao ooieoeeth Noii , oi yoa aea
ooieoeey eniieuecoaony e aeey au/eneaiey iaueo eoiaia. Anee au aianoi
ooieoeee Noiia eniieueciaaeanue ooieoeey N?aaeiaa , oi aianoi «iaueo
noii» iu iieo/ei « iauaa n?aaeiaa».
*oiau nicaeaoue naiaeioth oaaeeoeo aac iaueo eoiaia, a ieia aeeaeiaa
Ianoa? naiaeiuo oaaeeoe – oaa 4 ec 4 iaaeiai eiiieo Ia?aiao?u. Caoai
nieiai oeaaeee Iauay noiia ii noieaoeai e /eee Iauay noiia ii no?ieai.
Anee ioaeii oaeaeeoue iauea eoiae ec nouanoaothuae naiaeiie oaaeeoeu ,
auaa?ai eiiaiaeo Ia?aiao?u a iaith Naiaeiay oaaeeoea ia iaiaee
eino?oiaioia Naiaeiua oaaeeoeu. Caoai nieiai oeaaeee Iauay noiia ii
noieaoeai e / eee Iauay noiia ii no?ieai.
I?iiaaeooi/iua eoiae
Ii oiie/aieth Excel nicaeaao i?iiaaeooi/iua eoiae aeey anao
iieae, iiiauaiiuo a iaeanoue noieaoeia e no?ie
naiaeiie oaaeeoeu , ca eneeth/aieai naiuo aioo?aiieo iieae.
Eae e a neo/aa iaueo eoiaia , Excel aaia?e?oao iaeio no?ieo
i?iiaaeooi/iuo eoiaia aeey eaaeaeiai iiey aeaiiuo naiaeiie oaaeeoeu , e
ii oiie/aieth i?iiaaeooi/iua eoiae nicaeathony n iiiiuueth oie aea
ooieoeee , eioi?ay eniieuecoaony aeey au/eneaiey iiey aeaiiuo.
Ii a neo/aa i?iiaaeooi/iuo eoiaia iiaeii eciaieoue eniieuecoaioth ii
oiie/aieth eoiaiaoth ooieoeeth e aeaaea i?eiaieoue ianeieueei eoiaiauo
ooieoeee. Iiaeii oae aea ioiaieoue nicaeaiea i?iiaaeooi/iuo eoiaia aeey
ii?aaeaeaiiuo iieae.
*oiau eciaieoue eniieuecoaioth ii oiie/aieth eoiaiaoth ooieoeeth eee
i?eiaieoue ianeieueei ooieoeee , auiieiei neaaeothuea aeaenoaey:
Aeaaaeaeu uaeeiai ia caaieiaea iiea. Aianoi yoiai iiaeii
auaeaeeoue caaieiaie iiey e
iaaeaoue eiiieo Iiea naiaeiie oaaeeoeu ia iaiaee eino?oiaioia Naiaeiua
oaaeeoeu.
A ieia aeeaeiaa Au/eneaiea iiey naiaeiie oaaeeoeu auaa?ai iaeio eee
ianeieueei ooieoeee e iaaeiai eiiieo IE.
*oiau oaeaeeoue i?iiaaeooi/iua eoiae aeey iiey, i?iaeaeaai
neaaeothuaa:
1. Aeaaaeaeu uaeeiai ia caaieiaea iiea. Oaeaea iiaeii auaeaeeoue
caaieiaie iiea e iaaeaoue eiiieo Iiea naiaeiie oaaeeoeu ia iaiaee
eino?oiaioia Naiaeiua oaaeeoeu.
2. A ieia aeeaeiaa Au/eneaiea iiey naiaeiie oaaeeoeu onoaiiaei
ia?aeeth/aoaeue I?iiaaeooi/iua eoiae a iieiaeaiee Iao e iaaeiai eiiieo
IE.
Ii anee iicaeiaa iu niiaa ?aoei auaanoe a oaaeeoea i?iiaaeooi/iua
eoiae , oi naeaeaai oae:
Aeaaaeaeu uaeeiai ia caaieiaea iiea. E?iia oiai , iiaeii auaeaeeoue
caaieiaie iiea e iaaeaoue eiiieo Iiea naiaeiie oaaeeoeu ia iaiaee
eino?oiaioia Naiaeiua oaaeeoeu.
A ieia aeeaeiaa Au/eneaiea iiey naiaeiie oaaeeoeu onoaiiaei
ia?aeeth/aoaeue I?iiaaeooi/iua eoiae a iieiaeaiea Aaoiiaoe/aneea e
iaaeiai eiiieo IE.
I?iiaaeooi/iua eoiae aeey naiuo
aioo?aiieo iieae
Oioy ii oiie/aieth Excel ia aaia?e?oao i?iiaaeooi/iua eoiae aeey
naiuo aioo?aiieo iieae , iu iiaeai eo nicaeaoue e eniieueciaaoue i?e
yoii ianeieueei eoiaiauo ooieoeee. Yoe eoiae , anee iie eiathony ,
?aciauathony a ieaeiae eee i?aaie /anoe naiaeiie oaaeeoeu
iaiin?aaenoaaiii auoa eee neaaa io iaueo eoiaia.
*oiau aeiaaaeoue i?iiaaeooi/iua eoiae aeey naiiai aioo?aiiaai iiey,
auiieiei neaaeothuea aeaenoaey:
Aeaaaeaeu uaeeiooue ia caaieiaea aioo?aiiaai iiey. Aianoi yoiai iiaeii
auaeaeeoue caaieiaie iiey e iaaeaoue eiiieo Iiea naiaeiie oaaeeoeu ia
iaiaee eino?oiaioia Naiaeiua oaaeeoeu.
A ieia aeeaeiaa Au/eneaiea iiey naiaeiie oaaeeoeu auaa?ai iaeio eee
ianeieueei ooieoeee e iaaeiai eiiieo IE.
Eciaiaiea au/eneaiee a
naiaeiuo oaaeeoeao
E /eneiaui iieyi , iiiauaiiui a iaeanoue aeaiiuo naiaeiie
oaaeeoeu, Excel ii oiie/aieth i?eiaiyao ooieoeeth Noiia , a e ethaui ia
/eneiaui iieyi – Eiee/anoai cia/aiee. Ii iiaeii i?eiaieoue e iiiaea
ae?oaea oi?iu au/eneaiee. E?iia oiai , Microsoft Excel 97 iicaieyao
eniieueciaaoue a naiaeiuo oaaeeoeao au/eneyaiua iiey e yeaiaiou.
Eniieueciaaiea ae?oaeo eoiaiauo
ooieoeee
*oiau ia?aeeth/eoueny ia ae?oaoth eoiaiaoth ooieoeeth ,
auaeaeei ethaoth y/aeeo a iaeanoe aeaiiuo e iaaeiai eiiieo Iiea naiaeiie
oaaeeoeu ia iaiaee eino?oiaioia Naiaeiua oaaeeoeu. Excel auaaaeao ia
ye?ai ieii aeeaeiaa Au/eneaiea iiey naiaeiie oaaeeoeu. Auaa?ai ooieoeeth
, eioi?oth oioei eniieueciaaoue , e iaaeiai eiiieo IE.
I?eiaiaiea ianeieueeeo eoiaiauo
ooieoeee e iaeiiio iieth
E iieth iiaeii i?eiaieoue ethaia eiee/anoai eoiaiauo ooieoeee.
*oiau eniieueciaaoue aeiiieieoaeueiua ooieoeee aeey iiey , eioi?ia oaea
iaoiaeeony a iaeanoe aeaiiuo naiaeiie oaaeeoeu , auaeaeei ethaoth y/aeeo
a iaeanoe aeaiiuo e iaaeiai eiiieo Iiea naiaeiie oaaeeoeu ia iaiaee
eino?oiaioia. Ieacaaoenue a ieia aeeaeiaa Ianoa? naiaeiuo oaaeeoe – oaa
3 ec 4 ia?aoauei a iaeanoue aeaiiuo aeeaa?aiiu iaeaoa eiiieo yoiai aea
iiey aua ?ac , /oiau ?acianoeoue aoi?oth eiieth caaieiaea iiey.
Aeaaaeaeu uaeeioa ia eiiee caaieiaea , caoai a nienea
Iia?aoeey ieia aeeaeiaa Au/eneaiea iiey naiaeiie oaaeeoeu auaa?ai
ioaeioth eoiaiaoth ooieoeeth e iaaeiai eiiieo IE , /oiau aa?iooueny a
naiaeioth oaaeeoeo.
Nnueee ia aeaiiua a naiaeiie
oaaeeoea
Anee oi?ioea ?aai/aai eenoa eniieuecoao aeey iieo/aiey aeaiiuo
ec naiaeiie oaaeeoeu iau/ioth nnueeo ia y/aeeo , oi iia aoaeao i?ae?anii
?aaioaoue , iiea y/aeea inoaaony ia naiai ianoa. Ii iinea ?ai?aaiecaoeee
naiaeiie oaaeeoeu yoa oi?ioea aica?aoeo iaaa?iua aeaiiua. *oiau
ecaaaeaoue yoiai , eniieuecoai a oi?ioea ooieoeeth IIEO*EOUe.AeAIIUA.
NAIAeIIE. OAAEEOeU aeey nicaeaiey nnueee ia aeaiiua naiaeiie oaaeeoeu.
Ooieoeey IIEO*EOUe. AeAIIUA. NAIAeIIE. OAAEEOeU eiaao aeaa a?aoiaioa.
Ia?aue a?aoiaio neoaeeo aeey oeacaiey naiaeiie oaaeeoeu , a aoi?ie
a?aoiaio iienuaaao ecaeaeaaiua aeaiiua. Ia?aue a?aoiaio iiaeao auoue
ethaie y/aeeie naiaeiie oaaeeoeu eee eiaiai aeeaiaciia , iacia/aiiiai
naiaeiie oaaeeoea , a oae aea iaaeienueth , caienaiiie a y/aeea iaae
eaaui aa?oiei oaeii oaaeeoeu. Aoi?ie a?aoiaio , caeeth/aaiue a aeaieiua
eaau/ee , ia?a/eneyao eiaia iieae , ia ia?ana/aiee eioi?uo iaoiaeyony
ecaeaeaaiua aeaiiua. Eiaia iieae ai aoi?ii a?aoiaioa aeieaeiu auoue
?acaeaeaiu i?iaaeii.
Eniieueciaaiea naiaeiie oaaeeoeu aeey eiinieeaeaoeee aeeaiaciiia
N iiiiuueth ianoa?a naiaeiuo oaaeeoe iiaeii eiinieeaee?iaaoue
aeaiiua ec oaaeeoe , ?aniieiaeaiiuo ia ?aciuo ?aai/eo eenoao Excel.
Iai?aiaiiui oneiaeai oaeie eiinieeaeaoeee yaeyaony aaeeiay no?oeoo?a
oaaeeoe. I?e yoii eaaeaeay oaaeeoea aeieaeia niaea?aeaoue aeaiiua
iaeiiai a?aiaiiiai aeeaiaciia. Iai?eia? , aaaeiiinoe ca?ieaou ca
eaaeaeue eaa?oae 1998aiaea noi?ie?iaaiu ia ?aciuo ?aai/eo eenoao Excel n
eiaiaie 1ea -98 , 2ea -98 , 3ea -98 , 4ea -98.
Aeey iino?iaiey naiaeiie aaaeiiinoe ca aanue 1998 aiae ia iaycaoaeueii
ia?aiineoue eo ia iaeei ?aai/ee eeno EXCEL , a iiaeii ainiieueciaaoueny
n?aaenoaii eiinieeaeaoeee ianoa?a naiaeiuo oaaeeoe.
Aeey nicaeaiey eiinieeaee?iaaiiie naiaeiie oaaeeoeu ec ianeieueeeo
?aai/eo eenoia iaaei auiieieoue neaaeothuea aeaenoaey.
Ia?aeoe ia iiaue ?aai/ee eeno e aua?aoue a iaith Aeaiiua eiiaiaeo
Naiaeiay oaaeeoea. Ia ia?aii oaaa ianoa?a naiaeiuo oaaeeoe iaaei
onoaiiaeoue oeaaeie a ianeieueeeo aeeaiaciiao eiinieeaeaoeee.
Ia neaaeothuai oaaa ianoa?a naiaeiuo oaaeeoe neaaeoao inoaaeoue
onoaiiaeaiiui ii oiie/aieth ia?aeeth/aoaeue Nicaeaoue iaeii iiea
no?aieoeu. Aeaeaa iaiaoiaeeii oeacaoue aeeaiacii eaaeaeie
eiinieeaee?oaiie oaaeeoeu , aeeth/ay a iaai caaieiaee noieaoeia e no?ie
, e?iia eoiaiauo no?ie e noieaoeia.
Iinea caaeaiey anao aeeaiaciiia iauaaeeiyaiuo oaaeeoe ii eiiiea Aeaeaa
iiaeii ia?aeoe e o?aoueaio oaao , eioi?ue auaiaeeo ieii oi?ie?iaaiey
iaeaoa eoiaiaiai aeieoiaioa , ca eneeth/aieai oiai , /oi Excel ia
ioia?aaeaao eiaia iieae caaa?oaiey oi?ie?iaaiey naiaeiie oaaeeoeu. Aeey
noiie?iaaiey cia/aiee ec enoiaeiuo aeeaiaciiia aeinoaoi/ii iaaeaoue
eiiieo Aeaeaa , a aeey eniieueciaaiey ae?oaie eoiaiaie ooieoeee neaaeoao
aeaaaeaeu uaeeiooue ii caaieiaeo Noiia ii iieth Cia/aiea , a caoai
aua?aoue o?aaoaioth ooieoeeth.
Ii nieneo ( Ana ) iiaeii iieo/eoue naaaeaiey ii eaaeaeiio eaa?oaeo.
PAGE
PAGE 1
Нашли опечатку? Выделите и нажмите CTRL+Enter
