EXCEL ME FORMULAS MENUE KE SABHI OPTION KI JANKARI SIKHO

Formulas Option Inme Apko Har Tarah Ke Formule Milenge Bus Apko Lagana Ana Chahiye Baki  Me Apko Formulas Ke Bare Me Bataunga Agli Bar

Name Manger :- Isme Ap Kisi Bhi Data , Cell,Etc Ap Name De Sakte Ho Ya Fir Kisi Ko Bhi Name Dene Ke Bad Edit Bhi Kar Sakte Ho

  

Create For Selection Is Option Me Ap Ek Hi Bar Me  Select Karke Sabhi Ke Uske First Heading Ke Name Se Ya Fir Rown Ke Name Se Name  De Sakte Ho (According To Option)

Trace Precedent :- Isme Ap Formula Jaha Formulas Lagaye Ho Us Result Pe Click Karke Is Option Pe Click Karo Fir Automatic Hi Is Formule Me Aye Range Ko Select Kar Ke Apko Dikha Dega

Trace Dependent :- Isme Ap Kisi Bhi Cell Pe Click Karo Aur Yadi Wah Kisi Formule Ka Range Me Ata Hai To Ye Option Apko Bata Dega Arrow Dwara

Remove Arrow :- Is Option Me Jo Arrow Show Kar Raha He Use Remove Kar Sakte Hai

Show Formula :- Is Option Me Jaha Jaha Formula Laga Hua Hai Waha 

 Formula Show Karega

Error Checking Is Option Me Agar Apke Formule Me Koi Error Ata Hai Tab Ye Option Error Ka Pata Lagane Me Madad Karta Hai

 Evaluate Formula :- Is Option Me Hum Ek Sath Us Particulas Cell Ke Do Roop Dekh Sakte Hai Pahla Usme Kon Sa Formulas Laga Hai Aur Dusra Lagane Ke Bad Ka Kya Result Aya Hai

Watch Window :-Isme Ap Cell Ko Select Karke Add Kar Sakte Ho Agar Apko Waha Jana Ho To Bas Ap Ek Click Me Waha Ja Sakte Ho

 

DOSTO YE CLASS CONTINUE JOIN KARTE RAHO AUR SABHI KO YE FREE CLASS KE BARE ME BATAO TAKI SABHI  SIKH SAKE AUR KOI PROBLEM ATI HE TO MUJHE COMMENT JARUR KARNA  (PLS 🙏🙏SHARE KARNA AUR MUJHE FOLLOW JARUR KARNA )

APKA MERE PAGE PE ANE KE LYE DHANYAWAD 🙏🙏🙏🙏 

LINK :- ADVANCEBANO.BLOGSPOT.COM

BY-AAKASH