Top5 Advanced & Most Useful Formulas in Google Sheets |IMPORTRANGE|QUERY|SPLIT|ARRAYFORMULA|FILTER
Vložit
- čas přidán 29. 08. 2024
- Join us for Premium Learning Contents - bit.ly/joinsheetomatic 👉Get a ‘Profession Google Workspace Account’ here: bit.ly/referralurl
👉You don't want to make a boring form. And your audience won't answer one. Create a typeform instead-and make everyone happy: bit.ly/3HavWxA
Jotform: Whether you're selling a product, accepting a fee, or collecting a donation, Jotform allows you to get paid directly through your form. Ready to get started?
bit.ly/jotForm
WATI WhatsApp API For Business - Official WhatsApp partner
Send Order Updates, Reminders, Payment updates on WhatsApp using Official Business APIs. Setup WhatsApp Business with WATI & get chatbot, broadcast and third party.: bit.ly/sheetomatic
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Check out my videos on:
👉How to Get a Professional Email:bit.ly/getProfessionEmail
👉How to Send Messages on WhatsApp from Google sheets Automatically: bit.ly/WhatsAppAutomations
👉How prepare FMS:bit.ly/createFms
👉Google Data Studio:bit.ly/Lookerstudio
👉Google AppSheet: bit.ly/appSheetVideos
👉Google Forms: bit.ly/googleFormVideos
👉Google Sheets: bit.ly/googleSheetVideos
👉Google Calendar: bit.ly/CreateCalendar
Subscribe to my all-new channel, Sheetomatic - Admin Support, and learn about Admin Console! :bit.ly/sheetomaticadminsupport
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Useful links:
👉SkillShare: Every student who signs up using your referral link gets 1 free month of Skillshare. : bit.ly/myCourseInSkillShare
👉Udemy: Google Form for Beginners in Hindi bit.ly/MyudemyCourse
------------------------------------------------------------------------------------------------------------------------------------------------------------
For business enquiries
Enquiry Form - bit.ly/SheetomaticEnquiry
Call us - +919329103106 | sheetomatic@gmail.com
Readymade Solution which I offer in Good Price and Better Services.
👉Delegation system WA & Email Integrated
👉Staff Checklist with WA and Email Notifications
👉Purchase order system with auto Pdf Send to Supplier on Email & WA
👉Material Inward ( GRN) system on behalf of Purchase Order
👉Material Outward ( Issuance System)
👉Inventory Management System Master Dashboard
👉Quotation system with auto Pdf Send to Client on Email & WA
👉Proforma Invoice with auto Pdf Send to Client on Email & WA
👉Order Collection system with auto Pdf Send to Client on Email & WA
👉Invoice Making System with auto Pdf Send to Client on Email & WA
👉Dispatch Order System with auto Pdf Send to Client on Email & WA
👉Lead Capture system with Email And WA Notification to Client
👉Sales Lead Funnel with Follow-up Dashboard WA Integrated
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Let’s connect online:
📱 Instagram: / sheetomatic
👨🏻💻 LinkedIn: / shyam-kumar-03051986
😄 Facebook: / sheetomatic
🖋 Ask me on Quora: sheetomatic.qu...
-------------------------------------------------------------------------------------------------------------------------------------------------------------
🙋♂️ Who am I:
I am a quick learner and passionate about the building great products that make business owners lives easier, I have more than 6 Years of Experience in process automation and development in various industries like: Manufacturing, Service, Digital Products, Distributors, Schools, Institutes, CA, Doctors, Insurance Advisers, etc.
I am excited to partner with you!
-------------------------------------------------------------------------------------------------------------------------------------------------------------
queries solved - gsuitelab,top 5 most useful formulas in Google Sheets,5 advanced formulas in Google Sheets,Importrange,split formula in google sheets,split formula in excel sheet,filter formula google sheets,arrayformula google sheet,arrayformula vlookup google sheets,query formula google sheets,query in google sheets in hindi,query in google sheets,google sheets most useful formulas
Elevate your skills and reach new heights with my cutting-edge course and digital product! 🚀 Don't settle for mediocrity when you can excel beyond your wildest dreams. Click the link below to seize this opportunity now! 💡 sheetomatic.graphy.com/s/store
#UnlockYourPotential #SkillBoost #DigitalLearning 🌟
Thank you so much for your time
Sir Please make full formula video
How to count using dates in a data range of google sheet?
Very useful video
Very useful👌
kia sir ap petty cash format in different offices ma jo uses ha wo samjah saktha hain in google sheet pa
Very helpful video
Glad you think so!
Super !!!
👌👌👍👍💐💐
Sir kindly provide a video for Google sheets lock after data entry
Please explain Google form section wise data entry in different sheets (Example - 1st section entry 1st sheet and 2nd section entry 2nd sheet)
Its not possible dear
Best sir thanks sir
Hello sir, I have 10 student and on daily basis they fill Google form for attandance . Now issue is that all record store in one Google spreadsheet. like for example if student one want to view his attandance in spreadsheet record so their show all students record. Now I want to show student all form record in one spreadsheet and for student have their own mean that for everyone has their own specific spreadsheet record where they can only view his own record.. help me plz ?
You can get it separated using QUERY function>Create a New Spreadsheet and get all the Data sync with help of IMPORTRANGE function. share the file woth your students.
Sir quary function me ' ' ki jgha cell ka reference nhi de skte hai ky
For reference use ' " &cell reference&" '
Pls provide the link of worksheet dor practice.
Link not found in the description.
very very useful
Glad to hear that
Sir, i am try ti vlookup, cell that contains for of max and applies to vlookup but not working, y it is, and how to do it, pleae make a video
Sure, thanks for request
Sir during my online class someone comment and teachers said you do this comment but I not any comments How I proof that plz help me sir it's urgent for me
On Google meet sir
Comment can only be done when are joined the meeting and Details of commenter shows with email address. So its easy you could find the comments in Chat. While meeting
Screen thik se dikh nahi Raha hai
Apka screen clear nahi hai, sir!