Excel 2016 for Mac Functions & Formulas Quick Reference Guide (4-page Cheat Sheet focusing on examples and context for intermediate-to-advanced functions and formulas - Laminated Guide)

By Beezix Inc.

Geared toward the intermediate to advanced Excel 2016 user, this example-rich 4-page laminated quick reference card/guide provides explanations and context for many powerful Excel 2016 spreadsheet formulas and functions. Step-by-step instructions for many formula/function-related features such as using range names, and Excel's troubleshooting features. Written with Beezix's trademark focus on clarity, accuracy, and the user's perspective, this guide will be a valuable resource to improve your proficiency in using Microsoft Excel 2016. This guide is suitable as a training handout, or simply an easy to use reference guide. Topics include: Glossary.Conditionally Summing/Counting Data (SUMIF, COUNTIF).Being Precise (Rounding functions). Improving Clarity with Range Names: Name Rules, Creating Names, Using and Selecting Names, Managing Names, Indirectly Referring to a Named Range (INDIRECT).Merging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE).Changing Results: IF, AND, OR.Table Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH).Error Recovery (ISNA, ISERROR).Common Loan Functions (PMT, RATE, NPER, PV, FV).Array Formulas (Single-Cell & Multi-Cell Arrays) Why to use them, Entering, Editing, Expanding, Deleting.Counting Cells (COUNT, COUNTA).Dates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAYS).Using a Formula for Data Validation, Limit to a List.Troubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Showing/Hiding Formulas, Displaying Cell Relationships, Selecting Related Cells, Removing Relationship Arrows.Examples: Summing Selected Data, Being Precise, Merging Text and Numbers, Table Lookups, Table Lookups combined with IF and ISERROR, Multi-Cell Arrays, Single-Cell Arrays, Dates and Times.

• Format: Pamphlet
• Language: English
• ISBN: 1939791642
• ISBN13: 9781939791641
• Release Date: May 2016
• Publisher: Beezix Inc
• Length: 4 Pages
• Weight: 0.02 lbs.
• Dimensions: 8.5" x 11.0"