Excel 2019 Functions & Formulas Quick Reference
beezix.com
Software / Computer Software

Excel 2019 Functions & Formulas Quick Reference

$5.75
{{option.name}}: {{selected_options[option.position]}}
{{value_obj.value}}
Store Logo

Beezix

View Store

Geared toward the intermediate to advanced Excel 2019 user (Windows version), this example-rich 4-page laminated Excel 2019 quick reference 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. Topics include: Controlling Order of PrecedenceConditionally 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)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, NOTTable Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH)Error Recovery (ISNA, ISERROR)Array Formulas (Single C

Show More Show Less