I dissect the differences between tables in Excel and Google Sheets.
Sheets released tables FINALLY in 2024. Now, are they as good as Excel's?
🚀Get Good at Spreadsheets: https://gotsheet.xyz/subscribe
We receive commission on purchases made through some links on this page
_______________________________________________
🎓Software Recommendations:
► Starting a Newsletter? Check out Beehiiv with a free trial and 20% off your first 3 months: https://www.beehiiv.com/?via=eamonn
► ConvertKit - creator marketing & newsletter platform - https://partners.convertkit.com/358pj50hkecy
► HubSpot free CRM software for sales, marketing, customer service, operations teams. https://hubspot.sjv.io/c/4186908/1001264/12893
► Notion - productivity & note-taking app - https://affiliate.notion.so/p7771a8zwlsu
► Carrd - one page landing sites - https://try.carrd.co/s4x1c97b
► Coefficient - import data and sync with your business systems in Google Sheets - https://coefficient.io/?via=984f9f
_______________________________________________
🎓Data Course Suggestions: (coursera)
► Advanced Data Analytics Certificate by Google: https://imp.i384100.net/21dWGa
► Microsoft Power BI Data Analyst Certificate - https://imp.i384100.net/4PgjK3
►Microsoft Business Analyst Certificat - https://imp.i384100.net/anamAq
► Cybersecurity by Google: https://imp.i384100.net/VmN6oM
► Google Cloud Data Analytics Certificate - https://imp.i384100.net/B0ZJb0
_______________________________________________
🎓AI Course Suggestions: (coursera)
► IBM AI Developer Certificate - https://imp.i384100.net/B0ZR9L
► Overview IBM AI Engineer Certificate - https://imp.i384100.net/KjnyA9
► Google AI Essentials - https://www.coursera.org/learn/google-ai-essentials
_______________________________________________
🖥️ Office items I can't live without:
https://amzn.to/3uqSO7Q (amazon)
📲 Find me
on LinkedIn: https://www.linkedin.com/in/eamonncottrell/
on Twitter: https://twitter.com/EamonnCottrell
_______________________________________________
⌚Chapter Time Markers:
00:00:00 - setup
00:01:24 - begin comparison
00:01:55 - why do we want to create a table?
00:02:27 - create a table in excel
00:04:02 - create tables in sheets
00:05:09 - sorting in Excel
00:05:59 - sorting in Sheets
00:06:21 - advanced sorting Excel
00:07:25 - advanced Sheet sorting
00:08:26 - filtering in Excel
00:08:57 - filtering in Sheets
00:09:49 - formulas in Excel
00:11:46 - preventing spilling in Excel
00:12:48 - formulas in Sheets
00:14:08 - extend tables in Excel
00:15:06 - extend tables in Sheets
00:16:26 - inserting and deleting ranges in a table
00:17:33 - total row in Excel
00:18:37 - total row in Sheets
00:19:21 - final thoughts and ranking
00:20:04 - what we used to have to do in Sheets
=============================
#exceltips #googlesheets #spreadsheets #dataanalytics #excel #productivity #gotsheet #howtousespreadsheets #getgoodatspreadsheets