Excel sikuti ndi mkonzi wa spreadsheet zokha, komanso chida champhamvu pakuwerengedwa kosiyanasiyana kwamasamu ndi ziwerengero. Pulogalamuyi ili ndi nambala yayikulu yogwirira ntchito izi. Zowona, sizinthu zonse izi zomwe zimangoyambitsa zokha. Zobisika izi ndi bokosi la chida. "Kusanthula Kwambiri". Tiyeni tiwone momwe mungapangire izi.
Yatsani bokosi la chida
Kuti muthe kugwiritsa ntchito bwino zinthu zomwe zaperekedwa ndi ntchitoyi "Kusanthula Kwambiri", muyenera kuyambitsa gulu lazida Mapaketi Osanthulakutsatira njira zina mu Microsoft Excel. Ma algorithm pazinthu izi ali ofanana pafupifupi ndi mitundu yamapulogalamuyi 2010, 2013 ndi 2016, ndipo ali ndi kusiyana kocheperako pang'ono kokha mu mtundu wa 2007.
Kuseweretsa
- Pitani ku tabu Fayilo. Ngati mukugwiritsa ntchito mtundu wa Microsoft Excel 2007, ndiye m'malo mwa batani Fayilo dinani chizindikiro Microsoft Office pakona yakumanzere ya zenera.
- Timadina chimodzi mwazinthu zomwe zikuwonetsedwa kumanzere pazenera lomwe limatsegulira - "Zosankha".
- Pa zenera la Excel lotsegulidwa, pitani pagawo "Zowonjezera" (wopandiratu pamndandanda kumanzere kwa chenera).
- M'gawo lino, tikhala ndi chidwi pansi pazenera. Pali gawo "Management". Ngati fomu yotsikira yokhudzana ndi izo ndiyofunika mtengo wina kuposa Wonjezerani-Ex, ndiye muyenera kusintha kuti musonyeze zomwe zalembedwazi. Ngati izi zidayikidwa, ingodinani batani "Pita ..." kumanja kwake.
- Iwindo laling'ono la zowonjezera limapezeka. Pakati pawo, muyenera kusankha Mapaketi Osanthula ndi kuyiyesa. Pambuyo pake, dinani batani "Zabwino"ili pamwamba pomwe kumanja kwa zenera.
Mukatha kuchita izi, ntchito yomwe idakonzedwayo idzayatsidwa, ndipo zida zake zimapezeka ku riboni ya Excel.
Kukhazikitsa ntchito za Gulu Losanthula deta
Tsopano titha kuyendetsa zida zilizonse zamagulu "Kusanthula Kwambiri".
- Pitani ku tabu "Zambiri".
- Pa tabu yomwe imatsegulira, batani ya zida ili pamphepete lamanja la riboni "Kusanthula". Dinani batani "Kusanthula Kwambiri"amene aikidwamo.
- Pambuyo pake, zenera lokhala ndi mndandanda waukulu wazida zosiyanasiyana zomwe ntchitoyo imapereka "Kusanthula Kwambiri". Zina mwazo ndi izi:
- Chiyanjano
- Mbiri;
- Kupsinjika
- Kusakaniza;
- Kukonzanso kwamphamvu;
- Jenereta la manambala;
- Ziwerengero zofotokozera
- Kuwunika kwakukulu
- Mitundu yosiyanasiyana yosanthula mosiyanasiyana, etc.
Sankhani ntchito yomwe tikufuna kugwiritsa ntchito ndikudina batani "Zabwino".
Ntchito mu ntchito iliyonse imakhala ndi zake zomwe zikuchitika. Kugwiritsa ntchito zida zina zamagulu "Kusanthula Kwambiri" zofotokozedwera m'maphunziro osiyana.
Phunziro: Kusanthula kwa Excel Correlation
Phunziro: Kusanthula kwamakonzedwe ku Excel
Phunziro: Momwe mungapangire histogram ku Excel
Monga mukuwonera, ngakhale bokosi la chida Mapaketi Osanthula ndipo osakhudzidwa ndi kusakhazikika, njira zowathandizira ndizosavuta. Nthawi yomweyo, popanda kudziwa zotsogola zomveka bwino, sizingatheke kuti wogwiritsa ntchitoyo azitha kuyambitsa ntchitoyi mwachangu kwambiri.
