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.

Not everyone is familiar with Excel. You can protect the data input process by using Excel's UserForm object to collect data. Susan Harkins explains how.

How to Add a Second Y-Axis on Excel & Make a Second Series at the End of the Chart. Microsoft Excel charts give you a large number of options for displaying the data in your spreadsheet.

You can set Excel to display dates in a variety of ways, no matter how you type in the data. Here's how to find and change date formats in Excel on a Mac or PC.