Chimwe chezvinhu zvinonakidza kwazvo muMicrosoft Excel chirongwa chekutsvaga mhinduro. Panguva imwecheteyo, inofanira kucherechedzwa kuti chishandiso ichi hachigone kuzivikanwa kune yakakurumbira pakati pevashandisi mune iyi application. Uye pasina. Mushure mezvose, ichi chimiro, kushandisa iyo yekutanga data, nekudzima, inowana mhinduro yakakwana kubva kune zvese zviripo. Ngatitsvagei kushandisa mashandisiro okugadzirisa mhinduro muMicrosoft Excel.
Gonesa basa
Iwe unogona kutsvaga kwenguva yakareba pane iyo ribhoni, uko mhinduro iri kuwanikwa, asi kwete kuwana chishandiso ichi. Zviri nyore, kuita kuti chinhu ichi, iwe unofanirwa kugonesa mumamiriro ezvirongwa.
Kuti udzore kutsvaga kwekutsvagisa mhinduro muMicrosoft Excel 2010, uye gare gare, enda ku "Faira" tab. Kwa 2007, iwe unofanirwa kudzvanya paMicrosoft Office bhatani mukona yekuruboshwe yewindo. Muhwindo rinovhura, enda kune "parameter" chikamu.
Muwindo rekusarudza, tinya pane "Supertructure". Mushure mekushanduka, pazasi pepahwindo, pamberi pepairamende yekutonga, sarudza iyo "Excel Wedzera-pane" kukosha, uye tinya pane bhatani "enda".
Hwindo rinovhura nema superstructures. Isu tinoisa tick yakatarisana nemazita ekuwedzera-mukuda - "mhinduro mhinduro". Dzvanya pane "OK" bhatani.
Mushure meizvozvo, bhatani rekutanga iyo Solutions kutsvaga basa ichaonekwa pane excel tepi mune data tebhu.
Kugadzirira Tafura
Zvino, tapedza kuita basa racho, ngationgororei kuti zvinoshanda sei. Zviri nyore kuzviisa pasi pomumwe muenzaniso. Saka, tine tafura yemubhadharo yevashandi vebhizinesi. Isu tinofanirwa kuverenga mubairo wemushandi wega wega, iyo iri mubairo yakaratidzwa mune imwe ikhoramu, kune imwe coacffient. Panguva imwecheteyo, huwandu hwakazara hwemari yakagoverwa mubairo ndeye 30000 rubles. Iyo sero umo mari iyi izere izita rechinangwa, sezvo chinangwa chedu ndechekusarudza iyo data yeiyi nhamba.
Iyo coefficient iyo inoshandiswa kuverenga huwandu hwemubairo, isu tinofanirwa kuverengerwa kushandisa sarudzo-yekuwana mhinduro. Sero racho riripo rinonzi rinodiwa.
Iyo inotarisirwa uye sero raunoda rinofanirwa kuve rakabatanidzwa nemumwe uchishandisa formula. Mune zvatakangoitika, formula iri muchitokisi chakanangwa, uye ine fomu inotevera: "= C10 * $ G $ 3", uko $ G $ 3 izita repamusoro rechitokisi chaunoda, uye "c10" - Mari yakazara muhoro kubva kune iyo premium yakaverengerwa vashandi vebhizinesi.
Mhanya tumple mhinduro mhinduro
Mushure mekunge tafura yakagadzirirwa nekuva mu "data" tab, tinya pane "Solution yekutsvaga" bhatani, iyo iri patepi mu "Ongorora" Toolbar.
Iyo paramende hwindo inovhura iyo data inofanirwa kuwedzerwa. Mu "Optimize chinangwa basa" munda, iwe unofanirwa kupinda iyo kero yechitoro chinonongedzo, uko huwandu hwemberi hwembairo kune vese vashandi vachange vari. Izvi zvinogona kuitwa kana kudhindwa nehurongwa hwemanomo, kana nekudzvanya pane bhatani riri kuruboshwe kwedare rekusuma kwedata.
Pashure paizvozvo, hwindo remuparamende richauya, uye iwe unogona kusarudza iyo sero raunoda retafura. Zvadaro, iwe unofanirwa kudzvanya zvakare pamwe bhatani rimwe chete kuruboshwe rwechimiro nedatha rakapinda kuti ubvise kuhwindo paramende zvakare.
Pasi pehwindo nekero yeiyo tarisiro yesero, iwe unofanirwa kuseta maratidziro ehunyanzvi huchave mariri. Izvi zvinogona kuve zvakapfuura zvishoma, kana kukosha kwakananga. Kwedu isu, ichava yekupedzisira sarudzo. Naizvozvo, isu tinoisa kuchinjika ku "kukosha" chinzvimbo, uye mumunda kuruboshwe kwazvinorerwa nhamba makumi matatu. Sezvatinoverenga, ndiyo nhamba iyi yemamiriro ezvinhu anoumba huwandu hwemubairo kune vese vashandi ve Bhizinesi.
Pazasi ndeye "kuchinjisa sero kuchinja" munda. Pano iwe unofanirwa kutsanangura kero yesero raunoda, uko, apo patinoyeuka, pane coefficent, kuwanda kwemubhadharo mukuru uchaverengerwa huwandu hwemubairo. Kero iyi inogona kufuratirwa nenzira dzakafanana sezvatakaitira sero rinotarisirwa.
Mu "zvinoenderana nezvinogumira", unogona kuseta mimwe miganho yedata, semuenzaniso, kuita tsika seyakaenzana kana isiri-isina kunaka. Kuita izvi, tinya pane "Wedzera" bhatani.
Mushure meizvozvo, iyo yakawedzera ganhuro hwindo rinovhura. Mu "chinongedzo kumasero" munda, isu tinonyoresa masero emasero ane hukama umo kurambidzwa kwacho. Kwedu isu, iyi ndiyo sero raunoda neiyo coefficient. Tevere, isa chiratidzo chaunoda: "Zvishoma kana zvakaenzana", "zvakanyanya kana zvakaenzana", "akaenzana", "nhamba", "Binary", et. Kwedu isu, tichasarudza iyo "yakakura kana yakaenzana" chiratidzo kuti iite iyo coefficient yenhamba yakanaka. Saizvozvo, mu "kurambidzwa" munda, taura nhamba 0. Kana isu tichida kugadzirisa imwezve kurambidzwa, tobva tadzvanya pane bhatani rekuwedzera. Mune iyo yakatarisana kesi, tinya iyo "OK" bhatani kuti uchengetedze iyo yapindwa.
Sezvatinoona, mushure meizvozvo, kurambidzwa kunoonekwa mumunda wakakodzera wemugumo wekutsvaga paramita. Zvakare, ita zvakasiyana-siyana zvisiri-zvisina kunaka, unogona kuseta bhokisi rekutarisa padyo neiyo inoenderana paramende ingori pazasi. Izvo zvinodikanwa kuti paramende yakaiswa pano haina kupokana neiyo yaunonyoreswa mune zvausingakwanisi, neimwe nzira, kupokana kunogona kuitika.
Zvimwe zvigadziriso zvinogona kuiswa nekudzvanya pane "parameter" bhatani.
Pano iwe unogona kuseta chokwadi chechirambidzo uye miganhu yemhinduro. Kana iyo data yaunoda yapinda, tinya pane "OK" bhatani. Asi, kwatiri, iwe haufanire kuchinja aya paramita.
Mushure mekunge marongero ese akaiswa, tinya pane "Tsvaga mhinduro" bhatani.
Tevere, chirongwa cheEncel mumasero anoita kuverenga kwakakodzera. Panguva imwe chete nekuburitswa kwemhedzisiro, hwindo rinovhura mauri iwe unogona kana uchichengetedza mhinduro yakawanikwa, kana kudzoreredza iyo sosi tsika nekumisazve iyo switch kune yakakodzera chinzvimbo. Pasinei nesarudzo yakasarudzwa, kuisa iyo bhokisi rekutarisa "Dzokera kuParamende Dialog Bhokisi", iwe unogona zvakare kuenda kumhinduro yekutsvaga yekutsvaga. Mushure memabhokisi ekutarisa uye switches akaiswa, tinya pane "OK" bhatani.
Kana pane chero chikonzero chekutsvaga mhinduro dzemhinduro hadzikugutse iwe, kana paunoverenga chirongwa ichi, chirongwa ichi chinopa chikanganiso, ipapoka, mune ino nyaya, inotsanangurwa pamusoro munzira, mune yeparamende dialog box. Kudzokorora data rese rakapinda, nekuti zvinogoneka kumwe kukanganisa kwakaitwa. Kana kuti chikanganiso chisina kuwanikwa, wobva waenda ku "Sarudza mhinduro nzira" paramende. Inopa mukana wekusarudza imwe yenzira nhatu dzekuverenga: Nekusarudzika, iyo yekutanga nzira inoshandiswa. Isu tinoedza kugadzirisa basa racho, kusarudza chero imwe nzira. Panyaya yekutadza, isu tinodzokorora kuedza kushandisa nzira yekupedzisira. Zviito zveAlgorithm zvichiri zvakafanana kuti takatsanangura pamusoro.
Sezvauri kuona, kutsvaga kwebasa kune mhinduro inonyanya kufadza chishandiso icho, nekushandiswa kwakakodzera, kunogona kuchengetedza zvakanyanya nguva yemushandisi pane dzakasiyana siyana kuverenga. Nehurombo, kwete mushandisi wese anoziva nezvehupenyu hwake, kwete kutaura kodzero yekugona kushanda neiyi mashura. Mune chimwe chinhu, chishandiso ichi chakafanana nebasa rekuti "kusarudzwa kweparamende ...", asi panguva imwe chete, ine misiyano yakakosha nayo.