Don saukaka aiki tare da manyan bayanai a cikin tebur, dole ne a umurce su koyaushe gwargwadon takamaiman ma'auni. Bugu da kari, don cika takamaiman manufa, wani lokacin duk tsararren bayanan ba'a buƙatarsu, amma layuka guda ɗaya kawai. Sabili da haka, don kada rudewa cikin babban adadin bayanai, mahimmin ra'ayi shine shirya bayanan, da kuma fitar da ita daga sauran sakamakon. Bari mu gano yadda ake tsara bayanai da kuma sanyawa a cikin Microsoft Excel.
Rarrabe bayanai masu sauƙi
Tace yana daya daga cikin kayan aikin da suka dace yayin aiki a Microsoft Excel. Amfani da shi, zaku iya shirya layuka na tebur a tsarin haruffa, gwargwadon bayanan da ke cikin sel.
Za'a iya yin amfani da bayanai ta hanyar Microsoft Excel ta amfani da maɓallin "Sort da Filter", wanda yake a cikin "Gidan" shafin akan kintinkiri a cikin kayan aikin "Gyara". Amma, da farko, muna buƙatar danna kowane sel na shafi wanda zamu keɓance shi.
Misali, a cikin tebur da ke ƙasa, ya kamata ku ware ma'aikatan haruffa. Mun shiga cikin kowane sel na shafin "Suna", sannan danna maɓallin "Sort da Filter". Don ware sunayen haruffa, daga jerin da ke bayyana, zaɓi “Tace daga A zuwa Z”.
Kamar yadda kake gani, duk bayanan da ke cikin teburin an sanya su, gwargwadon jerin sunayen haruffa.
Domin tsarawa a cikin tsarin baya, a cikin menu guda, zaɓi maɓallin Zaɓi daga Z zuwa A. "
Jerin abubuwan an sake tsara su a tsari na gaba.
Ya kamata a sani cewa wannan nau'in rarrabuwa ana nuna shi kawai tare da tsarin bayanan rubutu. Misali, a tsarin lambobi, ana rarrabe shi ne “Daga mafi karancin zuwa mafi girman” (da kuma biyun), da kuma tsarin kwanan wata, “Daga tsohon zuwa sabo” (da sabanin haka).
Tsarin rarrabawa
Amma, kamar yadda kake gani, tare da nau'ikan alamun rarrabuwa ta ƙimar ɗaya, ana tsara bayanan da ke ɗauke da sunayen mutum ɗaya a cikin kewayon a cikin tsari mai sabani.
Amma menene idan muna so mu ware sunayen haruffa, amma misali, idan sunan ya dace, tabbatar cewa an tsara bayanan ta kwanan wata? Don yin wannan, kazalika da amfani da wasu fasalolin, duka a menu guda "Tsarin da Filin", muna buƙatar zuwa abu "Tsarin Zaɓuɓɓuka ...".
Bayan haka, taga keɓaɓɓen taga yana buɗewa. Idan teburin ku yana da kawunan kai, a kula cewa a wannan taga dole ne a sami alamar bincike kusa da zabin "My bayanai yana dauke da kawunan kai".
A filin “Shafi”, nuna sunan layin da za a yi jerin abubuwa. A cikin lamarinmu, wannan shine shafin "Suna". Filin "tsara" yana nuna nau'in abun cikin da za a ware. Akwai zaɓuɓɓuka huɗu:
- Dabi'u;
- Launin sel;
- Fon launi;
- Alamar tantanin halitta
Amma, a mafi yawan lokuta, ana amfani da abu "Valimar". An saita shi ta tsohuwa. A cikin yanayinmu, zamu kuma amfani da wannan takamaiman kayan.
A cikin shafi "oda" muna buƙatar nuna wane tsari ne za a tsara bayanan: "Daga A zuwa Z" ko kuma bi da bi. Zaɓi darajar "Daga A zuwa Z".
Don haka, mun saita rarrabuwa ta ɗayan ginshiƙai. Domin tsara jerin abubuwa dabam, danna maɓallin "Levelara Level".
Wani saitin filayen ya bayyana, wanda yakamata a cika shi domin rarrabuwa ta wani shafi. A cikin lamarinmu, ta hanyar "Kwanan wata". Tunda an saita tsarin kwanan wata ne a cikin wadannan sel, a filin "Umarni" ba mu sanya dabi'un "Daga A zuwa Z" ba, amma "Daga tsohon zuwa sabo" ko "Daga sabo zuwa sabo".
Ta wannan hanyar, a cikin wannan taga zaka iya saita, idan ya cancanta, rarrabe ta sauran ginshiƙai don fifiko. Lokacin da aka gama saitunan duka, danna maɓallin "Ok".
Kamar yadda kake gani, yanzu a cikin teburinmu duk ana tsara bayanai, na farko, ta sunayen ma'aikaci, sannan, ta hanyar biyan kuɗi.
Amma, wannan ba duk yiwuwa bane na keɓance al'ada. Idan ana so, a cikin wannan taga zaka iya saita rarrabawa ba da ginshiƙai ba, amma ta layuka. Don yin wannan, danna maɓallin "Zaɓuɓɓuka".
A cikin taga za optionsu optionsingukan rarrabuwa wanda yake budewa, matsar da juyawa daga matsayin “Range Lines” zuwa Matsayin “Range ginshikan”. Latsa maɓallin "Ok".
Yanzu, ta hanyar misalai tare da misalin da ya gabata, zaku iya shigar da bayanai don rarrabawa. Shigar da bayanan, sannan danna maballin "Ok".
Kamar yadda kake gani, bayan wannan, an canza ginshiƙan bisa ga sigogin da aka shigar.
Tabbas, don teburinmu, wanda aka ɗauka a matsayin misali, yin amfani da rarrabe tare da sauya wurin da ginshiƙai ba su da amfani musamman, amma ga wasu tebur irin wannan rarrabuwa na iya dacewa sosai.
Tace
Bugu da kari, Microsoft Excel yana da aikin tace bayanai. Yana ba ka damar barin bayyane bayanan kawai waɗanda kuke la'akari da tilas, da ɓoye sauran. Idan ya cancanta, za a iya dawo da bayanan ɓoye koyaushe zuwa yanayin bayyane.
Don amfani da wannan aikin, muna tsaye akan kowane sel a cikin tebur (kuma zai fi dacewa a cikin kai), sake danna maɓallin "Sort da Filter" a cikin kayan aiki na "Gyara". Amma, wannan lokacin, zaɓi abu "Filter" a cikin menu wanda ya bayyana. Hakanan zaka iya maimakon waɗannan ayyukan kawai danna maɓallin kewayawa Ctrl + Shift + L.
Kamar yadda kake gani, a cikin sel tare da sunayen duk ginshiƙai, wani gunki ya bayyana a sashin murabba'i mai kafaɗar, wanda a cikin sigar nuna alwatika mai jujjuyawa yana jujjuya su.
Mun danna wannan gunkin a cikin sashin kwatankwacin abin da za mu tace. A cikin lamarinmu, mun yanke shawarar tace da suna. Misali, muna buƙatar barin bayanai kawai don ma'aikacin Nikolaev. Saboda haka, cire duk sauran ma'aikata.
Lokacin da aka gama aikin, danna maɓallin "Ok".
Kamar yadda kake gani, layuka kawai tare da sunan ma'aikacin Nikolaev sun ragu a cikin tebur.
Bari mu rikita aikin, kuma mu bar a cikin tebur kawai bayanan da suka danganci Nikolaev don kwata na III na 2016. Don yin wannan, danna kan gunkin a cikin "Kwanan wata". A cikin jerin da ke buɗe, buɗe akwatunan watanni "Mayu", "Yuni" da "Oktoba", tunda ba sa cikin rukuni na uku, danna maballin "Ok".
Kamar yadda kake gani, kawai bayanan da muke buƙata sun ragu.
Domin cire tacewa ta wani takamammen shafi kuma nuna bayanan ɓoyewa, sake danna maɓallin alamar dake jikin tantanin tare da taken wannan shafi. A cikin menu wanda yake buɗe, danna kan abu "Cire tacewa daga ...".
Idan kanaso sake sake tacewa gaba daya gwargwadon tebur, to lallai kana bukatar danna maballin "tsara da tangarda" akan kintinkiri kuma zaɓi "Share"
Idan kuna buƙatar cire fil ɗin gaba ɗaya, to, kamar lokacin da kuke gudanar da shi, a cikin menu guda ɗaya ya kamata zaɓi zaɓi "Filter", ko buga maɓallin keɓaɓɓiyar keyboard Ctrl + Shift + L.
Kari kan wannan, ya kamata a lura cewa bayan mun kunna aikin “Filter”, lokacin da ka danna maballin da yake daidai a cikin sel na teburin, abubuwan da muka zayyano a sama zasu zama a cikin menu wanda ya bayyana: “Yanyan tsari daga A zuwa Z” , Tsara daga Z zuwa A, da kuma bambanta ta launi.
Darasi: Yadda zaka yi amfani da injin sarrafa kansa a Microsoft Excel
Tebur mai kauri
Hakanan za'a iya rarrabewa da tacewa ta hanyar sauya bayanan bayanan da kake aiki tare da su zuwa abin da ake kira tebur mai wayo.
Akwai hanyoyi guda biyu don ƙirƙirar tebur mai kaifin baki. Don amfani da farkon su, zaɓi duk yankin teburin, kuma, kasancewa a cikin "Gidan" shafin, danna maɓallin a kan tebur ɗin "Tsarin azaman tebur". Wannan maballin yana cikin toshe kayan aikin "Styles".
Na gaba, zaɓi ɗaya daga cikin salon da kuke so a cikin jerin waɗanda ke buɗe. Zabi ba zai shafi aikin tebur ba.
Bayan wannan, akwatin maganganu yana buɗewa wanda zaka iya canza daidaitawar teburin. Amma, idan kun zaɓi yankin da farko daidai, to babu wani abu kuma da za a yi. Babban abu shine a lura cewa akwai alamar rajistar kusa da sashin "Tebur tare da kawunan kawuna". Bayan haka, danna maballin "Ok".
Idan ka yanke shawara don amfani da hanyar ta biyu, to lallai kuna buƙatar zaɓi duk yankin teburin, amma wannan lokacin je shafin "Saka". Daga nan, a kan kintinkiri a cikin akwatin kayan aikin Tables, danna maɓallin Tebur.
Bayan wannan, kamar lokacin ƙarshe, taga yana buɗewa inda zaku iya daidaita daidaitawar teburin. Latsa maɓallin "Ok".
Ba tare da la’akari da yadda kake amfani da shi ba lokacin ƙirƙirar “smart table”, zaka ƙare tare da tebur a cikin ƙwayoyin kai wanda aka zazzage alamun gumakan da aka bayyana a sama.
Lokacin da ka danna wannan alamar, duk ayyukan guda ɗaya zasu kasance kamar lokacin fara matatar a hanyar da ta dace ta maɓallin "tsara da mado".
Darasi: Yadda za a ƙirƙiri tebur a Microsoft Excel
Kamar yadda kake gani, kayan aikin don rarrabawa da tacewa, idan anyi amfani dasu daidai, zasu iya sauƙaƙe masu amfani suyi aiki tare da tebur. Batun amfani dasu ya zama ya dace musamman idan aka rubuta tsararren bayanai cikin tebur.
