Working with ranges in Excel is a fast and simple way to identify, define, or refer to a single cell, a range (or group) of cells, a specific or constant value, or a formula. Then you can use ...

Figure F After converting a data set to a Table, update the dependent references. When you create a Table object, Excel names it — use that name or give it a more meaningful name yourself.

How to Change the Character Set in Excel 2007. When doing business internationally, it's often necessary to use international symbols to display financial information. Microsoft's Excel 2007 ...

In Microsoft Excel, changing the evaluated range on the fly requires a bit of work, but it's definitely possible thanks to the Offset() function.