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

Product Description 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 numbersExponents and rootsOrder of operations and nested functionsMonthly loan payments exampleCertificate of deposit’s future value exampleTime differencesUsing SUMIF, AVERAGEIF and COUNTIFSorting multiple columnsMerge cells Convert text to columnsFind & ReplaceRemove duplicatesFreeze row/columnFill buttonFill a seriesCreating static cell referencesReferencing other worksheetsFormat buttonCell StylesFormat PainterConditional FormattingLock a worksheetLock a fileSubtotalThe 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. About the Author IN 30 MINUTES are premium how-to guides covering technology, business, health, and other topics. Authors include award-winning journalists and top experts. Publisher i30 Media also offers the Google Drive Reference and Cheat Sheet (ISBN 9781939924438), the Google Docs Reference and Cheat Sheet (ISBN 9781939924445), and the Google Sheets Reference and Cheat Sheet (ISBN 9781939924452).