Contents
Koyarwar Excel don Dummies zai ba ku damar sauƙin fahimta da ƙware ainihin ƙwarewar aiki a cikin Excel, ta yadda za ku iya amincewa da matsawa kan batutuwa masu rikitarwa. Koyarwar za ta koyar da ku yadda ake amfani da ƙirar Excel, amfani da dabaru da ayyuka don magance matsaloli iri-iri, gina zane-zane da zane-zane, aiki tare da tebur pivot da ƙari mai yawa.
An ƙirƙiri koyawa ta musamman don novice masu amfani da Excel, mafi daidai don "cikakken dummies". Ana ba da bayanai a matakai, farawa da ainihin asali. Daga sashe zuwa sashe na koyawa, ana ba da ƙarin abubuwa masu ban sha'awa da ban sha'awa. Bayan kammala dukkan karatun, za ku amince da yin amfani da ilimin ku a aikace kuma ku koyi yadda ake aiki tare da kayan aikin Excel wanda zai warware 80% na duk ayyukanku. Kuma mafi mahimmanci:
- Za ku manta da tambayar har abada: "Yadda ake aiki a Excel?"
- Yanzu babu wanda zai taɓa kuskura ya kira ku "teapot".
- Babu buƙatar siyan koyawa marasa amfani don masu farawa, wanda zai tara ƙura a kan shiryayye na shekaru. Saya kawai adabi masu dacewa da amfani!
- A rukunin yanar gizon mu za ku sami ƙarin darussa daban-daban, darussa da litattafai don aiki a cikin Microsoft Excel ba kawai ba. Kuma duk wannan a wuri guda!
Sashi na 1: Abubuwan Abubuwan Excel
- Gabatarwa zuwa Excel
- Microsoft Excel Interface
- Ribbon a cikin Microsoft Excel
- Duba baya a cikin Excel
- Toolbar Samun Sauri da Duban Littafi
- Ƙirƙiri kuma buɗe littattafan aiki
- Ƙirƙiri kuma buɗe littattafan aikin Excel
- Yanayin dacewa a cikin Excel
- Ajiye littattafai da rabawa
- Ajiye da AutoRecover Workbooks a cikin Excel
- Fitar da Littattafan Ayyuka na Excel
- Raba littattafan aikin Excel
- Tushen Kwayoyin Halitta
- Cell a cikin Excel - mahimman ra'ayoyi
- Abubuwan cell a cikin Excel
- Kwafi, motsi da share sel a cikin Excel
- Kwamfuta ta atomatik a cikin Excel
- Nemo kuma Sauya a cikin Excel
- Canja ginshiƙai, layuka da sel
- Canza faɗin shafi da tsayin jere a cikin Excel
- Saka da share layuka da ginshiƙai a cikin Excel
- Matsar da ɓoye layuka da ginshiƙai a cikin Excel
- Rufe rubutu da haɗa sel a cikin Excel
- Tsarin Tantanin halitta
- Saitin Font a cikin Excel
- Daidaita rubutu a cikin sel na Excel
- Iyakoki, shading da salon salula a cikin Excel
- Tsarin lamba a cikin Excel
- Excel Sheet Basics
- Sake suna, saka da share takarda a cikin Excel
- Kwafi, motsawa da canza launi na takardar aiki a cikin Excel
- Rukunin zanen gado a cikin Excel
- Tsarin shafi
- Tsara magins da daidaitawar shafi a cikin Excel
- Saka hutun shafi, buga kanun labarai da ƙafafu a cikin Excel
- Buga littafi
- Buga panel a cikin Microsoft Excel
- Saita wurin bugawa a cikin Excel
- Saita margins da sikelin lokacin bugawa a cikin Excel
Sashi na 2: Formules da Ayyuka
- Sauƙaƙe Formules
- Masu aiki da lissafi da nassoshin tantanin halitta a cikin dabarun Excel
- Ƙirƙirar Sauƙaƙan Formula a cikin Microsoft Excel
- Shirya dabaru a cikin Excel
- Matsaloli masu rikitarwa
- Gabatarwa zuwa hadaddun dabaru a cikin Excel
- Ƙirƙirar hadaddun dabaru a cikin Microsoft Excel
- Dangantaka da cikakkun hanyoyin haɗin gwiwa
- Hanyoyin haɗi a cikin Excel
- Cikakken nassoshi a cikin Excel
- Hanyoyin haɗi zuwa wasu zanen gado a cikin Excel
- Formula da Ayyuka
- Gabatarwa zuwa Ayyuka a cikin Excel
- Saka Aiki a cikin Excel
- Aiki Library a cikin Excel
- Aiki Wizard a cikin Excel
Sashe na 3: Aiki tare da bayanai
- Kula da Bayyanar Fannin Aiki
- Yankunan daskarewa a cikin Microsoft Excel
- Raba zanen gado kuma duba littafin aikin Excel a cikin windows daban-daban
- Tsara bayanai a cikin Excel
- Tace bayanai a cikin Excel
- Yin aiki tare da ƙungiyoyi da kuma ba da labari
- Ƙungiya da Ƙarfafawa a cikin Excel
- Tables a cikin Excel
- Ƙirƙiri, gyara da share tebur a cikin Excel
- Charts da Sparklines
- Charts a cikin Excel - Basics
- Layout, Salo, da Sauran Zaɓuɓɓukan Chart
- Yadda ake aiki tare da sparklines a cikin Excel
Sashi na 4: Babban fasali na Excel
- Yin aiki tare da Bayanan kula da Canje-canje na Bibiya
- Bibiyar bita a cikin Excel
- Bitar bita a cikin Excel
- Bayanan salula a cikin Excel
- Kammalawa da Kare Littattafan Aiki
- Kashe kuma kare littattafan aiki a cikin Excel
- Tsarin Yanayi
- Tsarin Yanayi a cikin Excel
- Teburan pivot da nazarin bayanai
- Gabatarwa zuwa PivotTables a cikin Excel
- Pivot Data, Filters, Slicers, and PivotCharts
- Menene idan bincike a cikin Excel
Sashi na 5: Nagartattun Formula a cikin Excel
- Muna magance matsaloli ta amfani da ayyuka masu ma'ana
- Yadda ake saita yanayin boolean mai sauƙi a cikin Excel
- Yin amfani da Ayyukan Boolean na Excel don Ƙayyadaddun Yanayi masu rikitarwa
- IF aiki a cikin Excel tare da misali mai sauƙi
- Ƙidaya da tarawa a cikin Excel
- Ƙirƙiri sel a cikin Excel ta amfani da ayyukan COUNTIF da COUNTIF
- Sum a cikin Excel ta amfani da ayyukan SUM da SUMIF
- Yadda ake lissafin jimlar jimlar a cikin Excel
- Yi lissafin matsakaicin nauyi ta amfani da SUMPRODUCT
- Yin aiki tare da kwanakin da lokuta a cikin Excel
- Kwanan wata da lokaci a cikin Excel - mahimman ra'ayoyi
- Shigar da tsara kwanan wata da lokuta a cikin Excel
- Ayyuka don cire sigogi daban-daban daga kwanan wata da lokuta a cikin Excel
- Ayyuka don ƙirƙira da nuna ranaku da lokuta a cikin Excel
- Ayyukan Excel don ƙididdige kwanakin da lokuta
- Bincika bayanai
- Ayyukan VLOOKUP a cikin Excel tare da misalai masu sauƙi
- VIEW aiki a cikin Excel tare da misali mai sauƙi
- Ayyukan INDEX da MATCH a cikin Excel tare da misalai masu sauƙi
- Kyakkyawan sani
- Ayyukan Ƙididdiga na Excel Kuna Bukatar Ku sani
- Ayyukan lissafi na Excel kuna buƙatar sani
- Ayyukan rubutu na Excel a cikin misalai
- Bayanin kurakuran da ke faruwa a cikin dabarun Excel
- Yin aiki tare da suna a cikin Excel
- Gabatarwa ga sunayen tantanin halitta da kewayon a cikin Excel
- Yadda ake suna cell ko kewayon a Excel
- Dokoki 5 masu Amfani da Jagorori don Ƙirƙirar Sunaye da Sunaye a cikin Excel
- Mai sarrafa suna a cikin Excel - Kayan aiki da fasali
- Yadda za a yi suna akai-akai a cikin Excel?
- Yi aiki tare da tsararru a cikin Excel
- Gabatarwa zuwa tsarin tsarawa a cikin Excel
- Multicell array formulas a cikin Excel
- Samfuran tsararrun salula guda ɗaya a cikin Excel
- Ƙididdigar ƙididdiga a cikin Excel
- Shirya tsarin tsarawa a cikin Excel
- Aiwatar da tsarin tsarawa a cikin Excel
- Hanyar da za a gyara tsarin tsarawa a cikin Excel
Sashi na 6: Na zaɓi
- Ƙirƙirar hanyar sadarwa
- Yadda ake tsara Ribbon a cikin Excel 2013
- Yanayin Matsa Ribbon a cikin Excel 2013
- Hanyoyin haɗi a cikin Microsoft Excel
Kuna son ƙarin koyo game da Excel? Musamman a gare ku, mun shirya koyawa masu sauƙi da amfani guda biyu: Misalai 300 na Excel da ayyuka 30 na Excel a cikin kwanaki 30.