How to Build that Viral Travel Checklist in Google Sheets (With UPGRADES)
Create a travel checklist in Google Sheets like that one that went viral on TikTok. (WITH SOME UPGRADES)
The process is pretty simple, but it will teach you some excellent core principles you can use on any spreadsheet going forward.
🚀Join my free tech newsletter: https://got-sheet.beehiiv.com/
I add some formatting upgrades and quality of life details that will make this sheet a hair better than what you've seen on TikTok while keeping the core product intact.
Demo Sheet (this will make a copy for you to use): https://docs.google.com/spreadsheets/...
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/358pj...
► HubSpot free CRM software for sales, marketing, customer service, operations teams. https://hubspot.sjv.io/c/4186908/1001...
► 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...
_______________________________________________
🖥️ Office items I can't live without:
https://amzn.to/3uqSO7Q (amazon)
📲 Find me
on LinkedIn: / eamonncottrell
on Twitter: / eamonncottrell
_______________________________________________
⌚Chapter Time Markers:
00:00:00 - intro
00:00:16 - sheet setup
00:00:28 - named ranges
00:01:23 - checkboxes
00:02:04 - dropdown list
00:02:35 - advanced options
00:03:46 - percent packed formula
00:07:06 - conditional formatting
00:08:25 - housecleaning pro tips
00:09:44 - Filter and a warning
=============================
#exceltips #googlesheets #spreadsheets #dataanalytics #excel #productivity
