Google Sheets Intermediate Reference and Cheat Sheet: Functions, Formatting, Sharing, and Shortcuts

In 30 Minutes

ISBN 10: 1641880503 ISBN 13: 9781641880503

Publisher: i30 Media, 2020

Synopsis

This cheat sheet is packed with intermediate-level tips, examples, and shortcuts of Google Sheets, the free online spreadsheet program and Microsoft Excel alternative. The four-panel reference is printed on 8.5 by 11 inch high-quality card stock, perfect for desks, walls, and shelves. It has holes for three-ring binders. Fully recyclable and designed for readability. 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 and COUNTIF functions 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

Note that the Google Sheets Intermediate Reference and Cheat Sheet does not cover Google Drive, Google Docs, Google Slides, or other applications in Google s free online office suite.

The Google Sheets Intermediate Reference and Cheat Sheet was created by the publisher of the top-selling guides Google Drive and Docs In 30 Minutes, LinkedIn In 30 Minutes, Excel Basics In 30 Minutes, and other titles.

Edition details

• Publisher: i30 Media
• Publication date: 2020
• Language: English
• ISBN 10: 1641880503
• ISBN 13: 9781641880503
• Binding: Pamphlet