5 Useful tricks of Google Sheets that every excel user must know || Google Sheet in Hindi

Поділитися
Вставка
  • Опубліковано 25 сер 2024
  • In this Video you will 5 amazing and useful tricks of google sheet which is not available in microsoft excel, any version like excel 2007, excel 2010, excel 2013, excel 2016... but we can do the auto filter using filter macro in excel but in google sheet there is single formula to do the auto filter ....
    इस वीडियो गूगल शीट्स के ५ गजब फीचर्स हमने आसान भाषा में समजाये है ...काफी मजेदार फ़ॉर्मूलास और यूज़फुल टिर्क्स है जी
    5 amazing useful tricks of google sheet in Hindi
    1. Use of filter formula in google sheet :
    2. Use of sort formula in Google sheet :
    3. Use of Combine sheets data formula in Google sheet :
    4. Use of Geo Chart in Google sheet:
    5. How multiple people can work on one google sheet:
    #GoogleSheets
    #GoogleSheetsinHindi
    #GoogleSheetTutorials
    ------------------------------------------------------------------------------------------------------------------------------
    Learn Satish Sir courses with Certificate
    Download Course App : bit.ly/3BWfQVa
    Courses Website :bit.ly/skill_c...
    Course Features :
    ✅ सभी Videos सरल हिंदी भाषा में
    ⬇️ Download Video in APP
    ✅ Basic to Advance Courses
    ✅ Practice Files (Yes)
    ✅ PDF Shortcuts
    ✅ Course Completion Certificate
    ✅ Instant Access
    ✅ Watch on Desktop : skillcourse.in/
    ------------------------------------------------------------------------------------------------------------------------------
    To download the practice file visit our telegram channel: telegram.me/le...
    Check our latest blogs: learnmoreindia...
    ------------------------------------------------------------------------------------------------------------------------------
    Social media Pages:
    Facebook Page Link: bit.ly/3CvGlBT
    Instagram Page Link: bit.ly/3f9R37u
    ------------------------------------------------------------------------------------------------------------------------------
    My Other Channels:
    Real Tutorial: ✅
    / @realtutorial550
    Complete Technology:✅
    / @completetechnology
    Learn more shorts:✅
    / @learnmoreshorts
    Satish Tech (Marathi):✅
    / @satish_tech
    Tally Tutorial:✅
    / @tallytutorial
    Excel Tutorial:✅
    / @excel_tutorial
    Learn More:✅
    / @learn_more
    Curiosity: ✅
    / @curiosity9432
    ------------------------------------------------------------------------------------------------------------------------------
    My UA-cam Gears :
    Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
    Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
    My DSLR Camera Canon 200D: amzn.to/39ciw3E
    My Laptop (Video Editing): amzn.to/2UXQj8h
    Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
    Antivirus: amzn.to/3l3TIgi
    Screen Recording Software: bit.ly/2J39n2j
    Video Editing Software: bit.ly/3nOPlri
    Green screen with Stand: amzn.to/2KAl1Cu
    Watch Filter Macro in Excel: • एक्सेल मैक्रो में क्या...
    Watch Auto Sort in Excel: • Excel Magic Tricks || ...
    Watch Combine Data in Excel Like Google Sheet: • सभी शीट कंबाइन करने का...
    Watch other Videos :
    Excel Basic to Advance Series : • Excel tutorial || Exce...
    Excel Amazing Features - • समय बचाना है तो सीखो य...
    Excel Advance 100 Videos - • Excel Introduction In ...
    Excel VBA Series in Hindi- • What is VBA in Excel? ...
    Excel MIS Videos - • ये सीखने के बाद एक्सेल...
    Word Series :
    • MS-Word Introduction |...
    PowerPoint Series : • सेमिनार, प्रेजेंटेशन, ...
    AUTOCAD SERIES : • ऑटोकैड सीरीज अब हिंदी ...
    Technology Videos - • Interview Preparation ...
    Computer Hardware in Hindi - • कंप्यूटर रिपेरिंग सीखन...
    Tags - Learn More, Learn More Channel, Technology Tricks, Computer Tricks, Google sheets, Google sheet tutorial in hindi, Google docx tutorial, google docs tutorial, google sheets tricks,

КОМЕНТАРІ • 312

  • @Learn_More_Pro
    @Learn_More_Pro  4 роки тому +3

    Learn Satish Sir courses with Certificate
    Download Course App : bit.ly/3BWfQVa
    Course Website :bit.ly/skill_course
    Course Features :
    ✅ सभी Videos सरल हिंदी भाषा में
    ⬇ Download Video in APP
    ✅ Basic to Advance Courses
    ✅ Practice Files (Yes)
    ✅ PDF Shortcuts
    ✅ Course Completion Certificate
    ✅ Instant Access
    ✅ Watch on Desktop : skillcourse.in/

    • @niluns1579
      @niluns1579 Рік тому

      Sir Mai Roj Ek Hi Sheet Me Daily Data Entry karta Hu But Ek Problem Hai Jab bhi Sheet Open Karta Hu Tab First Column Se Open Hota But Muze jo Last Type Kiya Huwa Column hai Wo Open Huwe Jise Muze Har Bar Nicche Scroll Karke Last Column ko dhundna na pade Plz Sir Help Karo

  • @mohammaddaud3589
    @mohammaddaud3589 4 роки тому +1

    Very good 👍 formula

  • @shashisahu9330
    @shashisahu9330 4 роки тому +1

    Multiple data is best and new formula

  • @atulshukal4072
    @atulshukal4072 3 роки тому

    बहोत बहोत बढीया वर्क नया देकर खुशी पाता हे धन्यवाद साहेब सभी आईडिया सम्राट

  • @DevKumar-zz5pz
    @DevKumar-zz5pz 4 роки тому +1

    very good sir

  • @salmanhassan3864
    @salmanhassan3864 4 роки тому +1

    Thanks sir

  • @shubhangishinde1378
    @shubhangishinde1378 4 роки тому

    Tumache sagalech formula khup sopya padhatine samjtat.

  • @shivanijha5069
    @shivanijha5069 4 роки тому +1

    Thanks sar

  • @hemantsonawane153
    @hemantsonawane153 3 роки тому

    u have inspired me to work smarter

  • @ashishshiriskar123
    @ashishshiriskar123 4 роки тому

    Khup khup chhan, Sir Thanks alot

  • @rekhasharma-xy5mp
    @rekhasharma-xy5mp 4 роки тому

    Nice video my fav combine sheet formula

  • @Shrutikavk429
    @Shrutikavk429 5 років тому

    Wow google sheet me ye bhi hota hai ....bahot badiyan...mujhe filter ka formula bahot pasand aaya👍👍👍👍👍👍👍👍👍

  • @rahulmishra7139
    @rahulmishra7139 5 років тому +4

    Please make video on automating work flow through Google Forms

  • @chandrakantjain1814
    @chandrakantjain1814 3 роки тому

    Filter मेरे लिए बहुत उपयोगी रहा । Thanks

  • @Technical_guru231
    @Technical_guru231 5 місяців тому

    All three formulas are best sir😊😊

  • @RanaTarunSingh
    @RanaTarunSingh 3 роки тому +1

    Sir you are very very best best.

  • @sabbasachisaha
    @sabbasachisaha 5 років тому

    All are fantastic

  • @controlmgs8858
    @controlmgs8858 Рік тому

    very use full formula thanks
    Based on yours I also made its working very well
    =filter(IMPORTRANGE("google sheet ID/","Sheet name!A3:S"),IMPORTRANGE("google sheet ID/","Sheetname!Q3:Q")=A1) A1 cell is dropdown list for selection

  • @sureshagale3534
    @sureshagale3534 Рік тому

    Thanks, u r VDO is helpful

  • @mohamedaatif4092
    @mohamedaatif4092 4 роки тому +2

    I like merging sheets formula thank u sir.

  • @JotinderSinghAhluwalia
    @JotinderSinghAhluwalia 2 роки тому

    Woooooonderful

  • @surajsah4955
    @surajsah4955 2 роки тому

    Sir ,Awesome 1no.

  • @PawanSharma-fy9pt
    @PawanSharma-fy9pt 4 роки тому

    thank you so much dear have nice day

  • @rajeshchoudhary2520
    @rajeshchoudhary2520 5 років тому +1

    Nice video, Filter Formula aur Sort Formula

  • @jeetendrak8073
    @jeetendrak8073 4 роки тому

    Way of ur teaching is grt 👌
    But mujhe yeh bataye k google sheet se excel mein data import kare toh formulas vaise hi rehna chaiye possible hai

  • @vinaydhore7986
    @vinaydhore7986 4 роки тому

    All first 3 formulas are very useful

  • @bkdeshmukh12
    @bkdeshmukh12 5 років тому

    Aap ka video to Mai start karte hi like ke leta hu Sir kyuki hmare jaise excel aur computer lovers ke liye aapka video sabse best rhta hai thanks for Google sheet trick office me bhut useful hai

  • @rajeshthegamer5763
    @rajeshthegamer5763 5 місяців тому

    Thanks you sir

  • @rajibroy5614
    @rajibroy5614 4 роки тому

    All formula is very important and helpful for me.thannks

  • @junaidshaikh4880
    @junaidshaikh4880 5 років тому +1

    Although you all videos are great, but this one is awesome. I like it very much and will be using it. All are equally useful. I like them all. Thanks a lot for the video.

  • @opendream3458
    @opendream3458 4 роки тому

    All are awesome

  • @mdgulrez9187
    @mdgulrez9187 5 років тому +1

    I was so excited to know about Google sheet
    Thank you so much for this

  • @rahulmishra7139
    @rahulmishra7139 5 років тому +2

    Amazing merge formula

  • @mithleshsahu3614
    @mithleshsahu3614 5 років тому

    All farmula most intresting and informative 👍

  • @arunkumar-zt7ks
    @arunkumar-zt7ks 5 років тому

    Very useful thanks for efforts to provide best formulas knowledge

  • @jyothinibu4610
    @jyothinibu4610 4 роки тому +1

    All r excellent

  • @mahisinghaman5105
    @mahisinghaman5105 4 роки тому

    Wow multiple sheets hame bahut Accha laga Satish sir

  • @prabhakarpawar573
    @prabhakarpawar573 5 років тому +1

    खूप सुंदर आणि usefull व्हिडीओ सर

  • @jitendrabomble2218
    @jitendrabomble2218 3 роки тому

    Thanks.
    Very useful information.
    👌👌👍👍🌹🌹

  • @hamasjan5799
    @hamasjan5799 Рік тому

    Sir
    All formulas is best to one to another

  • @prthakkar1972
    @prthakkar1972 Рік тому

    Good explanation

  • @Jayuchalwadi
    @Jayuchalwadi 3 роки тому

    This is very useful

  • @rahulbhartiy8891
    @rahulbhartiy8891 4 роки тому

    Query formula is great sir

  • @santoshkumaracharya960
    @santoshkumaracharya960 5 років тому

    very useful and amazing video. waiting more videos about google sheets. thanks satish ji

  • @rajumasih234
    @rajumasih234 5 років тому +1

    Satish sir really you are a lovely teacher

  • @unitedyoutubers9970
    @unitedyoutubers9970 Рік тому

    sir mein aapka fan huin

  • @dipakgadhikar5903
    @dipakgadhikar5903 4 роки тому

    All three formulas are favorite very well explained

  • @jhantunayak3652
    @jhantunayak3652 4 роки тому +1

    sir you are great,

  • @imransaleem6686
    @imransaleem6686 4 роки тому

    so excellence formula sirjee i liked all of them

  • @mrsandy_
    @mrsandy_ 4 роки тому

    I am big fan of you sir ji

  • @hyderalikhan8681
    @hyderalikhan8681 3 роки тому

    Excellent

  • @santsharansahu59
    @santsharansahu59 5 років тому

    Best of multy combined formula

  • @jhantunayak3652
    @jhantunayak3652 4 роки тому +1

    super sir, Thank you for this video

  • @bankim0760
    @bankim0760 2 роки тому

    merge formula excellent

  • @gyanarjancomputereducation2776
    @gyanarjancomputereducation2776 5 років тому

    Awesome sir

  • @aftabsuco5233
    @aftabsuco5233 5 років тому +4

    WOW Its so most important tricks Sir Thank you so much

  • @adhikarisudhir1
    @adhikarisudhir1 4 роки тому

    Wow ! Merge formula is really useful for me. Thanks

  • @JitendraKumar-mv7hi
    @JitendraKumar-mv7hi 5 років тому

    Amazing...i like all formula....nice video sir g

  • @shivrajsinghrajput2931
    @shivrajsinghrajput2931 5 років тому

    Dear sir very intresting video, all formulas are very useful for us. I already use Google sheet last 2 years for our official attendance purpose we have more branches. I like your videos. Main request karunga ki aur video Google sheet ke liye banaye. Thanks

  • @bantyjariwala2613
    @bantyjariwala2613 4 роки тому

    All is good bro

  • @ranvirvashisht1415
    @ranvirvashisht1415 2 роки тому

    I really appreciate to learn new things in your interesting style always.

  • @gyanaranjanswain6349
    @gyanaranjanswain6349 2 роки тому

    All three formulas are great...

  • @Atulkartar401
    @Atulkartar401 5 років тому

    Bahut khub Sir

  • @Rahulkuril93
    @Rahulkuril93 5 років тому

    Very nice trick

  • @kolipateljagdish
    @kolipateljagdish 5 років тому

    Verry Nice

  • @KARWANJIFAMILY
    @KARWANJIFAMILY 5 років тому

    Hi combine wala formula bahut acha hai or baise to 3 formula good hai

  • @cmeplgswr2694
    @cmeplgswr2694 4 роки тому

    explained very well, query formula is the best one.

  • @bimalbiswas6121
    @bimalbiswas6121 5 років тому

    Nice video...sir

  • @tulsidasjamnani9455
    @tulsidasjamnani9455 5 років тому +1

    Known formulas for me sir, ...
    Please make videos on other formulas.....
    Like importfeed .....Etc..

  • @suhanenteprises6819
    @suhanenteprises6819 5 років тому

    Very nice

  • @ramcharanvishvakarma1482
    @ramcharanvishvakarma1482 3 роки тому

    Great,pls explain how to add menu bar like file ,insert view Data etc in googal sheet in Android mobile phone Application.

  • @rprshama
    @rprshama 5 років тому

    Very useful for those who want to go for a next step.

  • @javedkuwait620
    @javedkuwait620 5 років тому

    Bahot achha video sir👍

  • @ramavtarsingh146
    @ramavtarsingh146 5 років тому

    very very nice trick and helpful to all

  • @ashoksahu9546
    @ashoksahu9546 5 років тому

    Sir Really very Interesting video. Very useful.

  • @MdIlyasShaikh
    @MdIlyasShaikh 5 років тому

    excellent feature.thanks a lot.

  • @roshanlaldaheriya2344
    @roshanlaldaheriya2344 Рік тому

    very nice

  • @bharatrajauriya9837
    @bharatrajauriya9837 5 років тому

    Filter formula of google sheet is very useful for me...
    Thanks

  • @DeepakKumar-ph3gr
    @DeepakKumar-ph3gr 5 років тому

    Thank sir

  • @sabirswati
    @sabirswati 4 роки тому

    All is best

  • @abhiruhalder2868
    @abhiruhalder2868 3 роки тому

    Sir, please make video about VBA Excel.

  • @shankarkulwant5898
    @shankarkulwant5898 3 роки тому

    It's good content.
    I m really appreciate with your experience.

  • @kanchangupta2422
    @kanchangupta2422 2 роки тому

    Fantastic

  • @janidost2437
    @janidost2437 5 років тому

    Nice update
    Thanks 😊

  • @bibhashpattanaik6685
    @bibhashpattanaik6685 5 років тому

    Thank you very much sir.. Really amazing..

  • @manmohandeol4908
    @manmohandeol4908 5 років тому

    Satish ji very nice Video. Your explanation made it more shining. I feel after 5G network only Google Sheets will work instead of Excell. Thanks for giving us best information.

  • @yashpandavadara
    @yashpandavadara 5 років тому +1

    I am your new subcriber....

    • @Learn_More_Pro
      @Learn_More_Pro  5 років тому +1

      WELCOME TO CHANNEL YASH BHAI I WILL DEFINITELY REACH TO YOUR EXPECTATION

  • @hiteshchourey9730
    @hiteshchourey9730 Рік тому

    Sirji, google sheet query par full video banaye please

  • @mrsandy_
    @mrsandy_ 4 роки тому

    Short formula most like

  • @Marketking1995
    @Marketking1995 4 роки тому

    Video mast hai but query thoda complicated hai

  • @jasvirsingh9754
    @jasvirsingh9754 5 років тому

    query is a new thing i learnd from u Sir......great job....thanx

  • @yatinkakkar7580
    @yatinkakkar7580 Рік тому

    Thank u

  • @amitmishra1513
    @amitmishra1513 2 роки тому +1

    Hi Nice explanation!!! Very useful
    how can we update data from one sheet to another in Google sheet on button click like vlookup formula excel vba ??

  • @relaxingmusic5249
    @relaxingmusic5249 2 роки тому

    Satish Ji, It is amazing. I like your videos. Google sheet jio chart should be available for cities in the district and districts in the state and also for states in the country. You should do for the same. Thank.

  • @rahulmishra7139
    @rahulmishra7139 5 років тому +1

    You are making great videos

  • @mukeshgupta4583
    @mukeshgupta4583 5 років тому +1

    Great

  • @prahalladjena1634
    @prahalladjena1634 3 роки тому

    Thanks sir, u r great. Can u explain how to consolidate data from multiple sheets as in MS Excel.

  • @swemdip443
    @swemdip443 4 роки тому

    thank you sir for this video but google sheet me use hone bale sare chhotese lekar bare use full formula kaise use kare uske uparbhi ek video banaiye.

  • @AnujSharma-hv8ji
    @AnujSharma-hv8ji 5 років тому

    nice hai sir ji

  • @sunilchoudhary859
    @sunilchoudhary859 4 роки тому

    Sir aur bhi formula google sheet ka bataiye