Zamkatimu
Mukamagwira ntchito ndi Excel spreadsheets, nthawi zina zimakhala zofunikira kugawa zambiri kuchokera pagawo limodzi pamizere ingapo yolembedwa. Kuti musachite izi pamanja, mutha kugwiritsa ntchito zida zomangidwira pulogalamuyo yokha. Zomwezo zimagwiranso ntchito pakubala ntchito, mafomu. Akangochulukitsidwa ndi nambala yofunikira ya mizere, mutha kupeza zotsatira zenizeni za kuwerengera.
Kugawa kwa data kuchokera pagawo limodzi kukhala mizere yosiyana
Ku Excel, pali lamulo lapadera lomwe mungagawire zidziwitso zomwe zasonkhanitsidwa mugawo limodzi m'mizere yosiyana.
Kuti mugawire deta, muyenera kutsatira njira zingapo zosavuta:
- Pitani ku tabu "EXCEL", yomwe ili patsamba lalikulu la zida.
- Pezani chipikacho ndi zida za "Table", dinani pa izo ndi batani lakumanzere.
- Kuchokera pa menyu omwe atsegulidwa, sankhani "Kubwereza mzati ndi mizere".
- Pambuyo pake, zenera lokhala ndi zoikamo zomwe mwasankha liyenera kutsegulidwa. Mu gawo loyamba laulere, muyenera kusankha kuchokera pamndandanda womwe mukufuna kuti muwonjezere.
- Pamene ndime yasankhidwa, muyenera kusankha mtundu wa olekanitsa. Itha kukhala kadontho, koma, semicolon, danga, kukulunga mawu pamzere wina. Mwachidziwitso, mukhoza kusankha khalidwe lanu logawanika.
Mukamaliza masitepe onse omwe afotokozedwa pamwambapa, tsamba latsopano lidzapangidwa pomwe tebulo latsopano lidzamangidwa kuchokera m'mizere yambiri momwe deta yochokera pamndandanda wosankhidwa idzagawidwa.
Zofunika! Nthawi zina pamakhala zochitika pamene kuchulutsa zipilala kuchokera patsamba lalikulu kuyenera kuzindikirika. Pachifukwa ichi, mutha kusintha zomwe mwachita pogwiritsa ntchito kiyi "CTRL + Z" kapena dinani chizindikiro chosintha chomwe chili pamwamba pazida zazikulu.
Kupanganso ma formula
Nthawi zambiri mukamagwira ntchito ku Excel, pamakhala zochitika zomwe zimafunika kuchulutsa chilinganizo chimodzi nthawi imodzi m'mizere ingapo kuti mupeze zotsatira zofunika m'maselo oyandikana nawo. Mukhoza kuchita pamanja. Komabe, njirayi idzatenga nthawi yambiri. Pali njira ziwiri zosinthira ndondomekoyi. Ndi mbewa:
- Sankhani selo lapamwamba kwambiri patebulo pomwe fomula ili (pogwiritsa ntchito LMB).
- Sunthani cholozera kukona yakumanja kwa selo kuti muwonetse mtanda wakuda.
- Dinani LMB pa chithunzi chomwe chikuwoneka, kokerani mbewa mpaka pamaselo ofunikira.
Pambuyo pake, m'maselo osankhidwa, zotsatira zidzawoneka molingana ndi ndondomeko yomwe yakhazikitsidwa pa selo yoyamba.
Zofunika! Kupanganso chilinganizo kapena ntchito inayake pagawo lonse ndi mbewa ndizotheka pokhapokha ngati ma cell onse omwe ali pansipa adzazidwa. Ngati imodzi mwamaselo ilibe chidziwitso mkati, kuwerengera kumathera pamenepo.
Ngati ndime ili ndi mazana mpaka masauzande a maselo, ndipo ena alibe kanthu, mutha kusintha mawerengedwewo. Kuti muchite izi, muyenera kuchita zinthu zingapo:
- Chongani selo loyamba lazagawo ndikukanikiza LMB.
- Pendekera gudumu mpaka kumapeto kwa gawo lomwe lili patsamba.
- Pezani selo lomaliza, gwirani batani la "Shift", dinani pa selo ili.
Mtundu wofunikira udzawunikidwa.
Sanjani data ndi mizati ndi mizere
Nthawi zambiri pamakhala zochitika pomwe, mutangodzaza tsambalo ndi data, amagawidwa mwachisawawa. Kuti zikhale zosavuta kuti wogwiritsa ntchito azigwira ntchito m'tsogolomu, m'pofunika kusanja deta ndi mizere ndi mizati. Pankhaniyi, monga wogawa, mutha kuyika mtengowo ndi font, kutsika kapena kukwera, ndi mtundu, zilembo, kapena kuphatikiza magawo awa wina ndi mzake. Njira yosankhira deta pogwiritsa ntchito zida zomangidwa mu Excel:
- Dinani kumanja kulikonse patsamba logwirira ntchito.
- Kuchokera ku menyu omwe akuwoneka, sankhani njira - "Sort".
- Mosiyana ndi zomwe mwasankha, zosankha zingapo zosinthira deta zidzawonekera.
Njira ina yosankhira njira yosankhira zidziwitso ndiyo kudzera pa toolbar. Pa izo muyenera kupeza "Data" tabu, pansi pake kusankha "Sankhani" katunduyo. Njira yosanja tebulo ndi gawo limodzi:
- Choyamba, muyenera kusankha deta kuchokera pagawo limodzi.
- Chizindikiro chidzawonekera pa taskbar ndi zosankha zakusanja zambiri. Mukadina, mndandanda wazomwe mungasankhire udzatsegulidwa.
Ngati mizati ingapo patsambalo idasankhidwa koyambirira, mutatha kudina chizindikiro chamtundu pa taskbar, zenera lokhala ndi zoikamo izi lidzatsegulidwa. Pazosankha zomwe mwasankha, muyenera kusankha njira "onjezani zokha zomwe mwasankha". Ngati simuchita izi, zomwe zili mugawo loyamba zidzasankhidwa, koma dongosolo lonse la tebulo lidzasweka. Njira yosankhira mizere:
- Pazenera losankhira, pitani ku tabu "Parameters".
- Pazenera lomwe limatsegulidwa, sankhani "Range Columns".
- Kuti musunge zoikamo, dinani batani "Chabwino".
Zosintha zomwe zimayikidwa poyambirira pazosankha sizimalola kugawa deta mwachisawawa pamasamba onse ogwirira ntchito. Kuti muchite izi, muyenera kugwiritsa ntchito ntchito ya RAND.
Kutsiliza
Njira yochulukitsira zipilala m'mizere ndiyokhazikika, chifukwa chake si aliyense wogwiritsa ntchito amadziwa momwe angagwiritsire ntchito. Komabe, mutawerenga malangizo omwe ali pamwambawa, izi zikhoza kuchitika mofulumira kwambiri. Kuphatikiza pa izi, tikulimbikitsidwa kuchita ndi kubalana kwa ntchito ndi mafomu, chifukwa chake zidzatheka kupulumutsa nthawi yochuluka pa mawerengedwe osiyanasiyana m'magulu akuluakulu a maselo.