Zosefera mu Excel - Zoyambira

Kusefa data mu Excel kumakupatsani mwayi wowonetsa pakati pazambiri zomwe mukufuna. Mwachitsanzo, kukhala ndi mndandanda wazinthu masauzande ambiri mu hypermarket yayikulu patsogolo panu, mutha kusankha ma shampoos okha kapena zonona kuchokera pamenepo, ndikubisa kwakanthawi zina zonse. Mu phunziro ili, tiphunzira momwe tingagwiritsire ntchito zosefera pamndandanda wa Excel, kuyika zosefera pamizere ingapo nthawi imodzi, ndikuchotsa zosefera.

Ngati tebulo lanu lili ndi deta yambiri, zingakhale zovuta kupeza zomwe mukufuna. Zosefera zimagwiritsidwa ntchito kuchepetsa kuchuluka kwa deta yomwe ikuwonetsedwa pa pepala la Excel, kukulolani kuti muwone zomwe mukufuna.

Kugwiritsa ntchito fyuluta mu Excel

Muchitsanzo chotsatirachi, tidzagwiritsa ntchito fyuluta ku chipika chogwiritsira ntchito hardware kuti tiwonetse ma laputopu ndi mapiritsi okha omwe akupezeka kuti awonedwe.

1. Sankhani selo iliyonse patebulo, mwachitsanzo selo A2.

Kuti kusefa kugwire bwino ntchito mu Excel, tsamba logwirira ntchito liyenera kukhala ndi mzere wamutu womwe umagwiritsidwa ntchito kutchula gawo lililonse. Muchitsanzo chotsatirachi, zomwe zili patsamba lantchito zimakonzedwa ngati mizati yokhala ndi mitu pamzere woyamba: ID #, Mtundu, Kufotokozera kwa Iron, ndi zina zotero.

1. Dinani Deta, kenako dinani lamulo fyuluta.
2. Mabatani a mivi amawonekera pamitu ya gawo lililonse.
3. Dinani batani loterolo m'gawo lomwe mukufuna kusefa. Kwa ife, tidzagwiritsa ntchito fyuluta ku gawo B kuti tiwone mitundu yokha ya zida zomwe tikufuna.
4. Zosefera menyu zidzawonekera.
5. Chotsani cholembera m'bokosilo Sankhani zonsekuti musasankhe zinthu zonse mwachangu.
6. Chongani mabokosi a mitundu ya zida zomwe mukufuna kusiya patebulo, kenako dinani OK. Mu chitsanzo chathu, tidzasankha Malaputopu и mapiritsikuwona zida zamitundu imeneyo zokha.
7. Deta ya data idzasefedwa, ndikubisa zonse zomwe sizikugwirizana ndi zomwe mukufuna. Muchitsanzo chathu, ma laputopu ndi mapiritsi okha ndi omwe adatsalira.

Kusefa kungagwiritsidwenso ntchito posankha lamulo Sinthani ndi zosefera tsamba Kunyumba.

Ikani zosefera zingapo mu Excel

Zosefera mu Excel zitha kufotokozedwa mwachidule. Izi zikutanthauza kuti mutha kugwiritsa ntchito zosefera zingapo patebulo limodzi kuti muchepetse zotsatira zosefera. Muchitsanzo chapitachi, tasefa kale tebulo kuti tiwonetse ma laputopu ndi mapiritsi okha. Tsopano ntchito yathu ndikuchepetsa zambiri ndikuwonetsa ma laputopu ndi mapiritsi okha omwe adatumizidwa kuti awonedwe mu Ogasiti.

1. Dinani batani la muvi mumndandanda womwe mukufuna kusefa. Pamenepa, tidzayika fyuluta yowonjezera pagawo la D kuti tiwone zambiri pofika tsiku.
2. Zosefera menyu zidzawonekera.
3. Chongani kapena chotsani mabokosiwo malinga ndi deta yomwe mukufuna kusefa, ndiye dinani OK. Tidzachotsa zinthu zonse kupatulapo August.
4. Zosefera zatsopanozi zidzagwiritsidwa ntchito, ndipo ma laputopu ndi mapiritsi okha omwe adatumizidwa kuti atsimikizidwe mu Ogasiti ndiwo azikhala patebulo.

Kuchotsa fyuluta mu Excel

Mukatha kugwiritsa ntchito fyulutayo, posachedwa padzakhala kofunika kuchotsa kapena kuchotsa kuti musefe zomwe zili m'njira ina.

1. Dinani batani la muvi mumndandanda womwe mukufuna kuchotsamo zosefera. Muchitsanzo chathu, tichotsa zosefera pagawo la D.
2. Zosefera menyu zidzawonekera.
3. Sankhani chinthu Chotsani zosefera pagawo... Mu chitsanzo chathu, tidzachotsa fyuluta kuchokera pamzati Zatumizidwa kuti ziwunikenso.
4. Zosefera zidzachotsedwa ndipo zomwe zidabisidwa kale zidzawonekeranso patsamba la Excel.

Kuti muchotse zosefera zonse patebulo la Excel, dinani lamulo fyuluta tsamba Deta.