pc support newsletter

Systems Development

The University of North Carolina at Charlotte

September 2005

 

 

Contents

·         Accessing Banner from the Application Launcher

·         Email: Quarantine Notices

·         Excel: Scaling a Worksheet for Printing

·         Outlook: Making your Calendar visible by default

·         Word:  Fun Fonts and Page Borders

·         Outlook:  Adding a Task Reminder to the Calendar

·         Excel: Introduction to Autofilter

 

Accessing Banner from the Novell Application Launcher

Clicking the “Production INB” icon in the Novell Application Launcher will take you directly to Banner.  Like all other launcher icons, this one can be placed in your “frequently used” application folder.

 

Text Box: September Quick Tip

To quickly view the sum of selected cells in Excel, select the cells and look at the status bar.  The sum will be displayed there. For additional options (Average, Min, Max, etc), right click on the word “Sum” in the taskbar.
 

 


Email:  Quarantine Notices

I have been getting many questions about email Quarantine Notices. While these notices may seem to be annoying, they actually are beneficial.  It works this way:  Any email that is sent to you that the email server detects as spam is stopped at the server and placed in “quarantine”.  Once or twice a day, you receive a notice of all of the email sent to you that has been quarantined.  You have the option of reviewing the list and releasing any email that you want sent to your Inbox.  Here is one way to look at it: If your quarantine list contains 10 items – that’s 10 pieces of spam email that did not make it into your Inbox.  Instead, you receive one email (the quarantine notice) that conveniently lists these emails and allows you to release them if you want.

 

Why doesn’t the server simply delete the email?  Because even though the email server considers the email to be spam, it may not be spam to the intended recipient...  Case in point:  I subscribe to two work-related newsletters that are quarantined.  However, I want to receive these newsletters, so I have the ability to release them, or “white-list” them. 

 

One more note:  Prior to releasing mail from quarantine, note whether or not the email has been sent to multiple recipients.  If you release an email that has multiple recipients, all intended recipients will receive the email.

 

For more information about the Quarantine Notices, click here. Scroll down until you come to the MS Outlook documents.

 

Excel: Scaling a Worksheet for Printing

If your worksheet is a little bit larger than a page, and you don’t want to print it on two pages, you can tell Excel to scale the worksheet to fit on one page. Select File, Page Setup from the Excel menu.  In the Page Setup dialog box, select “Fit to 1 page(s) wide by 1 tall and click OK. When you print the worksheet, it will fit on one page.   NOTE:  This does “shrink” the text on the page, so it works best if your worksheet is only slightly over a page.

 

 

Outlook:  Making your Calendar visible by default

To make your Outlook calendar visible to other staff, right click on the calendar icon in the Outlook Taskbar to display your calendar.  Once your calendar is displayed, right click your calendar icon under “My Calendar” and select Properties.  Go to the Permissions tab and click Default.  Select Reviewer as the Permission Level, then click Apply, then click OK.  Once you do this, your calendar is visible to others.  If you want the details of an appointment hidden from others, make the appointment Private.

 

Word:  Have some fun with fonts and page borders

Word includes a number of “special effects” that you can use to format fonts:  Select Format, Font from the Word menu, and notice the options in the “Effects” box.  You can apply either the Shadow, Outline, Emboss or Engrave effect to your font for additional visual impact.

 

You can also add a page border to any word document.  Select Format, Borders and Shading from the word menu, then select the Page Border tab. You can select any of the line styles and widths, but you can also select one of the “Art” borders.  Click OK.  The border will not display in Normal view, only in Print Layout or Print Preview.  Click here for more information.

 

 

Outlook:  Adding a Task Reminder to the Calendar

We all have tasks that we need to periodically perform – for example:  we need to water the plants on Friday, check leave balances once a month, make sure time sheets are turned in every Monday.  You can easily add these tasks to Outlook.  Click here for more information.

 

Excel:  Using AutoFilter

Since many people use Excel to maintain databases, the Autofilter feature is worth knowing about as it allows you to look at subsets of your data based on your criteria.  Below is an example of a list that has had an autofilter applied. Click here for more information.

 

 

 

Questions or comments….Contact  jtfreed@email.uncc.edu