Uhlalutyo lwemvakalelo ye-Excel (isampulu yedatha yedatha)

Iinkqubo zezezimali zihlala zidibeneyo - enye into ixhomekeke kwelinye kwaye iguqukele nayo. Ukulandelela ezi nguqu kwaye uqonde ukuba unokulindela ukuba kwikamva linokwenzeka ukusebenzisa imisebenzi ye-Excel kunye neendlela zeTabar.

Ukufumana iziphumo ezininzi usebenzisa itafile yedatha

Izakhono zeetafile zedatha zezinto "zento ukuba" idla ngokuqhutywa kweMicrosoft Excel. Eli ligama lesibini lohlalutyo lovelwano.

Ngokubanzi

Itheyibhile yedatha luhlobo lweeseli zesel, apho unokucombulula iingxaki ezivela ngokutshintsha amaxabiso kwezinye iiseli. Yenziwa xa kufuneka iliso kuguquko kumacandelo efomyula kwaye ufumane uhlaziyo lweziphumo, ngokweenguqu. Fumana indlela yokufaka idatha yedatha kwizifundo, kwaye zeziphi iintlobo.

Ulwazi olusisiseko malunga neetafile zedatha

Zimbini iintlobo zeetafile zedatha, zahlukile kwinani lezinto. Yenza itafile ifuneka ngokuqhelaniswa nenani lamaxabiso afuna ukujongwa ngayo.

Iingcali zezithathu zisebenzisa itafile enenguqu enye xa kukho kuphela eyahlukileyo kwinqanaba elinye okanye elininzi elinokuchaphazela utshintsho kwiziphumo zazo. Umzekelo, ihlala isetyenziswa kwibhanti kunye ne-pl umsebenzi pl. Ifomula yenzelwe ukubala isixa semali ehlawulwa rhoqo kwaye ithathele ingqalelo irhafu yenzala esekwe kwisivumelwano. Ngolu hlobo ukubalwa, izinto eziguquguqukayo zibhalwe kwikholamu enye, kunye neziphumo zokubala kwenye. Umzekelo weplate yedatha enokutshintsha i-1:

Nye

Emva koko, cinga ngemiqondiso kunye neenguqu ezi-2. Bafaka isicelo kwiimeko apho izinto ezimbini zichaphazela utshintsho kulo nasiphi na isalathiso. Izinto ezimbini eziguquguqukayo zinokubakho kwenye itafile ezinxulunyaniswa nemali mboleko-kunye noncedo lwayo onokuthi ulichonga ixesha lokuhlawula ngokufanelekileyo kunye nenani lentlawulo yenyanga. Oku kubalo kufuneka kusebenzise umsebenzi we-PPT. Umzekelo weplate enezinto ezi-2 eziguquguqukayo:

2 Ukwenza itafile yedatha eguquguqukayo enye

Cinga ngendlela yohlalutyo kumzekelo wevenkile encinci, apho iincwadi ezili-100 kuphela ziyafumaneka. Abanye babo banokuthengiswa ngaphezulu ($ 50), abanye baya kuhlawula abathengi abaziindleko ($ 20). Ingeniso iyonke kwintengiso yazo zonke iimpahla zenziwe - umniniyo wagqiba kwelokuba kwixabiso eliphezulu lama-60% eepesenti. Kuyimfuneko ukufumanisa ukuba kuya kukhula njani ingeniso ukuba unyusa ixabiso lomthamo omkhulu weempahla - 70% nangokunjalo.

1. Khetha umgama weseli wasimahla ukusuka emphethweni wephepha kwaye ubhale ifomula kuyo: = iseli yengeniso iyonke. Umzekelo, ukuba umvuzo ubhalwe kwiseli ye-C14 (Uyilo olungacwangciswanga lubonisiwe), kunyanzelekile ukuba ubhale ngolu hlobo: = c14.
2. Sibhala phantsi isixa sempahla kwikholamu ukuya ngasekhohlo kwesi sisele-hayi phantsi kwayo, kubaluleke kakhulu.
3. Sabela ulwa uluhlu lweeseli apho ikholam yentsana ifumaneka khona kwaye ikhonkco kwingeniso iyonke.

3.

1. Sifumana kwi-"yedatha" ye "Uhlalutyo" uza kuthini ukuba "" kwaye icofe kuyo-kwimenyu evula, kufuneka ukhethe "itafile yedatha" ukhetho.

ezine

1. Ifestile encinci iya kuvulwa, apho kufuneka uchaze iseli ngepesenti yeencwadi ezazithengise ngexabiso eliphezulu kwikholamu "yokufaka endaweni yemilinganiselo kwi ...". Eli nyathelo lenziwe ukuphindaphinda ingeniso ngokubanzi, kuthathelwa ingqalelo ipesenti eyandayo.

Ntlanu

Emva kokucinezela iqhosha u "Kulungile" kwifestile apho idatha ifakiwe ukuze iqulunqe itafile, iziphumo zokubala ziya kuvela kwimiqolo.

Ukongeza ifomula kwitheyibhile yedatha eguquguqukayo enye

Ukusuka etafileni encede ukubala inyathelo kunye nokwahluka kuphela, unokwenza isixhobo sohlalutyo olunzima ngokongeza ifomula eyongezelelweyo. Kufuneka ifakwe kufutshane nefomula esele ikho - umzekelo, ukuba itafile igxile kwimiqolo, faka intetho kwiseli ngasekunene kwendlela esele ikho. Xa isifundo sifakwe kwikholamu, bhala ifomula entsha phantsi komdala. Okulandelayo kufanele ukuba kube senzo ngokwe-algorithm:

1. Siphinda sibalaselise uluhlu lweeseli, kodwa ngoku kufuneka ibandakanye ifomula entsha.
2. Vula "ntoni ukuba" yimenyu yohlalutyo kwaye ukhethe "itafile yedatha".
3. Yongeza ifomula entsha kumhlaba ohambelanayo kwilayini okanye ngeekholamu, kuxhomekeke kwiplati yeplate.

Ukwenza itafile yedatha kunye neenguqu ezimbini

Ukuqala kokulungiswa kwetafile enjalo kwahlukile kancinane- kufuneka ubeke ikhonkco kwingeniso iyonke ngaphezulu kwexabiso lepesenti. Emva koko, senza la manyathelo:

1. Rekhoda ukhetho lwexabiso lomgca omnye ngokubhekisele kwingeniso-ixabiso ngalinye liseli elinye.
2. Khetha uluhlu lweeseli.

6.

1. Vula i-festile yetafile yedatha, xa uzoba ukuqulunqa okwahlukileyo-ngethebhu yedatha kwibar yesixhobo.
2. Faka endaweni yokubalwa "ukufaka imilinganiselo yokufaka endaweni yekholamu ngaphakathi ..." iseli ngexabiso lokuqala.
3. Yongeza kwikholamu "ukufaka izinto endaweni yemitya ..." iseli ngomdla wokuqala kwintengiso yeencwadi ezinqabileyo kwaye ucofe u "Kulungile".

Ngenxa yoko, yonke iplate yeplate izele zizixa zengeniso enokwenzeka kunye nentengiso yeempahla.

Ukukhawulezisa ukubala kwamaphepha amashiti aneetafile zedatha

Ukuba izibalo ezikhawulezayo ziyafuneka kwiplate yedatha engayisebenzisiyo yonke i-realculation, unokwenza amanyathelo aliqela ukukhawulezisa inkqubo.

1. Vula i-parameter Window, khetha iGlowothi "ifomula" kwimenyu ngasekunene.
2. Khetha into ethi "Ngokuzenzekelayo, ngaphandle kweetafile zedatha" kwi "Ukubala kwincwadi".

Sibhozo

1. Yenza ukuphinda wenzelwe iziphumo kwiplate ngesandla. Kule nto kufuneka ubalule ifomula kwaye ucinezele iqhosha le-F

Ezinye izixhobo zokwenza uhlalutyo lovelwano

Le nkqubo inazo ezinye izixhobo ukunceda ukwenziwa kweemvakalelo. Bayenzela amanyathelo athile oqhele ukwenza ukuba yenziwe ngesandla.

1. "Umsebenzi" wokuzikhethela "kufanelekile ukuba iziphumo ezifunwayo ziyaziwa, kwaye kuya kufuneka ukuba ufumane ixabiso lokufaka ukuze ufumane iziphumo.
2. Msgstr "" "ICOCTE YOKUGCINA" yiyongeza ukusombulula iingxaki. Kuyimfuneko ukumisela umda kwaye ubonise, emva koko inkqubo iza kuyifumana impendulo. Isisombululo simiselwa ngokutshintsha amaxabiso.
3. Uhlalutyo lobuntununtunu lunokwenziwa lusebenzisa umphathi weskripthi. Esi sixhobo sikwi "Kuthekani ukuba" Imenyu yohlalutyo kwithebhu yedatha. Iyazithabatha imilinganiselo kwiiseli ezininzi - imali enokufikelela kuma-32. Igasana ithelekisa ezi nqobo, kwaye umsebenzisi akufuneki azitshintshe ngesandla. Umzekelo wokuSetyenziswa noMlawuli oMfutshane:

Thoba

Uhlalutyo lwemvakalelo yeprojekthi yotyalo-mali e-Excel

Indlela yokuhlaziya imvakalelo kwicandelo lotyalo-mali

Xa uhlalutya "Kuthekani ukuba" usebenzisa i-cust -imal okanye ezenzekelayo. Uluhlu lwamaxabiso awaziwayo, kwaye bangene endaweni yefomula. Ngenxa yoko, iseti yamaxabiso ifunyenwe. Kwezi, khetha inani elifanelekileyo. Qwalasela izikhombisi ezine ezikulo uhlalutyo lwemvakalelo kwicandelo lezezimali:

1. Ixabiso elingcwele langoku-libalwa ngokukhupha ubungakanani botyalo-mali ukusuka kwinani lengeniso.
2. Ixabiso langaphakathi lenzuzo / inzuzo - ibonisa ukuba yeyiphi na inzuzo efunekayo kutyalo-mali lonyaka.
3. Umyinge wokuhlawulwa ngumlinganiselo wazo zonke iingeniso kutyalo-mali lokuqala.
4. Isalathiso senzuzo ekhutshiweyo - ibonisa ukusebenza kwempumelelo kutyalo-mali.

Ifomula

Imvakalelo yokuncamathisela ingabalwa ngokusebenzisa le fomula: Guqula iparameter yeparamen kwi% / utshintsho kwiParameter yeParameter kwi%.

Iziphumo kunye neparamitha yegalelo inokuba ngamaxabiso achazwe ngaphambili.

1. Kuyimfuneko ukwazi iziphumo phantsi kweemeko ezisemgangathweni.
2. Sithatha indawo enye yezinto eziguquguqukayo kwaye silandele iziphumo zesiphumo.
3. Bala utshintsho lwepesenti kwimidlalo ye-parameter ahambelana neemeko ezimiselweyo.
4. Sifaka ipesenti efunyenwe kwifomula kwaye ichonge ubuntununtunu.

Umzekelo wohlalutyo lwemvakalelo yeprojekthi yotyalo-mali kwi-Excel

Ukuqonda okungcono kweendlela zovavanyo, umzekelo uyadingeka. Makhe sihlalutya iprojekthi enedatha eyaziwayo:

10

1. Gcwalisa itafile ukuhlalutya iprojekthi kuyo.

Shumi elinanye

1. Bala ukuhamba kwemali kusetyenziswa umsebenzi wokufuduka. Kwinqanaba lokuqala, ukuhamba kokuhamba okulingana notyalo-mali. Okulandelayo sisebenzisa ifomula: = ukuba (ukufuduswa (inombolo; 1; Yahluke, kuxhomekeke kwitafile yokubekwa. Ekupheleni, ixabiso elivela kwidatha yokuqala longezwa- ixabiso lokupheliswa.

12

1. Sichaza umhla obekiweyo wokuba isebenze kuyo iprojekthi. Kwisithuba sokuqala, sisebenzisa le fomula: = cwaka (G7: G17; "0; i-D.POPOK; 0). Le projekthi ikwikhefu-nokuphakama iminyaka emi-4.

13

1. Yenza ikholamu yeenombolo zelo xesha xa iprojekthi ihlawula.

Shumi elinane

1. Bala inzuzo yotyalo-mali. Kuyimfuneko ukwenza intetho, apho inzuzo ngexesha elithile lexesha lahlulwe yangumalilo wokuqala.

Shumi elinantlanu

1. Chonga i-indenteration ye-coaula: = 1 / (1 +) i-disc.%) ^ Inombolo.

Shumi elinesthandathu

1. Bala ixabiso langoku ngokuphindaphinda-ukuqulunqwa kwemali kuyanda ngexabiso lesaphulelo.

17.

1. Bala i-PI (Isalathiso seNzuzo). Ixabiso elinikiweyo kwicandelo lexesha lahlulahlulwe lazincamathisi ekuqaleni kophuhliso lweprojekthi.

Shumi elinesibhozo

1. Sichaza inqanaba langaphakathi lenzuzo yokusebenzisa umsebenzi we-EMD: = FMR (inqanaba lokuhamba kwemali).

Uhlalutyo lweemvakalelo zotyalo-mali usebenzisa itafile yedatha

Uhlalutyo lweeprojekthi kwicandelo lotyalo-mali, ezinye iindlela zilungele ngcono kunetafile yedatha. Abasebenzisi abaninzi banesiphithiphithi xa besenza ifomula. Ukufumanisa ukuxhomekeka kwento enye kwinguqu kwabanye, kufuneka ukhethe iiseli zokubala ezichanekileyo kunye nokufunda idatha.

Uhlalutyo kunye nohlalutyo lokusasaza kwi-Excel equkethe ukubala

Uhlalutyo lokusasazwa kwi-Excel

Injongo yolo hlalutyo kukwahlulahlula-hlula ubukhulu bezinto ezintathu:

1. Ukwahluka njengesiphumo sempembelelo yenye amaxabiso.
2. Utshintsho ngenxa yobudlelwane bamaxabiso obuchaphazela ngayo.
3. Utshintsho olungaqhelekanga.

Yenza uhlalutyo lokusasazwa ngokusebenzisa i-Excel ye-Excel Ukuba ayisebenzi, inokudityaniswa kwiiparamitha.

Itheyibhile yokuqala kufuneka ihambelane le mithetho mibini: Iiakhawunti nganye yexabiso lekholamu enye, kwaye idatha ekuyo ilungiselelwe ngokunyuka okanye ukuhla. Kuyimfuneko ukuvavanya ifuthe lenqanaba lemfundo ngokuziphatha kwimbambano.

Shumi elinethoba

1. Sifumana isixhobo "sedatha" yedatha "yedatha" kwaye sivule ifestile yayo. Uluhlu kufuneka lukhethe uhlalutyo lwezinto ezingatshatanga.

Amashumi amabini

1. Gcwalisa imiqolo yebhokisi yencoko yababini. I-inlet yokuphumla zonke iiseli ngaphandle kokuthatha ingqalelo iiCAPS kunye neenombolo. SIQHELEKILEYO KWIINGXAKI. Xelela iziphumo kwiphepha elitsha.

21.

Kuba ixabiso kwiseli ephuzi likhulu kuneyunithi, sinokuthatha isigqibo esingachanekanga- akukho luhlobo phakathi kwemfundo kunye nokuziphatha kwingxabano.

Uhlalutyo lwezinto e-Excel: Umzekelo

Sihlalutya ubudlelwane phakathi kwedatha kwicandelo lokuthengisa-kuyimfuneko ukuchonga iimpahla ezithandwayo nengathandekiyo. Ingcaciso yokuqala:

22.

1. Kuyimfuneko ukufumanisa ukuba zeziphi iimpahla zenyanga yesibini sele ikhule ngaphezulu kwenyanga yesibini. Senza itafile entsha ukumisela ukukhula nokuncitshiswa kwemfuno. Ukukhula kubalwa ngokwale fomula: = ukuba (((imfuno yesi-2)> 0; Ibango lesi-2 - i-1 - imfuno yoku-1; 0). Ifomula yokwehla: = Ukuba (ukukhula = 0; Imfuno yi-1- back 2; 0).

23.

1. Bala ukukhula kwemfuno yempahla ngeepesenti: = ukuba (ukukhula / i-2 = 0; ukuphakama / iyonke i-2).

24.

1. Siza kwenza itshathi ukuze siqapheshelo-Yabela uluhlu lweeseli kwaye wenze i-hidtogram ngokusebenzisa "Faka" ithebhu. Kwiisetingi kufuneka ususe ukugcwalisa, kungenziwa kwifomathi "yefomathi yedatha.

25 Uhlalutyo lwezinto ezimbini zokusasazeka kwe-Excel

Uhlalutyo lokusasazwa luqhutywa ngeenguqu ezininzi. Khawuqwalasele le nto kumzekelo: Kuya kufuneka ufumanise ukuba indlela yokusabela ngokukhawuleza kwisandi sesandi samadoda nabafazi babonakaliswa.

26.

1. Vula "uhlalutyo lwedatha", kufuneka ufumane uhlalutyo lwezinto ezimbini zokusasazwa ngaphandle kokuphindaphinda.
2. Ithuba lokufaka-iiseli apho idatha iqulethe (ngaphandle komnqwazi). Sizisa iziphumo kwiphepha elitsha kwaye ucofe u "Kulungile".

27.

Isalathisi f inkulu kune-F-bit-Oku kuthetha ukuba umgangatho uchaphazela umyinge wokuphendula kwisandi.

28.

Ukuqukumbela

Eli nqaku lichazwe ngokweenkcukacha uhlalutyo lobuntununtunu kwiprosesa ye-Excel, ukuze umsebenzisi ngamnye afumane iindlela zokusetyenziswa kwayo.

Umyalezo Uhlalutyo lovelwano kwi-Excel (itafile yedatha yedatha) ivele kuqala kwitekhnoloji yolwazi.