How to Create a Dashboard in Google Sheets in 5 Minutes

How to Create a Dashboard in Google Sheets in 5 Minutes - 2024 Edition 📈

Рет қаралды 191,050

Coupler․io Academy

Күн бұрын

Пікірлер: 36

@LordBuddhaReborn 2 ай бұрын

AND YOU TAUGHT ALL THIS TO PROMOTE YOUR APP?!! THAT'S CRAZY AND PERFECT

@paprmache 8 ай бұрын

Sick tutorial, found it helpful. Great delivery from the instructor!

@coupleracademy 8 ай бұрын

Thanks!

@selenabodhnarain6582 14 күн бұрын

can you make a version of the data that already has the dashboard

@googleBryce 27 күн бұрын

How do you edit the insane amount of digits after the decimal on the table chart?

@Khadijabb79 10 ай бұрын

Juste parfait! 👌🏼

@coupleracademy 10 ай бұрын

Merci! :)

@El3iram 2 ай бұрын

what if you don't have any data to pull into the dashboard yet? Is there a way to structure a dashboard without data?

@coupleracademy 2 ай бұрын

You can reference empty cells where the data will later reside and add some parts of a dashboard this way but you won't be able to test if everything works as expected without data. A far better option is to quickly generate some dummy data with sites like www.mockaroo.com/. Or ask ChatGPT to generate a dummy dataset meeting your specific criteria and give you a csv file to upload to Sheets.

@CaribouDataScience 6 ай бұрын

How do I format the Total Order column in the table?

@coupleracademy 6 ай бұрын

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

@ryanjamison5537 27 күн бұрын

If you just highlight the section your wanting. click the first box and then hold shift and click the last box so its all highlighted. Then just copy and paste from sheets to your canva sheet

@JK-fh6zf 7 ай бұрын

Super helpful!👍

@coupleracademy 7 ай бұрын

Awesome to hear that, thanks!

@venkythe.4828 11 ай бұрын

Really helpful 😊

@coupleracademy 10 ай бұрын

Glad you think this way, thanks!

@mohitdhiman8295 Жыл бұрын

Can we 2 slicer for 1 data

@coupleracademy Жыл бұрын

Hey! Definitely, add as many slicers as you need :)

@liaabiaaaa0557 7 ай бұрын

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.

@coupleracademy 7 ай бұрын

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