Chiyanjano cha Mail Mail cha Microsoft chimakulolani kutumiza chikalata chomwecho ndi kusintha pang'ono kwa anthu ambiri omwe alandira. Mawu oti "kuphatikizana" amachokera kukuti chilemba chimodzi (kalata, mwachitsanzo) chikuphatikizidwa ndi chikalata chofotokozera deta , monga spreadsheet .
Mauthenga a makalata a Mawu akugwira ntchito mosavuta ndi deta kuchokera ku Excel. Ngakhale Mawu akulolani kuti mupange chitsimikizo chake cha deta, zosankha zogwiritsa ntchito detayi ndizochepa. Komanso, ngati muli ndi deta yanu kale, sizimveka bwino kubwereza zonse zomwe zili mu deta.
Kukonzekera Deta Zanu Zogulitsa Mautumiki
Mwachidule, mungagwiritse ntchito pepala lililonse la Excel mu kulemberana mauthenga a Mawu popanda kukonzekera kokha. Komabe, tikulimbikitsidwa kuti mutenge nthawi yokonzekera tsamba lanu la ntchito kuti mukwaniritse ndondomeko yoyanjana makalata .
Nazi mfundo zochepa zomwe mungazione zomwe zingathandize kuti makalata aphatikizidwe akupita bwino.
Sungani Deta Zanu Zophatikiza
Pa chiopsezo chofotokozera momveka bwino, deta yanu iyenera kuyendetsedwa mwaukhondo m'mizere ndi mizere. Ganizilani mzere uliwonse ngati cholembera chimodzi ndipo gawo lililonse ngati munda womwe mukukayikira muzomwe mukulemba. (Fufuzani phunziro la Excel deta-entry ngati mukufunikira kubwezeretsa.)
Pangani Mzere Wamutu
Pangani mzere wa mutu pa pepala yomwe mukufuna kuti mugwiritse ntchito makalata ophatikizana. Mzere wamutu ndi mzere wokhala ndi malembo omwe amadziwa deta m'maselo omwe ali pansipa. Excel ikhoza kukhala yochuluka nthawi zina posiyanitsa pakati pa deta ndi malemba, kotero ikani izi momveka bwino pogwiritsa ntchito malemba olimba, maselo a selo ndi kujambulira maselo omwe ali osiyana ndi mzere wa mutu. Izi zidzatsimikizira kuti Excel imasiyanitsa ndi deta yanu yonse.
Pambuyo pake pamene mukugwirizanitsa deta ndi chikalata chachikulu, malembawo adzawoneka ngati mayina a masamba ophatikizana, kotero sipadzakhala chisokonezo pa zomwe mukulemba muzomwe mukulemba. Kuwonjezera apo, ndizochita bwino kulemba zipilala zanu, chifukwa zimathandiza kupewa zolakwika.
Ikani Zonse Zonse pa Tsamba Lokha
Deta yomwe mukufuna kuigwiritsa ntchito pa makalata akuphatikizidwa ayenera kukhala pa pepala limodzi. Ngati imafalitsidwa pamapepala ambiri, muyenera kuphatikiza mapepala kapena kuchita mautumiki angapo a makalata. Ndiponso, onetsetsani kuti mapepalawa amatchulidwa momveka bwino , monga mukufunikira kusankha pepala omwe mukufuna kuti muzigwiritsa ntchito popanda kuyang'ana.
Kusonkhanitsa Gwero la Data mu Msonkhano wa Ma Mail
Khwerero lotsatira mu ndondomeko yothandizira makalata ndiyo kusonkhanitsa wanu okonzekera Excel spreadsheet ndi chikalata chanu cha Mawu.
- Kalozera kothandizira pa Ma Mail, dinani Chotsegula Chotsegula Chinthu .
- Mu Chosankha Chachidule Chakufotokozera bokosi, pendani m'mawindo mpaka mutapeza buku lanu la Excel. Ngati simukutha kupeza fayilo yanu ya Excel, onetsetsani kuti "Zonse zochokera ku deta" zasankhidwa m'menyu yotsitsa yotchedwa "Files of type."
- Dinani kawiri pa fayilo yanu ya source Excel, kapena musankhe ilo ndipo dinani Open .
- Mu Chakudya Chakulumikiza dialog box, sankhani pepala la Excel lomwe liri ndi deta yomwe mukufuna kuti muphatikize ndi chilemba chanu.
- Onetsetsani kuti bokosi loyang'ana pafupi ndi "Mzere woyamba wa deta uli ndi mitu yamutu" yayendera.
- Dinani OK .
Tsopano kuti gwero la deta likugwirizanitsidwa ndi chikalata chachikulu, mukhoza kuyamba kulowa malemba ndi / kapena kukonza chikalata cha Mawu anu. Komabe, simungathe kusintha kusintha kwa deta yanu ku Excel; ngati mukufunikira kusintha pa deta, muyenera kutseka chikalata chachikulu mu Mawu musanayambe kutsegula deta yanu ku Excel.
Kuyika masamu masumiki anu m'kaunti yanu ndi kophweka potsatira izi:
- Dinani ku Bungwe la Insert Merge Field pamsakatuli wothandizira makalata. Bokosi la Insert Field dialog likuwonekera.
- Tchulani dzina la munda umene mukufuna kuika kuchokera pa mndandanda ndikusindikiza.
- Bokosilo lidzakhala lotseguka, kukulowetsani kuti muikepo minda yambiri. Ngati mumagwiritsa ntchito gawo limodzi potsatizana, Mawu sangangowonjezerapo malo pakati pa minda yanu; muyenera kuchita izi nokha mutatseka bokosi. M'malemba anu mudzawona dzina lachonde lozungulira ndi mivi iwiri.
- Mukamaliza, dinani Kutseka .
Kuika Mauthenga Ambiri ndi Moni-Gwiritsani Ntchito Mosamala
Microsoft posachedwapa inayambitsa makalata ophatikizana ndi makalata omwe amakulolani kuti muike zolemba maulendo ndi mzere. Pogwiritsa ntchito batani pamsakatuli, Mawu adzakulolani kuyika minda ingapo nthawi imodzi, yokonzedwa mosiyana.
Bungwe loikapo bwalo lokhala ndi adiresi ndilo kumanzere; mzere wolumikizira mzere uli kumanja.
Komanso, mukamalemba pa batani, Mawu amasonyeza bokosi la zokambirana zomwe zimakupatsani zosankha zina zomwe mungakonde kuziyika, momwe mungafunire kuti zikonzedwe, ndi zizindikiro ziti zomwe zimaphatikizapo ndi zina. Ngakhale izi zikumveka molunjika-ndipo ngati mukugwiritsa ntchito deta yolengedwa mu Mawu-izo zingasokoneze ngati mukugwiritsa ntchito tsamba la Excel.
Kumbukirani pamene ndondomeko yowonjezera mzere wa mutu pamutu wanu wa tsamba patsamba 1 la nkhaniyi? Chabwino, ngati munatchula munda china china osati chimene Mawu amagwiritsa ntchito monga dzina lachonde la deta yofanana, Mawu angagwirizane ndi minda molakwika.
Izi zikutanthawuza ngati mutagwiritsa ntchito malingaliro omwe akulowetsa mndandanda kapena kuika moni mndandanda wazitsulo, deta ikhoza kuwoneka mwadongosolo kusiyana ndi momwe mukufotokozera-chifukwa chakuti malemba sagwirizana. Mwamwayi, Microsoft akuyembekezera izi ndipo amamanga mbali ya Match Fields yomwe imakulolani kuti mufanane ndi maina anu akumunda kwa omwe Mawu amagwiritsira ntchito pamabwalo.
Kugwiritsira ntchito Minda ya Match ku Mapu Oyenera Mapu Malemba
Kuti mufanane ndi minda, tsatirani izi:
- Dinani pa Masewera a Masewera pa Toolbar.
- Mu bokosi la masewera a Match, mudzawona mndandanda wa maina a Mawu a kumanzere. Kumanja kumanja kwa bokosi, mudzawona mzere wa mabasi otsitsa. Dzina mu bokosi lililonse lochotsamo ndilo gawo limene Mawu akugwiritsira ntchito pamtundu uliwonse pa tsamba la Adilesi kapena Mzere wolemba mzere. Kuti mupange kusintha kulikonse, sankhani dzina lachonde kuchokera ku bokosi lochotsera.
- Mukamaliza kusintha, dinani OK .
Mukhozanso kukweza bokosi la Masewera a Match mwakumasulira Bwalo la Masewera pansi pa tsamba la Insert Address Block kapena Greeting Line bokosi, zonse zomwe zimawoneka mukamalemba batani lazamasamba.
Kuwona Malembo Ophatikiza Ma Mail
Tisanayambe kupenda ndi kusindikiza zikalata zanu zovomerezeka, zolembera zokhudzana ndi kukonzekera: Pamene mutsegulira masankhulidwe mu chikalata, Mawu samanyamula maonekedwe a deta kuchokera ku deta.
Kugwiritsa Ntchito Kupanga Maonekedwe Wapadera kuchokera ku Tsamba lamasamba
Ngati mukufuna kugwiritsa ntchito mapangidwe apadera monga azitsulo, olimba kapena ochepetsetsa, muyenera kumachita Mawu. Ngati mukuwona chikalatacho ndi minda, muyenera kusankha mizere iwiri kumbali zonse ziwiri zomwe mukufuna kugwiritsa ntchito maonekedwe. Ngati mukuwona deta yosakanizidwa mu chikalatacho, ingosonyeza zomwe mukufuna kusintha.
Kumbukirani kuti kusintha kulikonse kudzanyamula pamabuku onse ogwirizana, osati payekha.
Kuwonetsa Maofesi Ogwirizanitsidwa
Kuti muyang'ane zolemba zanu zogwirizanitsa, dinani pazithunzi Zowonongeka Zowonongeka pazitsulo la Masumiki Ophatikiza. Bululi limagwira ntchito ngati osintha mawonekedwe, kotero ngati mukufuna kubwerera kuti muwone malo okha osati deta yomwe ali nayo, dinani kachiwiri.
Mukhoza kuyendetsa zolemba zomwe mukugwirizana pogwiritsa ntchito zizindikiro zazomwe mukuyenda pazowunikira. Iwo ali, kuyambira kumanzere kupita kumanja: First Record , Previous Record , Pitani Kukalemba , Next Record , Last Record .
Musanaphatikize zikalata zanu, muyenera kuziwonetsa zonsezi, kapena zonse zomwe mungathe kutsimikizira kuti zonse zogwirizana bwino. Perekani chidwi pa zinthu monga zizindikiro ndi malo ozungulira deta yolumikizana.
Lembani Ndemanga Yanu Yogwirizana ndi Mauthenga
Mukakonzeka kuphatikiza zikalata zanu, muli ndi zisankho ziwiri.
Gwirizanitsani kwa Printer
Choyamba ndikuchiphatikizira ku printer. Ngati musankha njirayi, zikalatazo zidzaperekedwa kwa wosindikiza popanda kusintha. Mutha kuphatikiza kwa wosindikiza pokhapokha pakhomphani Chophatika Chophatikiza Kuphatikizira .
Gwirizanitsani mu Zopangidwe Zatsopano
Ngati mukufuna kusonyeza zina kapena zolemba zonse (ngakhale, mungakhale anzeru kuwonjezera gawo lachinsinsi muzolemba zopezeka pamasom'pamaso), kapena pangani zisinthidwe zina musanayambe kusindikiza, mukhoza kuziphatikiza pa chikalata chatsopano; ngati mukuphatikizidwa ku vesi latsopano, makalata akuphatikizira chikalata chachikulu ndi chitukuko cha deta chidzakhalabe chosasunthika, koma mutha kukhala ndi fayilo yachiwiri yomwe ili ndi zikalata zosakanikirana.
Kuti muchite izi, dinani kokha Kanikizani ku Koperani Yatsopano Yopangirako.
Mulimonse momwe mungasankhire, mudzakambidwa ndi bokosi la nkhani yomwe mungathe kuwuza Mawu kuti agwirizanitse zolemba zonse, zolembera zamakono, kapena zolemba zambiri.
Dinani batani omwe mungachite pafupi ndi kusankha kwanu ndipo kenako dinani.
Ngati mukufuna kuyanjana, muyenera kuyika nambala yoyamba ndi chiwerengero chomaliza cha zolemba zomwe mukufuna kuziphatikizira musanatsegule OK .
Ngati mwasankha kusindikiza zikalatazo, mutatha kukambirana, mudzafotokozedwa ndi bokosi la dialog. Mungathe kuyanjana nawo mofanana ndi momwe mungakhalire ndi zolembedwa zina zilizonse.