Excel for Microsoft 365 Cheat Sheet

Do you need a quick reference for Excel for Microsoft 365? The four-panel Excel for Microsoft 365 Reference & Cheat Sheet contains tips and examples of basic Excel functions and features for both Excel for Microsoft 365 for Windows and Excel for Microsoft 365 for macOS. Most instructions and examples also apply to Excel 2019 and earlier versions of the software. Topics include:

• New features of Excel for Microsoft 365
• An overview of Microsoft’s Ribbon interface.
• Annotated list of Home ribbon features and settings.
• 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 Microsoft Excel (Windows and macOS).

Note that the Excel for Microsoft 365 Reference and Cheat Sheet does not cover advanced features of Excel, the Excel mobile apps for tablets and phones, or other Microsoft Office/Office 365 applications.

The four-panel reference is available as a PDF download. The printed version (available April 2021) 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.

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

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