Excel Intermediate Cheat Sheet for Microsoft 365: Functions, formatting, security, and shortcuts (Windows/macOS)

Sinopsis

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.

"Sinopsis" puede pertenecer a otra edición de este libro.