Microsoft Office Productivity
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.
Paste Special is one of the most useful editing tools in Excel. It allows you to paste information into cells using specific criteria or commands. Using the “Transpose” command, you can move data from columns to rows, and vice versa, with the click of a few buttons.
Quick Parts helps you to reuse content in documents by creating and using building blocks (i.e. company’s contact information, mission statement, or directions to your office). This video will show you how to create a Quick Part in Word 2010. It will also show you how to use the newly created Quick Part. There is one more quick tip that will help you to utilize the "Quick Parts" command more efficiently, adding it to your Quick Access Toolbar. That process is demonstrated in the second half of this video.