For those faithful readers following this column, you know this is the second column devoted to timesaving tips for Microsoft Excel. This month we re taking a look at creating formulas beginning with the basic Autosum feature then moving to practical formulas using functions. The easiest way to add a column or row of numbers in Excel is to use the AutoSum button. Highlight the numbers to be summed AND include an empty row or column of cells that will contain the totals. Click the Autosum button on the Standard Toolbar.
Totals automatically appear in the blank cells.
If you d like to know how many days until Easter use this formula. The trick here is to remember to use the quotes. Finding the Average 1. Click in the cell that will contain the average. Click and Drag over all the cells to be included in the average, then press Enter to see the results.