Merging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE). Improving Clarity with Range Names: Name Rules, Creating Names, Using and Selecting Names, Managing Names, Indirectly Referring to a Named Range (INDIRECT). Step-by-step instructions for many formula/function-related features such as using range names, and Excel's troubleshooting features.Įxcel 2016 for Mac Functions & Formulas Quick Reference Topics include:Ĭonditionally Summing/Counting Data (SUMIF, COUNTIF). Geared toward the intermediate to advanced Excel 2016 for Mac user, this example-rich 4-page laminated Excel 2016 for Mac quick reference card/guide provides explanations and context for many powerful Excel 2016 spreadsheet formulas and functions. New Arrival: Excel 365 Functions & FormulasĮxcel for Office 365 Functions.& Formulas Coming Soon: macOS Big Sur and Adobe 2021