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!

[@jolynnmarie725]

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

[@hustlesheets]

My FIRST super like!!! Thank you so much

[@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?

[@mmdcrl]

Because of this, I got 1.0 in my Data Analytics Fundamentals class. Thank you so much, sir!

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

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

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

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

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

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

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

[@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?

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

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

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

[@popocaboudoir]

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

[@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!

[@andrejohnson2373]

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

[@rickmorton2494]

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

[@TheBusinessHandyMan]

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

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

[@oliverobwana287]

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

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

[@CODEMANTHEUNDERDARK]

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

[@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!

[@anantprakash_]

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

[@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?

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

[@shivanshgupta7165]

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

[@Cashdel_]

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

[@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!

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

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

[@grainofsalt2113]

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

[@GO-7777]

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

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

[@christinacintron9656]

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

[@aaronargo5138]

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

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

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

[@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!

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

[@diegolin13]

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

[@maiaguelo23]

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

[@theKiroo]

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

[@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?

[@dmaxey138]

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

[@PhilBailey-z5k]

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

[@wilsononu2162]

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

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

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

[@revelationmd]

An incredibly helpful video - thank you! Subscribed.

[@heavypen]

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

[@TheWatchmanOfTheEnd]

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

[@ranjithgreen]

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

[@tokyoterri]

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

[@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?

[@PerryLeerschen]

Thanks my dude, this has leveled me up.

[@LuminousAsianBeauties]

amazing, easy to follow, great great videos, thanks

[@timtajiev106]

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

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

[@Striker8-]

Keep Hustling man! Thank you so much for this

[@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?

[@HeatherLittleton-k7l]

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!

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

[@agniamit]

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

[@henryramirez4102]

Great tutorial. I was interested in Pivot tables within queries

[@fdentconsulting1103]

bro, u on another level.

[@ToddEklund]

Very informative. Thanks for breaking down

[@ScoviaNinsiima-b3b]

This is good indeed. i have learnt a lot.

[@braedenbaker5052]

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

[@LauraD228]

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

[@kareemnr]

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

[@michaeldonohue6493]

Fantastic video. Thanks so much for this.

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

[@oghenegareeyankware8167]

Thanks for the video. Now, I have an understanding of developing dashboards on Google sheets. However, pls is it possible to get the data you used, so I can practice exactly what you did. This is my first time using Google Sheets

[@freemanfamily6126]

Thank you a bunch for teaching me how to put this together!

[@hustlesheets]

Of course! Is there anything else you'd like to learn in Google Sheets?

[@freemanfamily6126]

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

[@amirulnazhif6859]

Thank you so so much, this is really helpful!

[@張米粒-s5q]

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?

[@rebouta]

You really deserve more views, this is a great tutorial. Knowledgeable, clean, and very handy. Thank you for your time doing this.

[@hustlesheets]

Thank you, I think so too :)) haha. Is there anything else you'd like to learn in Google Sheets?

[@arjunvenugopal4763]

Deserves more views. Great tutorial!

[@LIVINGSTONTH]

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

[@GianniHayre]

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

[@pdrfurtado]

dude thank you so much, this is GREAT.

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

[@ajon2000]

Instructor is very good looking!

[@ashleighnicole22]

What a cutie

[@atalia0112]

really grateful to found this video. thank you so much!!! its very helpful

[@overundercambodia8926]

This is fantastic! Instant subscribe!

[@gtassandinf]

Thanks, this is great and quite useful.

[@Aquino85ana]

Thank you!!!!! This was very helpful!!!!!!!!!!!!!!!!!!!!!!!

[@javen0509]

Thank you. This is very helpful.

[@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?

[@donreginaldlosentes8674]

This is really helpful bro! Thanks

[@mohdhairulnizamabu5034]

Very Good tutorial for beginers