Excel inopa akawanda maturusi ekudzora kutaridzika kwebhuku rebasa. Muchidzidzo chekupedzisira, takatodzidza kuomesa mitsara nemakoramu. Mune izvi, tichatarisa maturusi akati wandei anotendera iwe kukamura pepa muzvikamu zvakati wandei, pamwe nekuona gwaro mumahwindo akasiyana.
Kana bhuku rekushanda reExcel riine huwandu hukuru hwe data, zvingave zvakaoma kumepu zvikamu zvakasiyana. Excel ine dzimwe sarudzo dzinoita kuti zvive nyore kunzwisisa uye kuenzanisa data. Semuenzaniso, unogona kuvhura bhuku muhwindo idzva kana kupatsanura pepa munzvimbo dzakasiyana.
Kuvhura bhuku razvino pahwindo idzva
Excel inokubvumira kuti uvhure bhuku rimwe chete rekushanda mumahwindo akawanda panguva imwe chete. Mumuenzaniso wedu, tichashandisa chimiro ichi kuenzanisa mapepa maviri ekushanda akasiyana mubhuku rekushanda rimwechete.
- Baya maonero paRibhoni, wobva wasarudza murairo Hwindo idzva.
- Hwindo idzva richavhurika rebhuku razvino.
- Iye zvino unogona kufananidza mapepa ebhuku rimwe chete mumahwindo akasiyana. Mumuenzaniso wedu, isu tichasarudza iyo 2013 sales report kuenzanisa kutengesa muna 2012 uye 2013.
Kana uine akati wandei mahwindo akavhurika, unogona kushandisa rairo Ronga Zvose kukurumidza kuunganidzwa kwemahwindo.
Kuparadzanisa pepa munzvimbo dzakasiyana
Excel inokutendera kuti uenzanise zvikamu zvepepa rebasa rimwechete pasina kugadzira mamwe windows. Team Kugovana inokutendera iwe kukamura pepa munzvimbo dzakasiyana dzinogona kupepetwa zvakazvimiririra kune mumwe nemumwe.
- Sarudza sero paunoda kupatsanura pepa. Kana ukasarudza sero mumutsara wekutanga kana mutsara wekutanga, ipapo pepa richaparadzaniswa kuva 2 zvikamu, kana zvisina kudaro richaparadzaniswa kuva 4. Mumuenzaniso wedu, tichasarudza sero C7.
- Baya maonero paRibhoni, wobva wadzvanya murayiro Kugovana.
- Iyo pepa ichakamurwa munzvimbo dzinoverengeka. Unogona kupururudza munzvimbo imwe neimwe zvakasiyana uchishandisa ma scrollbar. Izvi zvinokutendera kuti uenzanise zvikamu zvakasiyana zvepepa rimwechete.
Iwe unogona kukweva zvipatsanuri zvakamira uye zvakachinjika kuti usaze chikamu chega chega. Kuti ubvise kupatsanurwa, dzvanya murairo zvakare Kugovana.