Ukuhlaziywa kwe-Excel Sensitivity (Isampula yetafula ledatha)

Izinqubo zezimali zihlala zihlangana - into eyodwa incike kolunye futhi izinguquko nayo. Ukulandelela lezi zinguquko futhi uqonde ukuthi yini okufanele uyilindele ngokuzayo kungenzeka kusetshenziswe imisebenzi ye-Excel nezindlela zeTabular.

Ukuthola imiphumela eminingi usebenzisa itafula ledatha

Amandla amatafula wedatha ayizinto ze- "Uma" ukuhlaziywa kuvame ukwenziwa nge-Microsoft Excel. Leli igama lesibili lokuhlaziywa kokuzwela.

Jwayelekile

Ithebula ledatha luhlobo lwebanga leseli, ongaxazulula ngalo izinkinga ezivela ngokushintsha amanani kwamanye amaseli. Kwenziwa uma kunesidingo sokubheka ushintsho ezingxenyeni zefomula futhi uthole izibuyekezo zemiphumela, ngokusho kwalezi zinguquko. Thola ukuthi ungasisebenzisa kanjani amaphilisi wedatha ezifundweni, futhi yiziphi izinhlobo eziyizinto eziyizinto.

Imininingwane eyisisekelo mayelana namatafula wedatha

Kunezinhlobo ezimbili zamatafula wedatha, ahlukile kwinani lezakhi. Yenza itafula liyadingeka ngokulandelana ngenani lamanani adinga ukubhekwa nalo.

Ochwepheshe bezibalo bafaka itafula ngokuhlukahluka okukodwa lapho kukhona okuhlukahlukene kuphela kulokho okukodwa noma okuningana, okungathinta ushintsho ngomphumela wabo. Isibonelo, kuvame ukusetshenziselwa inqwaba nomsebenzi we-PL. Ifomula yenzelwe ukubala inani le-BALK evamile futhi libheka inani lenzalo elibekwe kwinkontileka. Ngezibalo ezinjalo, okuguquguqukayo kuqoshwa kwikholamu eyodwa, kanye nemiphumela yokubalwa komunye. Isibonelo sepuleti ledatha ngokuhluka okungu-1:

okukodwa

Okulandelayo, cabanga ngezimpawu ezinokuhluka oku-2. Basebenza ezimweni lapho kuthinta khona izici ezimbili ushintsho kunoma iyiphi inkomba. Ukuhlukahluka okubili kungase kwenye ithebula elihlotshaniswa nemalimboleko - ngosizo lwayo ungakhomba isikhathi esifanele sokukhokha kanye nenani lenkokhelo yanyanga zonke. Lesi sibalo futhi sidinga ukusebenzisa umsebenzi we-PPT. Ipuleti lesibonelo elinokuhluka oku-2:

2 Ukudala Ithebula Ledatha Ngokuguquguquka okukodwa

Cabanga ngendlela yokuhlaziya esibonelweni sesitolo esincane sezincwadi, lapho kuphela izincwadi eziyi-100 zitholakala. Ezinye zazo zingathengiswa zibiza kakhulu ($ 50), ezinye zizobiza abathengi ezishibhile ($ 20). Imali ephelele evela ekuthengisweni kwazo zonke izimpahla iklanyelwe - Umnikazi wanquma ukuthi ngentengo ephezulu ka-60% yezincwadi. Kuyadingeka ukuthola ukuthi imali izokhula kanjani uma ukhulisa intengo yenani elikhudlwana lezimpahla - 70% nokunye.

1. Khetha ibanga leseli lamahhala kusuka emaphethelweni eshidi bese ubhala ifomula kuyo: = iseli lemali engenayo. Isibonelo, uma imali engenayo iqoshwa esitokisini se-C14 (ukubizwa okungahleliwe kukhonjisiwe), kuyadingeka ukubhala kanjena: = C14.
2. Sibhala phansi inani lezimpahla kwikholamu ngakwesokunxele sale cell - hhayi ngaphansi kwalo, kubaluleke kakhulu.
3. Silwa uhla lwamaseli lapho ikholomu yenzalo itholakala khona kanye nesixhumanisi semali ephelele.

3.

1. Sithola kuthebhu ethi "Idatha" ye- "Ukuhlaziywa" kuthiwani uma "" bese uqhafaza kuyo - kumenyu evula inketho "yetafula ledatha".

okune

1. Iwindi elincane lizovuleka, lapho udinga khona ukucacisa iseli ngephesenti lezincwadi ezithengiswayo ngentengo ephezulu kwikholamu "ukuze ungene esikhundleni semigqa ku ...". Lesi sinyathelo senziwa ukwenza kabusha kabusha kwemali engenayo ejwayelekile, kucatshangelwa amaphesenti andayo.

isihlanu

Ngemuva kokucindezela inkinobho ethi "Kulungile" ewindini lapho kufakwa khona idatha ukuze kuhlanganiswe itafula, imiphumela yokubalwa izovela emigqeni.

Ukungeza ifomula etafuleni ledatha ngokuhlukahluka okukodwa

Ukusuka etafuleni elisize ukubala isenzo ngokuhlukahluka okukodwa kuphela, ungenza ithuluzi lokuhlaziya eliyinkimbinkimbi ngokungeza ifomula eyengeziwe. Kufanele ifakwe eduze kwefomula esele ekhona - ngokwesibonelo, uma itafula ligxile emigqeni, faka inkulumo esitokisini ngakwesokudla esivele ikhona. Lapho ukuqondiswa kufakwe kumakholomu, bhala phansi ifomula entsha ngaphansi kwendala. Okulandelayo kufanele kube ukwenza ngokusho kwe-algorithm:

1. Siphinde siqokomise ububanzi bamaseli, kepha manje kufanele kufake ifomula entsha.
2. Vula i- "Kuthiwani uma" Imenyu yokuhlaziya bese ukhetha "Ithebula Ledatha".
3. Faka ifomula entsha kwinkambu ehambisanayo emgqeni noma ngamakholomu, kuya ngokuqondiswa kwepuleti.

Ukwakha itafula ledatha ngokuhlukahluka okubili

Ukuqala kokulungiswa kwetafula elinjalo kuhlukile kancane - udinga ukubeka isixhumanisi semali engenayo ephelele ngenhla kwamanani amaphesenti. Okulandelayo, senza lezi zinyathelo:

1. Qopha Izinketho zentengo yomugqa owodwa ngokubhekisele kwimali engenayo - intengo ngayinye yiseli elilodwa.
2. Khetha ububanzi bamaseli.

6.

1. Vula iwindi letafula ledatha, njengalapho udweba ukuguquguquka okukodwa - ngethebhu yedatha kubha yamathuluzi.
2. Faka esikhundleni sesibalo "ukufaka amanani afaka esikhundleni samakholomu ku ..." iseli ngentengo ephakeme yokuqala.
3. Faka kwikholamu "ukufaka esikhundleni samanani angena esikhundleni sezintambo ku ..." iseli ngenzalo yokuqala ekuthengisweni kwezincwadi ezibizayo bese uqhafaza u- "KULUNGILE".

Ngenxa yalokhu, lonke ipuleti ligcwele inani lemali engenayo enemigomo ehlukile yokuthengisa izimpahla.

Ukusheshiswa kokubala kwama-persets aqukethe amatafula edatha

Uma izibalo ezisheshayo zidingeka epuletini ledatha elingaqhubeki yonke incwadi kabusha, ungenza izenzo eziningi zokusheshisa inqubo.

1. Vula iwindi lepharamitha, khetha i-Clause "ifomula" kumenyu ngakwesokudla.
2. Khetha into "ngokuzenzakalelayo, ngaphandle kwamatafula wedatha" kwisigaba "encwadini ethi" Book ".

isishiyagalombili

1. Yenza ukuphinda kabusha kwemiphumela epuletini ngesandla. Kulokhu udinga ukugqamisa amafomula bese ucindezela ukhiye we-F

Amanye amathuluzi wokwenza ukuhlaziywa kokuzwela

Uhlelo lunamanye amathuluzi okusiza ukwenza ukuhlaziywa kokuzwela. Basebenzisa ezinye zezenzo ezingenziwa ngenye indlela.

1. Ukusebenza kwe- "Ukukhetha kwepharamitha" kufanelekile uma umphumela owuthandayo waziwa, futhi kuyadingeka ukuthola inani lokufaka lokuguquguquka lokuguquguquka ukuze uthole umphumela onjalo.
2. "Ukusesha kwesixazululo" kungukungezwa kokuxazulula izinkinga. Kuyadingeka ukusungula imikhawulo futhi ubakhombise, emva kwalokho uhlelo luzothola impendulo. Isixazululo sinqunywa ngokushintsha amanani.
3. Ukuhlaziywa kokuzwela kungenziwa kusetshenziswa umphathi weskripthi. Leli thuluzi liku- "Kuthiwani uma" Imenyu yokuhlaziya kwithebhu yedatha. Ifaka esikhundleni samanani amaseli ambalwa - inani lingafinyelela kuma-32. Isipesheli siqhathanisa la magugu, futhi umsebenzisi akufanele awashintshe ngesandla. Isibonelo sokusebenzisa Umphathi Wezokubhalisa:

isishiyagalolunye

Ukuhlaziywa kokuzwela kwephrojekthi yokutshala imali e-Excel

Indlela yokuhlaziya uzwela emkhakheni wokutshala imali

Lapho uhlaziya "ukuthi" kusetshenziswa yini "ukugcwala - ibhukwana noma okuzenzakalelayo. Ububanzi obaziwayo bamanani, futhi babuyiselwa esikhundleni sefomula. Ngenxa yalokhu, kutholwa iqoqo lamanani. Kulaba, khetha isibalo esifanele. Cabanga izinkomba ezine zokuhlaziywa kokuzwela emkhakheni wezezimali:

1. Inani lamanje elihlanzekile - libalwa ngokukhipha usayizi wokutshala imali kusuka kwinani lemali engenayo.
2. Izinga langaphakathi lenzuzo / inzuzo - libonisa ukuthi iyiphi inzuzo edingekayo kusuka ekutshalweni kwemali konyaka.
3. Isilinganiso sokukhokha siyisilinganiso sazo zonke izinzuzo ekutshalweni kwemali kokuqala.
4. Inkomba yenzuzo ehlisiwe - ikhombisa ukusebenza kahle kokutshalwa kwemali.

Uhlobo

Ukuzwela kokunamathiselwe kungabalwa kusetshenziswa le formula: shintsha ipharamitha yokukhipha ku% / ushintsho kwipharamitha yokufaka ku%.

Ukukhishwa kanye nepharamitha yokufaka kungenzeka kube amanani achazwe ngaphambili.

1. Kuyadingeka ukwazi umphumela ngaphansi kwezimo ezijwayelekile.
2. Simiselela enye yezinto eziguquguqukayo bese silandela imiphumela yomphumela.
3. Bala ushintsho lwamaphesenti kuwo womabili amapharamitha ahlobene nezimo ezisunguliwe.
4. Sifaka amaphesenti atholakala kwifomula futhi anqume ukuzwela.

Isibonelo sokuhlaziywa kokuzwela kwephrojekthi yokutshala imali e-Excel

Ukuqonda okungcono kwamasu wokuhlaziya, isibonelo siyadingeka. Ake sihlaziye iphrojekthi ngedatha enjalo eyaziwayo:

Okuthenyalwayo

1. Gcwalisa itafula ukuze uhlaziye iphrojekthi kuwo.

ishumi nanye

1. Bala ukugeleza kwemali usebenzisa umsebenzi wokufudumalo. Esigabeni sokuqala, ukugeleza kulingana nokutshalwa kwemali. Okulandelayo sisebenzisa ifomula: = Uma (indawo yokuchithwa (inombolo;) = 2; inflow (inflow 1: Izibalo (infow (inflow 1: I-inflow 1: $ b $ 5) Yehluka, kuya ngetafula lokubekwa. Ekugcineni, inani ledatha yokuqala lingezwa - inani lokumiswa kwemali.

Okuqophele imali

1. Sichaza umnqamulajuqu owawuyokhokha iphrojekthi. Isikhathi sokuqala, sisebenzisa le formula: = Silenga (G7: G17; "0; I-D.Potok; 0). Le phrojekthi isekhefu lekhefu leminyaka engu-4.

13

1. Dala ikholomu ngezinombolo zalezo zikhathi lapho iphrojekthi ikhokha.

ishumi nane

1. Bala inzuzo yokutshalwa kwemali. Kuyadingeka ukudala isisho, lapho inzuzo ngesikhathi esithile ihlukaniswe khona izimali zokuqala.

ishumi nanhlanu

1. Nquma i-coefficing esolisayo yale fomula: = 1/1 + disc.%) ^ Inombolo.

ishumi nesithupha

1. Bala inani lamanje ngokuphindaphindeka - Ukugeleza kwemali kuyaphindwa inani lesaphulelo.

17.

1. Bala i-PI (insiza yenzuzo). Inani elinikezwe engxenyeni yesikhathi lihlukaniswe izinamathiseli ekuqaleni kokuthuthukiswa kwephrojekthi.

ishumi nesishayagalombili

1. Sichaza isilinganiso sangaphakathi senzuzo sisebenzisa umsebenzi we-EMD: = FMR (Uhla lokuhamba kwemali).

Ukuhlaziywa kokuzwela kokutshalwa kwezimali kusetshenziswa itafula ledatha

Ukuhlaziywa kwamaphrojekthi emkhakheni wokutshala imali, ezinye izindlela zilungele kangcono kunethebula ledatha. Abasebenzisi abaningi banokudideka lapho bedonsa ifomula. Ukuthola ukuncika kwento eyodwa kusuka kwezinguquko kwabanye, udinga ukukhetha amaseli okubala afanele futhi ufunde imininingwane.

Ukuhlaziywa kwe-Factor nokuhambisa ku-Excel nge-automation of Calculations

Ukuhlaziywa kokuhlakazeka ku-Excel

Inhloso yokuhlaziywa okunjalo ukuhlukanisa ukuhlukahluka kobukhulu bezakhi ezintathu:

1. Ukuhluka ngenxa yethonya lamanye amanani.
2. Izinguquko ngenxa yobudlelwano bezindinganiso ezithinta yona.
3. Izinguquko ezingahleliwe.

Yenza ukuhlaziywa kokusakazwa ngokusebenzisa ukuhlaziywa kwedatha kwe-Excel Add-on ". Uma kungavunyelwe, kungaxhunywa kumapharamitha.

Ithebula lokuqala kufanele lihambisane nemithetho emibili: Inani ngalinye le-akhawunti yekholamu elilodwa, futhi imininingwane ekuyo ihlelwe ngokukhuphuka noma ukwehla. Kuyadingeka ukuvivinya umthelela wezinga lemfundo ngokuziphatha ezingxabanweni.

ishumi nesishiyagalolunye

1. Sithola ithubhu "ledatha" yethebhu "Idatha" bese uvula iwindi layo. Uhlu ludinga ukukhetha ukuhlaziywa kokusakazwa kwe-lingle-factor.

amashumi amabili

1. Gcwalisa imigqa yebhokisi lengxoxo. Isikhashana sokungenela wonke amaseli ngaphandle kokucabanga ngama-cap nezinombolo. Sihlanganisa amakholomu. Tshela imiphumela eshidini elisha.

21.

Njengoba inani elisesitokisini eliphuzi likhulu kuneyunithi, singacabanga ukuthi ukucabanga okungalungile - akukho buhlobo phakathi kwemfundo nokuziphatha engxabanweni.

Ukuhlaziywa kwe-Factor ku-Excel: Isibonelo

Sihlaziya ubudlelwano phakathi kwemininingwane emkhakheni wokuthengisa - kuyadingeka ukukhomba izimpahla ezithandwayo nezingathandeki. Imininingwane yokuqala:

22.

1. Kuyadingeka ukuthola ukuthi yiziphi izimpahla isidingo senyanga yesibili esekhule ngenyanga yesibili. Senza itafula elisha ukuthola ukukhula nokuncishiswa kwesidingo. Ukukhula kubalwa ngokuya ngale formula: = uma (((funa 2-funa 1)> Isidingo 2 - Isidingo 1; 0). Ifomula yokwehla: = Uma (ukukhula = 0; funa 1- funa 2; 0).

23.

1. Bala ukukhula okufunwayo kwezimpahla ngamaphesenti: = Uma (ukukhula / inani 2 = 0; ukunciphisa / inani 2; Ukuphakama / inani 2).

24.

1. Sizokwenza ishadi lokucacisa - yabela ububanzi bamaseli futhi sakha i-histogram ngethebhu ethi "Insert". Kuzilungiselelo ozidingayo ukususa u-Gcwalisa, kungenziwa ngethuluzi le- "Data Format Format".

Ukuhlaziywa kokusabalalisa okubili-2

Ukuhlaziywa kokuhlakazeka kwenziwa ngokuhlukahluka okuningana. Cabanga ngalokhu ngokwesibonelo: Udinga ukuthola ukuthi ukusabela kanjani emkhakheni we-veratus akwamukeli kwabesilisa nabesifazane kuboniswe.

26.

1. Vula "ukuhlaziywa kwedatha", udinga ukuthola ukuhlaziywa kokusakazwa kwezinto ezimbili ngaphandle kokuphindaphinda.
2. Isikhashana sokufaka - amaseli lapho idatha etholakala khona (ngaphandle kwesigqoko). Siletha imiphumela eshidi elisha bese uqhafaza u- "KULUNGILE".

27.

Isikhombisi F sikhulu kune-f-esibucayi - lokhu kusho ukuthi phansi kuthinta isilinganiso sokuphendula kumsindo.

28.

Ukugcina

Le ndatshana echazwe ngokuningiliziwe ukuhlaziywa kokuzwela ku-processor yethebula le-Excel, ukuze umsebenzisi ngamunye akwazi ukuthola izindlela zokusebenzisa kwawo.

Thumela ukuhlaziywa kokuzwela ku-Excel (Ithebula Ledatha Yesampula) livele kuqala kubuchwepheshe bolwazi.