How to make a Dashboard in Google Sheets (Full Tutorial)
Vložit
- čas přidán 29. 08. 2024
- Download the data report to follow along: spreadsheetcla...
Take the full dashboards course:
www.spreadshee...
Get help with your spreadsheet project, or personalized training:
www.spreadshee...
Get the ultimate formulas cheat sheet
www.spreadshee...
Above you will get free access to the entire data course that will take you from beginner to advanced. Here you can get the raw data, view the complete dashboards, and follow along step by step with a variety of dashboards builds.
If you want to build a faster and more simple version of the dashboard in this video, check out this tutorial: • Fast & simple dashboar...
Or if you want a super quick overview of the dashboard in this video, as well as to learn the 3 major steps for building any dashboard, check out this video: • Build a dashboard in 3...
NOTE: If you are located in Europe or outside of the U.S., your date format will be different than the United States. You can change this by clicking File... Settings... General... Locale... United States
In this video you will learn how to make a sales dashboard in Google Sheets, from start to finish. I will show you how to import data, how to parse the data and make calculations with formulas, how to perform data analysis in Google spreadsheets, and how to use conditional formatting and charts to visualize data.
Dashboards are an incredible tool that help businesses succeed in many ways. Companies all around the world use Google Sheets to stay organized, identify the performance of products / services / employees / students, to speed up tedious processes, and much more!
Learning how to build dashboards and perform data analysis is an incredibly valuable skill to have, and Google Sheets is the perfect platform to learn these skills on because it is free, easy to use, and extremely versatile.
My name is Corey Bustos, and I have been building Google Sheets dashboards professionally for over 5 years, and am very excited to have the opportunity to teach you what I have learned over the years.
This was such an amazing foundational course!! You did such a great job narrating the entire course, excellent 👍🏼👍🏼👍🏼👍🏼👍🏼🤯
Thank you so much for the kinds word! I am really glad that you enjoyed this.
Wow this was Great! As a student in a Business Analytics course I can say that this has helped me a lot! With this alone I can make my own Basic Dashboards! Thank you so much for the thorough explanation on the functions!
That means a lot, thanks for the kind words! I am VERY glad to hear that this helped you:) That's exciting that you can build dashboards now, your Google Sheets skills can make you very valuable in the professional world. Thanks very much for your comment. Have an amazing day.
Amazing tutorial.Just created my first dashboard with my own data, now I want to import a new set of data to the dashboard. Do I need to change all the formulas from Import to new sheet called Import1 or is there a short cut to clear the data out of the Dashboard and get the new data from Import1 into it. Also if I just wanted to tag on this new data to the present dashboard. Thankyou
Thanks for sharing your knowledge. One of the best google sheets tutorials I've seen. Love how well you explain everything.
Thank you so much for the kind words! I am glad that you enjoyed this
I love this, names for the sales rep can also be automated by "= UNIQUE(Import!C2:C)"
Glad you like it! Indeed that's how it's done! Good call, I go over that in my other course haha.
This is very explanatory. I was able to understand and finish up a task at work watching this tutorial.
That is so awesome, I am glad that you enjoyed the video and that it was clear. Thanks for the kind words! Have an amazing day.
Honestly you deserve more subscribers, you such a good teacher. Nice pace and nice explaination. I wish you all the best in your channel, you deserve it 👏
I really appreciate that:) Thank you for the kind words.
Thanks for the tutorial. It was very easy to modify your directions to meet the needs fo the dashboard I needed. Great info! Thanks again!
Wow that's truly great to hear as that's what I was hoping for with thid video! Thanks very much for your comment, and I am glad that you were able to put together your own dashboard!
A great tutorial, with high quality explanations. An excellent learning tool. Keep up the good work.
Thank you John, I am very glad that you enjoyed the video!!
Well explained making it very easy to follow along. I've now subscribed and will begin to watch more of your tutorials
That's awesome thank you Tony, I am glad that you enjoyed the video and that you subscribed!
Great tutorial thank you so much!!!
This channel is a gem.
You're very welcome, I am glad you feel that way, thank you!
Thanks dude, my very first dashboard!!!
Sweet!!! You're very welcome!
Thank you!
this is awesome man, keep it up. appreciate your efforts .
Just finished this. Really great tutorial, easy to follow and understand.
That is so awesome to hear, I am VERY happy that you liked the video / tutorial!
Thank you! Soooooo much
You are so welcome!
Thanks,that was helpful.
You bet!
Fantastic way of demonstration od developing a dash board to show various KPI's of Sales domain with help of Google Spreadsheet. I would like your strategy to develop a sales dashboard. Actually I am a associate Data analyst especially in sales and Marketing Domain.
I am glad that you enjoyed it! It just depends on the type of sales data that there is, there are so many different ways to do it. On my website there are sales templates that you can take a look at:)
Wonderful video. Clear explanations. Thank you
That's great to hear that you enjoyed the video / lesson! Have a wonderful day.
Very good Google sheet training video, thank you
That's so awesome, I am VERY glad that you are liking it!
Thanks a lot for the effective video,
Love it, learn from it
Thanks for the kind words, I am glad you enjoyed the tutorial!
Very informative! Question, how would one identify for time gaps between calls and get that average from the data? Assuming the data has time one call ended and where another began…
I am glad you enjoyed the video! I would use subtraction formulas down the column, then when you have a column that contains the gap / difference, then use the AVERAGE formula to average the entire column
Awesome !!! Thank you so much !!!!
You are very welcome! Glad you enjoyed:)
Thank you! I love learning Google Sheets as needed and this was perfect.
That is so awesome!! I am very glad to hear that you liked the tutorial.
It is very extremely high quality and well-explained tutorial. Your Voice Quality is very Clear and Excellent. Well done Sir. Kindly inform your other Tutorials. Best regards. Greetings from India
2
Spreadsheet Class
Thank you very much! I am very glad you liked the video.
Great Tutorial.
Thank you! I am glad that you enjoyed it.
HI, I have a question about the date format, when I imported the file to google sheet the date in cell G2 which is supposed to be August 10, 2020 (8/10/2020) is being recognized by google sheet and excel sheet as October 8, 2020. When I used the max function, I am getting a different answer
Hi, this may be related to the date format in your location. For example if you are located in Europe your date format will be different than the U.S. You can try to change this by clicking File > Settings > General > Locale > United States
hi, how did you select a2-d5 and a5-d5 seperatly? when ı use shift after ı select a2-d2 it choose under of them too.
Hi! Hold "Ctrl" while selecting.
Hey there! Spreadsheet Class. I want to learn google sheets from beginner to advance and build my custom dashboard from scratch to the end. Are these videos enough for me to do so? Kindly assist me to achieve my goal😊
Hey great question! This video alone is on the beginner side, but I do offer an entire free course that will take you all the way to being advanced! Here is the course: www.spreadsheetclass.com/dashboards/
Thanks
Absolutely!
WHEN I AM DOWNLOADING THE GOOGLE SHEETS TO EXCEL THE DASHBOARDS ARE NOT VISIBLE WHY??
These formulas may not transfer to excel perfectly, they are just designed for Google Sheets
I can't find the link where you describe how to obtain the revenue report. Where is the link you reference?!
It can be downloaded at spreadsheetclassroom.com/free
@@spreadsheetclass Perfect. thanks!
Absolutely!
I'm stuck on this and would appreciate some help! I'm unable to run any calculations for the dates. When I do "=G3-G2" I get either a "False" or "Value" error. So I can't get past this early step. I've tried reformatting the dates and changing my location and that's not rendering the correct calculation.
Can you tell me which time in the video that you are working on when you get this error? Initially it sounds like maybe one of the cells has something other than a number in it, but I can look into it if you tell me the time stamp for where you're having trouble.
@@spreadsheetclass Yeah same problem I too faced a while ago (timestamp 12:30), changed the locale to USA and then subtracted dates again only to find 46 and not 13 as result.
On replicating the step mentioned at 14:30, I got 8/12/2020 in A3 cell, instead of what the tutorial shows at 14:30 [UPDATE: On 15:33, I got 342 as time span which is surely wrong]. Now I am bamboozled and thinking of skipping the tutorials which I was really enjoying so far :/
Please help.
UPDATE-2: At 17:00, getting 0 in cell B3. [okay this was resolved when column E2 was formatted to 'currency', it is my fault actually that I too went straight to creating Dashboard instead of my usual practice of cleaning the raw data first]
Like this one
Glad you enjoyed it!
I dont have the "List from a range" option.
This may be due to the recent update from Google Sheets on how the drop-down menus work. Now the option is called Dropdown (from a range)
I am getting MAX date 8/12/2020 if using MAX formula. the formula should give the 9/8/2020 date. Can you please help me with this?
It was solved. :-)
Glad to hear you found the solution!
@@savitaverma1716 How are you able to solve this? I am also getting same error, date format becomes different when I imported the file
@@spreadsheetclass How are you able to solve this? I am also getting same error, date format becomes different when I imported the file
@@savitaverma1716 Hi Savita, How did you solve your issue? Kindly reply.
how did you automatically populate the name of the sales rep? it doesn't show on this video tutorial
I just typed them in this example. You can also use the UNIQUE function to gather a unique list of names that are found in the raw data, but this would assume that at least one of each name is found in the raw data.
Hi.. Just to check.. can you help us set up..we give you the fields and requirements..we will be happy to pay you for the services
Hey Selvaraj sorry for the late reply. I am not currently taking on any projects at this time. Sorry. I hope the course can help you build it though!
Awesome video! Thank you!
You bet, glad you liked it!!