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.