Microsoft Office Productivity

There are times you may need to know if a cell is part of a formula.  If you are altering or deleting cells, you can easily cause errors throughout your worksheet.  Using "Formula Auditing" you can easily determine if a cell is part of a formula. The technical terms for this are "Trace Dependants" and "Trace Precedents".

Using “Paste Special” with ‘Add’, will allow you to take two sets of data and add them together without having to create an extra column and a formula.  In this example one company purchased another company with the same product line.  We need to combine the sales figures for the year of the two identical products.
 

Using “Paste Special” with ‘Subtract’, will allow you to subtract a set of data from another set of data, without having to create an extra column and a formula.  In this example we are going to back out the defective returns from the sales figures for each month.
 

Using “Paste Special” with  “Divide” will allow you to take selected data and divide it by a number in just a few quick steps.  In this example we will take sales figure totals for a product and divide it by the price of the product to determine the quantity of items sold. This process is shown in Excel 2010, but will also work in Excel 2007 and Excel 2003.
 

Using “Paste Special” with a ‘Multiplier’ will allow you to take selected data and multiply it by a specific percentage in just a few quick steps.  In this example we will give a 5% raise across the board to a list of employees.