SUM is the spreadsheet equivalent of an open invite: it welcomes everything into the total, whether it belongs there or not.

If you have a lengthy column of numbers that you need to multiply by a percentage, Excel includes tools to instantly apply the product to the entire range of cells in the column.

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.