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. They are fully recyclable and have holes for three-ring binders. They contain top tips and easy-to-read annotated screenshots. Purchase individual cheat sheets for Excel 2019, Word 2019, Google Drive, Google Docs, Google Sheets, or macOS, or use our online shop to purchase them in bulk. Free shipping on orders over $25!

K-12, academic or corporate purchasing departments: We offer wholesale discounts for bulk orders. Please use our contact form and include amount, delivery destination, and timeline considerations.

NEW: PowerPoint 2019 Reference & Cheat Sheet (ISBN 9781641880282)

  • What the various ribbons in PowerPoint 2019 do
  • Annotated list of PowerPoint 2019 Home ribbon buttons
  • Inserting images, shapes, and videos
  • Adding transitions and animations
  • Creating and saving documents
  • How to change the slide layout
  • Working with MS PowerPoint templates
  • How to export PDFs
  • How print a presentation
  • Keyboard shortcuts for both Windows and Mac users
  • Four panels, 8.5 by 11 inches
  • Three-hole punched for easy storage
  • High-quality card stock, fully recyclable

Purchase options

NEW: LinkedIn Reference & Cheat Sheet (ISBN 9781641880381)

  • Navigating the LinkedIn homepage
  • Features accessed from the LinkedIn toolbar
  • How to start a post or article
  • How to create a LinkedIn account
  • What’s in a profile?
  • How to update your profile
  • How to add/edit profile and header photos
  • How to create a PDF resume
  • LinkedIn’s requirements for a “complete” profile
  • 9 critical elements for a successful profile
  • Networking basics
  • LinkedIn’s 3 types of connections
  • How to find connections
  • How to connect/add someone to your network
  • Who should be in your network?
  • How to connect with anyone on LinkedIn using InMail
  • Tips for nurturing your network
  • How to use LinkedIn Groups
  • 6 ways to protect your privacy on LinkedIn
  • 4 ways to reduce LinkedIn notifications
  • 4 ways to find jobs on LinkedIn
  • 4 tips for using LinkedIn to search for jobs
  • How to apply for jobs on LinkedIn
  • How to create a job listing on LinkedIn
  • Premium LinkedIn accounts and InMail access
  • Four panels, 8.5 by 11 inches
  • Three-hole punched for easy storage
  • High-quality card stock, fully recyclable

Purchase options

NEW: Word 2019 Reference & Cheat Sheet (ISBN 9781641880275)

  • What the various ribbons in Word 2019 do
  • Annotated list of the Word 2019 Home ribbon buttons
  • Adding images, shapes, text boxes, media, and other elements to a .docx document
  • Inserting headers, footers, charts, page numbers, and more
  • Creating and saving documents
  • Formatting text, and working with MS Word Styles and Themes
  • How to export .rtf, .txt, .doc and PDF files
  • How to add a footnote, endnote, index, and table of contents to a Word 2019 document
  • How to adjust Word 2019 margins or orientation for printing
  • Finding and replacing text in Word 2019
  • Word 2019 keyboard shortcuts for both Windows and Mac users
  • Four panels, 8.5 by 11 inches
  • Three-hole punched for easy storage
  • High-quality card stock, fully recyclable

Purchase options

NEW: Excel 2019 Reference & Cheat Sheet (ISBN 9781641880268)

  • New features of Excel 2019
  • An overview of Microsoft’s Ribbon interface.
  • Annotated list of Home tab features and settings with the new Excel 2019 icons.
  • Creating and saving workbooks
  • How to add, edit, and hide data
  • How to import and export .txt, .csv, .tsv, and .xls files.
  • How to use static cell references
  • Setting the Excel print area
  • 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 keyboard shortcuts for Excel 2019
  • Four panels, 8.5 by 11 inches
  • Three-hole punched for easy storage
  • High-quality card stock, fully recyclable

Purchase options

UPDATED: 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
  • Four panels, 8.5 by 11 inches
  • Three-hole punched for easy storage
  • High-quality card stock, fully recyclable

Purchase options

UPDATED: 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
  • Four panels, 8.5 by 11 inches
  • Three-hole punched for easy storage
  • High-quality card stock, fully recyclable

Purchase options

UPDATED: 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
  • Four panels, 8.5 by 11 inches
  • Three-hole punched for easy storage
  • High-quality card stock, fully recyclable

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
  • Four panels, 8.5 by 11 inches
  • Three-hole punched for easy storage
  • High-quality card stock, fully recyclable

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
  • Four panels, 8.5 by 11 inches
  • Three-hole punched for easy storage
  • High-quality card stock, fully recyclable

Purchase options

macOS Reference & Cheat Sheet (ISBN 9781939924766)

  • Applies to all recent versions of the operating system, including OS X 10.11 El Capitan, macOS 10.12 Sierra, and macOS 10.13 High 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
  • Four panels, 8.5 by 11 inches
  • Three-hole punched for easy storage
  • High-quality card stock, fully recyclable

Purchase options