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

Поделиться
HTML-код
  • Опубликовано: 21 авг 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 RUclips 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,

Комментарии • 311

  • @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

  • @atulshukal4072
    @atulshukal4072 3 года назад

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

  • @shashisahu9330
    @shashisahu9330 4 года назад +1

    Multiple data is best and new formula

  • @ashishshiriskar123
    @ashishshiriskar123 4 года назад

    Khup khup chhan, Sir Thanks alot

  • @hemantsonawane153
    @hemantsonawane153 3 года назад

    u have inspired me to work smarter

  • @surajsah4955
    @surajsah4955 2 года назад

    Sir ,Awesome 1no.

  • @salmanhassan3864
    @salmanhassan3864 4 года назад +1

    Thanks sir

  • @Technical_guru231
    @Technical_guru231 5 месяцев назад

    All three formulas are best sir😊😊

  • @shubhangishinde1378
    @shubhangishinde1378 4 года назад

    Tumache sagalech formula khup sopya padhatine samjtat.

  • @chandrakantjain1814
    @chandrakantjain1814 3 года назад

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

  • @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

  • @shivanijha5069
    @shivanijha5069 4 года назад +1

    Thanks sar

  • @rekhasharma-xy5mp
    @rekhasharma-xy5mp 3 года назад

    Nice video my fav combine sheet formula

  • @DevKumar-zz5pz
    @DevKumar-zz5pz 4 года назад +1

    very good sir

  • @Shrutikavk429
    @Shrutikavk429 5 лет назад

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

  • @sureshagale3534
    @sureshagale3534 Год назад

    Thanks, u r VDO is helpful

  • @JotinderSinghAhluwalia
    @JotinderSinghAhluwalia 2 года назад

    Woooooonderful

  • @RanaTarunSingh
    @RanaTarunSingh 3 года назад +1

    Sir you are very very best best.

  • @mrsandy_
    @mrsandy_ 4 года назад

    I am big fan of you sir ji

  • @PawanSharma-fy9pt
    @PawanSharma-fy9pt 4 года назад

    thank you so much dear have nice day

  • @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

  • @mahisinghaman5105
    @mahisinghaman5105 4 года назад

    Wow multiple sheets hame bahut Accha laga Satish sir

  • @sabbasachisaha
    @sabbasachisaha 5 лет назад

    All are fantastic

  • @rajibroy5614
    @rajibroy5614 4 года назад

    All formula is very important and helpful for me.thannks

  • @unitedyoutubers9970
    @unitedyoutubers9970 Год назад

    sir mein aapka fan huin

  • @vinaydhore7986
    @vinaydhore7986 4 года назад

    All first 3 formulas are very useful

  • @jitendrabomble2218
    @jitendrabomble2218 3 года назад

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

  • @dipakgadhikar5903
    @dipakgadhikar5903 4 года назад

    All three formulas are favorite very well explained

  • @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

  • @rajeshchoudhary2520
    @rajeshchoudhary2520 5 лет назад +1

    Nice video, Filter Formula aur Sort Formula

  • @jyothinibu4610
    @jyothinibu4610 4 года назад +1

    All r excellent

  • @rahulmishra7139
    @rahulmishra7139 5 лет назад +4

    Please make video on automating work flow through Google Forms

  • @hamasjan5799
    @hamasjan5799 Год назад

    Sir
    All formulas is best to one to another

  • @opendream3458
    @opendream3458 4 года назад

    All are awesome

  • @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

  • @gyanaranjanswain6349
    @gyanaranjanswain6349 2 года назад

    All three formulas are great...

  • @mohamedaatif4092
    @mohamedaatif4092 4 года назад +2

    I like merging sheets formula thank u sir.

  • @rahulbhartiy8891
    @rahulbhartiy8891 4 года назад

    Query formula is great sir

  • @rajumasih234
    @rajumasih234 5 лет назад +1

    Satish sir really you are a lovely teacher

  • @mithleshsahu3614
    @mithleshsahu3614 5 лет назад

    All farmula most intresting and informative 👍

  • @JitendraKumar-mv7hi
    @JitendraKumar-mv7hi 5 лет назад

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

  • @prabhakarpawar573
    @prabhakarpawar573 5 лет назад +1

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

  • @imransaleem6686
    @imransaleem6686 4 года назад

    so excellence formula sirjee i liked all of them

  • @Jayuchalwadi
    @Jayuchalwadi 3 года назад

    This is very useful

  • @Atulkartar401
    @Atulkartar401 5 лет назад

    Bahut khub Sir

  • @adhikarisudhir1
    @adhikarisudhir1 4 года назад

    Wow ! Merge formula is really useful for me. Thanks

  • @aftabsuco5233
    @aftabsuco5233 5 лет назад +4

    WOW Its so most important tricks Sir Thank you so much

  • @jhantunayak3652
    @jhantunayak3652 4 года назад +1

    sir you are great,

  • @javedkuwait620
    @javedkuwait620 5 лет назад

    Bahot achha video sir👍

  • @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.

  • @bantyjariwala2613
    @bantyjariwala2613 4 года назад

    All is good bro

  • @santoshkumaracharya960
    @santoshkumaracharya960 5 лет назад

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

  • @arunkumar-zt7ks
    @arunkumar-zt7ks 5 лет назад

    Very useful thanks for efforts to provide best formulas knowledge

  • @KARWANJIFAMILY
    @KARWANJIFAMILY 5 лет назад

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

  • @prthakkar1972
    @prthakkar1972 Год назад

    Good explanation

  • @gyanarjancomputereducation2776
    @gyanarjancomputereducation2776 5 лет назад

    Awesome sir

  • @cmeplgswr2694
    @cmeplgswr2694 4 года назад

    explained very well, query formula is the best one.

  • @mdgulrez9187
    @mdgulrez9187 5 лет назад +1

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

  • @ranvirvashisht1415
    @ranvirvashisht1415 2 года назад

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

  • @jhantunayak3652
    @jhantunayak3652 4 года назад +1

    super sir, Thank you for this video

  • @rahulmishra7139
    @rahulmishra7139 5 лет назад +2

    Amazing merge formula

  • @bimalbiswas6121
    @bimalbiswas6121 5 лет назад

    Nice video...sir

  • @bharatrajauriya9837
    @bharatrajauriya9837 5 лет назад

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

  • @santsharansahu59
    @santsharansahu59 5 лет назад

    Best of multy combined formula

  • @sabirswati
    @sabirswati 4 года назад

    All is best

  • @shankarkulwant5898
    @shankarkulwant5898 3 года назад

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

  • @ashoksahu9546
    @ashoksahu9546 5 лет назад

    Sir Really very Interesting video. Very useful.

  • @MdIlyasShaikh
    @MdIlyasShaikh 5 лет назад

    excellent feature.thanks a lot.

  • @hyderalikhan8681
    @hyderalikhan8681 3 года назад

    Excellent

  • @tulsidasjamnani9455
    @tulsidasjamnani9455 5 лет назад +1

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

  • @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.

  • @DeepakKumar-ph3gr
    @DeepakKumar-ph3gr 5 лет назад

    Thank sir

  • @kolipateljagdish
    @kolipateljagdish 5 лет назад

    Verry Nice

  • @rahulmishra7139
    @rahulmishra7139 5 лет назад +1

    You are making great videos

  • @ramavtarsingh146
    @ramavtarsingh146 5 лет назад

    very very nice trick and helpful to all

  • @durgeshtripathi8635
    @durgeshtripathi8635 3 года назад

    All Formula Amazing 🙏

  • @rprshama
    @rprshama 5 лет назад

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

  • @Rahulkuril93
    @Rahulkuril93 5 лет назад

    Very nice trick

  • @understandthewordsfeelthes3036
    @understandthewordsfeelthes3036 2 года назад

    👍

  • @bankim0760
    @bankim0760 2 года назад

    merge formula excellent

  • @jasvirsingh9754
    @jasvirsingh9754 5 лет назад

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

  • @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 ??

  • @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

  • @mrsandy_
    @mrsandy_ 4 года назад

    Short formula most like

  • @suhanenteprises6819
    @suhanenteprises6819 5 лет назад

    Very nice

  • @Marketking1995
    @Marketking1995 4 года назад

    Video mast hai but query thoda complicated hai

  • @LalitKumar-pg2mo
    @LalitKumar-pg2mo 4 года назад

    Thanks sir.. Sort formula or murgeing formula osm tha..
    Sir dashboard kese bana skte hai.

  • @bibhashpattanaik6685
    @bibhashpattanaik6685 5 лет назад

    Thank you very much sir.. Really amazing..

  • @yatinkakkar7580
    @yatinkakkar7580 Год назад

    Thank u

  • @wraichsaab8105
    @wraichsaab8105 Год назад

    Combine Is amazing

  • @AnujSharma-hv8ji
    @AnujSharma-hv8ji 5 лет назад

    nice hai sir ji

  • @kanchangupta2422
    @kanchangupta2422 2 года назад

    Fantastic

  • @rajmali9351
    @rajmali9351 4 года назад

    Merge bahut achcha

  • @bansheedharsingh7868
    @bansheedharsingh7868 5 лет назад +1

    Very Nice Bro

  • @mukeshgupta4583
    @mukeshgupta4583 5 лет назад +1

    Great

  • @roshanlaldaheriya2344
    @roshanlaldaheriya2344 Год назад

    very nice

  • @janidost2437
    @janidost2437 5 лет назад

    Nice update
    Thanks 😊

  • @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.