How to Create a Dashboard in Google Sheets in 5 Minutes - 2024 Edition 📈
HTML-код
- Опубликовано: 7 июл 2024
- Did you know you can create a dashboard in Google Sheets? Sounds crazy but you can actually turn a regular Google Sheet into a fully working dashboard.
I’ll walk you through the process of creating a dashboard in Google Sheet and making it interactive. Here is what to expect from this video:
✅ How to create a dashboard in Google Sheets
✅ How to customize Charts in Google Sheets
✅ How to add filters in Google Sheets
✅ Bonus: How to import data into Google Sheets automatically
And many other tips and tricks.
To follow along with the tutorial you can use our sample data set: docs.google.com/spreadsheets/...
Jump to the section that interests you the most:
00:00 Intro
00:32 Dashboard setup
00:53 First chart - scorecard
02:11 Extract month from date
02:45 Line chart
03:22 Table chart
03:52 Slicer filter
04:26 Importing data for the dashboard
05:15 Sum up
Learn more about Coupler.io and start for free at 🔗 app.coupler.io/register/sign_up
At Coupler.io Academy, we help you make sense of your data. We explain how to use spreadsheets, data warehouses, and BI tools. We share our tips on integrating data between apps and automating data transfers. Be sure to subscribe to our channel so you never miss a thing.
Learn more about Coupler.io and start a free trial at 🔗 app.coupler.io/register/sign_up. No credit card is required.
What is Coupler.io?
Coupler.io is a data automation and analytics platform that integrates data transfers from the business apps you use with over 200 available integrations. Over 800,000 users worldwide use Coupler.io to schedule automated data transfers, transform data, and bring it to various available destinations, including Google Sheets, Excel, BigQuery, Looker Studio, Power BI, and more. All available in a simple no-code interface that requires only a 5-minute setup.
See the complete list of the available data sources: bit.ly/3OP7in2
For more information, visit:
✅ Our website: www.coupler.io/
✅ Help Center: help.coupler.io/
✅ Email us: contact@coupler.io
📝 For more information on mastering Google Sheets, visit Coupler.io blog blog.coupler.io/
🔗 Google Sheets Dashboards Explained blog.coupler.io/how-to-create...
Keep in touch and join us on social media:
RUclips: @coupleracademy
Twitter: / coupler__io
Facebook: / coupler.io
LinkedIn: / coupler-io
#googlesheetdashboard
#googlesheetsdashboardtutorial
#createdashboardingooglesheets
#dashboardingooglesheets
#howtopreparedashboardingooglesheets
#howtocreateadashboardingooglesheets
#howtomakeadashboardingooglesheets
#howtobuildadashboardingooglesheets
#createdashboardingooglesheets
#makeadashboardingooglesheets
#buildadashboardingooglesheets
#automatedgooglesheetsdashboard
Sick tutorial, found it helpful. Great delivery from the instructor!
Thanks!
This was so helpful!
Glad to hear that!
Juste parfait! 👌🏼
Merci! :)
Month column is missing in the template in the description
Really helpful 😊
Glad you think this way, thanks!
Super helpful!👍
Awesome to hear that, thanks!
Great video!
FYI the month column is missing
How would you do the date part if you have data with numbers? (1/1/2020) instead of with text? (Report pulls directly form Salesforce so dates are unchangeable.
Great question! If your data has dates in number format (like 1/1/2020), you can still work with them in your Google Sheets dashboard. Google Sheets should recognize the numbers as dates if they’re formatted correctly.
If you need to manipulate these dates, you can use functions like DATE, TEXT, or DATEVALUE. For example, you can use:
=TEXT(A1, "mm/dd/yyyy")
to convert a numeric date to a text format. If you need to extract parts of the date, functions like YEAR, MONTH, and DAY can be handy too. :)
How do I format the Total Order column in the table?
Hi! How would you like to format it? You'll find plenty of options in the 'Format' menu, such as changing the currency symbol, number of decimals, different alignment within cell, etc
Can we 2 slicer for 1 data
Hey! Definitely, add as many slicers as you need :)
for the table chart, how can I display the amount for only 2 d.p?
Hi! You can use the "Custom number format" option from the Format -> Number menu to decide on the number of decimal places.
😍
Thanks :)
U good
cheers