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 use our online shop to purchase them in bulk. Free shipping on orders over $25!

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
macOS cheat sheet mac computer iMac MBP

Purchase options

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
Microsoft Word 2016 cheat sheet

Purchase options

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