Quickly Sum or Average without Formulas

If you wanted to do a quick sum or average of your rows or columns of data, you'd think that selection of the cells and writing a quick SUM or AVERAGE function was what needed to be done. However you can get the sum or average without writing any formulas. Just select your data and look at the taskbar. There a bunch of other things it can do besides sum or average like count, min and max.

Quickly Create Subtotals

Creating sub totals in Excel can be done many ways. One favorite is to use Pivot Tables; but if you don't needs all the extra fancy capabilities of the Pivot Table just use the Sub Total command. All you need to do is just sort a main column for the group you want to subtotal and then use the Sub Total command to take care of the rest.

Highlight All Formula Cells

When you've got a worksheet full of functions and formulas (or a combination of them), it sometimes gets hard to figure out what cells you'd need to pay attention to. This could be especially true if you're working with people that need to help fill in values or need to know where the formula are so they don't mistakenly update them. You can highlight cells that have formula in a couple easy steps