Text Box: Contents • Introducing Spybot • Excel: Using Hyperlinks to Organize Large Workbooks • Word: Creating Jump Points in Documents • Outlook: Creating Email Templates • Excel: Data Validation • Converting EPrint Files to Excel using Adobe Acrobat

Spybot v1.3 is an application that will scan your computer for adware and spyware.  After it has run once, and corrected any problems, you should run Spybot every week or so, more often if you are a heavy Internet  user.  The SpyBot application icon is located in the Windows-Tools section of the Novell Application Launcher.  Click here for more information.
 
Introducing Spybot

 

 

 

 

 

If your workbook consists of a large number of worksheets, you may find it helpful to use hyperlinks to easily access the worksheets.  This is also helpful when sharing workbooks with staff who may not know what each sheet tab refers to. A descriptive link to the worksheet may be helpful.  Click here for details!
 
Excel:  Using Hyperlinks to Organize Large Workbooks

 

 

 

 

Worksheet Using Hyperlinks

Text Box: December Quick Tip If you have a word document that is more than one page long, you can reduce it to fit on a page. Although the type of the page will be small and the page will print in columns, it might be useful for drafts of documents, etc. Select File. Print from the Word menu, then in the Zoom section of the dialog box, indicate how many pages you want to fit on the page – for example, if you have a two page document that you want to print on one page, select 2 in the Zoom box, then click OK.

 

Word:  Creating Jump Points in Documents

You can create “Jump Points” in a Word document by using a combination of Bookmarks and Hyperlinks.  The document below contains a hyperlinks to each section of the document, thus people reading the document can click on the topic that is of interest to them and be taken directly to that section.  Click here for more information!

 
 
 

 

 

 

 

 


Word Document with Jump Points
 

 

 

Outlook:  Creating Templates

In Outlook 2003, you can create an email message, and save it as a template so that you can use it over and over again. This would be useful if you find yourself sending the same email (for example, requests or reminders) to the same people on a regular basis.  Click here for details

 

Excel:  Data Validation

In Excel, data validation gives you the ability to set “rules” pertaining to data entered on a worksheet.  For example, you might want to insure that a column labeled DATE contains only dates or that another column contains only numbers. You could even insure that a column labeled DATE contains only dates during a certain period.  With Data Validation, you can control what is entered on the worksheet.  Click here for details

 

 

Converting EPrint Files to Excel Using Adobe Acrobat

While you can save an EPrint file as a text file and open it in Excel, there may be times (especially with larger files) that you want to open only a portion of the Eprint file in Excel; or paste a portion of the file in an email message.  This can be done using Adobe Acrobat.  Click here for details

 

 

Newsletter Archives at PC Support Newsletters

Address questions or comments about this newsletter to Judy Freed, Systems Development