Wataƙila, duk masu amfani waɗanda ke aiki tare da Microsoft Excel program ɗin koyaushe suna sane da irin wannan aikin mai amfani na wannan shirin kamar yadda ake tace bayanai. Amma ba kowa ba ne yasan cewa akwai kuma kayan aikin wannan kayan aikin. Bari mu bincika abin da Microsoft filter ɗin Microsoft mai haɓaka zai iya yi, da yadda ake amfani da shi.
Irƙira tebur tare da yanayin zaɓi
Don shigar da matattarar haɓaka, da farko, kuna buƙatar ƙirƙirar ƙarin tebur tare da yanayin zaɓi. Taken wannan tebur daidai yake da na babban teburin, wanda mu, a zahiri, zamu tace.
Misali, mun sanya wani tebur a saman wanda yake saman, muka zana kwarorin sa a cikin orange. Kodayake, zaku iya sanya wannan tebur a kowane wuri kyauta, har ma akan wani takarda.
Yanzu, mun shiga cikin ƙarin teburin bayanan da zasu buƙaci tace daga babban tebur. A cikin halinmu na musamman, daga jerin albashin da aka baiwa ma'aikata, mun yanke shawarar zaɓar bayanai akan manyan ma'aikatan maza don 07.25.2016.
Gudun Filin Ci gaba
Sai bayan an ƙirƙiri ƙarin tebur ne kawai za ku iya ci gaba don ƙaddamar da matattara mai ci gaba. Don yin wannan, je zuwa shafin "Data", da kan kintinkiri a cikin kayan aikin "Sort da Filter", danna maɓallin "Ci gaba".
Tsananin tace bayanan ya buɗe.
Kamar yadda kake gani, akwai hanyoyi biyu na amfani da wannan kayan aiki: "Tace jerin a wurin", da "Kwafi sakamakon zuwa wani wurin." A farkon lamari, za a yi matatar kai tsaye a cikin teburin tushen, kuma a karo na biyu, daban a kewayon ƙwayoyin da kuka ayyana.
A cikin "Tushen Source" filin, saka kewayon sel a cikin maɓallin asalin. Ana iya yin wannan da hannu ta hanyar fitar da abubuwan sarrafawa daga maballin, ko ta hanyar sa adadin ƙwayoyin da ake so tare da linzamin kwamfuta. A cikin "Range of situation" filin, dole ne a nuna iri ɗaya na kewayon taken na tablearin tebur da layin da ya containsunshi yanayin. A lokaci guda, kuna buƙatar kulawa don kada layin mara lahani ya faɗi cikin wannan kewayon, in ba haka ba komai zaiyi aiki. Bayan an gama dukkan saitunan, danna maballin "Ok".
Kamar yadda kake gani, abubuwan dabi'un da muka yanke shawarar su ne suka rage a cikin ainihin teburin.
Idan kun zaɓi zaɓi tare da sakamakon da aka nuna a wani wuri, sannan a cikin "Sanya sakamakon a cikin kewayon" filin, kuna buƙatar tantance kewayon sel waɗanda za'a nuna bayanan da aka tace. Kuna iya tantance tantanin halitta guda ɗaya. A wannan yanayin, zai zama babba hagu na sabon tebur. Bayan an yi zaɓi, danna maballin "Ok".
Kamar yadda kake gani, bayan wannan aikin, ainihin tebur ɗin baya canzawa, kuma bayanan da aka tace suna nunawa a cikin tebur daban.
Domin sake saita tacewa yayin amfani da ginin jerin wuraren, kana buƙatar danna maɓallin "Share" akan ribbon a cikin toshe kayan aiki.
Don haka, zamu iya yanke shawara cewa matattarar haɓakawa na samar da ƙarin zaɓuɓɓuka fiye da tace bayanai na al'ada. A lokaci guda, ya kamata a lura cewa yin aiki tare da wannan kayan aiki har yanzu ƙasa ba ta dace ba tare da daidaitaccen ma'aunin ba.
