Momwe mungathandizire kusanthula kwa deta ku Excel: Malangizo Ogwira Ntchito

Pulogalamu ya Excel si mkonzi wamba, komanso chida champhamvu cha masamu osiyanasiyana masamu komanso owerengera. Zakumapeto kuli ndi ziwerengero zambiri zomwe zimafuna ntchito izi. Zowona, sikuti zinthu zonsezi zimayendetsedwa ndi zosasinthika. Ndiye kuti ntchito zobisika zotere zimaphatikizapo zida zopenda deta. Tiyeni tiwone momwe zitha kutembenuka.

Kutembenukira pachimake

Kuti mugwiritse ntchito bwino zinthu zomwe "kufufuza kwa data, muyenera kuyambitsa gulu la chida" chowunikira "pochita zinthu zina mu Microsoft Chuma. Algorithm ya zomwe izi zili zofanana ndi masinthidwe a 2010, 2013 ndi 2016, ndipo ali ndi zosiyana pang'ono mu mtundu wa 2007.

Kutsegula

1. Pitani ku "fayilo" tabu. Ngati mukugwiritsa ntchito mtundu wa Microsoft Excel 2007, ndiye m'malo mwa batani la fayilo, dinani icon ya Microsoft pakona yakumanzere kwa zenera.



2. Dinani pa chimodzi mwazinthu zomwe zaperekedwa kumanzere kwazenera zomwe zinatsegulidwa ndi "magawo".



3. Pawindo lotseguka la magawo owonjezera, pitani ku "kuwonjezera" "mu gawo la"



4. Mu gawo ili, tidzakhala ndi chidwi ndi mbali yapansi pazenera. Pali "kasamalidwe". Ngati mawonekedwe otsika pansi okhudzana ndi iyo, ndikofunikira mtengo wina kupatula injini ya "Excel yowonjezera", ndiye kuti muyenera kuyisintha kumodzi. Ngati chinthu ichi chayikidwa, ndimangodina pa "Pitani ..." batani kumanja kwake.



5. Khomo laling'ono la maulendo omwe alipo amatsegula. Pakati pawo, muyenera kusankha chinthucho "phukusi la kusanthula" ndikuyika zojambulazo. Pambuyo pake, dinani batani la "Ok" lomwe lili pamwamba pa mbali yakumanja ya zenera.

Pambuyo pochita izi, ntchito yomwe yatchulidwayi idzayambitsidwa, ndipo chida chake chimapezeka pa riboni kwambiri.

Kuyendetsa Ntchito Yachidziwitso Yachidziwitso

Tsopano titha kuyendetsa zida iliyonse ya TEVISS.

1. Pitani ku "deta" tabu.



2. Mu tabu kuti riboni idatseguka pamphepete kumanzere kwa tepi ili. Dinani pa batani la "deta Yachidziwitso", yomwe ili mmenemo.



3. Pambuyo pake, zenera limayambika ndi mndandanda waukulu wa zida zosiyanasiyana zomwe zimapereka chidziwitso cha deta. Pakati pawo mutha kutsimikizira izi:
   • Kuphatikiza;
   • Graph;
   • Kusinthika;
   • Chitsanzo;
   • Kusintha kopambana;
   • Wophatikiza wamkulu;
   • Ziwerengero zofotokozera;
   • Kupendanso konse;
   • Mitundu yosiyanasiyana yofalitsa kusanthula, etc.

   Sankhani gawo lomwe tikufuna kugwiritsa ntchito ndikusindikiza batani la "Ok".

Ntchito mu ntchito iliyonse imakhala ndi algorithm yake. Kugwiritsa ntchito zida zina za gulu la deta kufotokozedwa kumafotokozedwa mu maphunziro osiyanasiyana.

Phunziro: Kusanthula Kukonzanso

Phunziro: Kusanthula kwa Renalsis ku Excel

Phunziro: Momwe mungapangire histogram mu Excel

Monga tikuwona, ngakhale kuti "chiwerengero chazida" sichinayendetsedwe, njira zake ndizosavuta. Nthawi yomweyo, osadziwa algorithm yowoneka bwino yogwira ntchito, wogwiritsa ntchitoyo sakufunira ntchito mwachangu kwambiri izi.