Tables in Google Sheets [new 2024 update]
Ғылым және технология
Big News! REAL TABLES are now in Google Sheets. No more of this fake alternating colors jazz. We've got the real deal.
🚀Join my free newsletter: gotsheet.xyz/subscribe
This has been a long time coming, and I'll walk you through the basics in a quick overview today.
=============================
🖥️ Office items I can't live without:
amzn.to/3uqSO7Q (amazon)
📲 Find me
on LinkedIn: / eamonncottrell
on Twitter: / eamonncottrell
on website: www.eamonncottrell.com/
🎓Course Suggestions:
► Advanced Data Analytics Certificate by Google: imp.i384100.net/21dWGa (coursera)
► Cybersecurity by Google: imp.i384100.net/VmN6oM (coursera)
=============================
⌚Chapter Time Markers:
00:00:00 - Tables in Google Sheets!
00:00:35 - Insert Pre-built table
00:02:30 - View Options
00:03:29 - Filtering
00:04:07 - Removing Filters
00:04:34 - Change Column TYpes
00:05:12 - Using Tables Dynamically in Formulas
00:06:29 - Turn Data into Table
=============================
#exceltips #googlesheets #spreadsheets #dataanalytics #excel #productivity #gotsheet #howtousespreadsheets #getgoodatspreadsheets
Пікірлер: 20
📌Here's the announcement post: workspaceupdates.googleblog.com/2024/05/tables-in-google-sheets.html
I didn't realise they were so new ... I've already sent my suggestions to Google on how to improve them 😂
@EamonnCottrell
6 күн бұрын
yeah, lol, def room for improvement
Thank you for the video! Regarding changing data type in a column while filtered, you can see the "Column Menu" selection at the top of the filter pop-up. This will take you back to the pre-filter pop-up and you can change type while still filtered.
@EamonnCottrell
Ай бұрын
Oh nice! This is good to know, thanks!
I just discovered this feature and it's going to be a game-changer for our team! Now I don't have to switch between google sheets and project management apps just to track things well.
@EamonnCottrell
29 күн бұрын
yay!
Hey @eamonncottrell thanks for the video. How would you compare this to clickup?
@EamonnCottrell
6 күн бұрын
I wouldn't really. I thought clickup was more of a project management/all-in-one platform. I haven't used it but I don't think it would be data analysis tool
Thank you!...
@EamonnCottrell
Ай бұрын
You're welcome!
Thanks for the video (and thank you Google for finally adding this). BUT how do I add new data easily? When I have cursor in bottom of a table (bottom/right - last cell of the table), when I hit Enter or Tab it does not create a new row to the table (as it does in Excel). Is there a shortcut I don't know of?
@EamonnCottrell
20 күн бұрын
Yeah, that's an area that Google is still falling way behind with. I'm getting together a more in depth comparison between Excel and Sheets tables. And it looks like with Sheets, you still have to manually add additional rows rather than easily hitting enter like you can do in Excel
Is there a way to add a sum row at the bottom of the table?
@EamonnCottrell
22 күн бұрын
Yes, if you sum the values in a table column i.e. =SUM(budget[Cost per person]) in the row below the table, it will automatically become a part of the table.
Hello Do you offer custom sheets that I want to create for my business. If so how much?
@EamonnCottrell
15 күн бұрын
shoot me an email - my full name at gmail
Is there a way to insert a table into a google doc
@EamonnCottrell
28 күн бұрын
Yes. you can copy it to a doc and even link them. Just select the table and paste it into docs. It'll pop up an option whether or not you want to link it so the Doc version can stay updated or not. I just recorded a short video on it - it'll be out next week