Publisher i30 Media is pleased to announce “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 for Excel 2016, Word 2016, Google Drive, Google Docs, Google Sheets, or macOS, or select a bulk order option. A Google cheat sheet bundle (print/PDF) is also available.

NEW: macOS Reference & Cheat Sheet (ISBN 9781939924766)

  • Applies to all recent versions of the operating system, including OS X 10.11 El Capitan and macOS 10.12 Sierra
  • Annotated list of most frequently accessed macOS features for your MacBook, MacBook Pro, iMac, Mac mini, or other Mac computer
  • macOS Menu Bar and Status Menu icons
  • How to use macOS Finder to browse files, folders, and apps
  • Deleting apps and files in macOS
  • Customizing the Mac display, from setting brightness to selecting a Screen Saver
  • macOS accessibility options
  • Customizing the macOS Dock
  • macOS power controls and Force Quit
  • Mouse and Trackpad options
  • Function keys and the Touch Bar
  • Setting up printers for macOS
  • Using Siri and Dictation
  • Managing macOS accounts and passwords
  • Apple ID
  • iCloud and iCloud keychain
  • Installing apps on macOS and customizing app behavior
  • macOS keyboard shortcuts

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
  • 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
Microsoft Excel 2016 Cheat Sheet

Purchase options

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 Drive cheat sheet and reference

Purchase options

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 docs cheat sheet front cover

Purchase options

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 Sheets reference and cheat sheet

Purchase options

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