Excel for Microsoft 365 Functions & Formulas Quick Reference
Geared toward the intermediate to advanced Excel user (Windows version), this example-rich 4-page laminated Excel for Microsoft 365 quick reference card/guide provides explanations and context for many powerful Excel 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 Precedence
Conditionally Summing/Counting Data (SUMIF, COUNTIF)
Being Precise (Rounding functions ROUND, MROUND, ROUNDUP CEILING, CEiLING.PRECISE, EVEN, INT)
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 365 (CONCAT, TEXTJOIN, IFS, MAXIFS/MINIFS, SWITCH, XLOOKUP)
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, XLOOKUP)
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 & Numbers; Table Lookups; Table Lookups with IF and ISERROR; Dates & Times; Single- and Multi-Cell Arrays.
