Don saukaka aiki tare da babban jerin bayanai a cikin teburin, dole ne a umarce su akai-akai bisa ga wani takaddama. Bugu da ƙari, don dalilai na musamman, wani lokaci ba za'a buƙatar jigidar bayanan bayanai ba, amma kawai ɗayan layi. Sabili da haka, domin kada a damu a cikin babban adadin bayanai, wani bayani mai kyau zai kasance don daidaita bayanai da kuma cirewa daga wasu sakamakon. Bari mu gano yadda za a raba da tace bayanai a cikin Microsoft Excel.
Sassaukar bayanai masu sauki
Kayan yana daya daga cikin kayan aiki mafi dacewa yayin aiki a Microsoft Excel. Tare da shi, zaka iya shirya layuka na tebur a cikin jerin haruffa, bisa ga bayanai da suke cikin sel na ginshiƙai.
Ana rarraba bayanai a cikin Microsoft Excel ta amfani da ma'anar "Tanawa da Filter", wadda take a cikin "Home" shafin a kan rubutun a cikin "Editing" toolbar. Amma na farko, muna buƙatar danna kan kowane tantanin halitta a cikin shafi da za mu shirya.
Alal misali, a cikin teburin da ke ƙasa, dole ne a haɗe ma'aikata a rubuce. Muna zama a kowane tantanin halitta na "Sunan", kuma danna maballin "Tsara da Filter". Don ware sunayen da aka rubuta ta hanyar haruffa, daga lissafin da ya bayyana, zaɓi abu "Yaɗa daga A zuwa Z".
Kamar yadda kake gani, duk bayanan da ke cikin tebur suna samuwa, bisa ga jerin sunayen sunayen haruffa.
Domin yin jeri a cikin tsari, a cikin wannan menu, zaɓi Maɓallin Maɓallin daga Z zuwa A ".
An sake sake gina lissafi a cikin tsari.
Ya kamata a lura cewa irin wannan fasalin yana nuna kawai tare da tsarin rubutun rubutu. Alal misali, lokacin da aka ƙayyade adadin lambobin, ƙaddamar "Daga mafi girma zuwa matsakaicin" (da kuma madaidaiciya) an ƙayyade, kuma lokacin da aka ƙayyade kwanan wata, "Daga tsoho zuwa sabon" (kuma a madaidaiciya).
Tsara ta al'ada
Amma, kamar yadda muka gani, tare da nau'in nau'i na ƙayyadadden ƙira ta daidai wannan darajar, an tsara bayanan da ke ƙunshe sunayen mutane iri ɗaya cikin tsari marar tsaida a cikin kewayon.
Kuma abin da za mu yi idan muna son rarraba sunaye ta hanyar haruffa, amma alal misali, idan sunan ya dace, yin bayanin da aka tsara ta kwanan wata? Don yin wannan, kazalika da amfani da wasu siffofi, duk a cikin wannan menu "Raba da kuma tace", muna buƙatar mu je wurin abu "Siffar al'adu ...".
Bayan haka, maɓallin saitin maɓallin ya buɗe. Idan akwai rubutun a cikin teburinka, to sai a lura cewa a cikin wannan taga akwai alamar dubawa kusa da "Bayanan na yana ƙunshe da rubutun".
A cikin filin "Column" saka sunan mahaɗin, wanda za'a tsara. A cikin yanayinmu, wannan shine sunan "Sunan". A cikin filin "Rabawa" an nuna ta hanyar irin nau'in abun ciki za'a tsara. Akwai zaɓi huɗu:
- Amsa;
- Launi na launi;
- Font launi;
- Alamar salula
Amma, a mafi yawan lokuta, ana amfani da "Ƙimar". An saita ta tsoho. A yanayinmu, zamu yi amfani da wannan abu.
A cikin "Rundin" shafi, muna buƙatar siffanta umarnin da za'a samo bayanan: "Daga A zuwa Z" ko kuma mataimakin. Zaɓi darajar "Daga A zuwa Z".
Sabili da haka, zamu shirya fashewa ta daya daga cikin ginshiƙai. Domin tsara siffantawa a wani shafi, danna kan maɓallin "Add matakin".
Wani bangare na filayen ya bayyana, wanda ya kamata a cike da shi don rigaya ta wani shafi. A cikin shari'ar mu, ta hanyar "kwanan wata". Tun lokacin da aka saita tsarin kwanan wata a waɗannan sel, a cikin "Order" filin da muke sanya dabi'u ba "Daga A zuwa Z", amma "Daga tsoho zuwa sabon", ko "Daga sabuwar zuwa tsufa."
Hakazalika, a cikin wannan taga, za ka iya saita, idan ya cancanta, da kuma rarraba wasu ginshiƙai don fifiko. Lokacin da aka gama saitunan, danna maballin "Ok".
Kamar yadda kake gani, yanzu a teburinmu dukkan bayanai an ware, na farko, da sunan ma'aikacin, sannan, ta hanyar biyan kuɗi.
Amma, wannan ba duk fasalin fasalin al'ada ba. Idan ana so, a cikin wannan taga zaka iya saita fashewa ba ta ginshiƙai ba, amma ta layuka. Don yin wannan, danna kan maɓallin "Yanayin".
A cikin jerin siginan shingen budewa, motsa sauyawa daga matsayi "Lines Lines" zuwa matsayi "ginshiƙai Range". Danna maballin "OK".
Yanzu, ta hanyar kwatanta da misali na baya, zaka iya shigar da bayanai don rarrabawa. Shigar da bayanai, kuma danna maballin "Ok".
Kamar yadda ka gani, bayan haka, ana juyo ginshiƙai bisa ga sigogin da aka shigar.
Tabbas, a kan teburin mu, misali misali, yin amfani da fashewa tare da canza wuri na ginshiƙai ba amfani ba ne, amma ga wasu tebur wannan nau'i na iya zama daidai.
Filter
Bugu da kari, a cikin Microsoft Excel, akwai aikin sarrafa bayanai. Yana ba ka damar barin bayyane kawai bayanan da ka ga ya dace, kuma ka boye sauran. Idan ya cancanta, ana iya mayar da bayanan da aka ɓoye a yanayin da aka gani.
Domin amfani da wannan aikin, za mu danna kan kowane tantanin halitta a cikin tebur (kuma zai fi dacewa a cikin rubutun), sannan kuma danna maɓallin "Tsara da Filter" a cikin "Gyara" kayan aiki. Amma, wannan lokaci a menu wanda ya bayyana, zaɓi abu "Filter". Hakanan zaka iya maimakon waɗannan ayyuka kawai danna maɓallin haɗin haɗin Ctrl + Shift L. L.
Kamar yadda kake gani, a cikin sel tare da sunan dukkan ginshiƙai, wani gunki ya bayyana a cikin hanyar ma'auni, wanda aka rubuta rubutun alƙaluman ƙasa.
Danna kan wannan gunkin a cikin shafi wanda za mu tace. A halinmu, mun yanke shawarar tace ta da suna. Alal misali, muna bukatar mu bar bayanai kawai ma'aikacin Nikolaev. Saboda haka, za mu cire alamar daga sunayen dukkan sauran ma'aikata.
Lokacin da aka kammala aikin, danna maballin "Ok".
Kamar yadda muka gani, a cikin teburin akwai kawai layi tare da sunan ma'aikacin Nikolaev.
Bari mu kara aiki, kuma mu bar bayanan da ya danganci Nikolaev don rukunin III na 2016. Don yin wannan, danna gunkin a tantanin halitta "Ranar". A cikin jerin da ya buɗe, cire tikitin daga watanni na "Mayu", "Yuni" da "Oktoba", saboda ba su da alaka da kashi ɗaya na uku, kuma danna maballin "Ok".
Kamar yadda kake gani, akwai bayanai kawai muke bukata.
Domin cire takarda a kan wani takamaiman shafi, kuma don nuna bayanan da aka ɓoye, sake danna gunkin dake cikin tantanin halitta tare da sunan wannan shafi. A cikin menu da ya buɗe, danna kan abu "Cire tace daga ...".
Idan kana so ka sake saita tace a matsayin cikakken bisa ga teburin, to kana buƙatar danna maɓallin "Raba da Filter" akan rubutun, sa'annan zaɓi zaɓi "Maɓallin".
Idan kana buƙatar cire fuska gaba daya, to, a lokacin da aka fara, a cikin wannan menu, zaɓi "Filter" abu, ko kuma rubuta maɓallin haɗin haɗin kan keyboard Ctrl + Shift L. L.
Bugu da ƙari, ya kamata a lura cewa bayan mun juya aikin "Filter", lokacin da ka danna kan icon ɗin da ya dace a cikin ɗakunan maɓallin kewayawa, a cikin menu wanda aka bayyana, ana samun ayyuka masu rarraba, wanda muka ce a sama: "A ware A zuwa Z" , "Sanya daga Z zuwa A", da kuma "Tsara ta launi".
Koyawa: Yadda za a yi amfani da tace ta atomatik a Microsoft Excel
Salon mai launi
Za'a iya iya rarrabawa da kuma tacewa ta hanyar juyawa yankin da kake aiki da shi a cikin wani "mai launi" mai mahimmanci.
Akwai hanyoyi biyu don ƙirƙirar tebur mai mahimmanci. Domin amfani da farko daga cikinsu, zaɓi dukan yanki na teburin, kuma, kasancewa a cikin Home shafin, danna kan maɓallin a kan Tsarin a matsayin Teburin Teburin. Wannan maɓallin yana samuwa a cikin kayan aikin Styles.
Kusa, zaɓi ɗaya daga cikin tsarin da kuka fi so a jerin da ke buɗewa. Zaɓin tebur bai rinjayi aikin da teburin ba.
Bayan haka, akwatin maganganu yana buɗewa inda zaka iya canza matsayin haɗin kebul. Amma, idan kun rigaya zaba yankin daidai, to babu wani abu da za a yi. Babban abu shine a lura cewa akwai alamar kusa da madaurin "Tebur da BBC". Na gaba, danna danna "OK" kawai.
Idan ka yanke shawara don amfani da hanyar na biyu, to sai ka buƙaci zaɓar dukan yankin tebur, amma wannan lokaci zuwa shafin "Saka". Duk da yake a nan, a kan rubutun a cikin "Tables" kayan aiki, ya kamata ka danna kan "Shigar" button.
Bayan haka, kamar lokaci na ƙarshe, taga zai buɗe inda za ku iya daidaita daidaitattun ladabi na tebur. Danna maballin "OK".
Ko da wane irin hanya kake amfani da lokacin da kake samar da tebur mai kaifin baki, za ka ƙare tare da tebur, a cikin ɓangaren ƙwanƙolin waɗanda alamun da aka bayyana a baya zasu shigar.
Lokacin da ka danna kan wannan gunkin, duk ayyuka ɗaya zasu kasance kamar lokacin da aka fara da tace a cikin hanya madaidaiciya ta hanyar maɓallin "Tsara da Filter".
Darasi: Yadda za a ƙirƙiri tebur a cikin Microsoft Excel
Kamar yadda kake gani, kayan rarraba da gyaran kayan aiki, idan aka yi amfani da su yadda ya dace, zai iya taimakawa masu amfani suyi aiki tare da tebur. Musamman mahimmanci shine tambaya game da amfani da su a yayin da tebur ya ƙunshi babban jigilar bayanai.
