Microsoft Excel 2019 Functions & Formulas Quick Reference Card - Windows Version (4-page Cheat Sheet focusing on examples and context for ... functions and formulas- Laminated Guide)

Book info: Microsoft Excel 2019 Functions & Formulas Quick Reference Card - Windows Version (4-page Cheat Sheet focusing on examples and context for ... functions and formulas- Laminated Guide) (Paperback, 4 pages) – Beezix Inc, 2019. Language: English.

Geared toward the intermediate to advanced Excel 2019 user, this example-rich 4-page laminated card/guide provides explanations and context for many powerful Excel 2019 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 2019. This guide is suitable as a training handout, or simply an easy to use reference guide. Topics include: Controlling Order of Precedence Conditionally Summing/Counting Data (SUMIF, COUNTIF) Being Precise (Rounding functions) Improving Clarity with Range Names: Creating Names, Limiting Scope, Defining a Constant or Formula for a Name, Managing Names, Indirectly Referring to a Named Range (INDIRECT) (CONCAT, TEXTJOIN, IFS, MAXIFS/MINIFS, SWITCH) New Functions in Excel 2019 (CONCAT, TEXTJOIN, IFS, MAXIFS/MINIFS, SWITCH) Merging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE) Changing Results: IF, AND, OR, NOT Table Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH) Error Recovery (ISNA, ISERROR) Array Formulas (Single Cell & Multi-Cell Arrays) Dates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAYS, EDATE) Using a Formula for Data Validation Troubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Showing/Hiding Formulas, Evaluating Nested Formulas, Selecting Related Cells, Displaying Cell Relationships, Removing Relationship Arrows. Examples: Summing Selected Data; Being Precise; Merging Text & Numers; Table Lookups; Table Lookups with IF and ISERROR; Dates & Times; Single- and Multi-Cell Arrays.This guide is one of multiple titles available for Excel 2019, other Excel titles are: Excel 2019 Introduction (ISBN 9781944684648); Excel 2019 Charts & Sparklines (ISBN 9781944684754); Excel 2019 Tables, PivotTables, Sorting, Filtering & Inquire (ISBN 9781944684716); Excel 2019 Advanced Features & Macros (ISBN 9781944684730).