Baro Microsoft Excel Af-Soomaali – Koorso Bilaash ah oo Dhameystiran (Zero ilaa Xirfadle)

 

Baro Microsoft Excel Af-Soomaali (Koorso Bilaash ah)

Koorso Dhameystiran oo Bilaash ah oo Af-Soomaali ah

Koorso cusub oo aad ku baran doonto Microsoft Excel laga bilaabo eber (zero) ilaa heer xirfadeed sare. Waxaa loogu talagalay ardayda, maamulayaasha, ganacsatada, xisaabiyeyaasha, iyo qof walba oo raba inuu la jaanqaado xirfadaha casriga ah.

Waxaad ku Baran Doontaa:

• 👉 Aqoonta aasaasiga ah: Cells, Rows, Columns
• 👉 Formula-yada muhiimka ah: SUM, IF, VLOOKUP, INDEX & MATCH
• 👉 Xog kala saar: Data Filtering, Pivot Tables & Charts
• 👉 Habeyn, Automation: iyo Dashboard-yada xirfadeed

Maxaa Kaa Dhigaya Koorso Tan Gaar Ah?

• ✅ Waxaad heli doontaa casharro kooban oo ficil ku saleysan
• ✅ Waa bilaash, si fududna waad ku daawan kartaa
• ✅ Waxaa la socda muuqaal sharaxaad leh oo playlist ahaan u diyaarsan

1. Hordhac – Waa Maxay Microsoft Excel?

Casharkaan waxaad ku baran doontaa waxa uu yahay Microsoft Excel iyo muhiimada uu leeyahay.

2. Interface-ka Excel – Fahamka Toolbar iyo Sheets

Waxa aad baran doontaa qeybaha shaashadda sida toolbar, cells iyo sheets.

3. Sida Loo Abuuro File Cusub

Waxaad baran doontaa in aad furan karto workbook, kaydin karto, iyo furri cusub ka sameyn karto.

4. Fahamka Cells, Columns & Rows

Casharkaan waxa uu sharxayaa qaab-dhismeedka Excel sida cells, columns, iyo rows.

5. Data Entry – Sida Loogu Qoro Xogta

Waxaad ku baran doontaa qorista iyo tafatirka xogta gudaha cells-ka.

6. Formatting Cells – Color, Font, Size

Casharkan waxa uu diiradda saarayo qurxinta cells-ka sida midab, font iyo size.

7. AutoFill & Copy Formula

Baro sida loo nuqulo formulas iyo buuxinta xogta si toos ah.

8. SUM & AVERAGE Functions

Waxaad ku baran doontaa isku darka iyo celceliska xogta gudaha Excel.

9. MAX & MIN Functions

Waxaad baran doontaa sida aad u hesho tirada ugu weyn iyo tan ugu yar.

10. COUNT & COUNTA

Casharkaan waxa aad ku baran doontaa tirinta cells-ka leh iyo kuwa aan lahayn xog.

11. Sorting & Filtering Xogta

Waxaad ku baran doontaa sida xogta loo kala saaro loona shaandheeyo si nadiif ah.

12. Conditional Formatting

Casharkaani waxa uu sharxayaa midabaynta xogta iyadoo la isticmaalayo shuruudo.

13. IF Function

Waxaad baran doontaa isticmaalka IF formula si loo go'aamiyo shuruudaha xogta.

14. VLOOKUP Function

Casharkaan waxa aad ku baran doontaa sida loo raadiyo xog adeegsanaya column kale.

15. INDEX & MATCH

Waxaad baran doontaa habka lagu helo xog sax ah adoo adeegsanaya INDEX iyo MATCH.

16. SUMIF Function

Ku dar xogta iyadoo la adeegsanayo SUMIF hal shardi lagu salaynayo.

17. COUNTIF Function

Tirinta xogta leh hal shardi adigoo isticmaalaya COUNTIF.

18. Charts – Sida Loo Sameeyo Graphs

Waxaad baran doontaa abuurista charts si xogta u muuqato si sahlan.

19. Pie & Column Charts

Casharkan waxa lagu bartaa abuurista Pie iyo Column charts.

20. Pivot Table

Xog uruurin heer sare ah adoo adeegsanaya Pivot Table.

21. Multiple Sheets Management

Baro abuurista, maareynta, iyo magacaabista worksheet-yo badan.

22. Cell References – Absolute vs Relative

Faraqa u dhexeeya reference noocyadiisa formula isticmaalka.

23. Freeze Panes

Sida loogu "xiro" rows ama columns si ay markasta u muuqdaan.

24. Data Validation

Xakameynta xogta la gelinayo adigoo isticmaalaya shuruudo.

25. Dropdown Menu

Abuur liis hoos u furmaya oo data lagu xusho (drop-down).

26. Formula Errors

Sida loo saxo qaladaadka #N/A, #DIV/0!, #REF!, iwm.

27. Find & Replace

Sida xogta loogu beddelo hal mar adigoo isticmaalaya find & replace.

28. Flash Fill

Excel si otomaatig ah taageeri karta qaababka xogta oo ay buuxiso.

29. Print Setup

Qaabeynta waraaqda ka hor daabacaadda sida margins, orientation iwm.

30. Excel Shortcuts

30 shortcut oo Excel ah si shaqadaada loo dedejiyo.

Casharro Excel (31–45)

31. Name Range with Formulas

Sida Name Ranges loola isticmaalo formulas sida SUM, COUNT, iwm.

32. Statistical Functions

Funkshannada sida SUMIF, COUNTIF, AVERAGEIF, SUMIFS, COUNTIFS, AVERAGEIFS.

33. Math & Trigonometry Functions

Sida SUMPRODUCT, MROUND, FLOOR, CEILING, MOD, QUOTIENT loo isticmaalo.

34. VLOOKUP Exact Match

Loo isticmaalo VLOOKUP si xog la mid ah loo helo (exact match).

35. VLOOKUP Approximate Match

VLOOKUP loogu adeegsado hab dembi qiyaas ah (approximate match).

36. INDEX & MATCH

Sida INDEX iyo MATCH loo dhex isku isticmaalo si xog sax ah loo raadiyo.

37. Charts in Excel

Fikradaha charts sida line, pie, column, iyo sida loo format gareeyo.

38. Creating Pivot Tables

Casharkan wuxuu sharaxayaa abuurista pivot tables si xogta loo kala hor geeyo.

39. Consolidation

Sida xogaha laga kala helay worksheets kala duwan loogu isku daro hal sheet.

40. Conditional Formatting Advanced

Midabeyn horumarsan sida color scales iyo icon sets.

41–44. Hyperlinks

Sida loo abuuro, edit, tirtir, midabbedel, iyo formulas la xiriira hyperlinks.

45–48. Print Setup & Header/Footer

Margin, orientation, page numbers, headers, footers iyo more ka.

Casharro Excel (58–67)

58–60. Table, Subtotal & Advanced Table

Casharradan waxa aad ku baran doontaa abuurista tables, slicing, iyo subtotal.

61. Charts in Excel

Baro sida loo sameeyo line, pie, column charts iyo qaabeynta.

62. Pivot Table Creation

Casharkan waxa aad ku baran doontaa abuurista pivot table iyo filtering/chart options.

63. Data Consolidation

Sida xogaha laga warqadaha kala duwan loogu isku daro consolidation.

64. Conditional Formatting Advanced

Waxaad baran doontaa color scales, icon sets iyo shuruudo horumarsan.

65. Data Validation

Baro sida loo sameeyo drop-down lists, error messages, iyo xanibaado xogta.

66. Import Data from PDF/Web

Sida loo keeno xogta laga soo helay PDF ama website loona geliyo Excel.

67. Excel Shortcuts - Top 30

Waxaad baran doontaa 30-ka shortcuts ee ugu faa'iidada badan Excel-ka.

Microsoft Excel waa aalad muhiim ah oo uu qof walba uga baahan yahay shaqo, ganacsi iyo maamul. Koorsadan waxa ay si cad kuu tusinaysaa sida Excel looga bilaabo eber ilaa heer xirfadlennimo, iyadoo la adeegsanayo af-Soomaali si fudud loo fahmi karo.

Barashada Excel waxay kuu sahleysaa inaad si xirfadeysan ula shaqeyso xogta, aad horumariso shaqadaada, islamarkaana aad la jaanqaaddo suuqa shaqada casriga ah.

💡 Talooyin Dhammaad ah

• Ku celceli casharrada – ha ku koobnaan daawasho, samee ficil.
• Isticmaal Excel maalin kasta si xirfaddaadu u xoogeysato.
• Baro function-nada cusub sida XLOOKUP iyo Dynamic Arrays.
• Samee mashruucyo yar yar si aad ugu tababarto xog xakameynta.
• La wadaag koorsadan asxaabtaada si ay adiga iyo iyaguba ugu faa’iideysataan.
• Haddii aad wax fahmi weydo, ku noqo casharka ama i waydii faahfaahin.