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

Please take the opportunity to connect and share this video with your friends and family if you find it useful.