Izikhokelo ze-Excel 2003 - 2016
Ukuba neentsika ezifanelekileyo kunye nemigca, ukukhetha amakhono, kunye neenkcukacha zokungena kwedatha, i-Excel ingaba isicelo esifanelekileyo sokungena nokugcina ulwazi olufana neenlist zoqhagamshelwano. Emva kokuba udale uluhlu olunzulu, ungayisebenzisa kunye nezinye izicelo ze-Microsoft Office kwimisebenzi emininzi. Ngefayile yokudibanisa i-imeyile kwi-MS Word, unokuprinta iileyile zeposi ukusuka kwi-Excel kwimizuzu yamaminithi. Funda indlela yokushicilela amaleyibhile ukusuka kwi-Excel kuxhomekeke kwinguqulelo ye-Ofisi oyisebenzisayo.
Excel 2016, Excel 2013, Excel 2010 okanye Excel 2007
Lungisa iWindows Worksheet
Ukwenza iileyile zokuthumela kwi-Excel, ispredishithi sakho kufuneka isetyenziswe kakuhle. Thayipha kwisihloko esisekuqaleni kwikholam nganye echaza idatha kule kholomu ngokucacileyo kwaye ngokukhawuleza. Yenza ikholomu yento nganye ofuna ukuyifaka kwiibhile. Ngokomzekelo, ukuba ufuna ukudala iileyile zee-imeyile ukusuka kwi-Excel, unokuba nezihloko ezilandelayo zekholomu:
- Isihloko (Mnu/Ms./Dr.)
- Igama lokuqala
- Ifani
- Idilesi yesitrato
- Sixeko
- Lumente
- Ikhowudi yeziphu
Faka iDatha
Thayipha amagama kunye needesi okanye enye idatha oyifunayo xa ushicilela amalebula kwi-Excel. Qinisekisa ukuba nganye into ekholekileyo. Gwema ukushiya iikholomu ezingenanto okanye imiqolo phakathi kwoluhlu. Gcina iphepha lokusebenzela xa ugqibe.
Qinisekisa ifayile yefayile
Ngethuba lokuqala udibanisa kwiphepha lokusebenzela lase Excel elivela kwiLizwi, kufuneka unike isilungiselelo esikuvumela ukuguqula iifayile phakathi kweenkqubo ezimbini.
- KwiLizwi, nqakraza kwiTebhu yefayile uze ukhethe Izinketho ezantsi kwiphepha lekhohlo.
- Cofa Ephakamileyo kwiphepha lesobunxele lwe window yeWindows kwi-window uze uphelele phantsi kwiCandelo jikelele .
- Qinisekisa ukuba Qinisekisa ukuguqulwa kwefayile yefayile kwi-Open kukhethwe kwaye uklikhe i- OK .
Hlela amaLebhile kwiLizwi
- Vula idokhumenti yeLizwi elingenanto.
- Yiya kwithebhu ye - Mailings , khetha u- Qala i-Mail Merge kwaye uklikha kwiilebhile .
- Khetha i-brand kwiBhokisi yabathengisi be-Label uze ukhethe inombolo yomkhiqizo, ebhalwe kwiphayibhile yeebhile. Unokhetha kwakhona iLayibhile entsha ukuba ufuna ukungena ubungakanani bendatshana yecala.
- Cofa ku- OK xa ulungele ukuqhubeka.
Xhuma iWebhu lokusebenzela kwiiLebel
Ngaphambi kokwenza ukudibanisa ukuprinta iileyile zeedilesi kwi-Excel, kufuneka udibanise iWiki kwixwebhu lokusebenzela eliqulethe uluhlu lwakho.
- Kwithebhu ye - Mailings , nqakraza Khetha Abamkeli kwiqela leMeyili yokudibanisa uze ukhethe Sebenzisa uLuhlu olukhoyo .
- Hamba kwiphepha lokusebenzela lase Excel eliqulethe uludwe lwakho kwifayile ye-Data Data window evula kwaye qhosha kwi- Open .
- Cofa u- OK uqinisekise ukuba ufuna ukusebenzisa uluhlu uze ukhethe Kulungile kwakhona ukukhetha itafile equle uluhlu lwakho. Eli phepha liya kuzaliswa ngamabhile athi " Okulandelayo" .
Yongeza i-Mail Merge Fields
Le yilapho ezo zihloko ozifakayo kwiphepha lakho lokusebenzela lase Excel liza kusebenza.
- Cofa kwileyibhile yokuqala kwikhasi uze ukhethe I- Block Block kwicandelo lokubhala nokufaka iiSiza zeTeyili.
- Cofa iqhosha le Match Fields kwibhokisi yencoko yebhokisi yebhokisi yencoko ebonakalayo.
- Qinisekisa ukuba izihloko zakho zihambelana neendawo ezifunekayo. Ukuba nayiphi na enye ayilunganga, sebenzisa i-arrow-down arrow phantsi kwayo ukuze uhambelane nendawo echanekileyo.
- Chofoza OK . Cofa u- OK kwakhona ukuvala ibhokisi yencoko kwaye ucofeze ii-Labels zokugqibela kwiCandelo leNgxelo yeNgxelo yokuNgenisa & yokufaka yeTyhu ye-Mailings.
Ukudibanisa
Xa unesipredishithi se-Excel kunye nexwebhu le-Word elimiselweyo, unokudibanisa ulwazi kwaye uprinte iilebula zakho.
- Cofa Qhaqha & Hlanganisa kwiqela eligqityiweyo kwithebhu ye-Mailings.
- Cofa Hlaziya iiMibhalo eziPhezulu ukuze ukhangele indlela eziza kubonakala ngayo. Khetha Zonke kwaye nqakraza Kulungile .
Uxwebhu olutsha luvulwa ngamabhalana okuposa kwiphepha lakho lokusebenzela lase Excel. Ungahlela, uprinte uze ulondoloze iilebula nje ngokuba unokwenza nawuphi na uxwebhu lwegama.
Excel 2003
Ukuba usebenzisa iMicrosoft Office 2003, amanyathelo okwenza iileyile zeedilesi kwi-Excel ahluke kakhulu.
Lungisa iWindows Worksheet
Ukwenza iileyile zokuthumela kwi-Excel, ispredishithi sakho kufuneka isetyenziswe kakuhle. Thayipha kwisihloko esisekuqaleni kwikholam nganye echaza idatha kule kholomu ngokucacileyo kwaye ngokukhawuleza. Yenza ikholomu yento nganye ofuna ukuyifaka kwiibhile. Ngokomzekelo, ukuba ufuna ukudala iileyile zee-imeyile ukusuka kwi-Excel, unokuba nezihloko ezilandelayo zekholomu:
- Isihloko (Mnu/Ms./Dr.)
- Igama lokuqala
- Ifani
- Idilesi yesitrato
- Sixeko
- Lumente
- Ikhowudi yeziphu
Faka iDatha
- Thayipha amagama kunye needesi okanye enye idatha oyifunayo xa ushicilela amalebula kwi-Excel.
- Qinisekisa ukuba nganye into ekholekileyo. Gwema ukushiya iikholomu ezingenanto okanye imiqolo phakathi kwoluhlu.
- Gcina iphepha lokusebenzela xa ugqibe.
Qalisa ukuhlanganisa
- Vula idokhumenti yeLizwi elitsha.
- Yiya kwimenyu yamathuluzi , phawula kwiincwadi kunye ne-Mailings uze ukhethe i- Mail Ukudibanisa ukuvula idilesi yomsebenzi weMeyili yokudibanisa.
- Khetha Iilebhile uze ukhethe Okulandelayo: Ukuqala uMqulu .
- Cofa iqhosha lokukhethwa kweelayi ukuvula ibhokisi yencoko yeebhokisi yeebhokisi.
Khetha iilebhile zakho
- Khetha i-brand kwiBhokisi yabathengisi be-Label uze ukhethe inombolo yomkhiqizo, ebhalwe kwiphayibhile yeebhile. Unokhetha kwakhona iLayibhile entsha ukuba ufuna ukungena ubungakanani bendatshana yecala.
- Cofa ku- OK xa ulungele ukuqhubeka.
Khetha Umthombo Wakho
- Cofa Sebenzisa uLuhlu Olukhoyo phantsi koBamkeli Abamkeli uze uqakraze Khangela .
- Hamba kwiphepha lokusebenzela lase Excel eliqulethe uludwe lwakho kwifayile ye-Data Data window evula kwaye qhosha kwi- Open . Iifayile ezidibanisa iifayile zivula.
- Qinisekisa ukuba idatha yakho ibonakala ichanekileyo kwaye nqakraza OK .
Hlela iiLebel
- Cofa Okulandelayo: Hlela iiLebels zakho .
- Khetha iBlock Block .
- Cofa iqhosha le Match Fields kwibhokisi yencoko yebhokisi yebhokisi yencoko ebonakalayo.
- Qinisekisa ukuba izihloko zakho zihambelana neendawo ezifunekayo. Ukuba nayiphi na enye ayilunganga, sebenzisa i-arrow-down arrow phantsi kwayo ukuze uhambelane nendawo echanekileyo. Chofoza OK .
- Chofoza Uhlaziyo Zonke iiLebhile phantsi kweeLebhile eziPhendulayo kwiBhokisi yodibanisa yebhokisi yencoko.
Ukujonga kuqala nokugqiba
- Sebenzisa iintolo phantsi koPhuculo lweeLebels zakho ukuqinisekisa ukuba zibonakala ngokuchanekileyo.
- Chofoza Okulandelayo: Gqibezela ukuhlanganisa .
- Ukuba ufuna ukwenza nayiphi iinguqulelo, nqakraza Hlela amaLebhile aBodwa.
- Xa unelisekile ngokudibanisa, nqakraza Phrinta ukuze uprinte iileyile zeedilesi kwi-Excel.