Sannu
Daga kwarewa na zan faɗi wani abu mai mahimmanci: yawancin masu amfani da rashin fahimta na Excel (kuma ina cewa suna da rashin sanin cikakken farashi). Wataƙila zan yi hukunci daga kwarewar sirri (lokacin da ba zan iya ƙara lambobi biyu ba) kuma ban yi tunanin dalilin da ya sa nake buƙatar Excel, sa'an nan kuma na zama mai amfani "mediocre" a Excel - Na iya magance sau da yawa sauƙi ayyuka da abin da nake amfani da su "tunani"
Dalilin wannan labarin ba wai kawai ya nuna yadda za a yi wani mataki ba, amma kuma ya nuna yiwuwar shirin da za a yi amfani da masu amfani da kullun da ba su sani ba game da su. Bayan haka, mallakin kwarewa na farko na aiki a Excel (kamar yadda na faɗa a baya) - zaka iya sauke aikinka sau da yawa!
Kalmomi ƙananan umarni ne don aiwatar da wani aiki. Na zabi batutuwa na darussan akan tambayoyin da na saba amsawa.
Darasi na darussan: rarraba jerin ta hanyar da ake buƙatar, lambobi masu lakabi (jimlar dabarar), tace layuka, ƙirƙirar tebur a Excel, ƙirƙirar hoto (ginshiƙi).
Excel 2016 Tutorials
1) Yadda za a raba lissafi a rubuce, a cikin tsari mai hau (bisa ga shafi / shafi da ake bukata)
Irin waɗannan ayyuka ana samun sauƙin yawa. Alal misali, akwai tebur a Excel (ko ka kwafe shi a can) kuma yanzu kana buƙatar gyara shi ta wasu ginshiƙai / shafi (alal misali, tebur kamar Fig. 1).
Yanzu aikin: yana da kyau a raba shi ta hanyar ƙara yawan lambobi a watan Disamba.
Fig. 1. Samfurin samfurin don rarrabawa
Da farko kana buƙatar zaɓin teburin tare da maɓallin linzamin hagu: lura cewa kana buƙatar zaɓar ginshiƙai da ginshiƙai da kake son warwarewa (wannan wani muhimmiyar mahimmanci ne: alal misali, idan ban zaɓi shafi na A (tare da sunayen mutane) kuma toshe ta "Disamba" ba - to, halayen daga shafi na B za a rasa dangane da sunaye a shafi na A. Wato, haɗin za a karya, kuma Albina ba zai kasance daga "1" ba, amma daga "5", alal misali).
Bayan zaɓin teburin, je zuwa sashe na gaba: "Data / Sort" (duba fig. 2).
Fig. 2. Zaɓin zaɓi na zaɓi + da rarrabawa
Sa'an nan kuma kana buƙatar daidaita fasalin: zaɓi shafi wanda zai tsara da kuma jagora: hawa ko sauka. Babu wani abu na musamman don yin sharhi kan (duba siffa 3).
Fig. 3. Sanya saitunan
Sa'an nan kuma za ku ga yadda ake shirya tebur a daidai lokacin da shafi ya so! Saboda haka, tebur za a iya tsara ta sauri da sauƙi ta kowane shafi (duba siffa 4)
Fig. 4. sakamakon sakamako
2) Yadda za a ƙara lambobi da dama a cikin tebur, da ma'anar jimla
Har ila yau, ɗaya daga cikin ayyukan da aka fi sani. Yi la'akari da yadda za'a warware shi da sauri. Ka yi la'akari da cewa muna bukatar mu ƙara watanni uku kuma mu sami adadin kuɗi don kowane ɗan takara (duba Fig. 5).
Mun zaɓi tantanin tantanin halitta wanda muke son karban kuɗi (a cikin siffa 5 - wannan zai zama "Albina").
Fig. 5. Zabin salula
Kashi na gaba, je zuwa sashen: "Formulas / Mathematical / SUM" (wannan shine jimlar lissafi wanda ya kara da dukkanin jikin da ka zaba).
Fig. 6. Adadin dabara
A gaskiya, a cikin taga wanda ya bayyana, kana buƙatar saka (zaɓi) sel da kake so ka ƙara. Ana yin haka sosai kawai: zaɓi maɓallin linzamin hagu kuma danna maballin "OK" (duba Fig. 7).
Fig. 7. Kayan Kwayoyin
Bayan haka, za ku ga sakamakon a cikin cell da aka zaba (duba siffa 7 - sakamakon shine "8").
Fig. 7. Sakamakon sakamakon
A ka'idar, irin wannan adadin yawanci ana buƙata ga kowane ɗan takara a cikin tebur. Sabili da haka, domin kada a sake shigar da wannan tsari da hannu - zaka iya kwafa shi cikin sel da ake so. A gaskiya ma, komai yana da sauƙi: zaɓin tantanin halitta (a cikin siffa 9 - wannan E2), a kusurwar wannan tantanin halitta za'a sami karamin madaidaici - "ja shi" zuwa ƙarshen tebur!
Fig. 9. Sakamakon sauran layin
A sakamakon haka, Excel zai lissafta adadin kowane ɗan takara (duba Figure 10). Duk abu mai sauki ne da sauri!
Fig. 10. Sakamakon
3) Tacewa: barin waɗannan layuka inda darajar ta fi girma (ko inda yake ƙunshi ...)
Bayan an ƙididdige kuɗin, sau da yawa, ana buƙatar barin waɗanda suka cika wani shamaki (misali, sanya fiye da 15). Don wannan Excel yana da siffar musamman - a tace.
Da farko kana buƙatar zaɓar tebur (duba siffa 11).
Fig. 11. Bayyana teburin
Bugu da ari a cikin menu na sama bude: "Data / tace" (kamar yadda a cikin siffa 12).
Fig. 12. Filter
Ya kamata ya bayyana kananan "kibiyoyi" 
. Idan ka danna kan shi, za a iya buɗe maɓallin tace: za ka iya zaɓa, misali, maɓallin numeric kuma saita abin da layuka don nuna (alal misali, zaɓin "ƙarin" zai bar waɗanda ke da mafi yawan lamba a cikin wannan shafi fiye da yadda ka bayyana).
Fig. 13. Saitunan Filter
By hanyar, lura cewa za a iya saita tafin kowane shafi! Gurbin inda akwai bayanan rubutu (a cikin yanayin mu, sunayen mutane) za a tace ta da sauran filters masu yawa: wato, babu sauran da ƙasa (kamar yadda a cikin filtata na lamba), amma "fara" ko "ya ƙunshi". Alal misali, a misalin na gabatar da tace don sunayen da suka fara da harafin "A".
Fig. 14. Rubutun sunan ya ƙunshi (ko ya fara da ...)
Kula da abu daya: ginshiƙan da aka yi amfani da tace ana alama a hanya ta musamman (duba kore kibiyoyi a siffar 15).
Fig. 15. An kammala ajiya
Gaba ɗaya, tace mai amfani ne mai mahimmanci kuma mai amfani. Ta hanyar, don kashe shi, kawai a saman menu na Excel - danna maballin wannan sunan.
4) Yadda za a ƙirƙiri tebur a Excel
Daga irin wannan tambaya, wani lokacin zan rasa. Gaskiyar ita ce Excel ita ce babban tebur. Gaskiya ne, ba shi da iyaka, babu launi, da dai sauransu. (Kamar yadda yake a cikin Kalma - kuma wannan yana yaudarar mutane da yawa).
Mafi yawancin lokuta, wannan tambaya yana haifar da ƙirƙirar iyakoki na kan iyakoki (shimfiɗa tebur). Anyi wannan sauƙin sauƙi: da farko zaɓi dukan tebur, to je zuwa sashen: "Home / Format a matsayin tebur." A cikin taga mai tushe ka zaɓi zanen da kake buƙata: nau'i-nau'i, launi, da dai sauransu (dubi fig. 16).
Fig. 16. Sanya azaman tebur
An nuna sakamakon tsarawa a Fig. 17. A wannan tsari, ana iya canja wannan tebur, alal misali, zuwa takardun Kalma, yin tasirin hoto mai ban mamaki, ko kuma gabatar da shi a kan allon don masu sauraro. A cikin wannan tsari, yana da sauƙin "karanta".
Fig. 17. Tsara tsarin
5) Yadda za a gina fayil / ginshiƙi a Excel
Don gina ginshiƙi, zaka buƙaci tebur mai shirye-shirye (ko akalla 2 ginshikan bayanai). Da farko, kana buƙatar ƙara chart, don yin wannan, danna: "Saka / zane / zane-zane" (alal misali). Zaɓin ginshiƙi ya dogara da bukatun (wanda kuke bin) ko abubuwan da kuke so.
Fig. 18. Saka layin zane
Sa'an nan kuma za ka iya zabar salo da zane. Ina ba da shawara kada a yi amfani da launuka masu rauni da launuka (ruwan hoda mai haske, rawaya, da dai sauransu) a cikin zane-zane. Gaskiyar ita ce yawanci ana yin zane don nuna shi - kuma waɗannan launi ba su da hankali sosai a kan allon da kuma lokacin da aka buga (musamman ma idan mai bugawa ba shine mafi kyawun) ba.
Fig. 19. Tsarin launi
A gaskiya, ya rage ne kawai don saka bayanan da aka ba da ginshiƙi. Don yin wannan, danna kan shi tare da maballin linzamin hagu: a saman, cikin menu na Excel, sashen "Aiki tare da Sharuɗɗa" ya kamata ya bayyana. A cikin wannan ɓangaren, danna "Select Data" tab (duba Figure 20).
Fig. 20. Zaɓi bayanai don chart
Sa'an nan kuma kawai zaɓi shafin tare da bayanan da kake buƙatar (tare da maɓallin linzamin hagu) (kawai zaɓi, babu abin da ake bukata).
Fig. 21. Zaɓin bayanan bayanai - 1
Sa'an nan kuma riƙe ƙasa maɓallin CTRL kuma zaɓi shafin tare da sunayen (alal misali) - duba fig. 22. Next, danna "Ya yi."
Fig. 22. Zaɓin tushen bayanai - 2
Ya kamata ku dubi zane-zane (duba fig. 23). A cikin wannan tsari, yana da matukar dace don ƙayyade sakamakon aikin kuma a fili ya nuna wasu lokuta.
Fig. 23. Sakamakon zane
A gaskiya, a kan wannan kuma wannan zane zan taƙaita sakamakon. A cikin labarin da na tattara (shine a gare ni), duk tambayoyi masu mahimmanci da suka taso ga masu amfani da novice. Bayan ci gaba da waɗannan fasali - ba za ku lura da yadda sabon "kwakwalwan kwamfuta" zai fara gano sauri da sauri ba.
Bayan koyon yin amfani da maƙalar 1-2, da dama wasu ƙididdiga za a "halitta" a daidai wannan hanya!
Bugu da kari, Ina bayar da shawarar sabon shiga wani labarin:
Good Luck 🙂
