Sheets and Docs
What can I do in Spreadsheets?
Most of what you use in Excel or Google Sheets:
- Formulas with suggestions as you type. Browse them under Insert → Function
- Charts, including column, line, pie, scatter and combo
- Pivot tables and slicers
- Conditional formatting and colour scales
- Filters, sorting, removing duplicates and splitting text to columns
- Data validation and dropdown lists
- Freezing rows and columns
- Protected ranges and sheets
- Comments and notes on cells
- Find and replace across all sheets
The list of keyboard shortcuts is under Help → Keyboard shortcuts
