Wataƙila, duk masu amfani da suke aiki tare da Microsoft Excel sun sani game da irin wannan aiki mai amfani na wannan shirin kamar yadda zazzage bayanai. Amma ba kowa ba san cewa akwai siffofi masu mahimmanci na wannan kayan aiki. Bari mu dubi abin da tace na Microsoft Excel mai ƙwarewa zai iya yi kuma yadda za a yi amfani da shi.
Samar da tebur tare da yanayin zaɓuɓɓuka
Domin shigar da tace mai zurfi, da farko, kana buƙatar ƙirƙirar ƙarin tebur tare da yanayin zaɓuɓɓuka. Hanya na wannan tebur daidai ne kamar babban teburin, wanda muke, a gaskiya, za ta tace.
Alal misali, mun sanya wani teburin ƙarin akan babban abu, kuma mun zana furanni a cikin orange. Ko da yake wannan tebur za a iya sanya shi a kowane sarari na sarari, har ma a kan wani takardar.
A yanzu, mun shigar da bayanan ƙarin bayani wanda zai buƙaci a cire daga babban tebur. A cikin shari'armu, daga jerin albashin da aka ba ma'aikata, mun yanke shawarar zaɓar bayanai a kan manyan ma'aikatan maza a ranar 25 ga Yuli, 2016.
Gudun matakan cigaba
Sai kawai bayan da aka ƙirƙiri ƙarin tebur, za ka iya ci gaba da kaddamar da tafin da aka ci gaba. Don yin wannan, je zuwa shafin "Data", da kan rubutun a cikin kayan aiki na "Tsara da Filter", danna maɓallin "Advanced".
Maɓallin taga mai zurfin ya buɗe.
Kamar yadda kake gani, akwai hanyoyi biyu na yin amfani da wannan kayan aiki: "Bincika jerin a wuri", da kuma "Kwafi sakamakon zuwa wani wuri." A cikin akwati na farko, za a yi gyare-gyaren kai tsaye a cikin tebur mai tushe, kuma a cikin akwati na biyu - daban a cikin kewayon kwayoyin da ka saka.
A cikin filin "Bayaniyar tushen" kana buƙatar saka tantanin tantanin halitta daga maɓallin tushe. Ana iya yin haka da hannu ta hanyar buga ɗawainiya daga keyboard, ko kuma ta hanyar zabar sassan da ake buƙata na sel tare da linzamin kwamfuta. A cikin "Range na yanayi", akwai buƙatar ka saka adadin maɓallin kebul na ƙarin, kuma layin da ke ƙunshe da yanayin. A lokaci guda, kana buƙatar kulawa don kada jannunan marasuwa su fada cikin wannan kewayon, in ba haka ba zai yi aiki ba. Bayan duk saitunan da aka yi, danna maballin "Ok".
Kamar yadda ka gani, a cikin tebur na farko akwai kawai dabi'u waɗanda muka yanke shawarar tace.
Idan an zaɓi zabin tare da fitar da sakamakon zuwa wani wuri, to, a cikin filin "Sakamakon sakamakon wuri" yana buƙatar ka ƙayyade kewayon kwayoyin da abin da aka ƙayyade zai zama fitarwa. Hakanan zaka iya tantance tantanin tantanin halitta. A wannan yanayin, zai zama babban hagu na hagu na sabon launi. Bayan an yi zaɓa, danna kan maɓallin "OK".
Kamar yadda ka gani, bayan wannan aikin, tebur na asali ba ya canzawa, kuma an nuna bayanan da aka ƙayyade a cikin tebur daban.
Domin sake saita tace yayin amfani da ginin gini a wuri, kana buƙatar rubutun a cikin "Bayyana da Filter" kayan aiki, danna kan "Maɓallin" Share ".
Ta haka ne, ana iya kammalawa cewa mai sarrafawa mai zurfi yana samar da wasu siffofi fiye da fasalin bayanai. A lokaci guda, ya kamata a lura cewa aiki tare da wannan kayan aiki har yanzu bai dace ba da daidaitattun daidaituwa.
