Sign In
Select Your Favourite
Category And Start Learning.
Excel For Business Data Analysis
Original price was: $40.00.$20.00Current price is: $20.00.
Course Content
Excel For Business Data Analysis
- 09:00
- 05:00
- 08:00
Isticmaalka Substitute Function Si loo saxo khaladaadka Indirect Function
06:00Absolute , Relative and Mixed cell Reference
10:00Tusaalo Mixed Cell Reference
04:00Mucaadaalka aasaasiga Basic Function
07:00Fahan qaabka u shaqeeyo Logical Test
09:00Sidee ushaqaysaa IF Function iyo Nested IF
10:00Tusaalo Nested IF Function
08:00Isticmaalka mucaadalaadka OR, AND Functions iyo IF Function
10:00Dhisida Warbixintii 1AAD adoo isticmaalayo COUNTIF Function With Chart
07:00Dhisida Warbixintii 2AAD adoo isticmaalayo SUMIF Function With Chart
08:00Dhisida Warbixintii 3AAD adoo isticmaalayo SUMIFS Function With Chart
12:00Qurxinta Chart ka
02:00Warbixinta kusoo saar Sheet cusub adoo isticmaalayo SUMIFS Function
11:00Kusoo Dhawoow Mucaadallada VLOOKUP
06:00Xallinta Khaladaadka VLOOKUP Adoo Isticmaalaayo COUNTA
05:00Xallinta Khaladaadka VLOOKUP Adoo Isticmaalaayo COLUMNS
06:00Xallinta Khaladaadka VLOOKUP Labo Jadwal Adoo Isticmaalaayo IF ERROR
06:00Xallinta Khaladaadka VLOOKUP With Approximate Match
05:00Raadinta Macluumaadka Jadwalka Two way lookup adiga oo isticmaalaayo INDEX MATCH
05:00Is barbar dhigida labo liis 1
09:00Is barbar dhigida labo liis 2
05:00Raadinta Qoraal (Text) Adoo Isticmaalayo Search Function
05:00Xallinta Qaladaadka Left Function Marka la Isticmaalayo Search Function
03:00Qaabka qoraalka loogu kal firdhiyo kolomyo kala duwan
06:00Qaabka loo kala qaado qoraalka adiga oo qarinaayo Column ka 2
03:00Flash Fill
02:00Farsamooyinka Qaabaynta Shuruudaha ah(Conditional Formatting Techniques)
15:00Muuji Dhammaan Safafka Ku Salaysan Hal Shardi
03:00Muuji Dhammaan Safafka Ku Salaysan Dhoowr Shuruud
07:00Cashiro kusaabsan Pivot Tables And Pivot Chart
06:00Beddelka Habka Isku-ururinta ee Jadwalka Pivot
02:0010-ka ugu Sarayso ee Falanqaynta Pivot table
04:00Ku muuji qiimaha sida boqolleyda ee Jadwalka Pivot
03:00PivotTable ee Xisaabinta Isbeddelka Boqolleyda Sannadlaha ah
04:00Sidee u Shaqeeyaa Advanced Filter
08:00Isticmaalka Logical Test si looga soo saaro Warbixinta Sare – Advanced Filter
06:00Isticmaalka ISNUMBER iyo SEARCH ee Advanced Filter
03:00Hel 5 ugu sareeyso adoo isticmaalayo Advance Filter
03:00Hel 5 ugu hooseeyso adoo isticmaalayo Advance Filter
03:00Raadinta qeeb kamid ah Xuruuftah ee Advanced Filter
03:00Hordhaca Cashirada Macros
08:00Sideen oga shaqeeysiiyaa Macros
03:00Duubidda Macro ee Advanced Filter
05:00Dhisida Qaab Falaqayn adiga khaas kuu ah 1
07:00Dhisida Qaab Falaqayn adiga khaas kuu ah 2
06:00
About Course
Koorsadan, waxaad ku baran doontaa aqoonta iyo xirfadaha lagaaga baahan yahay si aad u falanqeeyso Macluumaadka adiga oo isticmaalaayo Excel ka. Waxa kale oo aad baran doontaa sida si hufan oo wax ku ool ah loogu dabaqo Mucaadalaadka kala duwan ee Excel adigoo isticmaalaya Tusaalo Dhab ah.
Muuqaalkan hordhaca ah wuxuu muujinayaa muhiimadda Excel, wuxuuna ku tusayaa qaar ka mid ah Qeebaha barnaamijka Excel ka ee koorsadan aad ku qaadan doonto. Waxa kale oo lagu bari doonaa mucaadaaladka kala duwan ee aad baran doonto inta koorsadu socoto.
Instructor
Wax ay mahadi u sugnaatay Allaha inoo fududeeyey inaynu goobaheena ku helno cilmigaa muhiimka ah,sidoo kale waxaan u mahad celinaynaa Ustaadkeena wakhtiga iyo dadaalka ku bixiyey siduu inoogu soo gudbin lahaa cilmigaa USTAAD MUSTAFA XARIIR isaga iyo bahda sheerxirfadba Jazaaka Allaah ayaanu leenahay