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.
