10 INCREDIBLE things Google Sheets can do Right Now!
About this video
Jeff Su walks through Google Sheets features for formatting, organizing, and cleaning data faster. He starts by selecting data with Cmd/Ctrl+A, right-clicking to Convert to table, then renaming the table, changing its color, and setting column types (number/currency for sales, date instead of date/time, dropdown with true in green and false in red, checkbox) and enabling placeholders for new rows. He also notes using @table templates and reverting to unformatted data. Next he creates grouped views inside tables — grouping by phase or by owner — and saves an owner view that can be shared via URL. For filters, he shows right-click Filter by cell value, filtering by fill color after conditional formatting, and filtering checkboxes where checked is true. For cleanup he splits full names with Data > Split text to columns on space after pasting without formatting, removes duplicates via Data cleanup, validates with ISEMAIL and ISURL copied down with Cmd/Ctrl+D, counts errors with COUNTIF, checks Column stats, and views edit history. He then uses @ to insert file, calendar event, and people chips and extracts filename/URL, meeting title/URL, or email/name via Data extraction, builds an org chart from two columns under Insert > Chart, inserts today’s date with @today or Cmd+;, and uses sheets.new, Cmd/Ctrl+arrow navigation, Cmd/Ctrl+Shift+arrows to select, F4 to lock ranges, and Option+/ to search menus. He combines these in a conditional formatting example using a custom formula =J4 to highlight account managers in red when attendance is false, gets a link to a specific range, protects a range, converts currency with GOOGLEFINANCE (noting a 20-minute delay), and color-codes and divides tabs to bucket related sheets.
Key takeaways
- Convert raw ranges to Tables to set column types, validation, and placeholders in one place instead of formatting cells manually
- Use saved grouped views and filtered views (including filter by cell value and by fill color) to bucket tasks by phase or owner and share the exact view via URL
- Clean data with Split text to columns, Remove duplicates, ISEMAIL/ISURL validation, COUNTIF, and Column stats before trusting a sheet
- Use @ chips for files, events, and people plus Data extraction to pull names, URLs, and emails at scale, and use @today / Cmd+; for dates
- Speed up daily work with sheets.new, Cmd/Ctrl+arrow navigation, F4 to lock ranges, links to a specific cell/range, GOOGLEFINANCE for currency, and color-coded divider tabs
Episode details: published October 1, 2024 · 13:27 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: Learn 80% of Perplexity in under 10 minutes! · Next: 5 Ways I Actually Use ChatGPT at Work! →
All Jeff Su videos · Jeff Su profile · Jeff Su (official site)
