Friday, June 19, 2020

EXCEL ME DATA MENUE KE SARE OPTION KE BARE ME SIKHO PART - 5



Forecast Option :- Is Option Me Aankdo Ke Hisab Se Andaza Lagaya Jata Hai Jese Ki Mere Pas Ek Table Hai Jisme Year Wise Sale Dikhaya Gaya Hai  Ye 2001-2011 Tak Dikhaya Gaya Hai Ab Me Ye Andaza Lagana Chahta Hu Ki Next Year Me Kitni Sale Hogi To Me Is Forecast Option Ka Use Karke Andaza Laga Sakta Hu

Ab Mene Forecast Create Kya  Isme Hamare Pas Result A Gya Ki With Chart Ke Sath  Aur Next Year Me Kitni Sale Hogi Iski Bhi Jankari A Gyi

 Group:-  Isme Ap Column Ye Row Ko Group Banake Hide Ya Unhide Kar Sakte Ho Wo Bhi Ek Hi Bar Me (Group Wise)

Ye Mene Group Bana Lya Row Pe Click Karke Is Tarah Se Ho Gya Ab Ye Shine(-) Pe Click Karke Hide Kar Sakte Ho  Ek Hi Bar Me Ye Group Ye 1,2 Do Part He Uspe Click Karke Bhi Hide Unhide Kar Sakte Ho

Is Tarah Se (Hide Ho Gya Ya Dusre Step Pe Click  Karke Unhide Karo)

 

Ungroup :-  Isme Wapas Unhide Ho Jata Hai Pahle Ki Hi Tarah 

  • 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

     

3 comments:

  1. A very awesome blog post. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. big data analytics

    ReplyDelete
  2. Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. privacidadenlared

    ReplyDelete
  3. You have a real ability for writing unique content. I like how you think and the way you represent your views in this article.I agree with your way of thinking. Thank you for sharing. toronydaru szállítása Pesten

    ReplyDelete

THANKS FOR YOUR SUPPORT

Data copy paste on two another sheet with add row in google sheet by script

 function copyDataWithinWorkbook() {   var sourceSheetName = "Dashbord"; // Replace with the name of the source sheet   var target...