Excel Formula & Function Field Guide and How to use Excel well

Excel Formula & Function Field Guide

Purpose: the “keep this forever” reference.

• Formula anatomy
• Cell/range references
• Relative / absolute / mixed references
• Core calculations
• IF/IFS/AND/OR
• XLOOKUP, INDEX/MATCH, XMATCH
• FILTER, UNIQUE, SORT/SORTBY
• TEXT functions
• Date/time
• Dynamic arrays
• LET/LAMBDA
• Statistics
• Finance
• Error diagnosis
• Data-quality formulas
• Large function index covering modern, common, specialist and compatibility functions
• Real-world recipes such as:
• “sum columns”
• duplicate detection
• attendance
• sales
• inventory
• lookups
• text cleanup
• financial calculations