Excel Sensitivity Kuongorora (Data Tafura yeTafura)

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.

General

Iyo 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 data

Kune 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:

Poshi

Tevere, 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:

2 kugadzira tafura yedata neyakajairwa

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.

1. 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.
2. Isu tinonyora pasi huwandu hwezvinhu mukirabhu kuruboshwe kwechitokisi ichi - kwete pasi payo, zvakakosha.
3. Isu tinogovera huwandu hwemasero umo iyo mhodzi yekufarira iri kuwanikwa uye chinongedzo kune iyo mari yakazara.

3.

1. Isu tinowana pane "data" ye "kuongorora" chii kana "tinya pairi - mune menyu inovhura, iwe unofanirwa kusarudza iyo" data tafura "sarudzo.

ina

1. 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.

shanu

Mushure mekudzvanya "OK" bhatani muwindo iro data rakapinda kuti rinyore tafura, mhedzisiro yekuverenga ichauya mumitsara.

Kuwedzera fomula kune tafura yedata ine imwe musiyano

Kubva 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:

1. Isu tinosimbisa zvakare mhando yemasero, asi ikozvino inofanira kusanganisira fomu nyowani.
2. Vhura iyo "Ko kana" kuongorora menyu uye sarudza "tafura yedata".
3. Wedzera fomu nyowani kune iyo inoenderana munda pamutsetse kana nemakoramu, zvichienderana neyekutarisa kweplate.

Kugadzira tafura yedata nemhando mbiri dzakasiyana

Kutanga kwekugadzirira kwetafura yakadaro kwakasiyana zvishoma - iwe unofanirwa kuisa chinongedzo kune iyo yakawanda mari pamusoro pehuwandu hwehuwandu. Tevere, isu tinoita matanho aya:

1. Rekodha sarudzo dzemutengo wetsetse mumwe uchireva mari - yega yega mutengo isero rimwe chete.
2. Sarudza huwandu hwemasero.

6.

1. Vhura iyo tafura yetafura yedata, sekunge kana ichirova imwe musiyano
2. Kutsiva muhuwandu "kuti utange kukosha pamakoramu mu ..." Sero nemutengo wekutanga.
3. 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.

7 Kuwedzera kwekuverenga kwemashiti ane matafura e data

Kana gadziriso yekukurumidza ichidikanwa mukirowa yedata iyo isingamhanyi rese bhuku redzidziso, unogona kuita akati wandei zviito zvekumhanyisa maitiro.

1. Vhura iyo parameter hwindo, sarudza clause "formula" mumenu kurudyi.
2. Sarudza chinhu icho "otomatiki, kunze kwematafura ematafura" mu "kuverenga mubhuku" chikamu.

sere

1. Ita kudzikiswa kwemhedzisiro yacho mundiro yemunhu. Kune izvi iwe unofanirwa kuratidza mafomula uye dzvanya iyo F kiyi

Zvimwe Zvishandiso Zvekuita Kuongorora Kuongorora

Chirongwa ichi chine zvimwe zvishandiso zvekubatsira kuita kuongorora kwekunzwa. Ivo vanozvitakura zvimwe zviito izvo zvaizofanira kuitwa nemaoko.

1. "Kusarudzwa kweParamende" basa rakakodzera kana mhedzisiro yaunoda kuzivikanwa, uye inodikanwa kuti uwane kukosha kwekuisa kwekuisa kweiyo inoshanduka kuti uwane mhedzisiro yakadaro.
2. "Solution yekutsvaga" inowedzera-yekugadzirisa matambudziko. Izvo zvinodikanwa kuti ugadzire zvisingakwanisi uye uratidze, mushure maizvozvo hurongwa huchawana mhinduro. Mhinduro yacho inotarisirwa nekuchinja tsika.
3. 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:

pfumbamwe

Kuongororwa kwekunzwa kweiyo purojekiti yekudyara muExcel

Nzira yekuongorora kunzwa mumunda wekudyara

Kana 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:

1. Yakachena iripo kukosha - inoverengwa nekubvisa saizi yekudyara kubva kune huwandu hwemari.
2. Muyero wemukati wekushandisa / purofiti - zvinoratidza kuti ndeipi purofiti inodiwa kubva pakudyara kwegore.
3. Iyo yekubhadhara chiyero ndeye chiyero cheese purofiti kune yekutanga mari yekudyara.
4. Discounted purofiti index - inoratidza kushanda kwekudyara kwekudyara.

Formula

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.

1. Izvo zvinodikanwa kuziva mhedzisiro iri pasi pemamiriro ezvinhu.
2. Isu tinotsiva imwe yemhando dzakasiyana uye dzinotevera mhedzisiro yemhedzisiro.
3. Verenga iyo inoshandurwa muzana inoshandurwa mune maviri parameter zvichienderana nemamiriro akagadzwa.
4. Isu tinoisa muzana muzana yakawanikwa mune formula uye tinosarudza kunzwa kwekunzwa.

Muenzaniso wekuongorora kwekunzwa kweiyo purojekiti yekudyara muExcel

Kunzwisisa kuri nani kwehunyanzvi hwekuongorora, muenzaniso unodikanwa. Ngationgororei purojekiti ine data rinozivikanwa kwazvo:

10

1. Zadza tafura kuongorora chirongwa ichi pairi.

gumi neimwe

1. 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.

12

1. 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.

13

1. Gadzira chikamu chehuwandu hwehuwandu idzo nguva apo chirongwa ichi chabhadhara.

gumi neina

1. Verenga iyo yekubatsira kwekudyara. Izvo zvinodikanwa kuti ugadzire chirevo, uko purofiti mune imwe nguva yenguva yakakamurwa mukutanga mari.

gumi neshanu

1. Sarudza iyo kuderedzwa coefficient yeiyi formula: = 1 / (1 + disc.%) ... nhamba.

gumi nenhanhatu

1. Verenga kukosha kwazvino nekuwedzera - kuyerera kwemari kunowedzerwa nemutengo wekutora.

17.

1. Verenga pi (purogiramu index). Iko kukosha kwakapihwa muchikamu chenguva chakakamurwa kuita zvakabatanidzwa pakutanga kwekusimudzira kweprojekiti.

gumi nesere

1. 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 muExcel

Chinangwa chekuongororwa kwakadaro ndechekukamura kusiyanisa kwehukuru hwehukuru hwezvinhu zvitatu:

1. Kusiyanisa nekuda kwekumanikidza kwetsika.
2. Shanduko nekuda kwehukama hwehukama hunoitisa.
3. 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.

gumi nepfumbamwe

1. Isu tinowana iyo "data" tab "data" chombo uye vhura hwindo rayo. Rondedzero yacho inoda kusarudza imwe-factor inopararira yekuongorora.

makumi maviri

1. Zadza mitsara yebhokisi dialog. Iyo inlet kupindirana ndeye masero ese asina kufungira manhamba nenhamba. Isu takatarisana nemakoramu. Taura mhedzisiro pane imwe nyowani.

21.

Sezvo kukosha kwero muyero yakakura kupfuura iyo unit, tinogona kufunga kufungidzira kweiyo isiriyo - hapana hukama pakati pedzidzo nemaitiro mukukonana.

Kuongorora kwechokwadi muExcel: muenzaniso

Isu tinoongorora hukama pakati pematare mumunda wekutengesa - zvinodikanwa kuti tizive zvinhu zvakakurumbira uye zvisina kujairika. Ruzivo rwekutanga:

22.

1. 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).

23.

1. Verenga kukura kwekuda kwezvinhu mune muzana: = kana (kukura / yakazara 2 = 0; kuderedzwa / huwandu 2; kureba / yakazara 2).

24.

1. 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.

25 maviri-factor anopararira kuongororwa muExcel

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.

1. Vhura "kuongorora kwedata", iwe unofanirwa kuwana maviri-factor ekuongorora pasina kudzokorora.
2. Inpt Interval - masero ipo data iri mairi (isina ngowani). Isu tinounza zvaizoitika kune iyo nyowani pepa uye tinya "OK".

27.

Iyo chiratidzo f yakakura kupfuura iyo f-yakaoma - izvi zvinoreva kuti pasi inokanganisa huwandu hwekuita kurira.

28.

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.