Most people know that you can reference one or more cells, tables and their column headers, or named ranges in Excel formulas.