Excel's OFFSET function lets you create a reference that isquite literallyoffset from a starting point. It allows references to adjust dynamically to changes in your spreadsheet's data and structure.

A new COPILOT function in Excel lets you use AI in a formula. The new skill is now available to Microsoft 365 insiders. Reduces some of the complexity involved in creating formulas. Get more in-depth ...