Google Sheets INTERMEDIATE Cheat Sheet
Google Sheets INTERMEDIATE Cheat Sheet
Regular price
$6.99 USD
Regular price
Sale price
$6.99 USD
Unit price
/
per
This cheat sheet contains intermediate-level tips, examples, and shortcuts of Google Sheets, the free online spreadsheet program and Microsoft Excel alternative. Topics include:
- Keyboard shortcuts for Chromebooks, Windows, and macOS
- Join text and numbers
- Exponents and roots
- Order of operations & nested functions
- Calculate loan and interest payments
- Time differences Using SUMIF, AVERAGEIF & COUNTIF
- Sorting multiple columns
- Merge cells
- Convert text to columns
- Find & Replace
- Remove duplicates
- Freeze row/column
- Fill a series
- Creating static cell references
- Referencing other sheets
- Formatting and themes
- Protecting sheets and cell ranges
- Sharing and collaboration basics
- Convert Excel to Sheets and vice versa
Publisher i30 Media offers separate cheat sheets and references for Google Drive and Google Docs.