Publisher i30 Media is pleased to announce a new product line — “cheat sheets” based on our most popular guides! The handy, 4-page pamphlets are 8.5 by 11 inches and are printed on high-quality card stock, with holes for three-ring binders. They contain top tips and easy-to-read annotated screenshots. Purchase individual cheat sheets below, or select a bulk order option. A Google cheat sheet bundle (print/PDF) is also available.

NEW: MS Word 2016 Reference & Cheat Sheet (ISBN 9781939924650)

  • Covers Word 2016 in Office 2016/Office 365 (Windows and Mac) as well as Word Online (free via Office.com)
  • What the various ribbons in Word 2016 do
  • Annotated list of the Word 2016 Home ribbon buttons
  • Inserting headers, footers, charts, page numbers, and more
  • Creating and saving documents
  • Working with MS Word Styles and Themes
  • How to import and export .rtf, .txt, .doc or other formats
  • How to add a footnote, endnote, index, and table of contents to a Word 2016 document
  • How to adjust margins or orientation for printing
  • Finding and replacing text
  • Keyboard shortcuts for both Windows and Mac users

Excel 2016 Reference & Cheat Sheet (ISBN 9781939924469)

  • Annotated list of Home ribbon features and settings.
  • Microsoft Excel 2016 vs Excel Online
  • Creating and saving workbooks
  • How to import and export .txt, .csv, .tsv, and .xls files.
  • Printing basics
  • Examples of basic formulas, functions, and AutoFill
  • How to perform simple math and calculate averages
  • How to sort and filter data
  • How to create a chart or graph
  • Universal Windows/Mac keyboard shortcuts for Excel 2016

Google Drive Reference & Cheat Sheet (ISBN 9781939924438)

  • 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 * How to permanently delete files
  • How to restore files and folders
  • Google Drive app (Android/iOS): basic features
  • Keyboard shortcuts

Google Docs Reference & Cheat Sheet (ISBN 9781939924445)

  • Annotated screenshots of the Google Docs home page and formatting toolbar
  • Google Docs basics, from document creation to margin adjustments
  • Templates 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
  • Keyboard shortcuts

Google Sheets Reference & Cheat Sheet (ISBN 9781939924452)

  • 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

Google Cheat Sheet Bundle: Drive, Docs & Sheets

Order the Google Drive Reference & Cheat Sheet, the Google Docs Reference & Cheat Sheet, and the Google Sheets Reference & Cheat Sheet using our secure order form, at more than 20% off!

Purchase options

Help our authors spread the word!Share on Facebook0Tweet about this on TwitterShare on LinkedIn0Email this to someone