Skip to content
Excel Functions
Excel f(x)s = Excel Functions
Links between two workbooks – dynamically using functions
INDIRECT
OFFSET+MATCH
Formulas - combined functions
Week number to Month number
DATE
Workdays – Across months
DATE
CHOOSE – tree of decisions
CHOOSE
State Abbr with Index+Match+Validation
Data Validation
Always get 1st name (or last)
Formulas - combined functions
FORMULATEXT to show formulas
FORMULATEXT
prev
next
Scorring12481632 2