Litaelo tsa Excel 2003 - 2016
Kaha o na le mela e metle le mela, ho khetha bokhoni, le likarolo tsa ho kenya data, Excel e ka 'na ea e-ba kopo e phethahetseng ea ho kena le ho boloka boitsebiso bo kang lethathamo la ho kopanya. Hang ha u se u entse lenane le qaqileng, u ka le sebelisa le likarabo tse ling tsa Microsoft Office bakeng sa mesebetsi e mengata. Ka sebopeho sa poso sa poso MS Word, u ka hatisa melaetsa ea mangolo ho tloha Excel ka taba ea metsotso. Ithute ho hatisa melaetsa ho tsoa ho Excel ho itšetlehile ka hore na ke phetolelo efe ea Office eo ue sebelisang.
Excel 2016, Excel 2013, Excel 2010 kapa Excel 2007
Lokisetsa Leqephe la Mosebetsi
Ho etsa mangolo a mangolo a tsoang Excel, sepache sa hau se lokela ho thehoa hantle. Tšoaea sehlooho selekeleng ea pele ea mohala ka mong ho hlalosa data ho eona ka khoeli ka ho hlaka le ka ho toba. Etsa mohala bakeng sa ntho e 'ngoe le e' ngoe eo u batlang ho e kenyelletsa ho mangolo. Ka mohlala, haeba u batla ho etsa mangolo a mangolo a tsoang Excel, u ka 'na ua ba le lihlooho tse latelang tsa khohlopo:
- Sehlooho (Monghali / M./Dr.)
- Lebitso la pele
- Fane
- Aterese ea seterata
- Motse
- Naha
- K'houtu ea sebaka
Kenya Data
Tlanya mabitso le liaterese kapa lintlha tse ling tseo u li batlang ha u hatisa li-label ho tloha Excel. Etsa bonnete ba hore ntho e 'ngoe le e' ngoe e ka ho lekana. Qoba ho tlohela likhaolo tse se nang letho kapa mela ka har'a lenane. Boloka mokhoa oa mosebetsi ha u qetile.
Netefatsa Format ea Feshene
Lekhetlo la pele ha u kopanya sekhethong sa Excel ho tsoa lentsoeng, u tlameha ho lumella maemo a lumellang hore u fetole lifaele pakeng tsa mananeo a mabeli.
- Ka Lentsoe, tobetsa ho Thabiso ea hau ebe u khetha Lintlha tse ka tlase ho leihlo le letšehali.
- Tobetsa Boemo bo Hlakileng ka ho le letšehali le ka ho le letšehali la fensetere la Liolelo tsa Lentsoe '
- Etsa bonnete ba hore Phatlalatso ea Phatlalatso ea Feshene e tiisitsoeng ho Open e khethiloe mme o tobetsa OK
Beha Labele ka Lentsoe
- Bula tokomane ea Lentsoe le se nang letho.
- E-ea tab ea Li- Mailings , khetha Tsela ea ho Kopanya Mail le tobetsa ho Labels .
- Khetha mofuta oa lebokose la Letšoao la Vendors ebe o khetha nomoro ea sehlahisoa, e thathamisitsoeng lekhethong la letšoao. U ka boela ua khetha Letšoao le lecha haeba u batla ho kenya litekanyo tsa li-label.
- Tlanya OK ha u se u loketse ho tsoela pele.
Kopanya Lethathamo la Mosebetsi ho Labels
Pele o etsa meralo ea ho hatisa melaetsa ea aterese ho Excel, o tlameha ho hokahanya le tokomane ea Lentsoe mosebetsing o nang le lenane la hau.
- Thabeng ea Mailings , tobetsa Khetha Khetha ho sehlopha sa Merge ea Li-Mail 'me u khethe Sehlopha se teng .
- E-ea lethathamong la Excel le nang le lenane la hau fensetereng ea Khetha Data Source e butsoeng le ho tobetsa Open .
- Tobetsa OK ho netefatsa hore o batla ho sebelisa lenane mme o tobetsa Hona hape ho khetha tafole e nang le lenane la hau. Leqephe lena joale le tla tlala mangolo a reng « Tlaleho e latelang» .
Kenya Masimo a Merge ea Li-Mail
Mona ke moo lihlooho tseo u li kenyelletseng leqepheng la hau la Excel li tla kena hantle.
- Tobetsa lebopeng la pele leqepheng lena ebe o khetha Address Block karolong ea Lengolo le Lengolo la Maqephe a Mailings.
- Tobetsa konopo ea Match Fields ho Insert Address Block dialog box e hlahang.
- Etsa bonnete ba hore lihlooho tsa hau li lumellana le masimo a hlokahalang. Haeba leha e le efe ea tsona e sa nepahala, sebelisa motsu o theoha ka thōko ho eona ho tšoana le sebaka se nepahetseng.
- Tlanya OK . Tobetsa OK hape ho koala lebokose la lebokose mme o tobetsa Update Labels karolong ea Lengolo le Lengolo la Maqephe a Mailings.
Etsa Meralo
Hang ha u se u e-na le spreadsheet ea Excel le tokomane ea Lentsoe, u ka kopanya tlhahisoleseding mme o hatisa mabitso a hau.
- Tobetsa Qetella & Kopanya sehlopheng se phethehileng tabeng ea Mailings.
- Tlanya Edit Documents e le 'ngoe ho hlahloba kamoo litlhaku tsa hau tse ngotsoeng li tla hlaha kateng. Khetha tsohle mme o tobetsa OK .
Tokomane e ncha e bula ka mangolo a mangolo a tsoang Excel ea hau ea lipampiri. U ka fetola, ho hatisa le ho boloka maele feela joalokaha u ne u tla ba le lengolo le leng la Lentsoe.
Excel 2003
Haeba o sebelisa Microsoft Office 2003, mehato ea ho etsa lialete tsa aterese ho Excel e fapane haholo.
Lokisetsa Leqephe la Mosebetsi
Ho etsa mangolo a mangolo a tsoang Excel, sepache sa hau se lokela ho thehoa hantle. Tšoaea sehlooho selekeleng ea pele ea mohala ka mong ho hlalosa data ho eona ka khoeli ka ho hlaka le ka ho toba. Etsa mohala bakeng sa ntho e 'ngoe le e' ngoe eo u batlang ho e kenyelletsa ho mangolo. Ka mohlala, haeba u batla ho etsa mangolo a mangolo a tsoang Excel, u ka 'na ua ba le lihlooho tse latelang tsa khohlopo:
- Sehlooho (Monghali / M./Dr.)
- Lebitso la pele
- Fane
- Aterese ea seterata
- Motse
- Naha
- K'houtu ea sebaka
Kenya Data
- Tlanya mabitso le liaterese kapa lintlha tse ling tseo u li batlang ha u hatisa li-label ho tloha Excel.
- Etsa bonnete ba hore ntho e 'ngoe le e' ngoe e ka ho lekana. Qoba ho tlohela likhaolo tse se nang letho kapa mela ka har'a lenane.
- Boloka mokhoa oa mosebetsi ha u qetile.
Qala ho kopana
- Bula tokomane ea Lentsoe le lecha.
- E-ea Linthong tsa lisebelisoa , bonts'a Mangolo le Li-Mailings 'me u khethe Metsoalle ea Maqephe ho bula sesepa sa mosebetsi sa Merge sa Mail.
- Khetha Labels mme o tobetsa E latelang: Ho qala Tokomane .
- Tobetsa Lethathamo la Khetho ho bula lenaneo la lebokose la lebokose la lebokose
Khetha Li-Labels tsa Hao
- Khetha mofuta oa lebokose la Letšoao la Vendors ebe o khetha nomoro ea sehlahisoa, e thathamisitsoeng lekhethong la letšoao. U ka boela ua khetha Letšoao le lecha haeba u batla ho kenya litekanyo tsa li-label.
- Tlanya OK ha u se u loketse ho tsoela pele.
Khetha Mohloli oa Hao
- Tobetsa Sebelisa Lethathamo le Hlahang tlas'a Khetha Ba Amohelang 'me u tobetsa Phindisa .
- E-ea lethathamong la Excel le nang le lenane la hau fensetereng ea Khetha Data Source e butsoeng le ho tobetsa Open . Baamameli ba Mail Merge Baa fensetere ba bula.
- Etsa bonnete ba hore boitsebiso ba hau bo bonahala bo nepahetse '
Lokisa Labels
- Tlanya E latelang: Lokisetsa Li-Labels tsa hau .
- Khetha Blocked Address .
- Tobetsa konopo ea Match Fields ho Insert Address Block dialog box e hlahang.
- Etsa bonnete ba hore lihlooho tsa hau li lumellana le masimo a hlokahalang. Haeba leha e le efe ea tsona e sa nepahala, sebelisa motsu o theoha ka thōko ho eona ho tšoana le sebaka se nepahetseng. Tlanya OK .
- Tobetsa Phatlalatsa Lilebelisoa Tsohle ka tlas'a Lebokose la Labelle lebokoseng la boikhopotso la Mail.
Hlahloba le ho Qetella
- Sebelisa metsu ka tlas'a Lethathamo la Liteko tsa hau ho netefatsa hore li hlaha hantle.
- Tlanya E latelang: Tlatsa Kopano .
- Haeba o batla ho etsa liphetoho leha e le life, tobetsa Hlahisa Li-Labelle ka Boeona.
- Ha o khotsofetse ka ho kopanya, tobetsa Senyetsa ho hatisa mabitso a hau a aterese ho Excel.