Don dacewa da aiki tare da babban bayanan bayanai a cikin tebur, suna da mahimmanci koyaushe su tsara bisa ga takamaiman ra'ayi. Bugu da kari, don cika takamaiman dalilai, wani lokacin ba a buƙatar duka bayanan duka, amma kawai layi ne kawai. Sabili da haka, don kada a rikice cikin babban adadin bayanai, maganin m m bayanai, da kuma tace daga wasu sakamakon. Bari mu gano yadda ke warware matsalar da tace bayanai a Microsoft Excel ana yin su.
Sauƙaƙe bayanai
Rarraba shine ɗayan kayan aikin da ya fi dacewa lokacin aiki a Microsoft Excel. Amfani da shi, zaku iya sanya layin tebur a cikin tsarin haruffa, bisa ga bayanan da suke cikin sel na shafi.
Data kasawa a cikin Microsoft Excel shirin za a iya yi amfani da "A ware da kuma Tace" button, wanda aka posted a cikin Home shafin a kan tef a Editing toolbar. Amma, kafin haka, muna buƙatar danna kowane sel na waccan shafi wanda za mu iya yin rarrabewa.
Misali, a cikin tebur da aka gabatar a ƙasa, ya zama dole don tsara ma'aikata ta haruffa. Mun zama a cikin kowane sel na "Suna" shafi ", kuma danna maɓallin" Sort da tace ". Saboda haka an shirya sunayen ta hanyar haruffa, zaɓi abu "rarrabe daga A zuwa z" daga jerin.
Kamar yadda kake gani, duk bayanai a cikin tebur yana zaune, gwargwadon jerin hanyoyin haruffa.
Domin a ware a cikin juzu'in baya, a cikin menu iri ɗaya, zaɓi maɓallin nau'in daga ni har zuwa ".
An sake gina lissafin a cikin tsari na baya.
Ya kamata a lura cewa an nuna irin nau'in rarrabuwa kawai tare da tsarin bayanan rubutu. Misali, tare da tsari mai lamba, rarrabuwa "daga mafi karancin zuwa matsakaicin" (kuma, akasin haka), kuma lokacin da tsarin kwanan wata to "daga tsohon zuwa sabon" (kuma, akasin haka).
Rarrabuwa rarrabe
Amma, kamar yadda muke gani, tare da nau'ikan nau'ikan rarrabawa ta darajar ɗaya, bayanan da ke ɗauke da sunayen mutumin da ke cikin kewayon tsari.
Kuma abin da za a yi idan muna son rarrabe sunayen bisa ga haruffa, amma alal misali, lokacin da kuka dace da sunan don kwanan wata? A saboda wannan, da kuma amfani da wasu fasalolin, irin wannan a cikin menu ɗaya "Tsoro da tace", muna buƙatar zuwa abun "m rarrabawa ...".
Bayan haka, taga saitunan taga yana buɗewa. Idan akwai kanun labarai a cikin teburinku, to, ku lura cewa a cikin wannan taga wajibi ne don ya tsaya alamar bincike kusa da "bayanan na ya ƙunshi" siga.
A cikin filin "shafi", saka sunan shafin da aka samu. A cikin lamarinmu, wannan shine "Sunan" shafi. A cikin "raba" filin, an tsara shi gwargwadon irin nau'in abun ciki za a ware. Akwai zaɓuɓɓuka huɗu:
- Dabi'u;
- Launi na tantanin halitta;
- Font launi;
- Icon tantanin halitta.
Amma, a cikin mafi yawan rinjaye, ana amfani da abun "dabi'u". An saita shi ta tsohuwa. A cikin lamarinmu, zamu kuma amfani da wannan abun.
A cikin shafi na "oda" muna bukatar mu ayyana, a wane irin bayani za a samo su: "Daga A zuwa Z" ko akasin haka. Zaɓi darajar "daga A zuwa Z."
Don haka, mun kafa rarrabe daya daga cikin ginshiƙai. Don daidaita rarrabewa a kan wani shafi, danna maɓallin "ƙara matakin".
Wata filayen filayen sun bayyana, wanda ya kamata a cika don rarrabawa cikin wani shafi. A cikin lamarinmu, a cewar shafi "kwanan wata". Tun lokacin da aka saita ranar da waɗannan ƙwayoyin sel, sannan a filin "oda" mun saita dabi'u ba "daga A zuwa Sabon", ko "daga cikin Sabon" .
Haka kuma, a cikin wannan taga zaka iya saita, idan ya cancanta, da rarrabe sauran ginshiƙai don fifiko. Lokacin da aka yi duk saiti, danna maɓallin "Ok".
Kamar yadda kake gani, yanzu a cikin teburinmu duk bayanai da aka ware, da farko, ta sunayen ma'aikata, sannan, ta hanyar kwanakin aiki.
Amma, wannan ba duk damar warware al'ada ba. Idan ana so, a cikin wannan taga, zaku iya saita warware nau'ikan marasa ginshiƙai, amma ta hanyar layi. Don yin wannan, danna maɓallin "sigogi".
A cikin raba sigogi wanda ke buɗewa, muna fassara sauyawa daga "jere" zuwa ga "ginshiƙan ginshiƙi" matsayi. Latsa maɓallin "Ok".
Yanzu, ta hanyar analogy tare da misalin da ya gabata, zaku iya yin rubutun don rarrabewa. Shigar da bayanan, kuma danna maballin "Ok".
Kamar yadda muke gani, bayan wannan, ginshiƙai sun canza wurare, bisa ga sigogi da aka shigar.
Tabbas, don teburinmu, la'akari da rarrabewa, amfanin rarrabewa tare da canji a cikin shafin ba ya ɗaukar amfani na musamman, amma ga wasu nau'ikan nau'ikan nau'ikan na iya zama mai dacewa sosai.
Tata
Bugu da kari, a Microsoft Excel, akwai aikin tace data. Yana ba ku damar barin abubuwan bayyane kawai kawai waɗancan bayanan da kuka yi la'akari da suka zama dole, sauran ɓoye. Idan ya cancanta, ya cancanta koyaushe za'a iya mayar da shi zuwa yanayin bayyane.
Don amfani da wannan fasalin, muna zama a kan kowane sel a cikin tebur (kuma zai fi dacewa a cikin taken), kuma muna danna maɓallin "Sort da tace" a cikin akwatin kayan. Amma, wannan lokacin a menu wanda ya bayyana, zaɓi abu na "tace". Hakanan zaka iya maimakon waɗannan ayyukan kawai danna Ctrl + Canja wurin haɗuwa.
Kamar yadda muke gani, sel a cikin nau'i na murabba'i ya bayyana a cikin sel tare da sunan duka ginshiƙai, wanda aka juya alwatika.
Latsa wannan gunkin a cikin shafi, gwargwadon abin da za mu tace. A cikin lamarinmu, mun yanke shawarar tace da suna. Misali, muna buƙatar barin bayanan kawai ta hannun Nikolaev. Saboda haka, toshewa daga sunayen duk sauran ma'aikatan.
Lokacin da aka sanya hanyar, danna maɓallin "Ok".
Kamar yadda muke gani, kawai kirtani tare da sunan ma'aikacin Nikolaev ya kasance a cikin tebur.
Kammala aikin, kuma za mu bar tebur a cikin tebur wanda ya danganta ga Nikolaev ga III kwata na 2016. Don yin wannan, danna kan gunkin a cikin sel. A cikin jerin da ke buɗe, cire akwati daga watanni "Mayu" da "Oktoba", kamar yadda ba su cikin kwata na uku, kuma danna maɓallin "Ok".
Kamar yadda kake gani, kawai bayanan da muke buƙata ya kasance.
Domin cire matatar a kan takamaiman shafi, kuma nuna bayanan da ke ciki, sake, danna kan gunkin da ke cikin sel tare da taken wannan shafi. A cikin menu na bude, danna "Share tent c ..." abu.
Idan kana son sake saita tace a ko'ina a kan tebur, to latsa ka danna maballin "irin" a tef, ka zaɓi "aɓi".
Idan kana buƙatar cire matatar gaba ɗaya, to, kamar lokacin da ya fara, to ya kamata ka zaɓi maɓallin maɓallin maɓallin, ko buga maɓallin maballin.
Bugu da kari, ya kamata a lura da cewa bayan mun kunna aikin "tace", to, lokacin da muke magana a sama ana samun su a menu wanda muka bayyana: "Rarrabe daga A zuwa Z", "rarrabe ni zuwa", da "rarrabe cikin launi."
Darasi: Yadda ake amfani da Autoflter a Microsoft Excel
Tebur mai hikima
Hakanan za'a iya kunna rarrabawa, juya fannin bayanan da kuka yi aiki a cikin abin da ake kira "Table".
Akwai hanyoyi guda biyu don ƙirƙirar tebur mai ƙarfi. Don yin amfani da farkonsu, ware duk yankin na tebur, kuma, yayin da cikin "gida", danna maɓallin maɓallin "Tsara a matsayin tebur". Wannan maɓallin yana cikin kayan aikin "salon".
Bayan haka, mun zabi ɗaya daga cikin salon da kuke so, a cikin jerin da ke buɗe. Ba za ku iya shafar aikin tebur ba.
Bayan haka, akwatin maganganu yana buɗewa wanda zaka iya canza daidaitawar tebur. Amma idan kun sanya yankin daidai, ba kwa buƙatar wani abu. Babban abu, lura da cewa "tebur tare da kanun labarai" sigogi ya tsaya alamar bincike. Bayan haka, danna maɓallin "Ok".
Idan ka yanke shawarar yin amfani da hanya ta biyu, to kuma kuna buƙatar haskaka duka yankin tebur, amma wannan lokacin je zuwa "Saka" shafin. Kasance a nan, a kan tef a cikin kayan aikin "Table kayan aiki", ya kamata ka danna maballin "Table".
Bayan haka, a matsayin lokacin ƙarshe, taga zai buɗe inda jerin abubuwan da za a gyara. Latsa maɓallin "Ok".
Ba tare da la'akari da yadda kake amfani da lokacin da "tebur mai wayo ba, a ƙarshe zamu sami tebur, a cikin sel na iyakokin da muka bayyana.
Lokacin da ka danna wannan gunkin, duk irin wannan ayyuka za su samu kamar lokacin da ka fara tace tare da daidaitaccen tsari ta hanyar maɓallin "irin tsari.
Darasi: Yadda ake ƙirƙirar tebur a Microsoft Excel
Kamar yadda kake gani, rarrabuwa da kayan aikin tacewa, tare da amfanin da suka dace, na iya sauƙaƙe masu amfani don yin aiki tare da tebur. Wani batun da ya dace da amfani da amfanin su ya zama a lokacin da aka kawo cewa an rubuta manyan bayanan bayanai masu yawa a cikin tebur.