Skip to product information
1 of 5

Excel INTERMEDIATE Cheat Sheet for Microsoft 365

Excel INTERMEDIATE Cheat Sheet for Microsoft 365

Regular price $6.99 USD
Regular price Sale price $6.99 USD
Sale Sold out
Shipping calculated at checkout.
Format

New! Do you need an intermediate desktop reference for Microsoft Excel? This four-panel desktop reference and cheat sheet contains step-by-step instructions and shortcuts for commonly used intermediate-level features of Excel for Microsoft 365. Instructions and examples apply to both the Windows and macOS versions of Excel, and includes a list of keyboard shortcuts. Topics cover:

  • Join text and numbers
  • Exponents and roots
  • Order of operations & nested functions
  • Monthly loan payments example
  • Certificate of deposit’s future value example
  • Time differences
  • Using SUMIF, AVERAGEIF & COUNTIF
  • Sorting multiple columns
  • Merge cells
  • Convert text to columns
  • Find & Replace
  • Remove duplicates
  • Freeze row/column
  • Fill button
  • Fill a series
  • Creating static cell references
  • Referencing other worksheets
  • Format button
  • Cell Styles
  • Format Painter
  • Conditional Formatting
  • Lock a worksheet
  • Lock a file
  • Subtotal

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. Fully recyclable and designed for readability. A PDF edition is also available.

The Excel Intermediate Cheat Sheet for Microsoft 365 was created by the publisher of the award-winning IN 30 MINUTES guides and is based on Excel Basics In 30 Minutes.

The Excel Intermediate Cheat Sheet for Microsoft 365 is an independent publication and is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by Microsoft Corporation.

View full details