Magacyada la qeexay (Name Box)

Wax ka beddelka iyo Tirtirida Magacyada (Name Manager)

Raadinta macluumad Jadwal Two-Way Lookup ah (Indirect Function)

Isticmaalka Substitute Function Si loo saxo khaladaadka Indirect Function

Absolute , Relative and Mixed cell Reference

Tusaalo Mixed Cell Reference

Mucaadaalka aasaasiga Basic Function

Fahan qaabka u shaqeeyo Logical Test

Sidee ushaqaysaa IF Function iyo Nested IF

Tusaalo Nested IF Function

Isticmaalka mucaadalaadka OR, AND Functions iyo IF Function

Dhisida Warbixintii 1AAD adoo isticmaalayo COUNTIF Function With Chart

Dhisida Warbixintii 2AAD adoo isticmaalayo SUMIF Function With Chart

Dhisida Warbixintii 3AAD adoo isticmaalayo SUMIFS Function With Chart

Qurxinta Chart ka

Warbixinta kusoo saar Sheet cusub adoo isticmaalayo SUMIFS Function

Kusoo Dhawoow Mucaadallada VLOOKUP

Xallinta Khaladaadka VLOOKUP Adoo Isticmaalaayo COUNTA

Xallinta Khaladaadka VLOOKUP Adoo Isticmaalaayo COLUMNS

Xallinta Khaladaadka VLOOKUP Labo Jadwal Adoo Isticmaalaayo IF ERROR

Xallinta Khaladaadka VLOOKUP With Approximate Match

Raadinta Macluumaadka Jadwalka Two way lookup adiga oo isticmaalaayo INDEX MATCH

Is barbar dhigida labo liis 1

Is barbar dhigida labo liis 2

Raadinta Qoraal (Text) Adoo Isticmaalayo Search Function

Xallinta Qaladaadka Left Function Marka la Isticmaalayo Search Function

Qaabka qoraalka loogu kal firdhiyo kolomyo kala duwan

Qaabka loo kala qaado qoraalka adiga oo qarinaayo Column ka 2

Flash Fill

Farsamooyinka Qaabaynta Shuruudaha ah(Conditional Formatting Techniques)

Highlight All Rows Based On One Criteria

Highlight All Rows Based On Two Criteria

Pivot Tables And Pivot Chart In Depth

Changing The Method Of Aggregation In A Pivot Table

10-ka ugu Sarayso ee Falanqaynta Pivot table

Ku muuji qiimaha sida boqolleyda ee Jadwalka Pivot

PivotTable ee Xisaabinta Isbeddelka Boqolleyda Sannadlaha ah

Sidee u Shaqeeyaa Advanced Filter

Isticmaalka Logical Test si looga soo saaro Warbixinta Sare - Advanced Filter

Isticmaalka ISNUMBER iyo SEARCH ee Advanced Filter

Hel 5 ugu sareeyso adoo isticmaalayo Advance Filter

Hel 5 ugu hooseeyso adoo isticmaalayo Advance Filter

Raadinta qeeb kamid ah Xuruuftah ee Advanced Filter

Hordhaca Cashirada Macros

Sideen oga shaqeeysiiyaa Macros

Duubidda Macro ee Advanced Filter

Dhisida Qaab Falaqayn adiga khaas kuu ah 1

Dhisida Qaab Falaqayn adiga khaas kuu ah 2