How to Create a Dashboard in Google Sheets (10 steps) - Query Formula

[@hustlesheets]

How to create date and text filters using QUERY formula: kzbin.info/www/bejne/jnjZdIdpfsqMmqM&ab_channel=Hustlesheets

[@callanalexis5312]

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

[@ishaanjayce1368]

@Callan Alexis instablaster ;)

[@callanalexis5312]

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

[@callanalexis5312]

@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

[@ishaanjayce1368]

@Callan Alexis happy to help =)

[@assenavno]

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.

[@hustlesheets]

Wow! That's awesome! Thank you for watching

[@BenBrinkley]

This tutorial is fantastic. No rambling, just straight to the point, with live troubleshooting. Thank you!

[@jelmer2449]

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 :)

[@hustlesheets]

This is great to hear! A year later lol, but is there anything else you would like to learn about Google Sheets?

[@cristenazas8053]

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. :) :)

[@Miguel-px3jd]

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.

[@jinggao3931]

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]

This is awesome to hear! Glad it’s been helpful 🙏🏼

[@subbaramaiah8250]

8

[@hustlesheets]

Hi Jing, is there anything else you would like to learn about Google Sheets?

[@jinggao3931]

​@@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)?

[@popocaboudoir]

I've only done the first part and this is INCREDIBLE! Makes spreadsheets more fun and easy to read, thank you!

[@kentaromitsuma1251]

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.

[@hustlesheets]

Thank you Kentaro! Is there anything else you'd like to learn in Google Sheets?

[@josemuriel1651]

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.

[@anitabrearton6866]

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.

[@TeacherGunar]

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.

[@rickmorton2494]

This is an awesome resource. I have come back to it several times for help! Thank you.

[@dearickmilton]

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.

[@Cheddar_Dan]

This is one of the most informative videos I have ever seen on KZbin. Thank you for the knowledge, it really helped a lot

[@JonathanKelley]

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!

[@Dragon-Slay3r]

T shoulder without a bottom handle? 😭 this the same shoulders which held the Abu Ghraib costume

[@wilsononu2162]

You're a good man for sharing this. Thank you.

[@johnpeterchinelly6341]

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

[@andrejohnson2373]

Thank you for this video. I just finished creating my first dashboard at work and used your video as a guide. Thanks again.

[@anantprakash_]

The color theme is really soothing. I can say in the beginning of this video.

[@elliehawkins8324]

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! 🎉😊

[@fp30e]

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.

[@MarcParsons-h6v]

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!

[@beninjocoo]

Never leave comments on KZbin 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!

[@hustlesheets]

Great to hear! A bit late but, is there anything else you'd like to learn in Google Sheets?

[@grainofsalt2113]

so helpful. I realized that this was almost exactly like SQL with some slight differences. thanks for explaining it so well

[@oliverobwana287]

Mike, I'm seeing this 2 years later but its an amazing and helpful tutorial. Thank you very much.

[@aaronargo5138]

Hey man, great stuff. I've looked for a video like this for sheets for months. This is awesome.

[@lfabich]

Absolutely changed my life!! Loved it. Just what I needed for my spreadsheet. Thank you soooo much.

[@hustlesheets]

Great to hear Len! A year later but, is there anything else you'd like to learn in Google Sheets?

[@danielbanks9978]

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.

[@hustlesheets]

thank you Daniel! Hoping to find some time to make more videos about sheets/dashboards/data systems soon!

[@GO-7777]

Just want to say thank you for creating this content. You are helping so many people! Appreciated!!!

[@joannakalantzea9746]

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!

[@Cashdel_]

thank you!!! I didn't skip the add as my way of appreciation.

[@MrSuriyam]

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

[@tellyisko6908]

Hello there! I love your content. Direct to the point in teaching. Continur doing this! -from Philippines

[@therobotandjj]

SUBSCRIBED! This is GOLD man. Thank you for breaking this down so cleanly! Cheers man.

[@CODEMANTHEUNDERDARK]

I'm going to be spending hours analyzing this for implementation into my daily tasks.

[@maiaguelo23]

Thank you for this quick refresher tutorial. Now, its time to create sample portfolios for my future clients. ☺️

[@carlosescudero3161]

It is a well invested hour to watch this full video in detail. Thank you so much 😸

[@talebbagazi1435]

Amazing video, I applied straight away and now i have good looking dashboard

[@vex123]

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!

[@jaibhoir1488]

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 🇮🇳

[@PhilBailey-z5k]

Thanks for leaving your mistakes in the video. I learn from them also!

[@justinwest7925]

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.

[@grainofsalt2113]

I learned these query formulas from your videos and I eventually learned SQL. Your were my first introduction to SQL, thank you

[@hustlesheets]

Awesome! How advanced are you with SQL now?

[@grainofsalt2113]

@@hustlesheets I'm now a data analyst in tech, I use it pretty much everyday now haha

[@sufiannaeem3002]

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. 😅😬

[@christinacintron9656]

Most helpful video I've seen in a really long time!

[@diegolin13]

Just found your tutorial and its awesome, I was thinking to use Power BI, but this changed mi mind!

[@heavypen]

Awesome trick - didn't know that data validation is column-based. One sheet to rule them all. Very good tutorial. Thanks. Subscribed!

[@ruslanator]

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.

[@hustlesheets]

PART 2 with advanced features here: kzbin.info/www/bejne/mZS3lXeGeax4fa8&ab_channel=Hustlesheets

[@jolynnmarie725]

Thanks so much for this tutorial! This is gold! God Bless!

[@hustlesheets]

My FIRST super like!!! Thank you so much

[@hustlesheets]

I'll be releasing a full scale paid dashboard course soon! Signup if you want early access (will be limited to x amount of students): forms.gle/iPPQtHjP4GF6ukgAA

[@revelationmd]

An incredibly helpful video - thank you! Subscribed.

[@tokyoterri]

I really appreciate this video - have been trying to find a way to create a dashboard and this made it really clear!

[@timtajiev106]

Thank you very much for the presentation, Michael! It helped me a lot!

[@Sebnettic]

Awesome awesome awesome! I hated spreadsheets before this and have learned so much in seconds!

[@thehumanperformanceandread9857]

Dude you killed it! This is a very helpful and easy to follow video. Keep them coming.

[@TheBusinessHandyMan]

Mad these vidoes slap.Definetly inspired me to take me spreadsheet game up.

[@theKiroo]

Google sheets supports pseudo SQL queries?!! You opened so many possibilities for me, thank you so much

[@MaliniPatel]

Literally the BEST video EVER. This was extremely helpful!!! thank you so so much for posting this.

[@hustlesheets]

Thank you!!! Is there anything else you'd like to learn about within Google Sheets?

[@ibrhmmcht3907]

I have been learned in this video grouping more colum and limiting the rows.

[@ibrhmmcht3907]

and also order by. ı used to sort formula after writing the query code

[@ibrhmmcht3907]

it is also desc or esc

[@ibrhmmcht3907]

also helper colums will we in the begining of the table because if you add some new column entire formula will be sphagetti

[@PerryLeerschen]

Thanks my dude, this has leveled me up.

[@LIVINGSTONTH]

Excellent tut, thank you so much for the time you spend and all the knowledge you share !

[@agniamit]

excellent review. got almost all the basics in under an hour. Thanks :)

[@shivanshgupta7165]

Only problem with yt is you find the best content in the last .

[@fdentconsulting1103]

bro, u on another level.

[@ToddEklund]

Very informative. Thanks for breaking down

[@dmaxey138]

thanks a lot, my friend. saved me tons of time i appreciate your time

[@amarquezr75]

SPECTACULAR. You just open my eyes. Thanks!!!!!

[@LauraD228]

I would love to see how you add filters and make the dashboard interactive! Thanks!

[@ranjithgreen]

Very very thanks to you for this wonderful tutorial, once again thank you, I learned a lot

[@meganwyrick8810]

This video is amazing and gives me the motivation to try to create something myself! Can’t thank you enough!

[@Dragon-Slay3r]

Dash lines? Whats behind the line and light rectangle Yahoo

[@arjunvenugopal4763]

Deserves more views. Great tutorial!

[@msprettyinpink04]

This is great and helpful. Thank you for sharing the knowledge.

[@zn4rf]

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.

[@overundercambodia8926]

This is fantastic! Instant subscribe!

[@mohdhairulnizamabu5034]

Very Good tutorial for beginers

[@moonlitdreams]

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 :)

[@LukeSalaiz]

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.

[@hustlesheets]

Thanks Luke. What would you like to learn? Although I would not do a course for $20-30, a course would be minimum $500

[@kareemnr]

Thank you so much for this, this has been really helpful.

[@alexiscarre6670]

Thank you very much for this tutorial. Query formula is great !

[@Striker8-]

Keep Hustling man! Thank you so much for this

[@braedenbaker5052]

I rarely comment, but this is a great tutorial! Thanks!

[@bocobox]

well explained and structured approach. Thanks and keep it up.

[@knapesusahsgtni]

Thank you so much for sharing this knowledge! I appreciate it very much.

[@henryramirez4102]

Great tutorial. I was interested in Pivot tables within queries

[@AbhinavMaharwal]

Thanks for sharing this. Its truly helpful and wonderful

[@LuminousAsianBeauties]

amazing, easy to follow, great great videos, thanks

[@EugeneRoberts]

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!

[@hustlesheets]

Thanks Eugene! Is there anything else you'd like to learn about within Google Sheets?

[@ajon2000]

Instructor is very good looking!

[@ashleighnicole22]

What a cutie

[@michaeldonohue6493]

Fantastic video. Thanks so much for this.

[@danholstein411]

Great explanations. Well done!

[@javen0509]

Thank you. This is very helpful.

[@ScoviaNinsiima-b3b]

This is good indeed. i have learnt a lot.

[@MaggieBernard3]

This was so helpful and easy to understand. Thank you so much.

[@amirulnazhif6859]

Thank you so so much, this is really helpful!

[@saimakousar7125]

Great video.. loved the way you explain

[@anbukayalvizhi5372]

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?

[@StevePhelps]

Great video! Explained some things that I was not quite clear on!

[@guilbertvw]

I am so grateful.