Download or read book Google Sheets Intermediate Reference and Cheat Sheet written by i30 Media and published by . This book was released on 2020-09 with total page 4 pages. Available in PDF, EPUB and Kindle. Book excerpt: This cheat sheet contains 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 & 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 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 & Docs In 30 Minutes, LinkedIn In 30 Minutes, Excel Basics In 30 Minutes, and other titles.