UQeqesho lwe-Microsoft ® Office Excel ® 2007

1. UQeqesho lwe-Microsoft® Office Excel® 2007 Yila incwadi yokusebenzela yakho yokuqala

2. Iziqulatho zeZifundo • Ushwankathelo: Kuqalwa phi? • Isifundo 1: Dibana nencwadi yokusebenzela • Isifundo 2: Ngenisa idatha • Isifundo 3: Hlela idatha kwaye uqwalasele iishithi zokusebenzela kwakhona Isifundongasinyesiquletheuluhlulweethaskiezicetyisiweyokunyenoluhlulwemibuzoyovavanyo.

3. Ushwankathelo: Kuqalwa phi? Uceliweukubaungeniseidathakwi-Excel 2007, kodwaawuzangewakhewasebenzange-Excel. Uqala phi? Okanyemhlawumbiwakhewasebenzange-Excel kodwausaxakiwekukwenzaezinyezezintoezisisisekonjengokungenisanokuhlelaitekstinamanani, okanyeukongezanokucimaiikholamnemiqolo. Aphauzakufundaizakhonoozidingayoekusebenzisenikwi-Excel, ngokukhawulezanangokuphaphazelangentoencinci.

4. Imigomo yeSifundo • Yilaincwadiyokusebenzelaentsha. • Ngenisaitekstinamanani. • Hlelaitekstinamanani. • Fakelakwayeucimeiikholamnemiqolo.

5. Isifundo 1: Dibana nencwadi yokusebenzela

6. Dibana nencwadi yokusebenzela Xa uqalisa i-Excel, ujongana negridi enkulu engenanto eyenziwe ngeekholam, imiqolo, neeseli. Ukuba umtsha ku-Excel, unokuxakwa kukuba wenze ntoni na elandelayo. Ngoko ke esi sifundo siya kuqala ngokukunceda uqhelane neziseko ezithile ze-Excel eziya kukukhokela xa ungenisa idatha kwi-Excel.

7. IRibhoni Ibhendi ekumphezulu wefestile ye-Excel 2007 kuthiwa iRibhoni. iKhaya Fakela Cima Sota & Hluza Fomatha iiSeli Ukuhlela IRibhoni yenziwe ngezahlukileyo iithebu, nganye kuzo izalana neendidi ezithile zomsebenzi owenziwa ngabantu ku-Excel. Ucofa iithebhu kumphezulu weRibhoni ukubona imiyalelo eyahlukileyo kwithebhu nganye.

8. IRibhoni I eKhayathebhu, yokuqalaekhohlo, iquletheyonkeimiyaleloesetyenziswakakhulungabantu. iKhaya Fakela Cima Sota & Hluza Fomatha iiSeli Ukuhlela UmfanekisoubonakalisaeKhayaimiyaleloyethebhukwiRibhoni. IRibhoni ingxabalaza kumphezulu wefestile ye-Excel. Imiyalelo ekwiRibhoni ilungelelaniswe ngamancinci azalanayo amaqela. Umzekelo, imiyalelo yokusebenza ngeziqulatho zeeseli ihlanganyiswe ndawonye kwi Ukuhlela qela, kwaye imiyalelo yokusebenza ngeeseli ngokwazo ikwi iiSeli qela.

9. Iincwadi zokusebenzela neeshiti zokusebenzela Xa uqalisa i-Excel, uvula ifayili ekuthiwa yi ncwadi yokusebenzela. Incwadiyokusebenzelaentshanganyeizanezintathuii-worksheetongenisakuzoidatha. iNcwadi1 – i-Microsoft Excel Aphainjani? iShiti2 iShiti1 iShiti3 Okubonisweaphayishitiyokusebenzelaengenantokwincwadiyokusebenzelaentsha. Incwadiyokusebenzelayokuqalaoyakuyivulakuthiwa yiNcwadi1. Esisihlokosibonakalakwibhaephezuluyefestileudeubeuyigcinengesihlokoesisesakhoincwadiyokusebenzela.

10. Iincwadi zokusebenzela neeshiti zokusebenzela Xa uqalisa i-Excel, uvula ifayili ekuthiwa yi ncwadi yokusebenzela. Incwadiyokusebenzelaentshanganyeizanezintathuii-worksheetongenisakuzoidatha. iNcwadi1 – i-Microsoft Excel Aphainjani? iShiti2 iShiti1 iShiti3 Okuboniswe apha yishiti yokusebenzela engenanto kwincwadi yokusebenzela entsha. Iithebhu zeShiti zibonakala kumphantsi wefestile. Yingcinga elungileyo ukuzithiya ngokutsha iithebhu zeshiti ukwenza ulwazi olukwishiti nganye lwazeke ngokulula.

11. Iincwadi zokusebenzela neeshiti zokusebenzela Unokuba usaxakiwe ukuba iyilwa njani na incwadi yokusebenzela entsha. iNcwadi1 – i-Microsoft Excel Aphainjani? iShiti2 iShiti1 iShiti3 CofaiiQhoshalika-Microsoft Officekwinxenyeengaphezulwanakwikhohlo le-window. Cofa eNtsha. Kwi iNcwadi yokuSebenzela entsha festile, cofa iNcwadi yokuSebenzela eNgenanto.

12. Iikholam, imiqolo, neeseli IiShiti zokusebenzela zahlulwe ngokweekholam, imiqolo, neeseli. Le yigridi oyibonayo xa uvula incwadi yokusebenzela. Iikholam zisuka phezulu ziye phantsi kwishiti yokusebenzela, ngokuthe nkqo. Ikholam nganye inesihloko soonobumba kumphezulu. Imiqolo ihamba ngokunqamleze ishiti yokusebenzela, ngokuthe tyaba. Umqolo ngamnye nawo unesihloko. Izihloko zemiqolo zingamanani, asuka kwi-1 ukuya kwi-1,048,576.

13. Iikholam, imiqolo, neeseli IiShiti zokusebenzela zahlulwe ngokweekholam, imiqolo, neeseli. Le yigridi oyibonayo xa uvula incwadi yokusebenzela. Izihloko zoonobumba ezikwiikholam kunye nezihloko zamanani ezikwimiqolo zikuxelela ukuba uphi na kwishiti yokusebenzela xa ucofa iseli. Izihloko ziyadibana ukwenza idilesi yeseli. Umzekelo, iseli esekunqamlezeni kwekholam A nomqolo 3 kuthiwa yiseli A3. Le kukwathiwa yi referensi yeeseli.

14. iiSelizilaphoiyakhonaidatha iiSeli zilapho ungena kushishino kwaye ungenisa idatha kwi-worksheet. Umfanekiso osekhohlo ubonisa okubonayo xa uvula incwadi yokusebenzela entsha. Iseli yokuqala ekwikona ephezulwana yasekhohlo yeshiti yokusebenzela yi seli esebenzayo. Inemida emnyama, ebonisa ukuba nayiphi na idatha oyingenisayo iya kungena apho.

15. iiSelizilaphoiyakhonaidatha Ungangenisa idatha naphi na apho uthanda khona ngokucofa nayiphi na iseli kwishiti yokusebenzela ukukhetha iseli. Xa ukhetha nayiphi na iseli, iba yiseli esebenzayo. Njengoko kuchazwe ngaphambili, yenzelwa umda omnyama. Izihloko zekholam nomqolo ekulapho iseli ifumaneka nazo zikwaqaqanjisiwe.

16. iiSelizilaphoiyakhonaidatha Ungangenisa idatha naphi na apho uthanda khona ngokucofa nayiphi na iseli kwishiti yokusebenzela ukukhetha iseli. Umzekelo, ukuba ukhetha iseli ekwikholam C kumqolo 5, njengoko kuboniswe kumfanekiso osekunene: Ikholam C iqaqanjisiwe. Umqolo 5 uqaqanjisiwe.

17. iiSelizilaphoiyakhonaidatha Ungangenisa idatha naphi na apho uthanda khona ngokucofa nayiphi na iseli kwishiti yokusebenzela ukukhetha iseli. Umzekelo, ukuba ukhetha iseli ekwikholam C kumqolo 5, njengoko kuboniswe kumfanekiso osekunene: Iseli esebenzayo, i-C5 kule meko, iqaqanjisiwe. Kwaye igama layo—ekwaziwa njenge referensi yeseli—iboniswe kwiGama leBhokisi kwikona ye-worksheet ephezulwana ekhohlo.

18. iiSelizilaphoiyakhonaidatha Iselieyenzelweumda, ikholameqaqanjisiweyonezihlokozomqolo, nembonakaloyereferensiyeselikwiGamaleBhokisiyenzakubelulakuweukubonaukuba i-C5 iyiseliesebenzayo. Ezizibonisiazibalulekangakakhuluxaungaphezulukweshitiyokusebenzelakwiiseliezimbalwazokuqalangqa. Kodwaxausebenzaphambilinaphambiliphantsiokanyengaphesheyakweshitiyokusebenzela, zingakuncedangokwenene.

19. Iziphakamiso zomsebenzi • Thiya ngokutsha ithebhu yeshiti yokusebenzela. • Hambisela ishiti yokusebenzela enye ukuya kwenye. • Yongeza umbala kwiithebhu zeeshiti zokusebenzela. • Yongeza futhi ucime iishiti zokusebenzela. • Funda ngokutsha izihloko futhi usebenzise iGama leBhokisi.

20. Uvavanyo 1, umbuzo 1 Udinga incwadi yokusebenzela entsha. Uyiyila njani? (Chonga impendulo ibe nye.) KwiiiSeliqela, cofaFakela, kwayeuzeucofeFakelai-Sheet. CofaiiQhoshalika-Microsoft Office, kwayeuzeucofeeNtsha. KwiiNcwadiyokuSebenzelaentshafestile, cofaiNcwadiyokuSebenzelaeNgenanto. KwiiiSeliqela, cofaFakela, kwayeuzeucofeiNcwadiyokuSebenzela.

21. Uvavanyo 1, umbuzo 1: Impendulo CofaiiQhoshalika-Microsoft OfficekwayeuzeucofeeNtsha. KwiiNcwadiyokuSebenzelaeNtsha window, cofaiNcwadiyokuSebenzelaeNgenanto.

22. Uvavanyo 1, umbuzo 2 IGama leBhokisi libonisa iziqulatho zeseli esebenzayo. (Chonga impendulo ibe nye.) Inyaniso. Ubuxoki.

23. Uvavanyo 1, umbuzo 2: Impendulo Ubuxoki. IGama leBhokisi likunika ireferensi yeseli esebenzayo. Usenokusebenzisa iGama leBhokisi ukukhetha iseli, ngokutayipha loo referensi yeseli kwibhokisi.

24. Uvavanyo 1, umbuzo 3 Kwishiti yokusebenzela entsha, kufuneka uqalise ngokutayipha kwiseli A1. (Chonga impendulo ibe nye.) Inyaniso. Ubuxoki.

25. Uvavanyo 1, umbuzo 3: Impendulo Ubuxoki. Ukhululekile ukuba ubhadule kwaye utayiphe naphi na apho ufunayo. Cofa kuyo nayiphi na iseli futhi uqalise ukutayipha. Kodwa musa ukwenza abafundi basikrole ukubona idatha ebingaqalisa kwi-seli A1 okanye A2.

26. Isifundo 2: Ngenisa idatha

27. Ngenisa idatha Ungasebenzisai-Excel ukungenisazonkeiintlobozedatha, eyobuchuleokanyeeyobuqu. Ungangenisaiindidiezimbiniezisisisekozedathakwiiselizeshitiyokusebenzela: amananineteksti. Amabanga abafundi iNgxelo yeentengiso Iindleko zekhefu Ngokoungasebenzisai-Excel ukuyilaiibhajethi, ukusebenzangeerhafu, ukurekhodaamabangaokanyeubukhobabafundi, okanyeuluhlulweemvelisoozithengisayo. ungadeulogeimisetyenzanayemihlangemihla, ulandeleukuhlakobunzimabakho, okanyeulandeleumkhondowendlekozokubunjwangokutshakwendluyakho. Iindlelazokusebenzisaaziphelingenene. Ngokumasintywilelekungenisolwedatha.

28. Yibanobubelekubafundibakho: qalangezihlokozeekholam Xa ungenisa idatha, yingcinga entle ukuqala ngokungenisa izihloko kumphezulu wekholam nganye. Ngale ndlela, nabani na owabelana naye ngeshiti yokusebenzela yakho angakuqonda okuthethwa yidatha (kwaye nawe ungakuqonda, kamva). Kwakhona uya kufuna izihloko zemiqolo rhoqo.

29. Yibanobubelekubafundibakho: qalangezihlokozeekholam Ishiti yokusebenzela ekumfanekiso ibonisa iintsingiselo zokwenene nezilindelekileyo ngaphezu kweminyaka eyahlukeneyo. Isebenzisa izihloko zeekholam nezemiqolo: Izihloko zeekholam, ngaphesheya kumphezulu weshiti yokusebenzela, ziyiminyaka. Izihloko zemiqolo ngaphantsi kwecala lasekhohlo zingamagama enkampani.

30. Qalisa ukutayipha Masithi uyila uluhlu lwamagama abathengisi. Uluhlu nalo luya kuba nemihla yeentengiso, kunye neemali zazo. Igama Umhla Imali Ngoko uya kudinga ezi zihloko zeekholam: Igama, Umhla, ne Imali.

31. Qalisa ukutayipha Masithi uyila uluhlu lwamagama abathengisi. Uluhlu nalo luya kuba nemihla yeentengiso, kunye neemali zazo. Igama Umhla Imali Umfanekiso ubonisa iprosesi yokutayipha ulwazi nokuhambisa iseli uyisa kwenye iseli: TayiphaIgamakwiseli A1 futhiucinezeleTAB. KwakhonatayiphaUmhlakwiseli B1, ucinezeleTAB, uphindeutayipheImalikwiseli C1.

32. Qalisa ukutayipha Masithi uyila uluhlu lwamagama abathengisi. Uluhlu nalo luya kuba nemihla yeentengiso, kunye neemali zazo. Igama Umhla Imali I-Buchanan I-Suyama Ipikoko Umfanekiso ubonisa iprosesi yokutayipha ulwazi nokuhambisa iseli uyisa kwenye iseli: Emvakokutayiphaizihlokozeekholam, cofakwiseli A2 ukuqalisaukutayiphaamagamaabathengisi. Tayiphaigamalokuqala, kwayeuzeucinezeleENTER ukuhambisaukhethophantsiikholamngeseliukuyakwiseli A3. Uzeutayipheigamaelilandelayo, njl-njl.

33. Ngenisa imihla okanye amaxesha I-Excel ilungelelanisa iteksti kwicala lasekhohlo leeseli, kodwa ilungelelanisa imihla kwicala lasekunene leeseli. Igama Umhla Imali I-Buchanan 2009/05/03 I-Suyama 2009/06/05 Ipikoko 2009/05/05 Ukungenisa umhla kwikholam B, i Umhla kholam, kumele usebenzise isileshi okanye ihayifeni ukwahlula iindawo: 2009/07/16 okanye 16-eyeKhala-2009. I-Excel iya kuwuqaphela njengomhla nokuba ngowuphi na.

34. Ngenisa amanani I-Excel ilungelelanisa amanani kwicala lasekhohlo leeseli. Igama Umhla Imali I-Buchanan 2009/05/03 5500 I-Suyama 2009/06/05 6300 Ipikoko 2009/05/05 4180

35. Ngenisa amanani Amanye amanani kwanendlela owangenisa ngayo • Ukungenisa amaqhezu, shiya isithuba phakathi kwenani elipheleleyo kunye neqhezu. Umzekelo, 1 1/8. • Ukungenisa iqhezu kuphela, ngenisa uziro kuqala, umzekelo, 0 1/4. Ukuba ungenisa 1/4 ngaphandle kukaziro, i-Excel iya kulitolika inani njengomhla, uJanyuwari 4. • Ukuba utayipha (100) ukubonisa inani elinegethivu ngezigweqe, i-Excel iya kulibonisa inani njenge -100.

36. Iziphakamiso zomsebenzi • Ngenisaidathausebenzisa TAB no ENTER. • Lungisaiimposisonjengokoutayipha. • Ngenisaimihlanamaxesha. • Ngenisaamanani.

37. Uvavanyo 2, umbuzo 1 Ukucinezela ENTER kuhambiselaukhetholweselienyeekunene. (Chongaimpenduloibenye.) Inyaniso. Ubuxoki.

38. Uvavanyo 2, umbuzo 1: Impendulo Ubuxoki. UkucinezelaENTER kuhambiselaphantsiukhetho. UkucinezelaTAB kuhambiselaukhethoekunene.

39. Uvavanyo 2, umbuzo 2 Yeyiphi kule eya kuqatshelwa yi-Excel njengomhla? (Chonga impendulo ibe nye.) eyoMdumba6 1947. 2,6,47. 2-eyoMdumba-47.

40. Uvavanyo 2, umbuzo 2: Impendulo 2-eyoMdumba-47. Usebenzisa isileshi okanye ihayifeni ukwahlula iindawo zomhla.

41. Isifundo 3: Hlela idatha kwaye uqwalasele iishithi zokusebenzela kwakhona

42. Hlelaidathakwayeuqwalaseleiishithizokusebenzelakwakhona Wonkeubaniwenzaiimposiso. Nkqunedathaoyingenisengokuchanekileyoingadinga ii-updates kamva. Maxawambi, iyonkeishitiyokusebenzelaidingautshintsho. Fakela iKholam Hlela iDatha 13256 123456 Fakela uMqolo Masicingeukubaudingaukongezaenyeikholamyedatha, kumbindiweshitiyokusebenzelayakho. Okanyesicingeukubaudwelisaabaqeshwangabanyekumqolongamnye, ngokulandelelanakoonobumba—wenzantonixauqesheumntuomtsha? Esisifundosibonisaukubakululakanjaninaukuhlelaidathanokucimaiikholamnemiqoloyeshitiyokusebenzela.

43. Hlela idatha Masithi ubufuna ukungenisa 5400 kwiseli A2, kodwa ungenise 4500 ngemposiso. Wakuba uyibonile imposiso, kukho iindlela ezimbini zokuyilungisa. 4500 2007 2008 2009 4500 2700 3900 Hlela Cofa kabini kwiseli ukuhlela idatha ekuyo. Okanye, emva kokucofa kwiseli, hlela idatha kwiBha yeFomula. Emva kokucofa iseli nokuba kungendlela, ishiti yokusebenzela ithi Hlela kwibha yesikhundla ekwikona engaphantsana ekhohlo.

44. Hlela idatha Uyintoni umahluko phakathi kweendlela ezimbini? Uncedo lwakho. Unokufumanisa iBha yeFomula, okanye iseli uqobo lwayo, kulula ukusebenza ngayo. 4500 2007 2008 2009 4500 2700 3900 Hlela Naluuhloboongazenzangaloiinguqulelonokubakukweyiphinaindawo: • CimaoonobumbaokanyeamananingokucinezelaBACKSPACE okanyengokuwakhethakwayeuzeucinezeleDELETE. • Hlelaoonobumbaokanyeamananingokuwakhethafuthinangokutayipha into eyahlukileyo.

45. Hlela idatha Uyintoni umahluko phakathi kweendlela ezimbini? Uncedo lwakho. Unokufumanisa iBha yeFomula, okanye iseli uqobo lwayo, kulula ukusebenza ngayo. 4500 2007 2008 2009 4500 2700 3900 Hlela Naluuhloboongazenzangaloiinguqulelonokubakukweyiphinaindawo: • Fakela oonobumba okanye amanani amatsha kwiseli yedatha ngokubeka ikhesa nokutayipha.

46. Hlela idatha Uyintoni umahluko phakathi kweendlela ezimbini? Uncedo lwakho. Unokufumanisa iBha yeFomula, okanye iseli uqobo lwayo, kulula ukusebenza ngayo. 5400 2007 2008 2009 5400 2700 3900 Hlela Nokubawenzantonina, xaugqibekonke, khumbulaukucinezelaENTER okanyeTAB khon' ukuzeiinguqulelozakhozihlalezikwiseli.

47. Shenxisa ukufomathwa kwedatha Isimangaliso! Umntuothileongomnyeusebenziseishitiyokusebenzelayakho, wafakelaidathaethile, wazawalenzangqindililinabomvuinanielikwiseli B6 ukuqaqambisaukuba ama-2008 yayiyeyonavolyumiphantsikakhulu. iKhaya A B 2007 2008 5400 2700 A B 2007 2008 5400 Susa Konke Susa iiFomathi A B 2007 2008 4000 5400 Kodwa loo volyum itshintshile. Ufuna ukulungisa imeko.

48. Shenxisa ukufomathwa kwedatha Isimangaliso! Umntuothileongomnyeusebenziseishitiyokusebenzelayakho, wafakelaidathaethile, wazawalenzangqindililinabomvuinanielikwiseli B6 ukuqaqambisaukuba ama-2008 yayiyeyonavolyumiphantsikakhulu. iKhaya A B 2007 2008 5400 2700 A B 2007 2008 5400 Susa Konke Susa iiFomathi A B 2007 2008 4000 5400 Njengoko ubonisa umfanekiso: Inani yokuqala yafomathwa ngqindilili nabomvu. Ngoko ucima inani. Ungenisa inani elitsha. Kodwa lisengqindilili nabomvu! Yintoni enika?

49. Shenxisa ukufomathwa kwedatha Into eqhubekayo yeyokuba ubuqu beseli bufomathiwe, hayi idatha ekwiseli. iKhaya A B 2007 2008 5400 2700 A B 2007 2008 5400 Susa Konke Susa iiFomathi A B 2007 2008 4000 5400 Ngoko xa ucima idatha enokufomathwa okukhethekileyo, unokudingeka ukuba ucime ukufomathwa okukwiseli. Ude wenze njalo, nayiphi na idatha oyingenisa kulo seli iya kuba nokufomathwa okukhethekileyo.

50. Shenxisa ukufomathwa kwedatha Nalu uhlobo lokushenxisa ukufomathwa. iKhaya A B 2007 2008 5400 2700 A B 2007 2008 5400 Susa Konke Susa iiFomathi A B 2007 2008 4000 5400 Cofa kwiseli, kwaye uze kwi eKhaya thebhu, ekwi Ukuhlela qela, cofa utolo ku Susa . Cofa Susa iiFomathi, esusa ifomathi kwiseli. Okanye ungacofa Susa Konke ukushenxisa zombini idatha nokufomatha ngaxeshanye.