Barka da rana
Labarin yau game da zane-zane. Wataƙila, duk wanda ya taɓa yin ƙididdiga, ko tsara wani tsari, koyaushe yana da buƙatar gabatar da sakamakon su a cikin jadawali. Kari akan haka, ana iya gano sakamakon lissafin wannan tsari cikin sauki.
Ni kaina na tsallaka zane-zane a karo na farko lokacin da na gabatar da gabatarwa: don nuna a fili ga masu sauraro inda zan nemi riba, ba za ku iya tunanin wani abu mafi kyau ...
A cikin wannan labarin, Ina so in nuna tare da misali yadda ake gina zane a cikin Excel a cikin sigogi daban-daban: 2010 da 2013.
Mai zane a cikin Excel daga 2010. (a 2007 - makamancin haka)
Bari mu sauƙaƙa ginin cikin misalai a cikin matakai (kamar yadda yake a cikin wasu labaran).
1) Da ace Excel yana da karamin kwamfutar hannu tare da alamomi da yawa. A cikin misalaina, na ɗauki watanni da yawa da nau'ikan riba. Gabaɗaya, alal misali, ba mahimmanci irin nau'in adadi muke da su ba, yana da mahimmanci kama ma'anar ...
Don haka, kawai zamu zaɓi wannan yankin teburin (ko kuma gaba ɗaya tebur), a kan abin da zamu gina jadawali. Dubi hoton da ke ƙasa.
2) Na gaba, daga saman a cikin menu na Excel, zaɓi ɓangaren "Saka" sannan danna kan sashin "Graph", sannan daga jerin zaɓin zaɓi zaɓi ginshiƙi wanda kake buƙata. Na zabi mafi sauki - mafi kyawun yanayi, lokacin da aka gina layi madaidaiciya akan maki.
3) Lura cewa bisa ga kwamfutar hannu, muna da layuka 3 masu lalacewa waɗanda suke bayyana a cikin jadawalin, suna nuna cewa riba tana ƙaruwa duk wata. Af, Excel ta atomatik gano kowane layi a cikin ginshiƙi - ya dace sosai! A zahiri, yanzu za'a iya kwafin wannan ginshiƙi ko da a cikin gabatarwa, har a cikin rahoto ...
(Na tuna yadda muka zana karamin jadawalin rabin rabin rana a makaranta, yanzu ana iya ƙirƙirar shi a cikin mintuna 5 akan kowace komputa tare da Excel ... Fasaha ta ci gaba, kodayake.)
4) Idan bakya son madaidaicin salo, zaku iya yin ado dashi. Don yin wannan, danna sau biyu a kan tebur tare da maɓallin linzamin kwamfuta na hagu - taga zai bayyana a gabanka, a cikin sauƙin sauyawa ƙira. Misali, zaku iya cika kwalliyar ta da wani launi, ko canza launi iyakar, salon, girman, da sauransu. Ku shiga cikin shafuka - Excel zai nuna nan da nan yadda kwalin zai yi kama da bayan an adana dukkan sigogin da aka shigar.
Yadda ake gina zane a cikin Excel daga 2013
Af, wanda baƙon abu ne, mutane da yawa suna amfani da sabbin shirye-shirye na shirye-shirye, ana sabunta su, kawai don Office da Windows wannan ba su da amfani ... Yawancin abokaina har yanzu suna amfani da Windows XP da tsohon juyi na Excel. Suna cewa kawai sun fahimci shi ne, kuma me yasa aka canza tsarin aiki ... Saboda Ni kaina na riga na canza zuwa sabuwar sigar daga 2013, Na yanke shawara cewa ina buƙatar nuna yadda zan ƙirƙirar jadawali a cikin sabon fasalin na Excel. Af, don yin komai a kusan iri ɗaya, abu mafi kyau a cikin sabon sigar shine masu haɓaka sun goge layin tsakanin jadawali da ginshiƙi, ko kuma a haɗa su.
Sabili da haka, mataki-mataki ...
1) Misali, Na dauki wannan takarda kamar baya. Abu na farko da muke yi shine zaɓi kwamfutar hannu ko ɓangarenta daban, wanda zamu gina ginshiƙi.
2) Na gaba, je zuwa "INSERT" sashe (a sama, kusa da menu na "FILE") sannan zaɓi maɓallin "Shawarwarin da aka ba da shawarar". A cikin taga wanda ya bayyana, mun sami jadawalin da muke buƙata (Na zaɓi nau'in al'ada). A zahiri, bayan danna "Ok" - mai hoto zai bayyana kusa da farantanka. Sannan zaku iya matsar dashi zuwa wurin da ya dace.
3) Don canja shimfidar ginshiƙi, yi amfani da maballin da ya bayyana ga dama daga ita yayin da kake tafe da linzamin kwamfuta. Kuna iya canza launi, salon, launi iyaka, cika tare da wasu launi, da dai sauransu A matsayinka na mai mulkin, babu tambayoyi tare da zane.
A kan wannan labarin ya ƙare. Dukkan mafi kyau ...
