Ngemva kokuqoqa, ukuhlela nokucubungula idatha, ngokuvamile kuyadingeka ukuyibonisa. Amathebula mahle ekwethuleni idatha umugqa ngomugqa, kodwa ishadi lingaphefumulela ukuphila kulo. Umdwebo udala umthelela obonakalayo ongadluliseli idatha kuphela, kodwa futhi ubudlelwano nencazelo yawo.
Ishadi likaphayi liyindinganiso yemboni yokudlulisa ubudlelwano phakathi kwezingxenye nama-whole. Amashadi ophayi asetshenziswa uma kudingekile ukuze kuboniswe ukuthi izingcezu ezithile zedatha (noma imikhakha) zinengxenye engakanani esithombeni esikhulu. Amashadi ophayi awafanele ukubonisa idatha eshintshayo ngokuhamba kwesikhathi. Futhi, ungasebenzisi ishadi likaphayi ukuze uqhathanise idatha engahlanganisi isamba esikhulu ekugcineni.
Okulandelayo kubonisa indlela yokwengeza ishadi likaphayi eshidini le-Excel. Izindlela eziphakanyisiwe zisebenza ku-Excel 2007-2013. Izithombe ziphuma ku-Excel 2013 ye-Windows 7. Kuye ngenguqulo ye-Excel oyisebenzisayo, izinyathelo ngazinye zingahluka kancane.
Ifaka ishadi
Kulesi sibonelo, sifuna ukukhombisa ubudlelwano phakathi kwamazinga ahlukene abanikeli ababamba iqhaza enhlanganweni esiza abantulayo, uma kuqhathaniswa nenani eliphelele leminikelo. Ishadi likaphayi liphelele ukukhombisa lokhu. Ake siqale ngokufingqa imiphumela yezinga ngalinye lomnikelo.
- Khetha ububanzi noma ithebula ledatha ofuna ukulibonisa eshadini. Qaphela ukuthi uma ithebula linomugqa Umphumela uwonke (Isamba esikhulu), khona-ke lo mugqa awudingi ukukhethwa, ngaphandle kwalokho uzoboniswa njengomunye wemikhakha yeshadi likaphayi.
- Kuthebhu ethuthukisiwe Faka (Faka) esigabeni Imidwebo (Amashadi) chofoza isithonjana seshadi likaphayi. Kunamashadi amaningana ajwayelekile ongakhetha kuwo. Uma uhambisa phezulu phezu kwanoma yiziphi izinketho zeshadi eziphakanyisiwe, ukubuka kuqala kuzonikwa amandla. Khetha inketho efaneleke kakhulu.
Shesha! Ku-Excel 2013 noma izinguqulo ezintsha, ungasebenzisa isigaba Imidwebo (Amashadi) ithuluzi Ukuhlaziya okusheshayo (Ukuhlaziya Okusheshayo), inkinobho yayo evela eduze kwedatha ekhethiwe. Ngaphezu kwalokho, ungasebenzisa inkinobho Amashadi anconyiwe (Amashadi Anconyiwe) ithebhu Faka (Faka) ukuze uvule ibhokisi Faka ishadi (Faka amashadi).
★ Funda kabanzi esihlokweni: → Indlela yokwenza ishadi likaphayi ku-Excel, amafomula, isibonelo, imiyalelo yesinyathelo ngesinyathelo
Ukuhlela Ishadi Lophayi
Lapho umdwebo ufakwe endaweni efanele, kuyoba nesidingo sokwengeza, ukushintsha noma ukwenza ngokwezifiso izakhi zawo ezihlukahlukene. Chofoza eshadini ofuna ukulihlela ukuze uveze iqembu lethebhu ku-Ribbon Ukusebenza namashadi (Amathuluzi eshadi) nezinkinobho zokuhlela. Ku-Excel 2013, izinketho eziningi zingenziwa ngendlela oyifisayo kusetshenziswa izinkinobho zokuhlela eduze kweshadi.
Kuthebhu ethi Design
- Engeza amalebula edatha, yenza ngokwezifiso isihloko seshadi nenganekwane. Chofoza Izinketho eziningi (Izinketho Eziningi) ukuze uvule iphaneli yokufometha futhi ufinyelele izinketho ezengeziwe.
- Zama ukushintsha Isitayela Seshadi (Isitayela Seshadi) kanye Imibala yeshadi (Imibala Yeshadi).
Kuthebhu yefomethi
- Hlela futhi wenze ngendlela oyifisayo isitayela sombhalo esihlokweni, inganekwane, nokuningi.
- Hudula izici zeshadi ngazinye uziyise ezindaweni ezintsha.
- Sabalalisa imikhakha ngokwehlukana:
- Ukuze uhlehlise umkhakha owodwa, vele uwukhethe bese uwuhudulela kude neshadi.
- Ukuze ususe yonke imikhakha phakathi nendawo, chofoza kwesokudla kumdwebo bese ukhetha Ifomethi yochungechunge lwedatha (Uchungechunge Lwedatha Yefomethi). Kuphaneli evelayo, chofoza Ishadi Lophayi Osikiwe (Pie Explosion) ukushintsha ibanga phakathi kwezingcezu.
- Ngeshadi elinezinhlangothi ezintathu, ungakwazi ukulungisa ukujiya, i-engeli yokuzungeza, wengeze isithunzi namanye amapharamitha eshadi ngokwalo kanye nendawo yokuhlela.
Umphumela awuwona nje umfanekiso ofundisayo weqhaza leqembu ngalinye labanikeli ngenjongo yenhlangano, kodwa futhi umfanekiso oklanywe kahle ofanele izincwajana, amaphosta nokubekwa kumawebhusayithi, ngokuhlonipha imibala yebhizinisi nesitayela senhlangano yakho. .