i guess Im asking the wrong place but does someone know of a way to log back into an instagram account? I somehow forgot the account password. I love any assistance you can offer me
@Ishaan Jayce I really appreciate your reply. I got to the site on google and Im trying it out atm. Looks like it's gonna take quite some time so I will get back to you later when my account password hopefully is recovered.
Wow what can I say, I have been looking for a way to do formula for age, this video is really great to follow, I'm 69 yrs old and still learning, just shows you are never too old to learn.
Thank you so much! For an internship interview I had to visualize data in Google sheets while I never used Google sheets before (only excel). They were really impressed by my dashboard! I really wanted this internship and without your videos I do not think I would get the internship! So, thank you so much and keep up the good work :)
I work for a hospital and dashboards are big here. We literally starting using Google about 4 months ago, from MS products, and this video is going to make a a super star. I'll have to watch this video a couple more times, but I can't wait to get started on my first dashboard.
INCREDIBLE!! I look at many tutorials and never have I seen one that was so thorough, clear, and precise. THIS WAS GREAT! Thank you very much for sharing your wealth of knowledge.
This is nice! Just a tip if you want to change something in the formula and not have to worry whether you changed it or not, use the find and replace tool on the selected cell and tick the "within formulas" box and you should be able to replace everything without any problems.
It's the best google sheet tutorial I've ever had. Voice is clear, the presentation is easy to follow, and the pacing is not fast, not slow. Thank you.
I just want to share that your approach in teaching is very organized and friendly. I personally dread learning sheets in the past but I truly learned so much from this video. I hope you keep on teaching. Thank you so much for sharing your expertise. :) :)
I have watched this video last year, at that time I didn't understand and this week I watch this tutorial again almost everyday. Thank you very much, I have been searching the right formula for my report, and now I know how to use Query formula into my report. Thank you very much for helping me. It means a lot for me.
Hi Hustlesheets, I completed a formula using a line and a common fixed location (e.g c2). When I dragged the curser down the page, the 50 lines all came up with an incorrect or no answer at all. Then it occurred to me, if I place the common figure on each of the 50 lines, then from the top, line drag the cursor down, and this then worked. Phew!!!! I made it in the end. Really appreciate all your help which kept me going. Great video too. Thank you again.
I'm so impressed with this tutorial, I went from knowing nothing about Queries and charts to producing a fantastic dashboard. It gave me everything I needed to know in an easy to understand way.
This is one of the greatest tools for learning spreadsheets. I liked and subscribed, and am leaving the comment to help, because these skills are ridiculously valuable, and you can learn them here FREE.
Hi I truly love this video and watched it literally from start to finish three times (not including multiple replays of some sections), and I did build a dashboard using our org's own data! This is extremely helpful. And now i am watching your video on dynamic dashboard using query formula and dropdown lists. Just really want to thank you for this intuitive course.
@@hustlesheets Hi, thank you so much for reaching out! actually i am curious if you can do video tutorials on more advanced query functions and incorporate those into a real-world example (like sales dashboard)?
Hi Sir you are a Lifesaver I haven’t properly taken the time to reply. Because of your work I was able to do my job. It means a lot and thank you 🙏 for your hard work. Appreciate you very much sir. Sincerely
Never leave comments on RUclips but this is amazing! Thanks so much for sharing this, finally someone who is able to explain this in an easy way! Keep up the great work!
Excellent example of a great Sheets-based dashboard -- and one of the more useful practical examples of how to use the QUERY function that beginners can connect with. Thanks for creating the video!
What an amazing informative yet practical video, worth every minute i watched. Thank you very much brother for making such a detailed video. Love❤ from 🇮🇳
I found that if you check the box "Treat labels as text" (Customize -- >Vertical axis), the weird lines take a normal form. Great video, really helpful!
Great video, helpful, thanks. When you were seperating your query statement to make it easier to read, you selected where you wanted the break and then "hold option" . I don't know what that is. At 21:40
Thank you so much for sharing! I'm in software and I even have trouble following other tutorials out there, but using the Query command makes it so much easier and loads more powerful!
@ 4:40 you can resolve this issue by using an asterisk after the first quotation and before the last quotation. You can for example type "Michael H" in the criteria and it will only find "Michael H" but if you use " *Michael H* " it will search for anything with those letters in those orders ignoring case sensitivity, usually.
Wow! I’m a beginner at any kind of data entry and this video is so detailed and well done. Thank you for making this so easy to learn, I appreciate you! 🎉😊
You did great! No doubt. We are learning all the time. Something that gave me more confidence is that I could fix a few errors in my mind that you were coming across. 😅😬
31:37 Bless you! Really like how Sheets refreshes the data by its own, you don't need to push refresh button every time like in Excel We definitely need the in-depth know-how for analogue of Excel slicers in Google Sheets. I will check your channel hoping you already made something like this.
Thank you for sharing this tutorial. I'm new to creating spreadsheets. I'd like to know if the same formulas work on Excel too? If they don't, do you have a tutorial for excel? Thanks!
Just like to add, depending on your sheet language setting you need to use ; instead of , in formulars and in some chases " and ' can be different too and you can not depent 100% on the documentation sometimes since there are differences as well.
This is highly valuable info, thanks for taking time to create. Very interested in a deeper dive video/ course… I wouldn’t hesitate spending $20-30 one time for the info, FYI.
this has been a great help, quick question how can i get the data query to ignore when filtered? I'll manually copy and paste data in but the data will not adjust accordingly when the data sheet is filtered
nice! I got stuck with a business part of work that isn't being managed like one, so starting from scratch and prefer sheets to excel for ease of access and sharing :)
This video is fantastic! Would love a more in depth video and would also like to see a video that adds all the clauses together so we can see how they affect.
Yo, fam! Your Skill set is Fire! 🔥 Keep doing what you do! --Real man make something from nothing, and then teach another.... Your skills are dope kin folk! You've sharpened my "can Do!" Tool set. 🚀🚀🚀 Achieved lift off! --Make sure you make time for your full course, I will!
I keep trying the step at 5:59 selecting data range and Sheets just keeps making the dropdown apply to the Dropdown Menus list, not on the column selected in the Sales Data. Also Sheets looks a bit different now 2 years later so I'm wondering if there is a new step for using a Drupdown menu page to pull from.
Thank you ! Short question, what would be the Query if I wanted to add another condition to the 2 dates; like adding over the dates, a filter dropdown for "Sales person" ? This would help greatly. thanks in advance.
@@hustlesheets Mhmm, is there anything for a dash specifically tracking marketing only, that I could put together? I opened a business last year and I’m trying to really cracks down on it.
Is there a way to possibly create a wins and losses graph/to keep record of within this template? I recently purchased it and would like to add it. Greatly appreciated
Thank you so much for your tutorials. But I wonder how am I going to count the checks appeared on my checkboxes lists when creating a query that I will be using when making charts? Is there any way that I could turn the numbers/checked marks into percentage when making graphs?
How to create date and text filters using QUERY formula: ruclips.net/video/XGvCT3IeYdA/видео.html&ab_channel=Hustlesheets
i guess Im asking the wrong place but does someone know of a way to log back into an instagram account?
I somehow forgot the account password. I love any assistance you can offer me
@Callan Alexis instablaster ;)
@Ishaan Jayce I really appreciate your reply. I got to the site on google and Im trying it out atm.
Looks like it's gonna take quite some time so I will get back to you later when my account password hopefully is recovered.
@Ishaan Jayce It worked and I now got access to my account again. Im so happy!
Thank you so much you really help me out :D
@Callan Alexis happy to help =)
Wow what can I say, I have been looking for a way to do formula for age, this video is really great to follow, I'm 69 yrs old and still learning, just shows you are never too old to learn.
Wow! That's awesome! Thank you for watching
Because of this, I got 1.0 in my Data Analytics Fundamentals class. Thank you so much, sir!
This tutorial is fantastic. No rambling, just straight to the point, with live troubleshooting. Thank you!
Thank you so much! For an internship interview I had to visualize data in Google sheets while I never used Google sheets before (only excel). They were really impressed by my dashboard! I really wanted this internship and without your videos I do not think I would get the internship! So, thank you so much and keep up the good work :)
This is great to hear! A year later lol, but is there anything else you would like to learn about Google Sheets?
I work for a hospital and dashboards are big here. We literally starting using Google about 4 months ago, from MS products, and this video is going to make a a super star. I'll have to watch this video a couple more times, but I can't wait to get started on my first dashboard.
INCREDIBLE!! I look at many tutorials and never have I seen one that was so thorough, clear, and precise. THIS WAS GREAT! Thank you very much for sharing your wealth of knowledge.
This is nice! Just a tip if you want to change something in the formula and not have to worry whether you changed it or not, use the find and replace tool on the selected cell and tick the "within formulas" box and you should be able to replace everything without any problems.
It's the best google sheet tutorial I've ever had. Voice is clear, the presentation is easy to follow, and the pacing is not fast, not slow. Thank you.
Thank you Kentaro! Is there anything else you'd like to learn in Google Sheets?
I just want to share that your approach in teaching is very organized and friendly. I personally dread learning sheets in the past but I truly learned so much from this video. I hope you keep on teaching. Thank you so much for sharing your expertise. :) :)
Thanks so much for this tutorial! This is gold! God Bless!
My FIRST super like!!! Thank you so much
I have watched this video last year, at that time I didn't understand and this week I watch this tutorial again almost everyday. Thank you very much, I have been searching the right formula for my report, and now I know how to use Query formula into my report. Thank you very much for helping me. It means a lot for me.
Hi Hustlesheets, I completed a formula using a line and a common fixed location (e.g c2). When I dragged the curser down the page, the 50 lines all came up with an incorrect or no answer at all. Then it occurred to me, if I place the common figure on each of the 50 lines, then from the top, line drag the cursor down, and this then worked. Phew!!!! I made it in the end. Really appreciate all your help which kept me going. Great video too. Thank you again.
I'm so impressed with this tutorial, I went from knowing nothing about Queries and charts to producing a fantastic dashboard. It gave me everything I needed to know in an easy to understand way.
This is one of the greatest tools for learning spreadsheets. I liked and subscribed, and am leaving the comment to help, because these skills are ridiculously valuable, and you can learn them here FREE.
thank you Daniel! Hoping to find some time to make more videos about sheets/dashboards/data systems soon!
Hi I truly love this video and watched it literally from start to finish three times (not including multiple replays of some sections), and I did build a dashboard using our org's own data! This is extremely helpful. And now i am watching your video on dynamic dashboard using query formula and dropdown lists. Just really want to thank you for this intuitive course.
This is awesome to hear! Glad it’s been helpful 🙏🏼
8
Hi Jing, is there anything else you would like to learn about Google Sheets?
@@hustlesheets Hi, thank you so much for reaching out! actually i am curious if you can do video tutorials on more advanced query functions and incorporate those into a real-world example (like sales dashboard)?
i've been ssing around on a friends soft soft for years, finally bought it. I found your videos and instantly subscribed and have been
Mad these vidoes slap.Definetly inspired me to take me spreadsheet game up.
I've only done the first part and this is INCREDIBLE! Makes spreadsheets more fun and easy to read, thank you!
Thank you for this video. I just finished creating my first dashboard at work and used your video as a guide. Thanks again.
This is one of the most informative videos I have ever seen on RUclips. Thank you for the knowledge, it really helped a lot
The color theme is really soothing. I can say in the beginning of this video.
This is an awesome resource. I have come back to it several times for help! Thank you.
I learned these query formulas from your videos and I eventually learned SQL. Your were my first introduction to SQL, thank you
Awesome! How advanced are you with SQL now?
@@hustlesheets I'm now a data analyst in tech, I use it pretty much everyday now haha
Mike, I'm seeing this 2 years later but its an amazing and helpful tutorial. Thank you very much.
Hi Sir you are a Lifesaver I haven’t properly taken the time to reply. Because of your work I was able to do my job. It means a lot and thank you 🙏 for your hard work. Appreciate you very much sir. Sincerely
thank you!!! I didn't skip the add as my way of appreciation.
Never leave comments on RUclips but this is amazing! Thanks so much for sharing this, finally someone who is able to explain this in an easy way! Keep up the great work!
Great to hear! A bit late but, is there anything else you'd like to learn in Google Sheets?
Just want to say thank you for creating this content. You are helping so many people! Appreciated!!!
SUBSCRIBED! This is GOLD man. Thank you for breaking this down so cleanly! Cheers man.
I'm going to be spending hours analyzing this for implementation into my daily tasks.
Excellent example of a great Sheets-based dashboard -- and one of the more useful practical examples of how to use the QUERY function that beginners can connect with. Thanks for creating the video!
T shoulder without a bottom handle? 😭 this the same shoulders which held the Abu Ghraib costume
Most helpful video I've seen in a really long time!
Simply excellent content, and instruction. One of the best I've seen and the query is so powerful! My new go-to for G-Sheets problem solving!
Hello there! I love your content. Direct to the point in teaching. Continur doing this! -from Philippines
What an amazing informative yet practical video, worth every minute i watched. Thank you very much brother for making such a detailed video. Love❤ from 🇮🇳
Amazing video, I applied straight away and now i have good looking dashboard
so helpful. I realized that this was almost exactly like SQL with some slight differences. thanks for explaining it so well
It is a well invested hour to watch this full video in detail. Thank you so much 😸
I found that if you check the box "Treat labels as text" (Customize -- >Vertical axis), the weird lines take a normal form. Great video, really helpful!
Great video, helpful, thanks. When you were seperating your query statement to make it easier to read, you selected where you wanted the break and then "hold option" . I don't know what that is. At 21:40
Option is a key (on the keyboard) on Macs, I think PC’s have it too though
Thank you so much for sharing! I'm in software and I even have trouble following other tutorials out there, but using the Query command makes it so much easier and loads more powerful!
Hey man, great stuff. I've looked for a video like this for sheets for months. This is awesome.
Only problem with yt is you find the best content in the last .
Thank you for this quick refresher tutorial. Now, its time to create sample portfolios for my future clients. ☺️
Really helpful and straight to the point!!
May I know what if the data I have are in separate tabs ? Do I have to combine them all in one tab?
Just found your tutorial and its awesome, I was thinking to use Power BI, but this changed mi mind!
@ 4:40 you can resolve this issue by using an asterisk after the first quotation and before the last quotation. You can for example type "Michael H" in the criteria and it will only find "Michael H" but if you use " *Michael H* " it will search for anything with those letters in those orders ignoring case sensitivity, usually.
Wow! I’m a beginner at any kind of data entry and this video is so detailed and well done.
Thank you for making this so easy to learn, I appreciate you! 🎉😊
You did great! No doubt. We are learning all the time.
Something that gave me more confidence is that I could fix a few errors in my mind that you were coming across. 😅😬
31:37 Bless you!
Really like how Sheets refreshes the data by its own, you don't need to push refresh button every time like in Excel
We definitely need the in-depth know-how for analogue of Excel slicers in Google Sheets. I will check your channel hoping you already made something like this.
You're a good man for sharing this. Thank you.
Thanks for leaving your mistakes in the video. I learn from them also!
Google sheets supports pseudo SQL queries?!! You opened so many possibilities for me, thank you so much
21:55 @Hustlesheets Good ay sir, what keys did you click when you said "Option and Enter" tia. 😊
Option key on a Mac! I think it is "ALT" on a Windows
Absolutely changed my life!! Loved it. Just what I needed for my spreadsheet. Thank you soooo much.
Great to hear Len! A year later but, is there anything else you'd like to learn in Google Sheets?
Awesome awesome awesome! I hated spreadsheets before this and have learned so much in seconds!
I really appreciate this video - have been trying to find a way to create a dashboard and this made it really clear!
thanks a lot, my friend. saved me tons of time i appreciate your time
Thank you for sharing this tutorial. I'm new to creating spreadsheets. I'd like to know if the same formulas work on Excel too? If they don't, do you have a tutorial for excel? Thanks!
Great tutorial. I was interested in Pivot tables within queries
Thank you very much for the presentation, Michael! It helped me a lot!
Thanks my dude, this has leveled me up.
Dude you killed it! This is a very helpful and easy to follow video. Keep them coming.
Literally the BEST video EVER. This was extremely helpful!!! thank you so so much for posting this.
Thank you!!! Is there anything else you'd like to learn about within Google Sheets?
Keep Hustling man! Thank you so much for this
I have been learned in this video grouping more colum and limiting the rows.
and also order by. ı used to sort formula after writing the query code
it is also desc or esc
also helper colums will we in the begining of the table because if you add some new column entire formula will be sphagetti
I would love to see how you add filters and make the dashboard interactive! Thanks!
An incredibly helpful video - thank you! Subscribed.
Just like to add, depending on your sheet language setting you need to use ; instead of , in formulars and in some chases " and ' can be different too and you can not depent 100% on the documentation sometimes since there are differences as well.
Awesome trick - didn't know that data validation is column-based. One sheet to rule them all. Very good tutorial. Thanks. Subscribed!
excellent review. got almost all the basics in under an hour. Thanks :)
This is highly valuable info, thanks for taking time to create. Very interested in a deeper dive video/ course… I wouldn’t hesitate spending $20-30 one time for the info, FYI.
Thanks Luke. What would you like to learn? Although I would not do a course for $20-30, a course would be minimum $500
this has been a great help, quick question how can i get the data query to ignore when filtered? I'll manually copy and paste data in but the data will not adjust accordingly when the data sheet is filtered
nice! I got stuck with a business part of work that isn't being managed like one, so starting from scratch and prefer sheets to excel for ease of access and sharing :)
Deserves more views. Great tutorial!
This video is fantastic! Would love a more in depth video and would also like to see a video that adds all the clauses together so we can see how they affect.
Its really interesting...
Can you share a video on how to create dashboard based on the Date Range or by week in a given month?
I rarely comment, but this is a great tutorial! Thanks!
Very very thanks to you for this wonderful tutorial, once again thank you, I learned a lot
Yo, fam! Your Skill set is Fire! 🔥 Keep doing what you do! --Real man make something from nothing, and then teach another.... Your skills are dope kin folk! You've sharpened my "can Do!" Tool set. 🚀🚀🚀 Achieved lift off! --Make sure you make time for your full course, I will!
Thanks Eugene! Is there anything else you'd like to learn about within Google Sheets?
This video is amazing and gives me the motivation to try to create something myself! Can’t thank you enough!
Dash lines? Whats behind the line and light rectangle Yahoo
bro, u on another level.
Very informative. Thanks for breaking down
amazing, easy to follow, great great videos, thanks
SPECTACULAR. You just open my eyes. Thanks!!!!!
This is fantastic! Instant subscribe!
I keep trying the step at 5:59 selecting data range and Sheets just keeps making the dropdown apply to the Dropdown Menus list, not on the column selected in the Sales Data. Also Sheets looks a bit different now 2 years later so I'm wondering if there is a new step for using a Drupdown menu page to pull from.
Thank you ! Short question, what would be the Query if I wanted to add another condition to the 2 dates; like adding over the dates, a filter dropdown for "Sales person" ? This would help greatly. thanks in advance.
I'll make a video for this very soon!
Hi! Very helpful video. How do I get the link to the google sheet to practice? I only see the one to purchase
You really deserve more views, this is a great tutorial. Knowledgeable, clean, and very handy. Thank you for your time doing this.
Thank you, I think so too :)) haha. Is there anything else you'd like to learn in Google Sheets?
Thank you so much for this, this has been really helpful.
Excellent tut, thank you so much for the time you spend and all the knowledge you share !
Thank you very much for this tutorial. Query formula is great !
Thank you a bunch for teaching me how to put this together!
Of course! Is there anything else you'd like to learn in Google Sheets?
@@hustlesheets Mhmm, is there anything for a dash specifically tracking marketing only, that I could put together? I opened a business last year and I’m trying to really cracks down on it.
Instructor is very good looking!
What a cutie
Is there a way to possibly create a wins and losses graph/to keep record of within this template? I recently purchased it and would like to add it. Greatly appreciated
Thank you so much for your tutorials. But I wonder how am I going to count the checks appeared on my checkboxes lists when creating a query that I will be using when making charts? Is there any way that I could turn the numbers/checked marks into percentage when making graphs?
well explained and structured approach. Thanks and keep it up.
dude thank you so much, this is GREAT.