- Видео 61
- Просмотров 244 064
Google Sheet
Добавлен 9 фев 2022
This channel will create videos everything you need to know about Google Sheets.
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...
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
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
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
Thank u!
Thanks 🎉
This is so helpful. thanks for the tutorial!
What do you press to move them??????
Thank you so much 😢..I lost my customer data sheet from yesterday....Now I saw your video...I'll recover My data sheet....😊
It Did'nt Work For Me
Hi! Can I kindly know if it's possible to set a specific password for each tab in a Google Sheet?
TQ so much much ❤
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?
You are the best!!!!! It worked
Why sheet unlock when dubble click it. How i solve. I use your code step by step
how about to protect with password certain ranges and the trigger is onedit?
HOW do we delete that stupid inaccurate numbers column on the far left??
Okay, but when we got ERROR on the others ?
You can press 'X" to close the dialog and don't need to enter the password
Very simple and helpful ❤
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.
You Are A LIFESAVER !!!!!
If only we could do it on mobile…
thank you !!!! I had prepared worksheet ..but I needed to add a column, if I add a climb would it mess up the formulas ?
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.
thank you.
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.
THANKS
Welcome🙏🏾
AT THE TIME ENTER PASSWORD CLICK ESC BUTTON FAILED PASSWORD THEN OPENED SHEET
Thank you. I got my data
You are Welcome🙏, happy that my video helps you to recover your data👍
Thank you!
Thanks 🙏🏻👍🏻
You're welcome 😊
#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?
is there any ideas if i want to sequence counta for each group data ?
Does not work
Sorry, I was mistaken
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 🙏
How do I rename the letter on very top Collin
Just click on the title and rename it
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.
Thanks!
Welcome!
Can you please share me the code to copy paste. I could not find it in the description
bit.ly/3hopJnr
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?
But can the app script be locked so that people don't go in and delete the code? thank you
can we protect certain cells only rather whole sheet?
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
Thank You so much
Muchas gracias 😘
De nada
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
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
the script doesn't work on android phone, any solution for that?
What did u type on 11:42?
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 .
@@google_sheethi
Sir long vidio me bol kar bataiye Plz koi vidio nhi hai
I create a script in my Google sheet but I see one error (row no. 5) so plz solve this error
can you provide me the code and error screenshot
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
it is not working if you enter the spreadsheet using mobile devices, people can still edit it sir
Thanks! do you know how i can usa this type of apps script of this video? ruclips.net/video/CeWUAOK7Ui8/видео.html
Finally, found what I searching for, which is clear and concise. Thank you!