Synopsis
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).
About the Author
Beezix has been publishing quick reference computer guides for trainers, training companies, corporations, and individuals across the US and Canada for the past 20 years. Founded by trainers, extensive industry experience made us aware of the need for a line of high-quality guides that were clear, accurate and concise. Our cards are designed for casual computer users right through to trainers and help desk staff.
"About this title" may belong to another edition of this title.
