Excel's OFFSET function lets you create ... First, in cell H10, I'll type I can copy and paste the same formula into cell H11, but change SUM to AVERAGE, since I'm using the same references.

Excel lets you choose more specifically which elements you want to paste into the selected cell ... and Ctrl+C in the cell containing the formula you want to copy, and then F2 and Ctrl+V where ...

An curved arrow pointing right. The tool "Paste Special" in Excel can do so much more than just pasting values or formats. Here's how you can use it to transform your data in a variety of ...

There is nothing more frustrating than when someone pastes a value on top of a formula in your spreadsheet. This can ruin a beautiful excel model. And it can take awhile to fix because you have to ...