Nzira yekubvisa sei muExcel? Mukati meichi chinyorwa, tinokusiira iwe yakazara uye yakadzama dzidziso pazviri.
Excel spreadsheets
Excel ndiyo imwe yemapurogiramu ane yakanakisa calculation processor iripo, mukati mayo tinogona kuita akawanda maoperation, kubva pane akanyanya kukosha, akadai sekuwedzera, kubvisa, kupatsanura uye kuwanda kwedata, kune iyo yakanyanya kuoma kunzwisisa.
Iwo maspredishiti mamwechete, anoshanduka kuve anoshanda zvakanyanya, sezvo achitipa chaiwo mhedzisiro yenhamba yekushanda, nekuwedzera kune iyo isu tinogona kuona iyo graphic inomiririra yeakataurwa data, kana tichiida.
Kutaura zvazviri, kukwanisa kushandisa Excel tool inogona kuva basa rakaoma pakutanga, asi chaizvoizvo, nekudzidzira uye ruzivo rwakawanikwa mukati mechirongwa chimwe chete, tinogona kuita mabasa aya nyore uye nekukurumidza, pamakombiyuta edu.
Zvakare, isu tinofanira kutaura kuti isu hatigone kushandisa chishandiso chimwe chete ichi mukati meWindows makomputa, asiwo mukati memakomputa eMacOS, nekuti pane vhezheni inoenderana neApple system. Asi hey, pasina imwe ado, ngatidzikei kubhizinesi.
Unogona kubvisa muExcel?
Chaizvoizvo mukati meExcel system, hapana chairo basa ratinogona kubvisa naro, pamwe nebasa re "Chamakura”, iyo inotsanangurwa mukati mechirongwa, asi hazvireve kuti haigone kubviswa. Saka kunyangwe basa racho rikasawanikwa, kana richikwanisa bvisa mukati excel.
Iyo nzira yekubvisa muExcel
Iyi nzira yatinozopa kwauri kutanga, ndiyo iri nyore kushandisa mukati mechirongwa, nekuda kweizvi isu tichashandisa basa rekuwedzera, tichingoisa kukosha kwakashata.
Muenzaniso: = SUMA(10,-3), neiyi fomula, unogona kuita kuverenga kuri nyore, kuwana mhedzisiro yekubvisa, bone 7.
Muchiitiko ichi, zvatinenge tawana kuita kubviswa kwakavanzika, sekunge kuri kuwedzera.
Zviri nyore here? nenzira iyoyo unogona bvisa muexcel uchishandisa basa rekuwedzera.
Nzira yekubvisa ine maseru akati wandei
Iyi ndiyo imwe nzira yatinogona kubvisa nayo muExcel, kana tiine maseru akati wandei ekuita oparesheni nawo.
Muenzaniso: = A1+B1-C1-D1, kuisa iyi fomula, zvese zvakakosha zviri mukati memasero akatarwa, zvichawedzerwa kana kubviswa, zvichienderana nenhamba chiratidzo, chiri pamberi pavo.
Ndizvo! Very nyore, handiti? Saizvozvowo, unogona bvisa maseru akawanda muexcel. Pasina kukosha kwekushandisa iyo yekuwedzera basa, kungowedzera zvisina kunaka kana zvakanaka zviratidzo.
Nzira yekubvisa muExcel ine IM.SUSTR basa
Ichi chimwe tingabvisa sei muExcel, nokuda kwayo tichashandisa IM.SUSTR basa. Kutendeseka, basa iri harizivikanwi uye rinoshandiswa, asi naro tinokwanisa kuita zvikukutu pasina dambudziko.
Nokuda kweizvi tinoda kunyora maitiro maviri mumasero akasiyana.
Muenzaniso: Mukati mesero A1 kukosha kwe23 kuchaiswa, zvino muchitokisi B1 tichaisa kukosha kwe7, ipapo muchitokisi C1 tichanyora basa reIM.SUSTR uye tichava nechimwe chinhu chakadai: = IMSUSTRI(A1,B1).
Zvadaro purogiramu imwe chete ichaita basa rekubvisa masero ose, kunyange isu tichifanira kufunga kuti nenzira iyi, tinogona chete kuita maoparesheni nenhamba mbiri kana maitiro panguva imwe chete.
Ndizvo! Super nyore, nenzira iyoyo unenge watowana bvisa muExcel uchishandisa iyo IMSUSTR basa.
Bvisa nhamba kubva muzvikamu zvakasiyana-siyana
Kuti uwane bvisa manhamba kubva muchikamu chemasero muexcel, tinofanira kutevera nzira yekutanga yakatsanangurwa, zviri nyore, tinotora sum function, nayo, tinoisa nhamba yenhamba data, inoparadzaniswa ne + kana - chiratidzo.
Muenzaniso: = SUM(33,-23,53,-13,203), neizvi tinotora huwandu hunosanganisira hutsika husina kunaka, ipapo Excel inozofunga nezvechiratidzo chenhamba yega yega uye kuita kuwedzera kana kubvisa, sezvakakodzera panguva ino. . Saizvozvo, mushure mekuita oparesheni, ichatipa mhedzisiro inoenderana, kazhinji mhedzisiro inoratidzwa musero pazasi, kubva kwatakapinda basa. Kana kutadza izvozvo, muchitokisi isu pachedu tinoratidza mhedzisiro.
Ready! Ndidzo dzese nzira, dzaunogona kuwana kushandisa chero nguva yaunoda bvisa muexcel, kudivi rako zvinosara kuratidza kuti ndeipi inonyatsokodzera zvauri kutsvaga uye nekuishandisa.
zvimwezvo
Pano tinokupawo a rondedzero yezvinhu zvaunofanira kuziva nezveExcel, usati waishandisa seyaunofarira computational nzira. Izvo zvakafanana curiosities ndezvinotevera:
- Mukati meExcel, unogona kuita marudzi ese ekuverenga zvemari, kunyangwe iwo akaomarara akadai seyemvura iripo kukosha kana kuverenga Payback.
- Excel inogona zvakare kushandisa mafomula akaiswa kune hunhu hunosarudzwa nemushandisi mune yega yega kesi.
- Mukati memudziyo, unogona kushanda uye kuona akasiyana maspredishiti panguva imwe chete, ayo anogona kunyatso batsira maererano nekugadzirisa nguva nebasa.
- Mariri iwe unogona kuita kudzokorora mabasa otomatiki, izvo zvinogona kukuchengetedza iwe yakawedzera nguva, kana uine mabasa akafanana kana anodzokororwa.
- Rimwe remabasa makuru eExcel uye rimwe rinonyanya kutsvakwa nevashandisi kugona kwayo kugadzira matafura ane simba, kwatinogona kushanda neruzivo rwekukurumidza, runoshanda uye nenguva.
- Mukati meExcel, isu tinewo mukana wekugadzira magirafu, anonzi Dashboards, aya anogadziridzwa otomatiki, sezvo data rinowedzerwa kana semagadzirirwo anoitwa nemushandisi..
Ndizvo chete zvechinyorwa ichi! Tinovimba takajekesa imwe neimwe yekusahadzika kwako, pamusoro nzira yekubvisa muExcel. Chero chinhu, iwe unogona kuzvisiya zvichiratidzwa mumashoko.