Magacyada La Qeexay (Name Box)

Wax Ka Beddelka iyo Tirtirida Magacyada (Name Manager)

Raadinta Macluumaad Jadwal Two-Way Lookup Ah (Indirect Function)

Isticmaalka Substitute Function Si Loo Saxo Khaladaadka Indirect Function

Absolute, Relative iyo Mixed Cell Reference

Tusaalaha Mixed Cell Reference

Mucaadalaadka Aasaasiga Ah (Basic Function)

Fahan Qaabka Eey U Shaqeyso Logical Test

Sidee Eey U Shaqaysaa IF Function Iyo Nested IF

Tusaalaha Nested IF Function

Isticmaalka Mucaadalooyinka OR, AND Functions Iyo IF Function

Dhisida Warbixinta 1-aad Adoo Isticmaalaya COUNTIF Function Iyo Chart

Dhisida Warbixinta 2-aad Adoo Isticmaalaya SUMIF Function Iyo Chart

Dhisida Warbixinta 3-aad Adoo Isticmaalaya SUMIFS Function Iyo Chart

Qurxinta Chart-ka

Warbixinta Ku Soo Saar Sheet Cusub Adoo Isticmaalaya SUMIFS Function

Ku Soo Dhawoow Mucaadalada VLOOKUP

Xallinta Qaladaadka VLOOKUP Adoo Isticmaalaya COUNTA

Xallinta Qaladaadka VLOOKUP Adoo Isticmaalaya COLUMNS

Xallinta Qaladaadka VLOOKUP ee Labo Jadwal Adoo Isticmaalaya IF ERROR

Xallinta Qaladaadka VLOOKUP Adoo Isticmaalaya Approximate Match

Raadinta Macluumaadka Jadwalka ee Two Way Lookup Adoo Isticmaalaya INDEX MATCH

Isbarbardhiga Labo Liis 1

Isbarbardhiga Labo Liis 2

Raadinta Qoraal (Text) Adoo Isticmaalaya Search Function

Xallinta Qaladaadka Left Function Marka La Isticmaalayo Search Function

Qaabka Qoraalka Loogu Kala Firdhiyo Kolommo Kala Duwan

Qaabka Loo Kala Qaado Qoraalka Adoo Qarinaya Column-ka 2-aad

Flash Fill

Farsamooyinka Qaabaynta Shuruudaha Ah (Conditional Formatting)

Highlight-garaynta Dhammaan Sadarrada ee Hal Criteria

Highlight-garaynta Dhammaan Sadarrada ee Labo Criteria

Aqoonta Dheeraadka Ah Ee Pivot Tables Iyo Pivot Chart

Beddelidda Habka Isku-Geynta Ee Pivot Table

10-ka Ugu Sarreeya Ee Falanqaynta Pivot Table

Ku Muuji Qiimaha Sida Boqolleyda Ee Pivot Table

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-ta Ugu Sarreysa Adoo Isticmaalaya Advanced Filter

Hel 5-ta Ugu Hooseysa Adoo Isticmaalaya Advanced Filter

Raadinta Qeyb Ka Mid Ah Xarafaha Ee Advanced Filter

Hordhaca Casharrada Macros

Sideen Uga Shaqaysiiyaa Macros

Duubidda Macro Ee Advanced Filter

Dhisida Qaab Falanqayn Adiga Khaas Kuu Ah 1

Dhisida Qaab Falanqayn Adiga Khaas Kuu Ah 2