Skip to main content
Tag

Cheat Sheet

Google Sheets Cheat Sheet

By Product

One of the most useful tools in Google’s free online office suite is Google Sheets. It’s an online spreadsheet program that is easy to learn. It’s also a lot cheaper than Microsoft Excel, and includes some features that Excel doesn’t have. The Google Sheets Cheat Sheet lets you quickly access examples, browse a list of Google Sheets features/icons, or identify Google Sheets shortcuts. It’s described below. You can order a printed copy on the Cheat Sheets Store. It’s also possible to download the PDF edition of the guide.

Google Sheets Cheat Sheet: What’s inside?Google Sheets Cheat Sheet

This handy reference and cheat sheet contains tips, examples, and easy-to-read annotated screenshots 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. Topics include:

  • Overview of Google Sheets on the Web, including annotated screenshots of the main page and formatting toolbar.
  • Sheets basics: Creating, renaming, saving, and copying spreadsheets
  • How to edit while offline
  • How to add, edit, and hide data
  • How to import and export .txt, .csv, .pdf, and .xlsx files
  • Examples of basic formulas, functions, auto-fill
  • How to perform simple math and calculate averages
  • Sorting and filtering data
  • How to create a chart or graph
  • Keyboard shortcuts for Chromebooks, Windows, and OS X

Note that the Google Sheets Cheat Sheet does not cover Google Drive, Google Docs, Google Slides, or other applications in Google’s free online office suite. Publisher i30 Media offers separate cheat sheets, including the Google Drive Cheat Sheet and the Google Docs Cheat Sheet.

The Google Sheets 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.

How to order

To order a printed copy of the Google Sheets Cheat Sheet, visit the Cheat Sheets Store. The PDF can be downloaded using this secure order form.

PDF Printed 20 copies (25% off!)

Google Docs Cheat Sheet: What’s inside?

By Product

Google Docs Cheat Sheet - what's insideAre you a frequent user of Google Docs, the free online word processor? If so, you may wonder how to access commonly used features and shortcuts. The Google Docs Cheat Sheet can put that information at your fingertips! It is described below. The printed version of the Google Docs Cheat Sheet is available for purchase from the Cheat Sheet store or as a downloadable PDF. We also offer a Google Drive Cheat Sheet and Google Sheets Cheat Sheet.

Google Docs Cheat Sheet

The Google Docs Cheat Sheet contains top tips and easy-to-read annotated screenshots of Google Docs, the free online word processor and Microsoft Word alternative. The four-panel Google Docs Cheat Sheet 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. Topics include:

  • Annotated screenshots of the Google Docs home page and formatting toolbar
  • Google Docs basics, from document creation to margin adjustmentsTemplates and page styles
  • Inserting images, comments, headers & footers, and more
  • How to import Microsoft Word, .rtf, or .txt files
  • How to activate Office Compatibility Mode
  • How to convert to Microsoft Word, PDF, and other formats
  • How to edit documents while offline
  • How to use Office Compatibility Mode
  • Keyboard shortcuts

Note that the Google Docs Cheat Sheet does not cover Google Drive, Google Sheets, Google Slides, or other applications in Google’s free online office suite. Publisher i30 Media offers separate cheat sheets and references for Google Drive and other applications (see details about Google Drive Cheat Sheet).

The Google Docs 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.

How to order

To order a printed copy of the Google Docs Cheat Sheet, visit the Cheat Sheets store. The PDF can be downloaded using this secure order form.

PDF Printed

Google Drive Cheat Sheet: What’s inside?

By Product

Readers of Google Drive & Docs In 30 Minutes may be interested to know that we have several related products that can help them get the most out of Google’s free online office suite. They include a Google Drive Cheat Sheet, which is described below. The printed version of the Google Drive Cheat Sheet is available for purchase on the Cheat Sheet store or as a downloadable PDF. We also offer a Google Docs Cheat Sheet and Google Sheets Cheat Sheet.

Google Drive Cheat Sheet

Google Drive Cheat Sheet

The Google Drive Cheat Sheet contains top tips and easy-to-read annotated screenshots of Google Drive on the Web. 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. Topics include:

  • The new Google Drive interface, including icons, file and folder uploads, and shared files. Annotated for easy reference!
  • How to create new documents in Google Docs, spreadsheets in Google Sheets, and presentations in Google Slides
  • How to drag and drop files to Google Drive using a PC or Mac
  • Three options for converting Microsoft Office files (Word .doc and .docx, Excel .xls and .xlsx, and PowerPoint .ppt and .pptx)
  • How to use search in Google Drive to find specific files or file types
  • How to permanently delete files
  • How to restore files and folders
  • Keyboard shortcuts
  • Basic features of the Google Drive mobile app
  • And much more!

Note that aside from conversion, document creation, and keyboard shortcuts, the Google Drive Cheat Sheet does not cover Google Docs, Google Sheets, Google Slides, or other applications in Google’s free online office suite (we offer separate cheat sheets for those topics!)

The Google Drive Cheat Sheet was created by the author of the top-selling book Google Drive & Docs In 30 Minutes.

How to order the Google Drive Cheat Sheet

To order a printed copy of the Google Drive Cheat Sheet, purchase it from the Cheat Sheet store. The PDF can be downloaded using this secure order form.

PDF Printed