How to Build a Professional Dashboard in Google Sheets (Query Formula Advanced Course) Step-by-Step

Video Chapters:
0:00 Intro
4:34 Data entry
15:00 Conditional formatting
17:55 Group columns
18:47 Build dashboard
22:10 QUERY formula
34:55 Insert charts
44:04 DATE FILTERS
50:13 TEXT FILTERS
1:12:40 Sparklines
1:18:49 Weekly dashboard

[ukonkomarasari]

This video is indeed what I need. And your step-by-step elaboration, including even the errors that we need to know, so as to not getting panic, is ssoooo enriching. Thank you so much ... I cannot express my thanks to you more ... Subscribed right away !!

I love watching your videos! I work hard trying to do better in sheets, and I get so much out of your tutorials. Thanks for sharing the knowledge! :) Trying to work something out now and it's driving my crazyyy but I continue watching so I can learn more. Subscribed, definitelyyy!!

[titogarza]

I am an administrator in high school education, and this video has really impacted the way I am approaching my current end of year project. Thanks so much for this!

[tmizzle]

🐐🐐🐐 bought your dashboard on Etsy and using this to customize everything to my business. You're the man!

[qfkuhnp]

Just subscribed... Brilliant tutorials. I was one of those that thought I was a wizz on a spreadsheet, when watching these tutorials it makes me realise I probably only know about 0.01% of spreadsheet powers. Love it.. Thank You

[rosalycruzc]

This video was absolutely amazing and well explained, thank you so much for this. Now I'm looking for a way to include the expenses in the dashboard

[melaniem]

This was exactly what I needed. Thank you SO much. Incredibly thorough and simple explanation- saved me a ton of time and confusion. :)

[Captaintabiii]

20 minutes in and I’ve already learned SO much 🤩 Thank you!!!

[forexroy]

What a great video. It shows you put lot of thought and effort into it. Nice work and thanks!

[raiiiyann]

Just in time. Thank you for sharing advanced course!

[yxmmiho]

Thanks a lot for your tutorials, it's really helpful! Appreciate the videos you upload!

[danielkirigin]

Thank you man! It took me some time but I finally made it! Terrific explanation!

[yinziliang]

This is REALLY helped, well explained, the other query video is also really helpful. THANK YOU!

[marv]

Thanks a lot. Really helped me build a more comprehensive database with data entry and report dashboard. 😊

[hieulee]

this video and previous video is extremely helpful for me in creating dashboard.I have been watched many but finally I found and fell in love with it.Thanks alot for sharing this.

[varunraj]

Life saver. Thanks a bunch man! Enjoyed working through the entire video. And it was funny how the header conditional formatting kept turning white

[GermanRodriguezqndq]

GREAT VIDEO, as a customer i have been able to use some of your products and also i have been able to learn a lot from your videos, thank you

[scottcarrington]

Wonderful video. Really liked the clear instructions. Thank you

[unaisv]

This was exactly what I needed and good presentation. Thank you SO much

[ThijsVerberne]

Smart trick to use optional filters! Great job.