Save a Document or File as a PDF (Office 2010)
In Office 2010 it is quick and easy to save a file as a PDF.
Save a Document or File as a PDF (Office 2007)
There is an Add-in available from www.Microsoft.com/downloads, that will allow you to save and send files from Word, PowerPoint, Excel and Publisher (Office 2007), as a PDF. This video will show you where to locate the download and how to save a file as a PDF. Please check with your IT department BEFORE downloading any add-ins to your computer.
How to Create and Use ‘Quick Parts’ (Outlook/Word 2007/2010)
After creating quick parts (see online tutorials for instructional video), you can quickly access or preview the “Quick Parts” you have created. This works the same in Word 2007, Word 2010, Outlook 2007, and Outlook 2010.
Excel – Using Formula Auditing to Determine What Cells are Used in Formulas (Excel 2007 & Excel 2010)
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".
Excel – Add Data in Columns/Rows Without a Formula (Excel 2003, Excel 2007, Excel 2010)
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.