Excel Functions

This lecture explains the Excel if function, a logical test that returns a value if true or false. It covers the syntax—condition, value_if_true, value_if_false—and an example labeling numbers with yes or no.

Explore how the index function retrieves a value from a range by row and column location, with an optional final argument, illustrated by copying a list between sheets in Excel.

Explore how the offset function uses a starting address, moves rows and columns, and defines height and width to return a dynamic range, which you can use in sums.