Kusintha ndi kuchotsa deta mu Excel ndi ntchito yosapeŵeka. Ngati pali chiwerengero chochepa cha deta, ndiye kuti sipadzakhala mavuto ndi kusintha kapena kuwachotsa. Ngati mukufunika kusintha kusintha kwakukulu, ndiye kuti mudzafunika khama lochulukirapo. Ndipo n’zotheka ndithu kuti pochita zimenezi mudzalakwitsa zinthu zambiri.
Njira yochotsera zobwereza mu Excel ikhoza kukhala ntchito yosavuta, koma yowononga nthawi. Mwamwayi, chida ichi ndi chosavuta kugwiritsa ntchito komanso chothandiza, kotero chikhoza kukuthandizani kuyendetsa mizere ingapo nthawi imodzi.
Excel imapereka zida zitatu zothana ndi zobwereza. Wina amawachotsa, wachiwiri amawazindikiritsa, ndipo wachitatu amakulolani kusefa. Lero ndikuwonetsani momwe chida chochotsera chobwereza chimagwirira ntchito popeza ntchitoyi ndi imodzi mwantchito zodziwika kwambiri mu Excel.
Zofunikira: Muyenera kulinganiza deta mu Excel
Muchitsanzo chotsatira cha kitchenware, muwona momwe mungachotsere mizere yobwerezedwa mosavutikira. Yang'anani pa data yanga:
Ma tableware onse amapangidwa molingana ndi tsiku ndi dziko lomwe amapangidwira. Zotsatira zake, ndinamaliza ndi zobwereza 3: mbale (mbale), ma flaski (mitsuko) ndi mbale za shuga (mbale za shuga) zomwe sindikufuna kuziwona kawiri patebulo.
Kuti muyike mulingo woyenera, dinani kumanja pa selo iliyonse yokhala ndi data, pitani ku tabu Kuika (Ikani) ndikusankha Table (Table). Ndikofunikira kwambiri kuyang'ana mndandanda wa data womwe wasankhidwa pano. Ngati zonse zili zolondola, dinani Chabwino.
Pezani ndi kuchotsa zobwereza
Kuti muchotse zobwerezedwa, ndimadina pa selo iliyonse patebulo, pitani ku tabu Deta (Deta) ndikusankha chida Chotsani Zobwerezedwa (Chotsani zobwereza). Bokosi lazokambirana la dzina lomweli limatsegula:
Zenerali limakupatsani mwayi wosankha zipilala zingapo zoti zifufuzidwe. Ndimasankha onse atatu chifukwa ali ndi zobwereza zomwe ndiyenera kuchotsa. Kenako ndimangodina OK.
Bokosi la zokambirana lomwe limawonekera pambuyo pomaliza kukonza deta likuwonetsa kuchuluka kwa ma Excel omwe adapezeka ndikuchotsedwa. Dinani OK:
Zotsatira zake, palibe zobwereza patebulo, zonse zimathamanga komanso zosavuta. Chida chochotsa chophatikizira mu Excel chidzakupulumutsirani nthawi, makamaka ngati mukugwira ntchito ndi matebulo omwe ali ndi mizere masauzande okhala ndi mitundu yosiyanasiyana ya data. Yesani nokha ndipo muwona momwe mungafikire mwachangu zomwe mukufuna.