1 / 59

Microsoft ® Office Excel ® 2007 Ukuqeqesha

Microsoft ® Office Excel ® 2007 Ukuqeqesha. Yakha ibhuku lakho lokusebenza lokuqala. Okuqukethwe kwekhozi. Ukubuka konke: Kuqalwaphi? Isifundo 1: Sikwethulela ibhuku lokusebenza Isifundo 2: Faka idatha Isifundo 3: Hlela idatha bese ubukeza amakhasi okusebenza.

terri
Download Presentation

Microsoft ® Office Excel ® 2007 Ukuqeqesha

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft® Office Excel® 2007 Ukuqeqesha Yakha ibhuku lakho lokusebenza lokuqala

  2. Okuqukethwe kwekhozi • Ukubuka konke: Kuqalwaphi? • Isifundo 1: Sikwethulela ibhuku lokusebenza • Isifundo 2: Faka idatha • Isifundo 3: Hlela idatha bese ubukeza amakhasi okusebenza Isifundongasinyesibandakanyauhlalwemisebenziephakanyiswayokanyenesethiyemibuzoyokuvivinya.

  3. Ukubuka konke: Kuqalwaphi? Ucelweukubaufakeidathaku-Excel 2007, kodwaawukazeusebenzenge-Excel. Uqalaphi? Nomamhlawumbe wake wasebenzange-Excel kodwaawukakakwazikahleukwenzaezinyezezintoezisemqokanjengokufakanokuhlelaumbhalonezinamba, nomaukwengezanokusulaamakhalamunemigqa. Laphauzofundaamakhonoowadingayoukuzeusebenzenge-Excel, ngokusheshanangaphandlekwemicikilisho.

  4. Izinjongo zekhozi • Yakha ibhuku lokusebenza elisha. • Faka umbhalo nezinamba. • Hlela umbhalo nezinamba. • Shutheka ubuye usule amakhalamu nemigqa.

  5. Isifundo 1 Sikwethulela ibhuku lokusebenza

  6. Sikwethulela ibhuku lokusebenza Uma uqala i-Excel, ubhekene nohlaka olukhulu olungenalutho olwenziwe ngamakhalamu, imigqa, namaseli (cells). Uma umusha ku-Excel, ungadideka ukuthi yini elandelayo okufanele uyenze. Ngakhoke le khozi izoqala ngokukusiza ukuthi ukhululeke ngezinto ezithile ze-Excel ezisemqoka ezizokukhombisa indlela uma ufaka idatha kuyo.

  7. I-Ribbon Ibhande phezulu ewindini le-Excel 2007 kuthiwa yi-Ribbon. Ekhaya Shutheka Sula Hlungabese Uhluza Ifomathi Amaseli Ukuhlela I-Ribbon yenziwe ngama-thebhu ehlukene, iyinye kuwona ihlobene nezinhlobo ezithile zomsebenzi owenziwa ngabantu ku-Excel. Uqhafaza amathebhu phezulu ku-Ribbon ukuze ubone imiyalo ehlukene kwithebhu ngayinye.

  8. I-Ribbon IthebhuEkhaya, yokuqalaesinxeleni, inemiyaloyansukuzonkeesetshenziswakakhulungabantu. Ekhaya Shutheka Sula Hlungabese Uhluza Ifomathi Amaseli Ukuhlela IsithombesikhombisaimiyaloyethebhuEkhayaku-Ribbon. I-Ribbon yendlalekephezuluewindini le-Excel. Imiyaloku-Ribbon ihlelwengononinanga-Maqembuamancaneahlobene. Isibonelo, imiyaloyokusebenzanokuqukethwekumaseliiqoqelwendawonyeeqoqweniUkuhlela, kantiimiyaloyokusebenzanamaseliqoboiseqoqweniAmaseli.

  9. Amabhuku okusebenza namakhasi okusebenza Umauqalai-Excel, uvula ifayelaebizwangokuthiibhukulokusebenza. Lelonalelobhukulokusebenzaelishalifikana-makhasiokusebenzaamathathulaphoufakakhonaidatha. Ucwecwe1– Microsoft Excel Nansiindlela. Ucwecwe1 Ucwecwe3 Ucwecwe2 Okukhonjiswelaphayikhasilokusebenzaelingenaluthoebhukwinilokusebenzaelisha. Ibhukulokusebenzalokuqalaozolivulakuthiwa Ibhuku1. Lesihlokosivelakubhaephezuluewindiniuzeugcineibhukulokusebenzangesakhoisihloko.

  10. Amabhuku okusebenza namakhasi okusebenza Uma uqala i-Excel, uvula ifayela ebizwa ngokuthi ibhuku lokusebenza. Lelo nalelo bhuku lokusebenza elisha lifika namakhasi okusebenza amathathu lapho ufaka khona idatha. Ucwecwe1– Microsoft Excel Nansiindlela. Ucwecwe1 Ucwecwe3 Ucwecwe2 Okukhonjiswelaphayikhasilokusebenzaelingenaluthoebhukwinilokusebenzaelisha. Amathebhu amakhasi avela phansi ewindini. Yisu elihle ukuqamba kabusha amathebhu amakhasi ukwenza ulwazi ekhasini ngalinye luhlonzeke kalula.

  11. Amabhuku okusebenza namakhasi okusebenza Ungazibuza futhi ukuthi lakhiwa kanjani ibhuku lokusebenza elisha. Ucwecwe1– Microsoft Excel Nansi indlela. Ucwecwe1 Ucwecwe3 Ucwecwe2 Chofoza Ibhathini le-Microsoft Office engxenyeni engenhla esinxeleni sewindi. ChofozaOkusha. EwindiniIbhukulokusebenzaElisha, chofozaIbhukulokusebenzaElingenalutho.

  12. Amakhalamu, imigqa namaseli Amakhasi okusebenza ahlukaniswe ngamakhalamu, imigqa namaseli. Yilona hlaka olubonayo uma uvula ibhuku lokusebenza. Amakhalamu asuka phezulu ehlele phansi ekhasini lokusebenza, ngokubheka phezulu. Ikhalamu ngayinye inesihloko se-alfabhethi phezulu. Imigqa inqamula ikhasi lokusebenza, ngokuvundla. Umugqa umunye nawo unesihloko. Izihloko zemigqa yizinamba, zisuka ku 1 zifike ku 1,048,576.

  13. Amakhalamu, imigqa namaseli Amakhasi okusebenza ahlukaniswe ngamakhalamu, imigqa namaseli. Yilolu hlaka olubonayo uma uvula ibhuku lokusebenza. Izihloko eziyi-alfabhethi kumakhalamu nezihloko eziyizinamba emigqeni zikutshela ukuthi ukuphi ekhasini lokusebenza uma uqhafaza iseli. Izihloko zihlangana zenze ikheli leseli. Isibonelo, iseli esenhlanganweni yekhalamu A nomugqa 3 kuthiwa yiseli A3. Lokhu futhi kuthiwa yi-referensi yeseli.

  14. Amaseli yilapho kungena khona idatha Amaseli yilapho usebenza khona ufake idatha ekhasini lokusebenza. Isithombe esinxelelni sikhombisa okubonayo uma uvula ibhuku lokusebenza elisha. Iseli yokuqala ekhoneni elingenhla esinxeleni sekhasi lokusebenza yi seli evuliwe. Inomngcele omnyama, okusho ukuthi noma iyiphi idatha oyifakayo izoya khona.

  15. Amaseli yilapho kuya khona idatha Ungafaka idatha noma kuphi lapho uthanda khona ngokuqhafaza noma iyiphi iseli ekhasini lokusebenza ukuze uyikhethe. Uma ukhetha noma iyiphi iseli, iba yiseli evuliwe. Njengoba kuchaziwe ngenhla, iba nomngcele omnyama. Izihloko zekhalamu nomugqa lapho kukhona iseli nazo ziyagqanyiswa.

  16. Amaseli yilapho kungena khona idatha Ungafaka idatha noma kuphi lapho uthanda khona ngokuqhafaza noma iyiphi iseli ekhasini lokusebenza ukuze uyikhethe. Isibonelo, uma ukhetha iseli ekukhalamu C emgqeni 5, njengoba kukhonjiswe esithombeni kwesokudla: Ikhalamu C iyagqanyiswa. Umugqa 5 uyagqanyiswa.

  17. Amaseli yilapho kungena khona idatha Ungafaka idatha noma kuphi lapho uthanda khona ngokuqhafaza noma iyiphi iseli ekhasini lokusebenza ukuze uyikhethe. Isibonelo, uma ukhetha iseli kukhalamu C emgqeni 5, njengoba kukhonjiswe esithombeni kwesokudla: Iseli evuliwe, u-C5 lapha, iba nomngcele. Futhi igama layo—nayo eyaziwa ngokuthi irefarensi yeseli—livezwa eBhokisini Legama ekhoneni elingenhla esinxeleni sekhasi lokusebenza.

  18. Amaseli yilapho kungena khona idatha Iseli elinomngcele, ikhalamu egqanyisiwe nezihloko zemigqa, kanye nokuvela kwerefarensi yeseli eBhokisini Legamakwenza kube lula kuwena ukuthi ubone ukuthi u-C5 yiseli evuliwe. Lezi khombisi azibalulekile kangako uma uphezulu ekhasini lokusebenza kumaseli ambalwa okuqala. Kodwa uma uya ngokuqhubekela ngokwehla noma ngokuvundla ekhasini lokusebenza, zingakusiza ngempela.

  19. Iziphakamiso zokuzilolonga • Qamba kabusha ithebhu yekhasi lokusebenza. • Suka ekhasini lokusebenza uye kwelinye. • Ngeza umbala kumathebhu amakhasi okusebenza. • Ngeza ubuye usule amakhasi okusebenza. • Hlola izihloko zekhalamu bese usebenzisa Ibhokisi Legama.

  20. Isivivinyo 1, umbuzo 1 Udinga ibhuku lokusebenza elisha. Ulakha kanjani? (Khetha eyodwa impendulo.) EqoqweniAmaseli, chofozaShutheka, beseuqhafazaShuthekaIkhasi. ChofozaIbhathini le-Microsoft Office, beseuqhafazaOkusha. EwindiniIbhukulokusebenzaElisha, chofozaIbhukulokusebenzaElingenalutho. EqoqweniAmaseli, chofozaShutheka, beseuqhafazaIbhukulokusebenza.

  21. Isivivinyo 1, umbuzo 1: Impendulo ChofozaIbhathini le-Microsoft Office, beseuqhafazaOkusha. EwindiniIbhukulokusebenza Elisha, chofozaIbhukulokusebenzaElingenalutho.

  22. Isivivinyo 1, umbuzo 2 Ibhokisi Legama liveza okuqukethwe kweseli evuliwe. (Khetha eyodwa impendulo.) Yiqiniso. Yiphutha.

  23. Isivivinyo 1, umbuzo 2: Impendulo Yiphutha. Ibhokisi Legama likunika irefarensi yeseli evuliwe. Ungasebenzisa futhi iBhokisi Legama ukukhetha iseli, ngokuthayipha ireferensi yaleyo seli ebhokisini.

  24. Isivivinyo 1, umbuzo 3 Ekhasini lokusebenza elisha, kufanele uqale ngokuthayipha kuseli A1. (Khetha eyodwa impendulo.) Yiqiniso. Yiphutha.

  25. Isivivinyo 1, umbuzo 3: Impendulo Yiphutha. Ukhululekile ukuthi uzule futhi uthayiphe noma kuphi lapho uthanda khona. Chofoza kunoma iyiphi iseli bese uqala ukuthayipha. Kodwa ungenzi abafundi bapheqe ukubona idatha ebingaqala nakuseli A1 noma A2.

  26. Isifundo 2 Faka idatha

  27. Faka idatha Ungasebenzisai-Excel ukufakazonkeizinhlobozedatha, yobuchwepheshenomaeqondenenawe. Ungafakaizinhloboezimbiliezisemqokazedathakumaseliamakhasiokusebenza: izinombolonombhalo. Amabanga Ezitshudeni Khetha Umbiko Izindlelo Zeholidi Ngakhokeungasebenzisai-Excel ukwakhaamabhajethi, ukusebenzangezintela, ukurekhodaamabanganomaukufikaesikolenikwabafundi, nomaukuklelisaimikhiqizooyidayisayo. Ungaqophangishoukuzivocavocakwansukuzonke, ulandeleukunciphakwakhongesisindo, nomaulandeleizindlekozokulungisaumuziwakho. Ongakwenzaempeleniakunamkhawuko. Manje ake singene ekufakeni idatha.

  28. Yibanomusakubafundibakho: qalangezihlokozamakhalamu Uma ufaka idatha, yisu elihle ukuqala ngokufaka izihloko phezulu kukhalamu ngayinye. Ngale ndlela, noma wubani ohlanganyela naye ikhasi lakho lokusebenza angaqonda ukuthi isho ukuthini idatha (nawe qobo ungaqonda, kamuva). Kaningi uzofuna futhi ukufaka nezihloko zemigqa.

  29. Yibanomusakubafundibakho: qalangezihlokozamakhalamu Ikhasilokusebenzaesithombenilikhombisaokwenzekayokwangempelanokulindelekilengeminyakaehlukene. Lisebenzisa izihloko zamakhalamu nezemigqa: Izihloko zamakhalamu, phezulu ekhasini lokusebenza, yiminyaka. Izihloko zemigqa ezehla ohlangothini lwesinxele ngamagama ezinkampani.

  30. Qala ukuthayipha Ake sithi uqamba uhla lwamagama abadayisi. Lolu hla luzoba futhi nezinsuku zokudayisa, namanani azo. Ngakhoke uyodinga lezi hloko zamakhalamu: Igama, Usuku, ne-Inani.

  31. Qala ukuthayipha Ake sithi uqamba uhla lwamagama abadayisi. Lolu hla luzoba futhi nezinsuku zokudayisa, namanani azo. Igama Usuku Inani Isithombe sikhombisa inqubo yokuthayipha ulwazi nokusuka kwiseli uye kwenye: ThayiphaIgamakuseli A1 beseucindezela TAB. BeseuthayiphaUsukukuseli B1, cindezela TAB, beseuthayiphaInanikuseli C1.

  32. Qala ukuthayipha Ake sithi uqamba uhla lwamagama abadayisi. Lolu hla luzoba futhi nezinsuku zokudayisa, namanani azo. Igama Usuku Inani Buchanan Suyama Iphikoko Isithombe sikhombisa inqubo yokuthayipha ulwazi nokusuka kwiseli uye kwenye: Emvakokuthayiphaizihlokozamakhalamu, chofozakuseli A2 ukuqalaukuthayiphaamagamaabadayisi. Thayiphaigamalokuqala, beseucindezela ENTER ukwehliselaokukhethiweezansikekhalamungeselieyodwakuyekuseli A3. Beseuthayiphaigamaelilandelayo, njalonjalo.

  33. Faka izinsuku nezikhathi I-Excel iqondanisa umbhalo ohlangothini lwesinxele lwamaseli, kodwa iqondanisa izinsuku kwesokudla samaseli. Igama Usuku Inani Buchanan 2009/05/03 Suyama 2009/06/05 Iphikoko 2009/05/05 Ukufakausukukukhalamu B, okungeyoSuku, kufaneleusebenziseisleshinomaikhonco (hyphen) ukuhlukanisaizingxenye: 2009/07/16 noma16-uJulayi-2009. I-Excel izokubonakokubilinjengosuku.

  34. Faka izinombolo I-Excel iqondanisa izinamba ohlangothini lwesokudla samaseli. Igama Usuku Inani Buchanan 2009/05/03 5500 Suyama 2009/06/05 6300 Iphikoko 2009/05/05 4180

  35. Faka izinombolo Ezinye izinombolo nezindlela zokuzifaka • Ukufaka izingcezu, shiya isikhala phakathi kwenamba ephelele nocezu. Isibonelo, 1 1/8. • Ukufaka ucezu kuphela, faka u-zero kuqala, isibonelo, 0 1/4. Uma ufaka 1/4 ngaphandle kuka-zero, i-Excel izotolika inamba njengosuku, Januwari 4. • Uma uthayipha (100) ukukhombisa inamba embi ngama-parentheses, i-Excel izoveza inamba njengo -100.

  36. Iziphakamiso zokuzilolonga • Faka idatha ngokusebenzisa u-TAB no-ENTER. • Lungisa amaphutha khathi uthayipha. • Faka izinsuku nezikhathi. • Faka izinombolo.

  37. Isivivinyo 2, umbuzo 1 Ukucindezela ENTER kugudlulela okukhethiwe kwiseli elilodwa uma uya kwesokudla. (Khetha eyodwa impendulo.) Yiqiniso. Yiphutha.

  38. Isivivinyo 2, umbuzo 1: Impendulo Yiphutha. Ukucindezela ENTER kukuyisa ezansi okukhethiwe. Ukucindezela TAB kuhambisa okukhethiwe kwesokudla.

  39. Isivivinyo 2, umbuzo 2 Yikuphi kulokhu i-Excel ezokubona njengosuku? (Khetha eyodwa impendulo.) uFebuwari6 1947. 2,6,47. 2u- uFebuwari -47.

  40. Isivivinyo 2, umbuzo 2: Impendulo 2u- uFebuwari -47. Usebenzisa isleshi noma ikhonco ukwehlukanisa izingxenye zosuku.

  41. Isifundo 3 Hlela idatha bese ubukeza amakhasi okusebenza

  42. Hlelaidathabeseubukezaamakhasiokusebenza Wonkeumuntuuyawenzaamaphutha. Ngishonedathaoyifakengendlelaeyiyoingadingaukubukezwaemvakwesikhathi. Kwesinyeisikhathi, lonkeikhasilokusebenzalidingaukushintshwa. Shutheka Ikhalamu Hlela Idatha 13256 123456 ShuthekaUmugqa Akesithiudingaukwengezaenyeikhalamuyedatha, phakathinendawoyekhasilakholokusebenza. Nomaakesithiuklelisaabasebenzioyedwangomugqa, ngokulandelai-alfabhethi—wenzenjaniumauqashaomusha? Lesifundosikukhombisaukuthikululakanjaniukuhlelaidatha, wengezefuthiusuleamakhalamunemigqakwekhasilokusebenza.

  43. Hlela idatha Ake sithi ubufuna ukufaka 5400 kuseli A2, kodwa wafaka 4500 ngephutha. Uma usulibonile iphutha, zimbili izindlela zokulilungisa. 4500 2007 2008 2009 4500 2700 3900 Hlela Chofoza kabili iseli ukuhlela idatha ekulona. Noma, emva kokuqhafaza kwiseli, hlela idatha kwiBha yeFomula. Emva kokukhetha iseli nganoma iyiphi indlela, ikhasi lokusebenza lithi Hlela kwibha yomumo ekhoneni elingezansi esinxeleni.

  44. Hlela idatha Yimuphi umehluko phakathi kwalezi ndlela ezimbili? Ukusizakala kwakho. Ungathola ukuthi kulula ukusebenza neBha Yefomula, noma neseli uqobo. 4500 2007 2008 2009 4500 2700 3900 Hlela Nansiindlelaongenzangayoizinguqukokunomaiyiphiindawo: • Sula izinhlamvu noma izinamba ngokucindezela BACKSPACE noma ngokuzikhetha bese ucindezela DELETE. • Hlela izinhlamvu noma izinamba ngokuzikhetha bese uthayipha okunye okuhlukile.

  45. Hlela idatha Yimuphi umehluko phakathi kwalezi ndlela ezimbili? Ukusizakala kwakho. Ungathola ukuthi kulula ukusebenza neBha Yefomula, noma neseli uqobo. 4500 2007 2008 2009 4500 2700 3900 Hlela Nansiindlelaongenzangayoizinguqukokunomaiyiphiindawo: • Shutheka izinhlamvu noma izinamba ezintsha kudatha yeseli ngokubeka isikhombisi bese uyathayipha.

  46. Hlela idatha Yimuphi umehluko phakathi kwalezi ndlela ezimbili? Ukusizakala kwakho. Ungathola ukuthi kulula ukusebenza neBha Yefomula, noma neseli uqobo. 5400 2007 2008 2009 5400 2700 3900 Hlela Noma ngabe wenzani, uma usuqedile, khumbula ukucindezela ENTER noma TAB ukuze izinguquko zakho zihlale kwiseli.

  47. Susa ukufomathwa kwedatha Mangala! Kukhonaomunyeosebenziseikhasilakholokusebenza, wagcwalisaidathaethile, wenzainambakuseli B6 yagqamafuthiyababomvuekhombisaukuthi u 2008 wawunevolumuephansikunayoyonke. Ekhaya A B 2007 2008 5400 2700 A B 2007 2008 5400 Sula Konke Sula Amafomathi A B 2007 2008 4000 5400 Kodwa leya volumu isishintshile. Ufuna ukulungisa le simo.

  48. Susa ukufomathwa kwedatha Mangala! Kukhonaomunyeosebenziseikhasilakholokusebenza, wagcwalisaidathaethile, wenzainambakuseli B6 yagqamafuthiyababomvuekhombisaukuthi u 2008 wawunevolumuephansikunayoyonke. Ekhaya A B 2007 2008 5400 2700 A B 2007 2008 5400 Sula Konke Sula Amafomathi A B 2007 2008 4000 5400 Njengoba isithombe sikhombisa: Inambayasekuqaleniyafomathwayagqamafuthiyabomvu. Ngakhokeusulainamba. Ufakainambaentsha. Kodwailokhuigqamilefuthiibomvu! Kwenzekani?

  49. Susa ukufomathwa kwedatha Okwenzekayo wukuthi iseli qobo ifomathiwe, hhayi idatha ekulona. Ekhaya A B 2007 2008 5400 2700 A B 2007 2008 5400 Sula Konke Sula Amafomathi A B 2007 2008 4000 5400 Ngakhoke uma usula idatha enefomathi eyisipesheli, udinga futhi ukusula ifomathi kuseli. Kuze kube wenze njalo, noma iyiphi idatha oyifaka kuleyo seli izoba nefomathi eyisipesheli.

  50. Susa ukufomathwa kwedatha Nansi indlela yokususa ifomathi. Ekhaya A B 2007 2008 5400 2700 A B 2007 2008 5400 Sula Konke Sula Amafomathi A B 2007 2008 4000 5400 Chofozakuthebhuyeseli, nethiEkhaya, eqoqwenielithiUkuhlela, chofozaumcibisholokuSula. Chofoza Sula Amafomathi, okususa ifomathi kwiseli. Noma ungaqhafaza Sula Konke ukususa idatha nefomathi kanyekanye.

More Related