Excel ilibe mphamvu zogwiritsira ntchito deta mapulogalamu ogwirizana monga SQL Server ndi Microsoft Access. Zomwe zingathe kuchita, komabe, ndizomwe zimakhala zolemba zosavuta kapena zosavuta zomwe zimakwaniritsa zofunikira zoyendetsa deta nthawi zambiri.
Mu Excel, deta imapangidwira m'matawuni pogwiritsa ntchito mizere ndi zigawo za tsamba. Mapulogalamu atsopano kwambiri ali ndi tebulo , zomwe zimapangitsa kuti zikhale zosavuta kulowa, kusintha, ndi kugwiritsira ntchito deta .
Deta iliyonse kapena chidziwitso chokhudza nkhani - monga nambala ya gawo kapena adiresi ya munthu - amasungidwa mu selo limodzi lamasamba lamasamba ndipo amatchulidwa ngati munda.
Malemba Achidule: Ndandanda, Zolemba, ndi Masamba ku Excel
Mndandanda wazithunzithunzi ndi mndandanda wa mauthenga ofanana omwe amasungidwa mu fayilo imodzi kapena makompyuta ambiri mwadongosolo.
Kawirikawiri chidziwitso kapena deta zimakhazikitsidwa mu matebulo. Dongosolo losavuta kapena lachinsinsi, monga Excel, limagwira zonse zokhudza phunziro limodzi mu tebulo limodzi.
Zolinga zamtundu wina, zotsalira, zili ndi matebulo angapo ndi tebulo lililonse lomwe lili ndi zokhudzana ndi nkhani zosiyanasiyana, koma zokhudzana.
Zomwe zili mu tebulo zakonzedweratu kuti zikhale mosavuta:
- Kusinthidwa
- Zosankhidwa
- Akonzedwa
- Kusankhidwa kapena kufufuza zambiri
Zolemba
M'masewero a database, mbiri imagwiritsira ntchito zonse kapena deta zokhudza chinthu china chomwe chatsekedwa m'ndandanda.
Mu Excel, zolemba zimakhazikitsidwa m'mizere yolemba limodzi ndi selo iliyonse mumzere wokhala ndi chidziwitso chimodzi kapena phindu.
Minda
Chidziwitso cha munthu payekha - monga nambala ya foni kapena nambala ya msewu - amatchulidwa ngati munda .
Mu Excel, maselo amodzi a pepala amapanga ngati minda, popeza selo iliyonse imakhala ndi chidziwitso chimodzi cha chinthu.
Maina a Munda
Ndikofunikira kuti deta ikhale yosinthidwa mwadongosolo kuti ikhale yosankhidwa kapena yosankhidwa kuti mudziwe zambiri.
Kuti mutsimikizire kuti deta yalowa mu dongosolo lomwelo la rekodi iliyonse, zilembo zawonjezedwa ku gawo lililonse la tebulo. Mitu ya mitu imeneyi imatchulidwa ngati mayina akumunda.
Mu Excel, mzere wapamwamba wa tebulo uli ndi mayina akumunda pa tebulo. Mzere uwu nthawi zambiri umatchedwa mzere wa mutu .
Chitsanzo
Mu chithunzi pamwambapa, mfundo zonse zasonkhanitsidwa kwa wophunzira mmodzi zimasungidwa mumzere kapena payekha payekha. Wophunzira aliyense, mosasamala kanthu za kuchuluka kwa momwe akusonkhanitsira mfundo ali ndi mzere wosiyana pa tebulo.
Selo lirilonse liri pamzere ndi munda womwe uli ndi chidutswa chimodzi chazomwezo. Maina a m'munda mumzere wotsogolera amathandiza kuti deta ikhale yokonzedwa mwa kusunga deta yonse pa mutu wina, monga dzina kapena zaka, mu gawo lomwelo kwa ophunzira onse.
Zida za Data za Excel
Microsoft imaphatikizapo zipangizo zingapo zadeta kuti zikhale zosavuta kugwira ntchito ndi deta yochuluka yosungidwa mu matebulo a Excel ndikuthandizira kuisunga bwino.
Kugwiritsa Ntchito Fomu ya Zolemba
Chimodzi mwa zida zomwe zimapangitsa kuti zikhale zosavuta kugwira ntchito ndi zolembedwa payekha ndi mawonekedwe a deta. Fomu ikhoza kugwiritsidwa ntchito kupeza, kusintha, kulowetsa, kapena kuchotsa zolemba m'matawu okhala ndi masamba kapena mizere 32.
Fomu yosasinthika imaphatikizapo mndandanda wa mayina amtundu momwe akukonzekera patebulo, kuti atsimikizire kuti zolembedwera zimalowa bwino. Pambuyo pa dzina lililonse lamasamba ndilolemba bokosi lolowetsa kapena kukonza mbali iliyonse ya deta.
Ngakhale kuti n'zotheka kupanga fomu yamakhalidwe, kulenga ndi kugwiritsa ntchito fomu yoperewera ndi kosavuta komanso nthawi zonse ndizofunika.
Chotsani Duplicate Data Records
Vuto lodziwika ndi mazenera onse ndi zolakwika za deta. Kuphatikiza pa zophweka zosavuta zapelera kapena zosowa za deta, zowerengera zolemba zomwe zingakhale zodetsa nkhawa kwambiri ngati deta ya deta ikukula kukula.
Chinthu china cha Excel chachinsinsi chogwiritsidwa ntchito chingagwiritsidwe ntchito kuchotsa zolembazo zowerengera - kaya zenizeni kapena zochepa.
Dongosolo la Kusankha
Kusankha kumatanthauza kukonzanso deta molingana ndi malo enieni, monga kupatula tebulo mwachidule ndi dzina lomaliza kapena nthawi yake kuyambira kalekale mpaka wamng'ono kwambiri.
Zosankha za mtundu wa Excel zikuphatikizapo kusankha ndi malo amodzi kapena angapo, kusankha mwambo, monga tsiku kapena nthawi, ndikusankha ndi mizera yomwe imathekera kukonzanso masitepe patebulo.