(Updated version available for Excel 365 Intermediate) Do you need an intermediate desktop reference for Microsoft Excel 2019? The four-panel desktop reference and cheat sheet (printed and PDF versions available) contains step-by-step instructions and shortcuts for commonly used intermediate-level features of Excel 2019. Instructions and examples apply to both the Windows and macOS versions of Excel 2019, 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
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.
The Excel 2019 INTERMEDIATE 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 2019 INTERMEDIATE 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.
Select the printed cheat sheet (8.5 x 11 inches printed on high-quality card stock, three-hole punched) or the color PDF which can be downloaded to the device of your choice to be read on the screen or printed out on paper.