Excel iri, pahunhu hwayo, iyo chishandiso chakanakisa kugadzira maspredishiti, kubva pane akapusa sekuchengeta hupfumi hwemba, kumashizha ane data risingachawanikwi, ayo anoreva mamwe mafaera uye / kana mapeji ewebhu, dhatabhesi anoramba achigadziridzwa ayo anotendera kuenderera kwedata uye ruzivo rwekuvandudzwa mune imwe nguva.
Yese faira reExcel rakagadzirwa nemashizha uye ese machira anoumba iyo Excel faira anonzi Bhuku. Izvi zvinotibvumira gadzira akasiyana machira mune imwecheteyo faira / bhuku kuva nazvo zvese panzvimbo imwechete. Shizha rega rega rinogona kuwana iyo data rakazvimiririra kunyangwe hazvo chimiro chakafanana.
Ndokunge, isu tinogona kuve nemashiti akati wandei ayo akafanana chaizvo mukugadzirwa asi imwe neimwe inotiratidza dzakasiyana data kana otomatiki inowana data kubva kune zvimwe zviwanikwa. Asi izvi, chinhu chekutanga chatinofanira kuita ndeche teedzera iro jira rimwechete kakawanda mune imwechete faira / bhuku.
Kukopa maspredishiti akati wandei mubhuku rimwe chete, kuchengetedza dhizaini uye chimiro, tine sarudzo mbiri:
1 nzira
- Isa mbeva pamusoro pepepa ratiri kuda kuteedzera uye tinya iro bhatani rekurudyi rembeva.
- Wobva wasarudza Fambisa kana kutevedzera.
- Mubhokisi rinotevera, tinotarisa bhokisi Gadzira kopi uye isu tinosarudza chinzvimbo chichava nacho pane iyo pepa, iyo sarudzo yekuenda kumagumo iri sarudzo yakakurudzirwa, kuitira kuti iro jira nyowani riiswe seye pekupedzisira pepa rebhuku.
2 nzira
Imwe sarudzo inokurumidza uye tinya pabepa rebhuku ratiri kuda kuteedzera uye tinya bhatani rekutonga uchifambisa mbeva takananga kwatinoda kugadzira kopi yesheet iri kutaurwa.