Umurnin Excel 2003 - 2016
Tana da ginshiƙai da layuka, rarraba damar iyawa, da abubuwan fasalin bayanai, Excel zai zama cikakkiyar aikace-aikacen don shiga da adana bayanai kamar jerin lambobi. Da zarar ka ƙirƙiri jerin cikakken, za ka iya amfani da shi tare da wasu aikace-aikacen Microsoft Office don ayyuka masu yawa. Tare da jerin haɗin mail a cikin MS Word, za ka iya buga sakonnin aikawa daga Excel a cikin lamarin minti. Koyi yadda za a buga lakabi daga Excel dangane da abin da kake amfani da shi.
Excel 2016, Excel 2013, Excel 2010 ko Excel 2007
Shirya Taswalin
Don yin alamar aikawasiku daga Excel, dole ne a saita kwamfutarka ta hanyar dacewa. Rubuta a cikin batu a cikin tantanin farko na kowanne shafi da ke bayyana bayanan a cikin wannan shafi a fili kuma a hankali. Yi shafi don kowane ɓangaren da kake son hadawa a kan lakabi. Alal misali, idan kana son ƙirƙirar alamomi daga Excel, zaku iya samun waɗannan rubutun shafi:
- Title (Mr./Ms./Dr.)
- Sunan rana
- Sunan mahaifa
- Adireshin Street
- City
- Jihar
- Lambar titi
Shigar da Bayanan
Rubuta sunayen da adiresoshin ko wasu bayanan da kake so a yayin da ka buga lakabi daga Excel. Tabbatar kowane abu yana cikin shafi na daidai. Ka guji barin ginshiƙai marar layi ko layuka cikin jerin. Ajiye takardar aiki lokacin da ka gama.
Tabbatar da Tsarin Fayil
A karo na farko da kake haɗi zuwa takardar aiki na Excel daga Kalma, dole ne ka ba da damar saitin da zai ba ka damar canza fayiloli tsakanin shirye-shiryen biyu.
- A cikin Kalma, danna kan fayil ɗin shafin kuma zaɓi Zabuka a kasa na aikin hagu na hagu.
- Click Advanced a cikin hagu na hagu na Zaɓuɓɓukan Maɓallin Zabuka sa'annan gungura ƙasa zuwa Gaba ɗaya .
- Tabbatar da zaɓin Tabbatar da Tsarin Fayil ɗin Fayil akan Buɗe kuma zaɓi Ok .
Saita Labels a cikin Kalma
- Bude takaddun Kalmaccen rubutu.
- Jeka zuwa Shafukan Labarai , zabi Fara Mail Haɗa kuma danna Labels .
- Zaɓi nau'in a cikin Akwatin Kasuwanci Label sa'annan ku zaɓi lambar samfurin, wanda aka jera a kunshin lakabin. Hakanan zaka iya zaɓar Sabuwar Label idan kana so ka shigar da ƙididdiga na layi na al'ada.
- Danna Ya yi lokacin da kake shirye don ci gaba.
Haɗa Wurin Kayan aiki zuwa Labels
Kafin yin haɗin don buga rubutun adireshin daga Excel, dole ne ka haɗa da Rubutun Kalma zuwa aikin aiki wanda ke dauke da jerin ku.
- A Aikace-aikacen shafin, danna Zabi Masu karɓa a cikin Ƙungiyar Ƙungiyar Hanyoyin Saƙo kuma zaɓi Yi amfani da Lissafin da ke faruwa .
- Nuna zuwa ga aikin aikin na Excel wanda ke dauke da jerinku a cikin Zaɓin Bayanin Bayanin Bayanan wanda ya buɗe kuma danna Buɗe .
- Danna Ya yi don tabbatar da cewa kana so ka yi amfani da jerin kuma ka latsa OK sake don zaɓar teburin da ke dauke da jerinka. Shafin zai cika yanzu tare da takardun da ke cewa « Next Record» .
Ƙara Shafin Jakada filin
Wannan shi ne inda wa] annan takardun da kuka} arawa a cikin takardar aikin na Excel za su zo a cikin hannu.
- Danna kan lakabin farko a kan shafin sannan sannan ka zaɓa Adireshin Adireshi a Rubuta & Saka Sashe na Ƙungiyar Sharuɗɗa shafin.
- Danna maɓallin Maɓallan Match ɗin akan akwatin Siffar Adireshin Block akwatin da yake bayyana.
- Tabbatar da rubutunku ya dace da filayen da ake bukata. Idan wani daga cikin su ba daidai ba ne, yi amfani da alamar saukewa kusa da ita don daidaitawa zuwa filin daidai.
- Danna Ya yi . Danna Ya sake don rufe akwatin maganganu sannan ka danna Ɗaukaka Labels a cikin Rubuta & Saka Sashe na Ƙungiyar Sharuɗɗa shafin.
Yi haɗin
Da zarar kana da maƙunsar Bayani mai mahimmanci da kuma rubutun Kalma, za ka iya hada bayanai da buga takardunku.
- Danna Ƙarshe & Haɗa a Ƙungiyar Ƙarshe a kan Sharuɗɗa shafin.
- Danna Shirya Takardun Kayan Mutum don duba yadda za a bayyana alamar bugawa. Zaɓi Duk kuma danna Ya yi .
Wani sabon takardun aiki yana farawa tare da takardun aikawasiku daga aikin aikin ka na Excel. Zaka iya shirya, bugawa da adana alamomi kamar yadda za ku yi wani takardun Kalma.
Excel 2003
Idan kuna amfani da Microsoft Office 2003, matakai don yin adireshin adireshi daga Excel su ne daban-daban.
Shirya Taswalin
Don yin alamar aikawasiku daga Excel, dole ne a saita kwamfutarka ta hanyar dacewa. Rubuta a cikin batu a cikin tantanin farko na kowanne shafi da ke bayyana bayanan a cikin wannan shafi a fili kuma a hankali. Yi shafi don kowane ɓangaren da kake son hadawa a kan lakabi. Alal misali, idan kana son ƙirƙirar alamomi daga Excel, zaku iya samun waɗannan rubutun shafi:
- Title (Mr./Ms./Dr.)
- Sunan rana
- Sunan mahaifa
- Adireshin Street
- City
- Jihar
- Lambar titi
Shigar da Bayanan
- Rubuta sunayen da adiresoshin ko wasu bayanan da kake so a yayin da ka buga lakabi daga Excel.
- Tabbatar kowane abu yana cikin shafi na daidai. Ka guji barin ginshiƙai marar layi ko layuka cikin jerin.
- Ajiye takardar aiki lokacin da ka gama.
Fara Haɗin
- Bude sabon takardun Kalma.
- Jeka menu na Kayayyakin kayan aiki , zayyana wasiƙa da wasiku da kuma zaɓin Hanin Hanji don bude Maɓallin Ayyukan Hanya Mail.
- Zaɓi Labels kuma danna Next: Fara Takardun .
- Danna Zaɓuɓɓukan Label don buɗe akwatin maganganun Label na Label.
Zaɓi Labels naka
- Zaɓi nau'in a cikin Akwatin Kasuwanci Label sa'annan ku zaɓi lambar samfurin, wanda aka jera a kunshin lakabin. Hakanan zaka iya zaɓar Sabuwar Label idan kana so ka shigar da ƙididdiga na layi na al'ada.
- Danna Ya yi lokacin da kake shirye don ci gaba.
Zabi Madogararku
- Danna Yi amfani da Lissafin da ke faruwa a ƙarƙashin Zaɓa Masu karɓa sannan ka danna Browse .
- Nuna zuwa ga aikin aikin na Excel wanda ke dauke da jerinku a cikin Zaɓin Bayanin Bayanin Bayanan wanda ya buɗe kuma danna Buɗe . Ƙungiyar masu karɓar Maɗauki na Ƙafa ta buɗe.
- Tabbatar da bayaninku ya bayyana daidai kuma danna Ya yi .
Shirya Labels
- Danna Next: Shirya Rubutunku .
- Zaɓi Block Adireshin .
- Danna maɓallin Maɓallan Match ɗin akan akwatin Siffar Adireshin Block akwatin da yake bayyana.
- Tabbatar da rubutunku ya dace da filayen da ake bukata. Idan wani daga cikin su ba daidai ba ne, yi amfani da alamar saukewa kusa da ita don daidaitawa zuwa filin daidai. Danna Ya yi .
- Danna Sabunta Duk Label a ƙarƙashin Rubutun Maɓallin Rubutun a cikin akwatin jigilar Magana.
Binciko da Ƙarshe
- Yi amfani da kiban a ƙarƙashin Label Labarunku don tabbatar da sun bayyana daidai.
- Danna Next: Kammala Haɗin .
- Idan kana son yin canje-canje, danna Shirya Rubutun Mutum.
- Idan kun yarda da haɗin, danna Print don buga adireshin adireshin ku daga Excel.