Course Content
Excel For Business Data Analysis
0/48
Magacyada la qeexay (Name Box)
09:00
Wax ka beddelka iyo Tirtirida Magacyada (Name Manager)
05:00
Raadinta macluumad Jadwal Two-Way Lookup ah (Indirect Function) 
08:00
Isticmaalka Substitute Function Si loo saxo khaladaadka Indirect Function
06:00
Absolute , Relative and Mixed cell Reference
10:00
Tusaalo Mixed Cell Reference
04:00
Mucaadaalka aasaasiga Basic Function
07:00
Fahan qaabka u shaqeeyo Logical Test
09:00
Sidee ushaqaysaa IF Function iyo Nested IF
10:00
Tusaalo Nested IF Function
08:00
Isticmaalka mucaadalaadka OR, AND Functions iyo IF Function
10:00
Dhisida Warbixintii 1AAD adoo isticmaalayo COUNTIF Function With Chart
07:00
Dhisida Warbixintii 2AAD adoo isticmaalayo SUMIF Function With Chart
08:00
Dhisida Warbixintii 3AAD adoo isticmaalayo SUMIFS Function With Chart
12:00
Qurxinta Chart ka
02:00
Warbixinta kusoo saar Sheet cusub adoo isticmaalayo SUMIFS Function
11:00
Kusoo Dhawoow Mucaadallada VLOOKUP
06:00
Xallinta Khaladaadka VLOOKUP Adoo Isticmaalaayo COUNTA
05:00
Xallinta Khaladaadka VLOOKUP Adoo Isticmaalaayo COLUMNS
06:00
Xallinta Khaladaadka VLOOKUP Labo Jadwal Adoo Isticmaalaayo IF ERROR
06:00
Xallinta Khaladaadka VLOOKUP With Approximate Match
05:00
Raadinta Macluumaadka Jadwalka Two way lookup adiga oo isticmaalaayo INDEX MATCH
05:00
Is barbar dhigida labo liis 1
09:00
Is barbar dhigida labo liis 2
05:00
Raadinta Qoraal (Text) Adoo Isticmaalayo Search Function
05:00
Xallinta Qaladaadka Left Function Marka la Isticmaalayo Search Function
03:00
Qaabka qoraalka loogu kal firdhiyo kolomyo kala duwan
06:00
Qaabka loo kala qaado qoraalka adiga oo qarinaayo Column ka 2
03:00
Flash Fill
02:00
Farsamooyinka Qaabaynta Shuruudaha ah(Conditional Formatting Techniques)
15:00
Muuji Dhammaan Safafka Ku Salaysan Hal Shardi
03:00
Muuji Dhammaan Safafka Ku Salaysan Dhoowr Shuruud
07:00
Cashiro kusaabsan Pivot Tables And Pivot Chart
06:00
Beddelka Habka Isku-ururinta ee Jadwalka Pivot
02:00
10-ka ugu Sarayso ee Falanqaynta Pivot table
04:00
Ku muuji qiimaha sida boqolleyda ee Jadwalka Pivot
03:00
PivotTable ee Xisaabinta Isbeddelka Boqolleyda Sannadlaha ah
04:00
Sidee u Shaqeeyaa Advanced Filter
08:00
Isticmaalka Logical Test si looga soo saaro Warbixinta Sare – Advanced Filter
06:00
Isticmaalka ISNUMBER iyo SEARCH ee Advanced Filter
03:00
Hel 5 ugu sareeyso adoo isticmaalayo Advance Filter
03:00
Hel 5 ugu hooseeyso adoo isticmaalayo Advance Filter
03:00
Raadinta qeeb kamid ah Xuruuftah ee Advanced Filter
03:00
Hordhaca Cashirada Macros
08:00
Sideen oga shaqeeysiiyaa Macros
03:00
Duubidda Macro ee Advanced Filter
05:00
Dhisida Qaab Falaqayn adiga khaas kuu ah 1
07:00
Dhisida Qaab Falaqayn adiga khaas kuu ah 2
06:00
Excel For Business Data Analysis
Previous
Next
0% Complete