Isu tinowanzo kudaidza imwe neimwe Excel faira sespredishiti. Zvinobatsira kunzwisisa kuti spreadsheet muExcel haina kusiyana nespredishiti. A spreadsheet muExcel software inogona kunyatso kurerutsa mamwe mabasa ezuva nezuva kwauri, kumba uye mubhizinesi rako.
Muchikamu chino, tichakudzidzisa mashandisiro aungaita mamwe ekutanga pfungwa dzechishandiso.
Chii chinonzi spreadsheet muExcel?
Iro pepa rekushanda rinongova tebhu muExcel faira.
Iwe unogona kunge uchiziva kuti humwe hunyanzvi hunodiwa mazuvano mumakambani ndiko kugona kweExcel, asi isu tinogona kukuvimbisa kuti kudzidza mabasa ayo ese kunoda imwe nguva uye pamusoro pese simba.
Kugadzira maspredishiti muExcel, kana watova muExcel interface, ingoisa tebhu nyowani. Unogona kusarudza sarudzo yekushandisa nzira yekudimbudzira kiibhodhi Shift + F11 kana kudzvanya pakanzi "+" padivi pezita rebepa rebasa.
Nzira yekufambisa sei pakati pemashizha?
Isu kazhinji tine dhatabhesi akati wandei kana ruzivo rwakasiyana, uye izvi zvinofanirwa kuiswa mumatabu akasiyana kana maspredishiti kuti zviite kurongeka kwebasa. Kuti ufambe pakati pematabhu kana mashiti, unogona kudzvanya-kuruboshwe pane yega yega tebhu kuti uvhure, kana kushandisa nzira yekudimbudzira CTRL + PgDn kuenda kumberi kana CTRL + PgUp kudzokera kumashure.
Nguva zhinji waifanira kuwedzera matafura akafanana mumapepa ekushanda akasiyana uko chete data inosiyana. Mamiriro ezvinhu akadai akajairika pakati pevanhu vanoshanda ne periodic cheki (zuva nezuva, vhiki nevhiki, pamwedzi). Saka zvakakosha kuziva nzira yekuaronga kuitira kuti rumwe ruzivo ruwanikwe nyore.
Nzira yekushandisa sei mavara mune spreadsheet?
Paunenge uchishanda nematabhu / mashiti akawanda, imwe sarudzo yekuparadzanisa nzvimbo dzine hukama, kana kutoona kusiyanisa imwe neimwe yedata, ndeye kushandisa mavara akasiyana pachinhu chimwe nechimwe. Kuti uite izvi, unogona kungodzvanya-kurudyi pamutsara, koramu, kana seti yemaseru, wobva wadzvanya-kurudyi wosarudza "zadza ruvara", wozosarudza ruvara rwaunoda kune chinhu chiri mubvunzo.
Nzira yekubatanidza sei mapepa ekushanda muExcel?
Mushure mekuisa dhatabhesi yako mumaspredishiti, zvinonakidza kuita mashandiro akadai sehuwandu hwehuwandu hwakaratidzwa, kuverenga kwezvikamu zvichashandiswa, uye mamwe akawanda data aungade, uye boka kuita maseru muspredishiti rako.
Kana izvozvo zvangoitwa, iwe unofanirwa kudzidza kugadzira mafomula kubva kune data rauinaro. Semuenzaniso, kukosha kwezvigadzirwa pamutsara 1 wepeji rekupfupisa repurazi richava huwandu hwekukosha kwezvigadzirwa pamutsara 1 weimwe neimwe data yebasa rezvikwata, zvichingodaro kune ruzivo rwakakodzera. kumutsara wega wega uye koramu yekudzora sheet yako.
Iwe unogona zvakare kudzidza kushandisa machati uye magirafu kududzira zvirinani zvawawana. Chinangwa chegirafu, sekureva kunoita zita, ndechekupa ratidziro yemifananidzo yakakosha data, yekuona zvirinani zvemhedzisiro yakawanikwa.
Mukupedzisa
Iwe unonzwa sei kana iwe ukaona kuti Excel chinhu chinodiwa pamusika webasa wanhasi? Kana iwe uchivhiringwa nemamwe mabasa uye usingazive maitiro ekushandura iyo data kuti ive ruzivo rwakakosha, usazvinetse, unogona kudzidza kushandisa Excel zvinobudirira, uye kune emahara ekudzidzisa mavhidhiyo yakanyorwa pane yedu saiti. Ivo vanobva kumapuratifomu makuru ekufunda.
