Top 10 Google Sheets Tips for Productive Professionals!
About this video
Jeff Su presents ten Google Sheets tips for working professionals, framed around collaborating without disrupting others and presenting data professionally to stakeholders. He starts with creating your own filtered view so filtering for one product area does not mess up the view for everyone else, sharing the filtered-view URL so recipients land on it directly, and filtering by color after using conditional formatting to turn empty cells red. He then shows getting a link to a specific range so a colleague is taken directly to the cells needing their input, protecting a range via Data > Protected sheets and ranges so other teams cannot edit it by mistake, and using Show edit history on a cell to see every edit made. Other tips cover building an org chart directly in Sheets from report-to and manager columns and copying it linked into Google Slides so it updates after a reorg, changing comment notifications to only yours or none, and formatting with alternating colors, color-coded and grouped tabs, and data validation dropdowns or checkboxes. He closes with copying an entire tab to another spreadsheet with formatting intact via Copy to > Existing spreadsheet, removing duplicates in one click for an RSVP list, and using the GOOGLEFINANCE function to convert prices into another currency such as Hong Kong dollars.
Key takeaways
- Use a personal filtered view and share its URL instead of filtering the shared table and disrupting colleagues
- Send a link to a specific range so contributors are brought directly to the cells where you need their input
- Protect ranges other teams should not edit, and use Show edit history to trace who changed a cell
- Build org charts in Sheets from manager data and paste them linked into Slides so they update automatically
- Use Remove duplicates for lists like RSVPs and GOOGLEFINANCE for quick currency conversions
Episode details: published April 27, 2021 · 10:15 long. Summary written by Self Growth Videos from the episode itself. Business results and any income figures mentioned are Jeff Su’s own claims, shared for education — they are not typical or guaranteed.
← Previous: How to Take Notes Productively (Notion Template Included) · Next: How to Take Notes for Work | Note-taking Tutorial for Professionals →
All Jeff Su videos · Jeff Su profile · Jeff Su (official site)
