December, 2004

If there are any topics you would like to see discussed in the future or if you have any comments, please contact me at JoeT@HighCaliber.com


Bullet Points

  • Permanently Deleting Email, Bypassing Deleted Items Folder

    As you know, when you delete items from your Inbox using the Delete key or by right clicking and selecting Delete, the selected email is not permanently deleted - it is simply moved into your Deleted Items folder. To permanently delete email, you must select the Deleted Items folder and again delete the email from there.

    There are times when you might want to skip moving email to Deleted Items and permanently delete it while browsing your Inbox, Sent Items or any other Outlook email folder. To do this:

    1. Select the email you want to permanently delete
    2. Press Shift and Del at the same time

     

  • Displaying CPU Speed

    A CPU (central processing unit) or as it is commonly called, the central processor, is the brains of a computer. The CPU is where most calculations take place. In terms of computing power, the CPU is the most important element of a computer system. Its speed is often quoted in megahertz (MHz).

    You can determine the speed of a PC's CPU in at least two different ways:

    1. Right click My Computer and select Properties. THen click the General tab. The processor speed is listed under Computer.
    2. Click Start, Control Panel and then click the System applet. CPU speed is shown on the General tab, under Computer.

     

  • Indenting Paragraphs in MS Word

    To indent a paragraph while using Microsoft Word follow these steps:

    1. Select the paragraph or paragraphs you want to indent.
    2. Click the button at the left end of the horizontal ruler until it displays the First Line Indent marker.
    3. Click the ruler where you want to set the indent. For example, to indent your paragraph one inch, click 1 on the ruler.

     

  • Anti-Spyware Tips

    Here are some precautions that will help prevent spyware from infesting your PC:

    • Don't download search assistant programs, coupon/rebate offers or Internet optimizers
    • Never click on anything within a pop-up to close it. Instead close it by clicking the X in the upper right-hand corner.
    • Kazaa and other peer-to-peer software is a major source of spyware getting into systems. Avoid using these (mostly music download) sites like the plague.
    • Not all spyware comes over the Internet. Some people have ended up with spyware and adware from software they installed from CDs got for free. Remember that nothing is ever free.

    Contact us if you are interested in protecting your entire network from spyware/adware/scumware infestation.

     

  • Those Crazily Worded Emails

    Many spam filtering services are now using something called Bayesian Screening as part of their anti-spam arsenal. These techniques involve using probability models to determine the likelihood that a particular email is actually spam.

    Spammers have tried to get around Bayesian screening by creating messages using random words, which is why you are seeing those gibberish emails in your inbox these days.

    So the next time you receive an email with something like this in it:

    complication succession stinker matchable Amsterdam factorizations claim Heywood tracer insidious indifferently cheeses busiest Ivanhoe Aleck organizers Bodleian crumple dill Puccini vehicles Africans Cosgrove ridiculing intelligibility whispering winding Corsican blizzard bivouac gnawing superposition promised evenhandedly upturns undoubtedly stumps

    ...you will know why!

     

Top


Finding Functions in MS Excel

While Excel contains a large assortment of functions, everything from calculating the inverse hyperbolic tangent of a number to the interest paid on during a specific period on an investment, but Excel's function naming scheme can make it difficult to find the function you're looking for. Scrolling through a long list of sometimes cryptic function names can be frustrating. Luckily Excel has made it a little easier to find the function you need with its function search feature.

Suppose you need to calculate a mortgage payment, but have no idea how to do the math. Click Insert and then Function to display the Insert Function dialog box. Here you will find the Search for a function text box. Type a brief description of what you are trying to accomplish with the function and click Go

Excel will provide you with what it believes is the appropriate function(s). For example, if you wanted to determine a mortgage payment, you could type "How do I calculate a monthly loan payment?" Click Go and Excel returns two functions: one that calculates the payments for a loan based on constant payments and a constant interest rate and another that returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.

If you want more information on a particular function, select the function from the list and click Help on this function from the bottom of the dialog box.

Once you choose the function you want, Excel also makes it easier to specify the function's arguments. When you select the function and click OK Excel displays the Function Arguments dialog box. This box prompts you to enter all the function's required arguments and offers a description of each argument.

 

Top