Skip to content
Excel Functions
Excel f(x)s = Excel Functions
Excel keeps converting all cells to “Date” (or Time)
Excel User tips
Links between two workbooks – dynamically using functions
INDIRECT
Walking Columns
ActiveX controls
GoLast to jump to last cell in a column
CELL
Count Unique
COUNTIF
VALUE() of LEFT()
Formulas - combined functions
Sum of divide – Array formula
Array formula
CONVERT function
CONVERT
prev
next
Scorring12481632 3