Google Sheet
Google Sheet
  • Видео 61
  • Просмотров 244 064
HLOOKUP Explained: Beginner's Guide to Using HLOOKUP in Google Sheets #googlesheets #hlookup
Welcome to our RUclips tutorial on "HLOOKUP for Beginners in Google Sheets"! 📊✨
This comprehensive guide demystifies the HLOOKUP function and shows you how to harness its power for data analysis and manipulation in Google Sheets. Whether you're a spreadsheet novice or looking to expand your skills, this tutorial is tailored to provide you with a solid foundation in using HLOOKUP effectively.
📋 What you'll learn in this video:
Introduction to the HLOOKUP function and its purpose.
Step-by-step guide on how to use HLOOKUP to search for data horizontally.
Understanding the syntax and arguments of the HLOOKUP function.
Real-world examples showcasing different use cases for HLOOKUP.
Tips and tricks to...
Просмотров: 3 377

Видео

Google Sheets Tutorial for Beginners: Top 10 Essential Terms You Need to Know! @google_sheet
Просмотров 261Год назад
Welcome to our RUclips video on "Mastering Google Sheets: Top 10 Essential Terms You Need to Know!" 📊✨ In this comprehensive tutorial, we'll dive into the fundamental concepts of Google Sheets, equipping you with the knowledge you need to become a spreadsheet pro! Whether you're a beginner or looking to brush up on your skills, this video is perfect for anyone seeking to harness the full potent...
What is Row, Column, Cell, and Index in Google Sheets? | Basic Terms used in #googlesheets
Просмотров 449Год назад
What is Row, Column, Cell, and Index in Google Sheets? | Basic Terms used in #googlesheets
How to Group Rows & Columns in Google Sheets
Просмотров 25 тыс.Год назад
How to Group Rows & Columns in Google Sheets
Resize Rows & Columns in Google Sheets
Просмотров 697Год назад
Resize Rows & Columns in Google Sheets
How to Freeze & Unfreeze Rows & Columns in Google Sheets
Просмотров 2,4 тыс.Год назад
How to Freeze & Unfreeze Rows & Columns in Google Sheets
How to Move Rows & Columns in Google Sheets
Просмотров 4,4 тыс.Год назад
How to Move Rows & Columns in Google Sheets
How to Hide & Unhide Rows & Columns in Google Sheets
Просмотров 1,6 тыс.Год назад
How to Hide & Unhide Rows & Columns in Google Sheets
How to Clear Rows & Columns in Google Sheets
Просмотров 1,6 тыс.Год назад
How to Clear Rows & Columns in Google Sheets
How to Delete Rows & Columns in Google Sheets
Просмотров 19 тыс.Год назад
How to Delete Rows & Columns in Google Sheets
How to Insert Rows & Columns in Google Sheets
Просмотров 4,4 тыс.Год назад
How to Insert Rows & Columns in Google Sheets
How to get lost data in Google Sheets | Version History
Просмотров 1,3 тыс.Год назад
How to get lost data in Google Sheets | Version History
How to Protect worksheets in Google Sheets
Просмотров 991Год назад
How to Protect worksheets in Google Sheets
How to Duplicate, Hide, Unhide, Color, and Copy worksheets in Google Sheets
Просмотров 292Год назад
How to Duplicate, Hide, Unhide, Color, and Copy worksheets in Google Sheets
How to Insert, Delete, Rename, Reorder, and Switch tabs in Google Sheets
Просмотров 598Год назад
How to Insert, Delete, Rename, Reorder, and Switch tabs in Google Sheets
Google sheets tutorial for beginners | How to Share Google Sheets
Просмотров 319Год назад
Google sheets tutorial for beginners | How to Share Google Sheets
Google sheets tutorial for beginners | How to Create, Rename, and Organize Google Sheets
Просмотров 1,5 тыс.Год назад
Google sheets tutorial for beginners | How to Create, Rename, and Organize Google Sheets
Checkbox in Google Sheets | How to make attendance using check box in Google Sheets
Просмотров 669Год назад
Checkbox in Google Sheets | How to make attendance using check box in Google Sheets
How to Make a Dropdown List in Google Sheets #googlesheets
Просмотров 1,5 тыс.Год назад
How to Make a Dropdown List in Google Sheets #googlesheets
Highlight Duplicate Data in Google Sheets | Finding and Highlighting Duplicates in #googlesheets
Просмотров 445Год назад
Highlight Duplicate Data in Google Sheets | Finding and Highlighting Duplicates in #googlesheets
IFERROR Function | How to remove error in google sheets formula #googlesheets
Просмотров 2,3 тыс.Год назад
IFERROR Function | How to remove error in google sheets formula #googlesheets
VLOOKUP in Google Sheets
Просмотров 948Год назад
VLOOKUP in Google Sheets
How to protect google sheet with password | Using App Script for Password Protection #googlesheets
Просмотров 22 тыс.Год назад
How to protect google sheet with password | Using App Script for Password Protection #googlesheets

Комментарии

  • @traywaters1575
    @traywaters1575 2 дня назад

    Thank u!

  • @rajaburajabu7105
    @rajaburajabu7105 12 дней назад

    Thanks 🎉

  • @RafaelPaler-dh2xb
    @RafaelPaler-dh2xb 15 дней назад

    This is so helpful. thanks for the tutorial!

  • @rajaburajabu7105
    @rajaburajabu7105 16 дней назад

    What do you press to move them??????

  • @nithyafelicia6941
    @nithyafelicia6941 18 дней назад

    Thank you so much 😢..I lost my customer data sheet from yesterday....Now I saw your video...I'll recover My data sheet....😊

  • @TimmyFountain21
    @TimmyFountain21 23 дня назад

    It Did'nt Work For Me

  • @catherinecasquejo
    @catherinecasquejo Месяц назад

    Hi! Can I kindly know if it's possible to set a specific password for each tab in a Google Sheet?

  • @Ammu_1127
    @Ammu_1127 Месяц назад

    TQ so much much ❤

  • @sweetmask1690
    @sweetmask1690 4 месяца назад

    Hello my file is shared through multiple user. Can I password it only on my Google account? And the rest can freely open it using their own google acc?

  • @leciabromley8645
    @leciabromley8645 4 месяца назад

    You are the best!!!!! It worked

  • @sujithpremachandra-rl1hh
    @sujithpremachandra-rl1hh 4 месяца назад

    Why sheet unlock when dubble click it. How i solve. I use your code step by step

  • @angelodeocampo3643
    @angelodeocampo3643 4 месяца назад

    how about to protect with password certain ranges and the trigger is onedit?

  • @manuelnunez8802
    @manuelnunez8802 4 месяца назад

    HOW do we delete that stupid inaccurate numbers column on the far left??

  • @Mal-xl8jh
    @Mal-xl8jh 5 месяцев назад

    Okay, but when we got ERROR on the others ?

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

    You can press 'X" to close the dialog and don't need to enter the password

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

    Very simple and helpful ❤

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

    But this is working only for the Google account on which you are working, for rest of others its not asking any password. Please suggest something.

  • @jjpasik4720
    @jjpasik4720 6 месяцев назад

    You Are A LIFESAVER !!!!!

  • @dustinvandiver7271
    @dustinvandiver7271 6 месяцев назад

    If only we could do it on mobile…

  • @zerototalenergy150
    @zerototalenergy150 7 месяцев назад

    thank you !!!! I had prepared worksheet ..but I needed to add a column, if I add a climb would it mess up the formulas ?

    • @google_sheet
      @google_sheet 6 месяцев назад

      Adding column usually won't create problems in formula. Formula will auto correct accordingly but in some case it will based on how we entered the formula.

    • @zerototalenergy150
      @zerototalenergy150 6 месяцев назад

      thank you.

  • @claudelRodin
    @claudelRodin 8 месяцев назад

    Malheureusement, un clic hors de la fenêtre et l'accès à la feuille est autorisé. Ca ne bloque en rien l'accès. Sympa pour l'exercice. Unfortunately, one click outside the window and access to the sheet is allowed. It does not block access in any way. Thanks for the code which is very nice.

  • @darshananipun6196
    @darshananipun6196 9 месяцев назад

    THANKS

  • @mr.sharma8380
    @mr.sharma8380 9 месяцев назад

    AT THE TIME ENTER PASSWORD CLICK ESC BUTTON FAILED PASSWORD THEN OPENED SHEET

  • @amaravathigopagani691
    @amaravathigopagani691 9 месяцев назад

    Thank you. I got my data

    • @google_sheet
      @google_sheet 9 месяцев назад

      You are Welcome🙏, happy that my video helps you to recover your data👍

  • @Hungryreviewer
    @Hungryreviewer 10 месяцев назад

    Thank you!

  • @nirbhaymorgulwar2412
    @nirbhaymorgulwar2412 10 месяцев назад

    Thanks 🙏🏻👍🏻

  • @TeamRaja
    @TeamRaja 10 месяцев назад

    #FailureToProtectWithPassword 🔐🔓 If you click another part of the screen, the "Enter Password" pop-up will disappear, and you can edit it without a password. However, you will receive notifications on your email immediately, which is good. But It would be a good option to protect your G Sheets with a password, If it's work properly. Please provide us with alternative methods, sir. Thank you! 😊 How to enable Password Protection in the Add-ons option on Google Sheets?

  • @satkerpusdatin24
    @satkerpusdatin24 10 месяцев назад

    is there any ideas if i want to sequence counta for each group data ?

  • @pecamian
    @pecamian 10 месяцев назад

    Does not work

    • @pecamian
      @pecamian 10 месяцев назад

      Sorry, I was mistaken

  • @r_o_s_h_a_n_p_a_n_d_i_t
    @r_o_s_h_a_n_p_a_n_d_i_t 10 месяцев назад

    Brother Pls make video's on daily basis any query update in Google sheets then you make a video. pls it's humble request to you 🙏

  • @briannaashley6570
    @briannaashley6570 11 месяцев назад

    How do I rename the letter on very top Collin

    • @google_sheet
      @google_sheet 11 месяцев назад

      Just click on the title and rename it

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

    Hey , I want to download email id from Gmail I'd Mail IDs all in Excel or Google sheets How to download inbox mail IDs Plz share youtube link.

  • @健斗-l1l
    @健斗-l1l Год назад

    Thanks!

  • @hariprasadreddy.k1085
    @hariprasadreddy.k1085 Год назад

    Can you please share me the code to copy paste. I could not find it in the description

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

    Sir, ek Google sheet hai us me 4 salesman wise 4 sheet hai har salesman apne Naam Ki sheet me data daily update karke n dusre salesman ki sheet na dekh sake and all salesman sheet manager dekh ske Yeh manage google sheet me kese kare?

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

    But can the app script be locked so that people don't go in and delete the code? thank you

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

    can we protect certain cells only rather whole sheet?

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

    Thank you for this video, is was something I was looking for, the only problem is, I need the password to show before it show the sheets data, is this possible

  • @ABHIJITD-t5v
    @ABHIJITD-t5v Год назад

    Thank You so much

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

    Muchas gracias 😘

  • @HarshadaTarange-x8l
    @HarshadaTarange-x8l Год назад

    Sir its works amazingly but... Whenever we sign out this particuoar mail id and we are trying to paste this url agin with diff mail id then te password protection is not work the excel file can easily open without asking any password

    • @m-108
      @m-108 Год назад

      yes. we need some method so that we can tackle it. i request the owner of this youtube channel to help in tackling this practical problem p.s. i highly appreciate this video which is rendered with so wonderful and simple explanation

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

    the script doesn't work on android phone, any solution for that?

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

    What did u type on 11:42?

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

      It's a condition which will check for the correct password and clicking on ok button. providing correct password and clicking close (closing pop-up window) or providing wrong password will prompt for message. only clicking ok and providing correct password will allow you in .

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

      ​@@google_sheethi

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

    Sir long vidio me bol kar bataiye Plz koi vidio nhi hai

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

    I create a script in my Google sheet but I see one error (row no. 5) so plz solve this error

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

      can you provide me the code and error screenshot

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

    Hi Thanks for your code sir, how to create different pwd for different users ,who having rights to open and write in the Sheet Thanks

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

    it is not working if you enter the spreadsheet using mobile devices, people can still edit it sir

  • @lucasa.w.romeiro2136
    @lucasa.w.romeiro2136 Год назад

    Thanks! do you know how i can usa this type of apps script of this video? ruclips.net/video/CeWUAOK7Ui8/видео.html

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

    Finally, found what I searching for, which is clear and concise. Thank you!