Lokacin yin kowane irin zane (bisa la'akari da bayanai masu canzawa), ƙididdigar yiwuwar, binciken, bincika tsakanin takaddun daban, neman ƙimar mizani ... ko kawai tebur inda muke fallasa bayanan da muke son tsarawa, Microsoft Excel shine mafi kyawun mafita a kasuwa a yau. Kuma a halin yanzu, zai ci gaba da kasancewa haka tsawon shekaru.
Kodayake gaskiya ne cewa a cikin kasuwa za mu iya samun daban-daban gaba daya free zabi, kamar Libre Office ko Apple Numbers, yawan ayyuka masu rikitarwa basu kusa da wadanda Excel tayi mana. Tablesirƙirar tebur a cikin Excel don juya su zuwa jadawalin abu ne mai sauƙi. Mene ne idan ba mu son sakamakon zane? Mafi kyawun zaɓi a cikin waɗannan sharuɗɗa shine canza layuka don ginshiƙai.
Kodayake yana iya zama wauta, idan muka canza bayanin layuka don na ginshiƙai, sakamakon jadawalin zai iya zama sauƙin fahimta, ba kawai a gare mu ba, har ma ga waɗanda dole ne su karanta daftarin aiki da ake magana. Abubuwa na iya zama masu rikitarwa, lokacin da adadin layuka da ginshiƙai suka yi yawa sosai, tunda yana iya ɗaukar mu lokaci mai yawa, sai dai idan mun yi amfani da aikin da Excel ya ba mu mu yi ta atomatik.
- Da farko dai, dole ne mu zaɓi tebur daga abin da muke so mu juya layuka ta ginshiƙai. Don yin wannan, dole ne kawai mu danna tare da linzamin kwamfuta a cikin kwayar halitta ta farko inda taken bayanan bayanan shafi da jere wanda muke son musanyawa suka ɗauke shi zuwa ƙimar tebur ta ƙarshe.
- Gaba, muna shawagi a kan zaɓi tare da linzamin kwamfuta da daman-dama zuwa kwafa abun ciki zuwa allo.
- Nan gaba, zamu tafi tantanin halitta inda muke son ƙirƙirar sabon tebur tare da layuka da ginshiƙai sun juya kuma mun sanya linzamin kwamfuta inda muke son teburin ya fara. A wannan lokacin, dole ne mu je saman menu na Excel kuma danna kan inverted alwatika wanda aka nuna akan maɓallin Manna. Wannan zaɓin yana ba mu zaɓuɓɓukan gluing na musamman waɗanda aikace-aikacen ke ba mu.
- Don samun damar liƙa abun cikin, amma canza layuka ta ginshiƙai, dole ne mu latsa Fassara.
Idan kun taɓa mamakin abin da zaɓin Transpose ya kasance, kun riga kun sami amsar. Kamar yadda za mu iya a cikin hoton da ke jagorantar wannan labarin, wannan aikin zai kasance mai kula da ƙa'idodin ginshiƙai da layuka don su kasance daidaita da rarrabawar da muka yi.