Skip to product information
1 of 6

Google Sheets INTERMEDIATE Cheat Sheet

Google Sheets INTERMEDIATE Cheat Sheet

Regular price $6.99 USD
Regular price Sale price $6.99 USD
Sale Sold out
Shipping calculated at checkout.

1 total reviews

Format

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.

View full details