Excel 2011 for Mac Functions & Formulas Quick Reference
Mac Excel 2011 Functions & Formulas Quick Reference Topics include:
Conditionally Summing/Counting Data (SUMIF, COUNTIF).
Being Precise (Rounding functions).Ê
Improving Clarity with Range Names: Name Rules, Creating Names, Using and Selecting Names, Managing Names, Indirectly Referring to a Named Range (INDIRECT).
Merging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE).
Changing Results: IF, AND, OR.
Table Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH).
Error Recovery (ISNA, ISERROR).
Array Formulas (Single-Cell & Multi-Cell Arrays) Why to use them, Entering, Editing, Expanding, Deleting.
Dates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAYS).
Using a Formula for Data Validation, Limit to a List.
Troubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Showing/Hiding Formulas, Displaying Cell Relationships, Selecting Related Cells, Removing Relationship Arrows.