Okuqukethwe
Esifundweni sokugcina, sajwayelana nezinhlobo zamashadi ku-Excel, sahlola izakhi zawo eziyinhloko, futhi sakha i-histogram elula. Kulesi sifundo, sizoqhubeka nokujwayelana nemidwebo, kodwa ezingeni eliphezulu kakhulu. Sizofunda ukufometha amashadi ku-Excel, ukuwahambisa phakathi kwamashidi, ukususa nokwengeza izici, nokunye okuningi.
Isakhiwo seshadi nesitayela
Ngemva kokufaka ishadi eshidini lokusebenzela le-Excel, ngokuvamile kuba kudingekile ukushintsha ezinye izinketho zokubonisa idatha. Isakhiwo nesitayela kungashintshwa kuthebhu umakhi. Nazi ezinye zezenzo ezitholakalayo:
- I-Excel ikuvumela ukuthi ungeze izinto ezifana nezihloko, izinganekwane, amalebula edatha, nokunye eshadini lakho. Izakhi ezengeziwe zisiza ukwenza lula ukubona nokwandisa okuqukethwe kolwazi. Ukwengeza i-elementi, chofoza umyalo Engeza isici Seshadi ithebhu umakhi, bese ukhetha oyidingayo kumenyu yokudonsela phansi.
- Ukuze uhlele into, njengesihloko, chofoza kabili kuyo bese uyihlela.
- Uma ungafuni ukwengeza ama-elementi ngawodwana, ungasebenzisa esinye sezakhiwo ezisethwe ngaphambilini. Ukuze wenze lokhu, chofoza umyalo Isakhiwo se-Express, bese ukhetha isakhiwo osifunayo kumenyu yokudonsela phansi.
- I-Excel inenani elikhulu lezitayela ezikuvumela ukuthi uguqule ngokushesha ukubukeka kweshadi lakho. Ukuze usebenzise isitayela, sikhethe eqenjini lomyalo Izitayela zeshadi.
Ungasebenzisa futhi izinkinobho zezinqamuleli zokufometha ukuze wengeze izici eshadini, ushintshe isitayela, noma uhlunge idatha.
Ezinye Izinketho Zeshadi
Ziningi ezinye izindlela zokwenza ngendlela oyifisayo namashadi esitayela. Isibonelo, i-Excel ikuvumela ukuthi uchaze kabusha idatha yoqobo, ushintshe uhlobo, futhi uhambise ishadi eshidini elihlukile.
Ukushintsha imigqa namakholomu
Kwesinye isikhathi udinga ukushintsha ukuthi idatha iqoqwa kanjani eshadini le-Excel. Esibonelweni esilandelayo, ulwazi luqoqwa ngonyaka futhi uchungechunge lwedatha yizinhlobo. Nokho, singakwazi ukushintsha imigqa namakholomu ukuze idatha iqoqwe ngohlobo. Kuzo zombili izimo, ishadi liqukethe ulwazi olufanayo kodwa lihlelwe ngendlela ehlukile.
- Khetha ishadi ofuna ukulishintsha.
- Kuthebhu ethuthukisiwe umakhi cindezela umyalo Ikholomu yomugqa.
- Imigqa namakholomu kuzoshintshana. Esibonelweni sethu, idatha manje isiqoqwe ngohlobo futhi uchungechunge lwedatha seluyiminyaka.
Shintsha uhlobo lweshadi ku-Excel
Uma uthola ukuthi ishadi lamanje alilingani nedatha ekhona, ungakwazi ukushintshela kolunye uhlobo kalula. Esibonelweni esilandelayo, sizoshintsha uhlobo lweshadi ukusuka Ama-histogram on I-Timetable.
- Kuthebhu ethuthukisiwe umakhi chofoza umyalo Shintsha uhlobo lweshadi.
- Ebhokisini lengxoxo elivelayo Shintsha uhlobo lweshadi khetha uhlobo lweshadi nesakhiwo esisha, bese uchofoza OK. Esibonelweni sethu, sizokhetha I-Timetable.
- Kuvela uhlobo lweshadi elikhethiwe. Esibonelweni samanje, ungakubona lokho I-Timetable idlulisa ngokucace kakhudlwana ukuguquguquka kokuthengisa ngesikhathi esitholakalayo.
Hambisa ishadi ku-Excel
Uma kunamathiselwe, ishadi livela njengento eseshidini elifanayo nedatha. Ku-Excel, lokhu kwenzeka ngokuzenzakalelayo. Uma kudingeka, ungahambisa ishadi eshidini elihlukile ukuze umise kangcono idatha.
- Khetha ishadi ofuna ukulihambisa.
- Chofoza umakhi, bese ucindezela umyalo Hambisa Ishadi.
- Ibhokisi lengxoxo lizovuleka Ukuhambisa ishadi. Khetha indawo oyifunayo. Esibonelweni samanje, sizobeka ishadi eshidini elihlukile futhi silinikeze igama Ukuthengiswa kwezincwadi 2008-2012.
- Cindezela OK.
- Ishadi lizoyiswa endaweni entsha. Esimweni sethu, leli yishidi esisanda kulidala.