Items related to Excel Intermediate Cheat Sheet for Microsoft 365: Functions,...
Excel Intermediate Cheat Sheet for Microsoft 365: Functions, formatting, security, and shortcuts (Windows/macOS)
Synopsis
New for 2021! Do you need an intermediate desktop reference for Microsoft Excel? The 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:
- Joining text and numbers
- Exponents and roots
- Order of operations and nested functions
- Monthly loan payments example
- Certificate of deposit’s future value example
- Time differences
- Using SUMIF, AVERAGEIF and 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.
"synopsis" may belong to another edition of this title.
- Publisheri30 Media
- Publication date2021
- ISBN 10 1641880600
- ISBN 13 9781641880602
- BindingPamphlet
- LanguageEnglish
(No Available Copies)
Search Books: Create a WantCan't find the book you're looking for? We'll keep searching for you. If one of our booksellers adds it to AbeBooks, we'll let you know!
Create a Want