Add a column to any data set in an Excel spreadsheet and fill it with random numbers generated with RAND () b_y dragging the _RAND formula down the column.

If you have an Excel table that's longer than one page, it's often helpful to repeat the header row at the top of every page or the row labels on the left side of every page—a feature that's ...

To tell Excel 2007 to repeat one or more rows or columns, first chose the Page Layout tab in the Ruler, then Print Titles (in Excel 2003, choose File | Page Setup, then Sheet).

If your Excel table is longer than one page, it's often helpful to repeat the header row at the top of every page.

Use this Excel formula to easily return the last item from any list. If you work with chronological lists or daily updates, you might also track the last item in a constantly changing list of ...

This is where the number-crunching fun starts. Learn the ins and outs of the logical formulas that represent the heart of Excel.