Kutarisira bhuku reakaundi kunogona kutora nguva, uye izvi zvinogadzirwa kugadzira kurongeka mune chero chikamu chehupenyu. Zvichipa izvi, ipfungwa yakanaka kuziva sei dzidza Excel nekukurumidza uye kudzora mamiriro ese chii chinoitika.
Kune avo vachiri kukahadzika. Microsoft Excel chishandiso chakagadzirirwa kutarisira uye kugadzira mhinduro data risati rasimudzwa. Mukuwedzera, yakakamurwa kuva mapepa emabhuku kuchengetedza sangano rakakwana rakapoteredza mabasa.
Kana zvichikwanisika kuchengetedza data senge: mazita, zvidzidzo, mabasa, invoice, zvinyorwa zvekutumira, mubhadharo wakaitwa kana kuitwa. Zvakare, iyo yakanakira modhi kuwana mhinduro dzemasvomhu kubva pakuvhiya kuri nyore.
Ndezvipi zvakakosha zvinobatwa neExcel?
Chimwe chezvinhu zvakabata pfungwa dze Vashandisi veMicrosoft ndizvo zvirongwa zvavo uye zvigadzirwa zvinogona kubatwa pasina kudiwa kwenguva yakawanda yekudzidza. Vanhu havafanirwe kuenda kumakosi akawanda kuti vanzwisise.
Saka, zvinoreva here izvozvo Excel senge zvese zvishandiso inobata zvakakosha sarudzo dzakagadzirirwa munhu wega wega.
- Mitsara inoparadzaniswa nemaseru kuitira kuti rimwe nerimwe riite basa rakasiyana.
- Mitsara yakawanda kana maseru anogona kubatanidzwa pamwe chete kugadzira yakakura fomati mhedzisiro.
- Paunenge uchidhinda mabasa, maseru kupatsanurwa haaonekwe.
- Imwe mari inogona kuwedzerwa mukushanda kuti uwane mibairo yehupfumi.
- Kana faira rachengetwa rinogona kushandiswa zvakare.
- Chero ani ane Excel achave nemukana wekuishandisa pakombuta yake.
- Zvinokwanisika kugadzira sangano rezvinyorwa uye ruzivo runobva pane alphabet.
Nzira yekushandisa sei Excel zvinobudirira?
Kuti ubatanidze ruzivo runoshanda rweExcel, zvinodikanwa kukunda mu macode ayo mudziyo unobata. Zvinosanganisira kugadzirisa kune alphanumeric musanganiswa kuti uone kuti ndeipi oparesheni ichanyanya kushanda.
- Ctrl + A: Ipa bhokisi kuti uvhure gwaro
- Ctrl + B: Inounza iyo faira browser muExcel
- Ctrl + C: Nenzira yekukurumidza inobata kopi yemasero akasarudzwa
- Ctrl + D: Inokutendera kuti ukope kurudyi fomula yemasvomhu yemhando yakasarudzwa
- Ctrl + E: Inopa mukana wekusarudza sero rega repepa rakashandiswa
Neaya mapfupi ekhibhodi zviri nyore kuwana rubatsiro rwakajeka munzvimbo yekubata Excel nekukurumidza.
Iva nyanzvi yeExcel
Zviri pachena kuti neusiku humwe, munhu haazokwanisi kuva yakazara excel nyanzvi. Nekudaro, kana paine mukana wekudzora zvirimo zvinoratidzwa panguva chero chiitiko chiri muchishandiso.
Nekune rimwe divi, kana paine matanho ekutevera kubata Excel nekukasira nekukasira uye kugona zvese zve iyi modhi kubva kuMicrosoft.
- Iwe unofanirwa kudzidza mirairo nesero kuti uwane mibairo yekushanda
- Gadzirisa yekutanga-ruoko rudzi rweakaundi inodhirowa
- Gadzira mapepa mafomati kuti upinde zvakananga chiitiko
- Ronga nemaarufabheti mabasa ekupa
- Usaite nyonganiso pakati pemainvoice nemaodha ekutumira
- Sevha mamwe mabasa kuti uve nemainvoice
Mukuwedzera, zvinodikanwa kuratidza izvo zvekutarisa zvidzidzo zvekushandisa Excel zvichabatsirawo zvinobudirira.