La spreadsheet rave chishandiso chakakosha uye inonakidza kune vakawanda. Kwakaenda iyo yakakurumbira nhoroondo mushumo yakaitwa netapureta kana neNotepad uye yakawedzerwa neCasio Calculator.
Ndiwo mvura yakare iyo yakapedzwa neExcel nemabasa ayo. Asi zvinosuwisa havazi vese vanodzora kana kuziva kugona kuzere kwechirongwa ichi cheMicrosoft uye nguva yekuchengetedza iyo inogona kuburitsa kana uchishanda neichi chirongwa.
Mune ino kesi isu tashandisa Excel 2013 yekureva. Iyo vhezheni iyo vazhinji vatove nayo uye inoenderanawo neshanduro dzeramangwana, saka madhiri anogona kushandiswa muExcel 2013 uye gare gare.
Pfekera Zuva iri MuSero.
MuExcel 2013 tinogona isa zuva racho nenzira inokurumidza uchishandisa musanganiswa wekiyi dzinotevera: "CTRL +;". Iyi kiyi yekubatanidza inokutendera iwe kuti upinze iro zuva iro iro system irimo mune sero uye inozviita nenzira inomira. Musanganiswa unobatsira kana tikashandisa pepa rekuparadzira sechirevo kana invoice.
Kurumidza kufamba pakati pemabhuku nemashiti
Nzira yakanakisa yekukwirisa nzvimbo nemaakaunzi muExpcel ndeye kushandiswa kwemashizha akasiyana uye mabhuku atinogona kugadzira. Iri idambudziko kana isu tichida kufamba pakati pavo nekukasira, zvirinani idambudziko kana tikachienzanisa nekuve nedata rese mukati mekadhi rimwe chete.
Chinhu chidiki chekufamba pakati pemabhuku kushandisa "CTRL + TAB" makiyi uye kana tichida kufamba pakati pemashiti isu tinofanirwa kushandisa musanganiswa unotevera: CTRL + PEJI PASI, kufambisa peji uye CTRL + PEJI RE kuti udzokere .
Viga data renhare muExcel 2013
Iri kuramba ichiwedzera kuwanda gadzira mafomu uye bvunzo zvinoenderana nezvatinonyora, mamwe maseru anopedzwa kana kuzadzwa nemamwe data. Izvi zvinonyanya kubatsira asi dzimwe nguva kuzviita isu tinofanirwa kuvanza mamwe mafomula kana ruzivo.
Zvirinani kuitira kuti mushandisi asashandure kana kungoitira aesthetics. Kuti uwane izvi, kutanga isu tinofanirwa kusarudza sero ine data ratiri kuda kuvanza. Ipapo tinodzvanya nekiyi bhatani uye tinoenda ku «Fomati Masero».
Sarudza iyo tsika yechikwata uye mhando ";;;" Isu tinoichengeta uye ikozvino hapana chiratidzo chekukanganisa kana data rakafanana richaonekwa, rinongoonekwa sekunge sero rakanga risina chinhu.
Mhedziso
Pane mamwe manomano muExcel 2013 kuti tiite kuti tibudirire. Panogona kuve nemazana kana zviuru zvavo, asi chero zvakadaro, izvi zvitatu zvinonakidza, zvirinani kune avo vanoshanda neExcel nenzira yehunyanzvi. Haufungi here?