Kuna son ƙarin koyo game da ayyukan Excel? Yaya game da koyon yadda ake amfani da su a cikin aikinku? Microsoft Excel yana ƙunshe da ayyuka da yawa waɗanda hatta ƙwararrun masu amfani ba koyaushe za su iya kewaya duk wannan bambancin ba. To 30 Excel yana aiki a cikin kwanaki 30 zai zama mai ƙarfi mai ƙarfi don haɓaka kai a gare ku kuma zai koya muku yadda ake ƙirƙirar abubuwa masu ban mamaki a cikin littattafan Excel.
Idan kai novice mai amfani da Excel ne kuma ka zo wannan rukunin yanar gizon don koyan komai daga ainihin abubuwan da ake buƙata, Ina ba da shawarar ka fara koma zuwa ga Koyarwarmu ta Excel don Masu farawa. A ciki za ku sami bayanai masu inganci da yawa masu amfani.
Menene wannan kwas?
Duk darussa 30 fassarar marathon na labarai ne ta wani guru na Excel na Kanada - Debrie Dalleish. Kowace rana daga Janairu 2, 2011 zuwa 31 ga Janairu, 2011, an sami labarin a kan Ma'anar Rubutun da ke kwatanta ɗayan waɗannan siffofi. An rarraba duk ayyuka: rubutu, bayanai, da bincike da hanyoyin haɗin gwiwa. Sashen Lissafin Fasaloli yana ba da hanyoyin haɗin kai zuwa fassarar duk waɗannan labaran.
Kowane labarin ya ƙunshi abubuwa masu zuwa:
- Bayanin da ke ba da cikakken bayanin yadda kowane fasalin ke aiki.
- Dukkan darussan 30 suna tare da hotunan kariyar kwamfuta waɗanda ke ba ku damar isar da mahimman bayanai a sarari (an ɗauki hotuna a cikin Excel 2010).
- Misalai masu amfani na amfani da dabarun Excel duka su kadai da sauran ayyuka.
- Matsalolin da ka iya tasowa yayin aiki tare da ayyuka.
- Kazalika da yawa sauran bayanai masu amfani daidai.
Me zan samu?
Tare da taimakon wannan marathon, za ku iya faɗaɗa ilimin ku game da ayyukan Microsoft Excel da kuma sa littattafan aikinku su fi dacewa. Koyi waɗanne fasalolin ne ke aiki mafi kyau a wasu yanayi, da kuma waɗanne fasalolin don guje wa gaba ɗaya.
Wannan jagorar zai taimake ka ka yi amfani da sanannun ayyuka yadda ya kamata. Hatta waɗancan ayyukan Excel da kuke aiki da su kowace rana na iya ƙunsar ɓoyayyun siffofi da matsuguni waɗanda ba ku san su ba. Kuna iya amfani da duk misalan da aka gabatar a cikin aikin ku a amince.
Jerin fasali:
Rana ta 01 - GASKIYA - na iya duba igiyoyin rubutu guda biyu don daidaitaccen wasa, kuma, ƙari kuma, mai hankali.
Ranar 02 - AREAS - Yana dawo da adadin wuraren da ke cikin hanyar haɗin gwiwa.
Ranar 03 - TRIM - Yana kawar da duk sarari daga igiyar rubutu, ban da sarari ɗaya tsakanin kalmomi.
Ranar 04 - INFO - Yana nuna bayanai game da yanayin aiki na yanzu.
Ranar 05 - ZABI - Yana dawo da ƙima daga jeri, yana zaɓar ta bisa ga ma'aunin lamba.
Rana ta 06 – FIXED – Yana zagayawa lamba zuwa takamaiman adadin wurare na goma kuma yana mayar da sakamakon a tsarin rubutu tare da ko ba tare da dubban masu raba ba.
Ranar 07 - CODE - Yana dawo da lambar lamba na farkon haruffan rubutu.
Rana ta 08 – CHAR – Yana dawo da takamaiman hali wanda lambar sa ta yi daidai da lambar da aka shigar, dangane da tebur ɗin halayen kwamfutarka.
Ranar 09 - VLOOKUP - Yana duba ƙima a cikin ginshiƙi na farko na tebur kuma ya dawo da wata ƙima daga jere ɗaya a cikin tebur.
Ranar 10 - HLOOKUP - Yana neman ƙima a jere na farko na tebur kuma ya dawo da wata ƙima daga wannan shafi a cikin tebur.
Ranar 11 - CELL (CELL) - yana nuna bayani game da tsarawa, abun ciki da wuri na tantanin halitta a hanyar da aka ba.
Ranar 12 - COLUMNS - Yana mayar da adadin ginshiƙai a cikin tsararru ko tunani.
Rana ta 13 - TRANSPOSE - Yana dawo da kewayon sel a kwance azaman kewayo a tsaye ko akasin haka.
Ranar 14 - T (T) - Yana mayar da rubutu idan darajar cikin tantanin halitta rubutu ne, ko kirtani mara komai idan ba rubutu ba.
Ranar 15 - Maimaita (REPT) - yana maimaita kirtani rubutu ƙayyadadden adadin lokuta.
Ranar 16 – DUBA – Yana dawo da ƙima daga jere ɗaya, shafi ɗaya, ko tsararru.
Ranar 17 - ERROR.TYPE - Yana gano nau'in kuskure ta lamba ko mayar da # N/A idan ba a sami kuskure ba.
Rana ta 18 - SEARCH - Yana neman saƙon rubutu a cikin wani saƙon rubutu, kuma idan an same shi, yana ba da rahoton matsayinsa.
Ranar 19 - MATCH - Yana mayar da matsayin darajar a cikin tsararru, ko kuskuren #N/A idan ba'a samo shi ba.
Ranar 20 - ADDRESS - Yana dawo da bayanin tantanin halitta azaman rubutu bisa jere da lambar shafi.
Ranar 21 - TYPE - Yana dawo da lamba wanda ke ƙayyade nau'in bayanai.
Ranar 22 - N (N) - Yana mayar da ƙimar da aka canza zuwa lamba.
Rana ta 23 - NEMO - Nemo kirtan rubutu a cikin wani igiyar rubutu, mai hankali.
Ranar 24 - INDEX - Yana dawo da ƙima ko nuni ga ƙima.
Ranar 25 – MUSA – Yana canza haruffa a cikin rubutu dangane da ƙayyadadden adadin haruffa da matsayi na farawa.
Ranar 26 - KASHE - Yana dawo da hanyar haɗin yanar gizon daga hanyar haɗin da aka bayar ta wasu adadin layuka da ginshiƙai.
Ranar 27 – MUSA - Yana maye gurbin tsohon rubutu tare da sabon rubutu a cikin sigar rubutu.
Ranar 28 - HYPERLINK - yana ƙirƙirar hanyar haɗi wanda ke buɗe daftarin aiki da aka adana akan kwamfuta, uwar garken cibiyar sadarwa, cibiyar sadarwar gida ko Intanet.
Rana ta 29 - TSARKI - Yana kawar da wasu haruffa marasa bugawa daga rubutu.
Rana ta 30 - BAYANAN - Yana dawo da hanyar haɗin da aka bayar ta hanyar rubutun.