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: gotsheet.xyz/subscribe
=============================
🖥️ 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 - 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