Maitiro emari anogara akabatanidzwa - chimwe chinhu chinoenderana nedzimwe uye shanduko pamwe nazvo. Kutsvaga izvi shanduko uye kunzwisisa izvo zvekutarisira mune ramangwana zvinokwanisika uchishandisa excel mabasa uye nzira dzekutenderera.
Kuwana akawanda mhinduro uchishandisa tafura yedata
Iko kugona kwematafura edata ndeyezvinhu zve "ko kana" kuongororwa kunowanzoitwa kuburikidza neMicrosoft Excel. Iri izita rechipiri rekuongorora kwekunzwa.
GeneralIyo tafura yedata ndiyo mhando yeiyo cell range, iyo iwe yaunogona kugadzirisa matambudziko acho achisimuka nekuchinja tsika mune mamwe masero. Iyo inogadzirwa pazvinenge zvakafanira kutarisa shanduko mune zvikamu zve formula uye gamuchira zvigadziriso zvemhedzisiro, maererano nekuchinja uku. Tsvaga kuti ungashandisa sei mahwendefa edata muzvidzidzo, uye ndeapi marudzi.
Ruzivo rwekutanga nezve matafura e dataKune marudzi maviri ematafura e data, ivo vakasiyana muhuwandu hwezvinhu. Ita kuti tafura inodiwa neyekutarisa nehuwandu hwehunhu hunoda kuongororwa nazvo.
Statistics nyanzvi dzinoshandisa tafura neyakajairwa kana paine chete musiyano mune rimwe chete kana akati wandei, izvo zvinogona kukanganisa shanduko mumhedzisiro yavo. Semuenzaniso, kazhinji inowanzoshandiswa mune bundle ine pl basa. Iyo formula yakagadzirirwa kuverenga huwandu hwemubhadharo wenguva dzose uye anofanirwa kuenderana neyekuita mwero wakaiswa muchibvumirano. Nekuverenga kwakadaro, kusiana kwakanyorwa mune imwe ikoramu, uye mhedzisiro yekuverenga kune imwe. Muenzaniso wedatha data ne1 inoshanduka:
PoshiTevere, funga zviratidzo zvine 2 akasiyana. Ivo vanoshanda mumatare mune zvinhu zviviri zvinokanganisa shanduko mune chero chiratidzo. Misiyano mbiri inogona kunge iri mune imwe tafura yakabatana nechikwereti - nerubatsiro rwaro iwe unogona kuziva iyo yakakwana yekubhadhara nguva uye huwandu hwekubhadhara kwemwedzi. Uku kuverenga kunodawo kushandisa iyo PPT basa. Muenzaniso ndiro ne2 akasiyana:
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_1](/userfiles/22/1235_1.webp)
Funga nezve nzira yekuongorora pane iyo muenzaniso wechitoro chidiki chebhuku, apo mabhuku zana chete aripo. Vamwe vacho vanogona kutengeswa zvakanyanya kudhura (madhora makumi mashanu), zororo rinoda vatengi zvakachipa ($ 20). Mari yakazara kubva kutengeswa kwezvinhu zvese zvakagadzirwa - muridzi akasarudza iyo mumutengo wepamusoro we60% yemabhuku. Izvo zvinodikanwa kuti uzive kuti mari inokura sei kana iwe ukawedzera mutengo wehuwandu hukuru hwezvinhu - 70% uye zvichingodaro.
- Sarudza iyo yemahara cell kure kure kubva kumucheto kweiyo pepa uye nyora fomula mazviri: = sero renzvimbo yakazara. Semuenzaniso, kana mari yacho yakanyorwa muC14 Cell (kusarudzika kusarudzika kunoratidzwa), zvinodikanwa kunyora seizvi: = c14.
- Isu tinonyora pasi huwandu hwezvinhu mukirabhu kuruboshwe kwechitokisi ichi - kwete pasi payo, zvakakosha.
- Isu tinogovera huwandu hwemasero umo iyo mhodzi yekufarira iri kuwanikwa uye chinongedzo kune iyo mari yakazara.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_2](/userfiles/22/1235_2.webp)
- Isu tinowana pane "data" ye "kuongorora" chii kana "tinya pairi - mune menyu inovhura, iwe unofanirwa kusarudza iyo" data tafura "sarudzo.
- Iwindo diki rinovhura, kwaunoda kuti utaure sero neine muzana wemabhuku anotengeswa nemutengo wakakwira muColumn "kutsiva tsika pamitsetse iri mu ...". Iyi nhanho inoitwa kuti iite kudzikiswa kwehuwandu hwemari, kutora account inowedzera.
Mushure mekudzvanya "OK" bhatani muwindo iro data rakapinda kuti rinyore tafura, mhedzisiro yekuverenga ichauya mumitsara.
Kuwedzera fomula kune tafura yedata ine imwe musiyanoKubva patafura yakabatsira kuverenga chiitiko pamwe chete neyakasiyana chete, iwe unogona kugadzira chishandiso chakaomarara nekuwedzera imwe formula. Inofanira kuve yakaiswa padhuze narwo ratovepo - semuenzaniso, kana tafura yakatarisana nemitsara, isa chirevo muchitokisi kurudyi rwechiripo chatovepo. Kana kutaridzika kwacho kwakaiswa pamakoramu, nyora pasi fomu nyowani pasi pekare. Inotevera inofanirwa kunge ichiita maererano nealgorithm:
- Isu tinosimbisa zvakare mhando yemasero, asi ikozvino inofanira kusanganisira fomu nyowani.
- Vhura iyo "Ko kana" kuongorora menyu uye sarudza "tafura yedata".
- Wedzera fomu nyowani kune iyo inoenderana munda pamutsetse kana nemakoramu, zvichienderana neyekutarisa kweplate.
Kutanga kwekugadzirira kwetafura yakadaro kwakasiyana zvishoma - iwe unofanirwa kuisa chinongedzo kune iyo yakawanda mari pamusoro pehuwandu hwehuwandu. Tevere, isu tinoita matanho aya:
- Rekodha sarudzo dzemutengo wetsetse mumwe uchireva mari - yega yega mutengo isero rimwe chete.
- Sarudza huwandu hwemasero.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_3](/userfiles/22/1235_3.webp)
- Vhura iyo tafura yetafura yedata, sekunge kana ichirova imwe musiyano
- Kutsiva muhuwandu "kuti utange kukosha pamakoramu mu ..." Sero nemutengo wekutanga.
- Wedzera kune imwe ikholamu "yekutsiva tsika pamabhuruku mu ..." Cell ine yekutanga kufarira mukutengesa mabhuku anodhura uye tinya "Zvakanaka".
Nekuda kweizvozvo, ndiro yese yakazara nehuwandu hwemari inogona kuitika nemitemo yakasiyana yekutengesa zvinhu.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_4](/userfiles/22/1235_4.webp)
Kana gadziriso yekukurumidza ichidikanwa mukirowa yedata iyo isingamhanyi rese bhuku redzidziso, unogona kuita akati wandei zviito zvekumhanyisa maitiro.
- Vhura iyo parameter hwindo, sarudza clause "formula" mumenu kurudyi.
- Sarudza chinhu icho "otomatiki, kunze kwematafura ematafura" mu "kuverenga mubhuku" chikamu.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_5](/userfiles/22/1235_5.webp)
- Ita kudzikiswa kwemhedzisiro yacho mundiro yemunhu. Kune izvi iwe unofanirwa kuratidza mafomula uye dzvanya iyo F kiyi
Chirongwa ichi chine zvimwe zvishandiso zvekubatsira kuita kuongorora kwekunzwa. Ivo vanozvitakura zvimwe zviito izvo zvaizofanira kuitwa nemaoko.
- "Kusarudzwa kweParamende" basa rakakodzera kana mhedzisiro yaunoda kuzivikanwa, uye inodikanwa kuti uwane kukosha kwekuisa kwekuisa kweiyo inoshanduka kuti uwane mhedzisiro yakadaro.
- "Solution yekutsvaga" inowedzera-yekugadzirisa matambudziko. Izvo zvinodikanwa kuti ugadzire zvisingakwanisi uye uratidze, mushure maizvozvo hurongwa huchawana mhinduro. Mhinduro yacho inotarisirwa nekuchinja tsika.
- Kuongorora kwekunzwa kunogona kuitwa uchishandisa iyo Script Manager. Ichi chishandiso chiri mu "ko kana" kuongorora menyu pane iyo data tab. Iyo inomutsa tsika mumasero akati wandei - huwandu hunogona kusvika 32. Iyo disatcher inofananidza idzi tsika, uye mushandisi haafanire kuzvichinja. Muenzaniso wekushandisa maneja ekunyora:
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_6](/userfiles/22/1235_6.webp)
Kuongororwa kwekunzwa kweiyo purojekiti yekudyara muExcel
Nzira yekuongorora kunzwa mumunda wekudyaraKana uchiongorora "Ko kana" uchishandisa bust - bhuku kana otomatiki. Inozivikanwa mhando dzehunhu, uye dzakatenderwa mune formula. Nekuda kweizvozvo, seti yetsika inowanikwa. Pane izvi, sarudza chimiro chakakodzera. Funga nezvechiratidzo chechina idzo kuongororwa kwekunzwa kwekunzwa mumunda wemari:
- Yakachena iripo kukosha - inoverengwa nekubvisa saizi yekudyara kubva kune huwandu hwemari.
- Muyero wemukati wekushandisa / purofiti - zvinoratidza kuti ndeipi purofiti inodiwa kubva pakudyara kwegore.
- Iyo yekubhadhara chiyero ndeye chiyero cheese purofiti kune yekutanga mari yekudyara.
- Discounted purofiti index - inoratidza kushanda kwekudyara kwekudyara.
Iko kunzwira tsitsi kwechisungo kunogona kuverengerwa uchishandisa iyi formula: Chinja paramende paramende mu% / shanduko mune iyo yekuisa paramende mu%.
Iyo inobuda uye input paramende inogona kunge iri tsika dzakatsanangurwa kare.
- Izvo zvinodikanwa kuziva mhedzisiro iri pasi pemamiriro ezvinhu.
- Isu tinotsiva imwe yemhando dzakasiyana uye dzinotevera mhedzisiro yemhedzisiro.
- Verenga iyo inoshandurwa muzana inoshandurwa mune maviri parameter zvichienderana nemamiriro akagadzwa.
- Isu tinoisa muzana muzana yakawanikwa mune formula uye tinosarudza kunzwa kwekunzwa.
Kunzwisisa kuri nani kwehunyanzvi hwekuongorora, muenzaniso unodikanwa. Ngationgororei purojekiti ine data rinozivikanwa kwazvo:
10- Zadza tafura kuongorora chirongwa ichi pairi.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_7](/userfiles/22/1235_7.webp)
- Verenga kuyerera kwemari uchishandisa iyo yekudzikisira basa. Paziva rekutanga, kuyerera kwakaenzana nekudyara. Tevere isu tinoshandisa formula: = kana (nhamba (nhamba; 1;) 2; Iva akasiyana, zvinoenderana nepafura yekuvhara. Pakupera, kukosha kubva ku data yekutanga kunowedzerwa - kukosha kwemvura.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_8](/userfiles/22/1235_8.webp)
- Isu tinotsanangura iyo yekupedzisira iyo iyo chirongwa ichi chingabhadhara. Kwenguva yekutanga, isu tinoshandisa iyi formula: = kunyarara (G7: G17; "0; kutanga D.Potok; 0). Iyo purojekiti iri kupaza-kunyange point kwemakore mana.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_9](/userfiles/22/1235_9.webp)
- Gadzira chikamu chehuwandu hwehuwandu idzo nguva apo chirongwa ichi chabhadhara.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_10](/userfiles/22/1235_10.webp)
- Verenga iyo yekubatsira kwekudyara. Izvo zvinodikanwa kuti ugadzire chirevo, uko purofiti mune imwe nguva yenguva yakakamurwa mukutanga mari.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_11](/userfiles/22/1235_11.webp)
- Sarudza iyo kuderedzwa coefficient yeiyi formula: = 1 / (1 + disc.%) ... nhamba.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_12](/userfiles/22/1235_12.webp)
- Verenga kukosha kwazvino nekuwedzera - kuyerera kwemari kunowedzerwa nemutengo wekutora.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_13](/userfiles/22/1235_13.webp)
- Verenga pi (purogiramu index). Iko kukosha kwakapihwa muchikamu chenguva chakakamurwa kuita zvakabatanidzwa pakutanga kwekusimudzira kweprojekiti.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_14](/userfiles/22/1235_14.webp)
- Isu tinotsanangura chiyero chemukati che purofiti tichishandisa basa reEMD: = FMR (Cash Flow range).
Kuongororwa kwekunyepedzera kwekudyara uchishandisa tafura yedata
Kuti uwane kuongororwa kwemapurojekiti mumunda wekudyara, dzimwe nzira dziri nani dzakakwaniriswa pane tafura yedata. Vazhinji vashandisi vane nyonganiso kana vachikwevera formula. Kuti uwane kutsamira kwechinhu chimwe kubva pakuchinja mune vamwe, iwe unofanirwa kusarudza iwo maseru ekuverenga uye kuverenga iyo data.Chinhu uye kupararira kuongororwa muExcel ne automation yekuverenga
Kupararira kuongororwa muExcelChinangwa chekuongororwa kwakadaro ndechekukamura kusiyanisa kwehukuru hwehukuru hwezvinhu zvitatu:
- Kusiyanisa nekuda kwekumanikidza kwetsika.
- Shanduko nekuda kwehukama hwehukama hunoitisa.
- Shanduko dzisina kurongeka.
Ita ongororo yekupararira kuburikidza neExcel inowedzera-pane "kuongorora kwedata". Kana isina kugoneswa, inogona kubatana mu parameter.
Tafura yekutanga inofanira kutevedzera mitemo miviri: yega yega kukosha kwenyaya yekhoriyamu imwe, uye iyo data mazviri yakarongedzwa mukukwira kana kuburuka. Izvo zvinodikanwa kuyedza kukanganiswa kweiyo mwero wedzidzo pane maitiro mukupokana.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_15](/userfiles/22/1235_15.webp)
- Isu tinowana iyo "data" tab "data" chombo uye vhura hwindo rayo. Rondedzero yacho inoda kusarudza imwe-factor inopararira yekuongorora.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_16](/userfiles/22/1235_16.webp)
- Zadza mitsara yebhokisi dialog. Iyo inlet kupindirana ndeye masero ese asina kufungira manhamba nenhamba. Isu takatarisana nemakoramu. Taura mhedzisiro pane imwe nyowani.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_17](/userfiles/22/1235_17.webp)
Sezvo kukosha kwero muyero yakakura kupfuura iyo unit, tinogona kufunga kufungidzira kweiyo isiriyo - hapana hukama pakati pedzidzo nemaitiro mukukonana.
Kuongorora kwechokwadi muExcel: muenzanisoIsu tinoongorora hukama pakati pematare mumunda wekutengesa - zvinodikanwa kuti tizive zvinhu zvakakurumbira uye zvisina kujairika. Ruzivo rwekutanga:
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_18](/userfiles/22/1235_18.webp)
- Izvo zvinodiwa kuti uzive kuti ndeipi zvinhu zvinodiwa nemwedzi wechipiri wakura pamusoro pemwedzi wechipiri. Isu tinoita tafura nyowani yekuona kukura uye kuderedza kwekuda. Kukura kunoverengerwa zvichienderana neiyi formula: = kana (((kuda 2-kuda 1)> 0; kuda 2 - kuda 1; 0). Fomula yekuderera: = kana (kukura = 0; kuda ndeye 1- kuda 2; 0).
- Verenga kukura kwekuda kwezvinhu mune muzana: = kana (kukura / yakazara 2 = 0; kuderedzwa / huwandu 2; kureba / yakazara 2).
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_19](/userfiles/22/1235_19.webp)
- Isu tichagadzira chati yekujekeswa - kugovera huwandu hwemasero uye gadzira histogram kuburikidza ne "isa" tab. Mune zvigadziriso zvaunoda kuti ubvise kuzadza, zvinogona kuitwa kuburikidza ne "data fomati fomati" chishandiso.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_20](/userfiles/22/1235_20.webp)
Kuongororwa kwekuparadzira kunoitwa pamwe neakati wandei akasiyana. Chimbofunga izvi pane iyo muenzaniso: Iwe unofanirwa kutsvaga kuti nekukurumidza kuita kwakanzwika kurira kwakasiyana muvanhu nevakadzi kunoratidzwa.
26.- Vhura "kuongorora kwedata", iwe unofanirwa kuwana maviri-factor ekuongorora pasina kudzokorora.
- Inpt Interval - masero ipo data iri mairi (isina ngowani). Isu tinounza zvaizoitika kune iyo nyowani pepa uye tinya "OK".
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_21](/userfiles/22/1235_21.webp)
Iyo chiratidzo f yakakura kupfuura iyo f-yakaoma - izvi zvinoreva kuti pasi inokanganisa huwandu hwekuita kurira.
![Excel Sensitivity Kuongorora (Data Tafura yeTafura) 1235_22](/userfiles/22/1235_22.webp)
Mhedziso
Ichi chinyorwa chakarondedzera zvakadzama kuongorora kwekunzwa muExcel tafura processor, kuitira kuti mushandisi wega wega anogona kuona nzira dzekushandisa kwayo.
Mharidzo iyo yekunzwa kuongororwa muExcel (sample data tafura) yakaonekwa yekutanga kune technology tekinoroji.