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

Quickly Remove Blank Rows

When you get a table of data sometimes it's got some blanks cells. For those records in the row where there's any cell that is blank, you may not need that record...so you want to get rid of them. To delete some record rows manually is not hard if you have just a few rows, but if you've got a lot, there's any easier and faster way to do this.

Clear All Formatting - Excel

Sometime you get all sorts of formatting on your spreadsheet like bold, underline, some funky magenta cell fill and just need to start over. You don't want to go into each cell and find and "find" the multiple types of formatting that might be there. Let's just do it one and done.

Separate / Extract Data Flash Fill

Flash Fill was introduced in Excel 2016 and give you an easy way to split or extract text or values from one column cell to another. A common use is to split out a column with full name (i.e. first name last name like John Smith) to separate first and last name columns. Before you might have used LEFT, MID or RIGHT functions, but now with Flash Fill, there's no need to use those functions.

Millionaire Calculator NPER- Excel

f you're got a mutual fund or some kind of investment vehicle that lets you put in an initial investment and give you the chance to put in additional investments, how long will it take to get to a million bucks? Use the NPER function to find out.