Google Sheets INTERMEDIATE Cheat Sheet

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.