Matthew Ferrara Tech Hotline

MATTHEW FERRARA TECH HOTLINE TECH TIPS – 2007-2009
(in reverse chronological order)

Tech Tips for 04/10/09:

AUTORECOVER YOUR DOCUMENTS IN WORD
As you are working on your document, Word automatically saves a temporary copy of it in the event that you run into computer problems. This is referred to as Auto Recover.
When Word saves an Auto Recover file, it is saved in the same directory as the original document. You can have Word save your Auto Recover files to a specific location. This requires you to modify the Auto Recover location as outlined below.
Within Word, click Options from the Tools menu.
1. Click the File Locations tab.
2. From the list of file types, click the Auto Recover files option.
3. Click on the Modify button.
4. Browse to the folder in which you want the Auto Recover files stored.
5. Click OK.
6. Click on Close.

WORK IN GROUPS WITH WIGGIO
Wiggio is a FREE online toolkit that makes it easy to work in groups. You can keep a shared calendar, send mass emails, text messages and voice notes, store and edit files, create polls and host group conference calls. Another great feature about wiggio is that each member is not required to register. All they have to do is click on the link in the welcome email and they are “in”!
www.wiggio.com

JOB SEARCHING?
Sure, there are plenty of job boards and services out there, but Link Up is connected to company websites, not the usual job search portals. When a company adds or removes a posting, Link Up is automatically updated! You will not find any work from home jobs or potential “scams”. Give it a try!
http://www.linkup.com/

COOL TOOL:
http://trackclass.com/

VIRUS LINK:
http://www.symantec.com/business/security_response/writeup.jsp?docid=2009-041009-2647-99

Tech Tips for 04/03/09:

DISTRIBUTE ROWS AND COLUMNS IN WORD 2007
You can easily add a table to your Word document using the Insert | Table option on the Table menu. After you create a table, you might notice that you columns or rows are not evenly distributed. If you have some free time on your hands, you can try to manually distribute them evenly. Alternatively, with only a few clicks, you can have all the rows and columns in your table distributed evenly.
To distribute rows and columns in Word 2007:
• Click inside the appropriate table.
• Under Table Tools, on the Layout tab, in the Cell Size group, click Distribute Rows or Distribute Columns

AUDIT FORMULAS IN EXCEL
Formulas can often be difficult in Excel If you are not a math whiz, you may not recall the standard order of precedence that Excel uses. For example, within a formula, multiplication is performed before any addition or subtraction and calculations within parenthesis are performed before any others. If you do not understand how Excel is performing a calculation, you can use the Evaluate Formula option to make it clearer.
To use the Evaluate Formula option in Excel 2003
1. Within Excel, select the cell you want to evaluate.
2. From the Tools menu, point to Formula Auditing and click Evaluate Formula.
3. Click the Evaluate button to watch as Excel evaluates each step of the formula.
4. To view the evaluation again, click Restart.
VISIT THE KNOL PROJECT!
The Knol project is a site that hosts many knols – units of knowledge – written about various subjects. The authors of the knols can take credit for their writing, provide credentials, and elicit reviews and comments. Users can provide feedback, comments, and related information. Therefore, the Knol project is a platform for sharing information, with multiple cues that help you evaluate the quality and veracity of information.

http://knol.google.com/k/

COOL TOOL:
http://www.wirelessinput.com/?gclid=CKiZ5_vV1ZkCFYVM5QodcHY3YA

VIRUS LINK:
http://www.symantec.com/business/security_response/writeup.jsp?docid=2009-040311-3827-99

Tech Tips for 03/20/09:

MORE HANDY SHORTCUTS!
To select all items on a webpage CTRL + A
Open a new explorer window CTRL + N
Open Favorites CTRL + I
Refresh CTRL + R

BLOCKING SENDERS IN OUTLOOK EXPRESS
If you keep getting email from someone that you don’t know and you want to block them from sending mail to you using outlook express, follow the steps below..
Select the message header
Go to the Message menu at the top of Outlook Express and select Block Sender.
This will send all of those junk e-mails’s straight to your Deleted Items folder upon arrival. To modify your list of Blocked Senders, go to the Tools menu in OE, go down to Message Rules and select Blocked Senders List. From here you can tweak all of the rules that are associated with your Blocked Senders List.
SYSTEM TRAY FEATURES
The system tray is the area where your clock sits at the bottom right hand side of the screen. You can DISABLE system tray icons by right clicking and then hitting EXIT. You can also set the system tray properties by right clicking, select properties and then in the notification area, check “SHOW THE CLOCK” or “HIDE INACTIVE ICONS”.

COOL TOOL:
http://www.geeks.com/details.asp?invtid=STASHCARD&cat=GDT

VIRUS LINK:
http://www.symantec.com/business/security_response/writeup.jsp?docid=2009-031905-5048-99

Tech Tips for 03/06/09:

PASTE OPTIONS TOOL
When you copy and paste text within a document, Word displays a ‘paste options’ tool once you complete the paste operation. The tool resembles a tiny clipboard with a piece of paper. By clicking the drop down arrow beside the Paste Options tool, Word displays several options for applying variations to the pasted text.
If you do not use the Paste Options tool and find it to be more of a distraction, you can disable it using the steps described below.
To disable Paste Options in Word 2002:
• From the Tools menu, click Options.
• Click the Edit tab.
• Clear the Show Paste Options check box.
• Click OK.

OUTLOOK DISTRIBUTION LISTS
A distribution list (DL) is a grouping of contacts. It gives you a quick and easy way to send a message to a group of people. If you use Outlook as your e-mail client, you can create your own distribution lists. You may want to create a list that contains e-mail addresses of family members, friends, or co-workers. To create a distribution list in Outlook:
1. Open Outlook and click Contacts.
2. From the File menu, point to New, and click distribution list. Now you’ve opened an empty distribution list.
3. Click the Select Members button.
4. Double click the particular address you want to add to the list.
5. Repeat step 4 for each additional e-mail address you want to add to the list.
6. Click OK.
7. Type in a name for the distribution list.
8. Click Save and Close.
9. The new distribution list will now appear in your list of contacts

ADD A BULLET TO THE MIDDLE OF A SENTENCE IN WORD
Have you ever tried to add a bullet to the middle of a sentence? Sounds easy enough but clicking the bullet button on the Formatting toolbar is not the way to go.
Instead, you need to insert a special character as described outlined below.
• Place the cursor mid-sentence where you want the bullet located.
• From the Insert menu, click Symbol. The Symbol dialog box will appear.
• Select the character you want to insert as a bullet.
• Click Insert and then click Close.

COOL TOOL:
http://www.sharetabs.com/

VIRUS LINK:
http://www.symantec.com/business/security_response/writeup.jsp?docid=2009-030418-0338-99

Tech Tips for 02/20/09:

PRINT COMMENTS IN EXCEL WORKSHEETS
Normally when you print a spreadsheet, any comments that exist are not printed. However, there may be cases where you want to be able to see your comments in the printed version of your spreadsheet. If so, you can configure Excel to print your comments.
To accomplish this in Excel 2002:
1. On the Reviewing toolbar, click the “Show All Comments” button.
2. From the File menu, click Page Setup.
3. Click the Sheet tab.
4. Click the drop down arrow beside Comments and select one of the following options: At end of sheet or as displayed on sheet.
5. Click OK.
6. From the File menu, click Print.

CREATE A NOTE IN OUTLOOK QUICKLY
The fastest way to create a Note, regardless of where you are in Outlook, is by pressing CTRL+SHIFT+N.

IDENTITIES IN OUTLOOK EXPRESS
You can create multiple identities in Outlook Express without creating additional windows accounts. This can be helpful if you have family members that share the computer. Each person can have his or her own identity in Outlook Express. To create additional identities, just open Outlook Express and click on FILE then IDENTITIES and add NEW IDENTITY. Type in the name and then you will have an option to set a password.

COOL TOOL:
http://www.stardock.com/products/objectdock/

VIRUS LINK:
http://www.symantec.com/business/security_response/writeup.jsp?docid=2009-022010-4100-99

 

Tech Tips for 02/06/09

GOOGLE WEATHER CHECK

To find a quick local weather forecast in the US with Google, simply type weather followed by a city and state or a zip code. For example, to find the weather in Eldorado, Texas, search for weather eldorado tx

FREE ONLINE PICTURE GALLERY WITH 2PAD

Email is the tool of choice to share photos or videos with one’s friends and family. 2pad is a handy program that filters through your email, both sent and received, finds the photos and videos, labels them according to the subject in the email and then houses them in an online gallery for you to share with others or keep privately! Check it out!

http://www.2pad.com/index.php

CELL PHONE SHORTCUTS

Here are some helpful shortcuts by carrier:

To skip over messages…

AT&T: press #
Sprint: press 1
T-Mobile: press #
Verizon: press *

Delete a message while listening…

AT&T: 77 (Delete)’; 33 and then 9 (Save); 3 (Fast Forward); 1 (Rewind)
Sprint: 7 (Delete); 9 (Save); 3 (Fast Forward); 1 (Rewind)
T-Mobile: 7 (Delete); 9 (Save); 3 (Fast Forward); 1 (Rewind)
Verizon: 7 (Delete); 9 (Save); 3 (Fast Forward); 1 (Rewind)

COOL TOOL:

http://www.wepapers.com/

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2009-020600-4945-99

Tech Tips for 01/24/09:

WHERE IS YOUR PRODUCT KEY?

Sometimes it is necessary for you to find the product key for a piece of software that is installed on your computer.  Where do you look for that key?  Different products have different locations and it can be very time consuming trying to figure it all out!  You can download a free utility called Magical Jelly Bean Keyfinder!

http://magicaljellybean.com/keyfinder/

 

PASSWORD PROTECT YOUR BLACKBERRY

Under General Settings or OPTIONS set Password to Enabled. You may also want to change other settings here, such as the number of password attempts allowed before the device is locked, and whether the device should automatically lock on holstering. Choose a password you will remember and that will be quick and easy to type using the device’s keypad. Confirm that password, and then exit to the main menu. Lock your phone to confirm that it has been password-protected.

WINDOWS VISTA QUICK SEARCH
If you need to find a file quickly, the Windows Vista indexed file system makes it easy.

Click START

Type as much information as you know about the file in the text box. As you type, the files that meet your criteria will appear.

COOL TOOL:

https://www.shoeboxed.com/index.htm;jsessionid=B0CC15D491116314ED8685C595407AB7


VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2009-012216-4245-99

Tech Tips for 01/09/09:

 

GET YOUR DOCUMENTS HERE

Docstoc is the premier online community to find and share professional documents. Docstoc provides the platform for users and businesses to upload and share their documents with all the world, and serves as a vast repository of documents in variety of categories including legal, business, financial, technology, educational, and creative. All documents on docstoc can be easily searched, previewed and downloaded for free.

http://www.docstoc.com/

 

DON’T SAVE THOSE DRAFTS

When you compose an email message in Outlook, the message is automatically saved after 3 minutes. This means that if you decide not to send the message, Outlook will inform you that it has automatically saved a copy of it in the Drafts folder. You will be prompted as the whether or not you want to keep a copy of the message.

If you rarely save messages to the Drafts folder, you can turn this feature off completely using the steps that are described below.

  • Open Outlook
  • From the Tools menu, click Options
  • On the Preferences tab, under E-mail, click E-mail Options
  • Clear the check box beside the Automatically save unsent messages option.
  • Click OK.
  • Click OK to close the Options windows and save your changes.

CHANGE THE DEFAULT VIEW IN POWERPOINT

By default, when you open Power Point opens in Normal view with the Outline and Slides tabs displayed on the left hand side. If you prefer a different view, you can manually change the view each time you open the application. Alternatively, you can configure PowerPoint to always open in the view of your preference.

To change the default view in PowerPoint 2007:

Open PowerPoint.

Click the Microsoft Office button and click PowerPoint Options.

Click Advanced.

Under Display, in the Open all documents using view list, choose the view that you want as the default.

Click OK to save your changes.

COOL TOOL:

http://www.goplanit.com/


VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2009-010807-5046-99

Tech Tips for 12/26/08:

SHRINK TO FIT ON ONE PAGE

Microsoft WORD has a useful tool that you might not have noticed before called the SHRINK TO FIT ON ONE PAGE tool.  If you have a document that has a last page with one sentence or one word on it, click on Print Preview and then under the preview section, select SHRINK TO FIT ON ONE PAGE. 

VISUAL SEARCHING

Searchme.com is a search engine for those who like to SEE their results! Type in a search phrase and you can actually SEE the individual page results and sift through them, selecting the page or pages you want!  Check it out, it’s fun!

http://www.searchme.com/

SMS TEXTING FROM OUTLOOK

You can send quick SMS messages right from OUTLOOK as long as you know the cell phone number and cell service carrier! Type in their cell phone number followed by the “@” and their service provider.  Here is a quick list of carriers…

Alltel

@message.alltel.com

AT&T

@mms.att.net

Nextel

@messaging.nextel.com

Sprint

@messaging.sprintpcs.com

SunCom

@tms.suncom.com

T-mobile

@tmomail.net

VoiceStream

@voicestream.net

Verizon

@vtext.com (text only)
@vzwpix.com (pictures and videos)


COOL TOOL:

http://www.newsoftwares.net/


VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-122602-5549-99

Tech Tips for 12/19/08:

KEYBOARD SHORTCUTS FOR OUTLOOK CALENDAR

Here is a handy tip for you to use while working in OUTLOOK.  While your calendar is open, click on a day.  Now, hit ALT + 2 to display two days.  ALT +3 for three….all the way up to 9 days! This shortcut helps when you need to quickly see the days ahead on your calendar.

ARE ANIMATED ADS SLOWING YOU DOWN?

Bouncing, popping, singing and dancing advertisements are all over the internet.  You can set your Internet Explorer to NOT play animations in websites if you choose.  Follow the steps below…

  • 1. Select TOOLS
  • 2. Select INTERNET OPTIONS
  • 3. Select ADVANCED
  • 4. About half way down the page, you will see MULTIMEDIA
  • 5. Uncheck the box that says “Play animations in webpages”

HOP STOP TO THE RESCUE

HopStop is your city transit guide. They provide door-to-door subway and bus directions for many major cities.  With Hop Stop, you can

  • Send directions by e-mail or text message to a cell phone directly from the website
  • Plan a trip with multiple destinations using the itinerary feature
  • Find places to eat drink or sleep using the city guide.

http://www.hopstop.com/

COOL TOOL:

http://www.optomausa.com/Product_detail.asp?product_id=399


VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-121816-5855-99

Tech Tips for 12/05/08:

JUMBO TEXT ON WEBSITES

If while surfing the Internet, you find that the text you are reading on a website is too small for comfortable reading, then enlarge the text. It is easy. The two most common ways to do it are:

  • If you have a mouse with a scroll wheel, just hold down the control key and then scroll the wheel up or down to adjust text size.

Go to “View” at the top of your web browser and select “Text size”. Adjust it to your preferred size.

 

UNIVERSAL SPELL CHECKER

Spell check is a necessary feature of whichever program you use for writing text, yet it has never been available everywhere … until now. Enso Words gives you spell-check power for all of your favorite programs, from Microsoft Word and Mozilla Firefox to Macromedia Fireworks. It is so simple and elegant, that it feels like magic.

www.humanized.com/enso/words

 

CREATE DROP DOWN LISTS IN MS EXCEL

 

Sometimes you want someone to select only from a list that you offer in your worksheet. This is very easy to do in MS Excel 2007.

Follow the steps below to learn how:

  • 1. Select row or column cells you will not be using.
  • 2. Place one list item in each cell.
  • 3. Where you would like the drop-down list to appear, highlight the cells — they need not be contiguous.
  • 4. Click on Data | Validation.
  • 5. Under Allow, select List.
  • 6. Check In-cell dropdown.
  • 7. Left-Click the Source box and highlight the cells containing your list.
  • 8. Click OK.

COOL TOOL:

http://contestmachine.com/site


VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-120407-4742-99

Tech Tips for 11/21/08:

ALT KEY IN OFFICE 2007

In Office 2007, you no longer have to hold down the ALT key to use shortcuts to access menus and their corresponding commands/sub-menus. Now you just have to hold ALT down long enough for the letters to pop up next to the menu headings. This enables a far more accurate and faster method of reaching the commands that you need!

TOP SECRET NOTES

If you have something super secret to say and want to make sure that it’s private, check out privnote!

Just write your note, and you’ll get a link. Then you copy and paste that link into an email (or instant message) that you send to the person who you want to read the note. When that person clicks the link for the first time, it will see the note in her browser and the note will automatically self-destruct, which means no one (even that very same person) can read the note again. The link won’t work anymore.

https://privnote.com/

CUSTOMIZE VIEW IN OUTLOOK

Outlook lets you display its contents using different views. For example, you can display your address book in one of the following view: Business Card, Address Cards, Detailed Address Cards, or Phone List. You can further customize each of these views to include the fields you find most useful.

Each view consists of predefined fields that are displayed when you switch to that view. If you require additional fields or want to change the order of them, you can do so using the procedure listed below. The following steps outline how to customize the Phone List view.

  • Within Outlook, click Contacts.
  • From the View menu, point to Current View and click Phone List.
  • Click the View menu again, point to Current View, and click Customize Current View.
  • From the list of Available fields, select the field you just created and click Add.
  • You can use the Move Up and Move Down buttons to change the order of the fields.
  • Click OK

COOL TOOL:

https://jabbify.com/


VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-112012-2714-99


Tech Tips for 11/07/08:

OUTLOOK CONTACT HISTORY

Here is a great tip for those of you who use Outlook as your email client. You can quickly, and effortlessly, find a full history of mail sent to and received from any outlook contacts.

To get a full mail history with an Outlook contact:

  • Open Outlook.
  • Click Contacts.
  • Locate the appropriate contact from your contacts list.
  • Double click the contact.
  • Select the Activities tab

The resulting window will display a history of all your communications with that particular contact.

 

KEYBOARD SHORTCUTS FOR EXCEL

If you want to quickly move from one worksheet to another using the keyboard, you can do so by using Ctrl+PgUp and Ctrl+PgDown. You use Ctrl+PgUp to move toward the first worksheet in the workbook, and Ctrl+PgDown to move toward the last. When you reach the first or last worksheet, Excel does not wrap to the opposite end of the workbook if you continue to press the same shortcut key.

 

MAKE YOUR OWN ICONS

You can make your own desktop icons in XP. Here’s how:

  • 1. Click Start | All Programs | Accessories
  • 2. Select Paint
  • 3. Click the Image menu and select Attributes
  • 4. In the Width and Height fields, enter 32 for each value
  • 5. Under “Units,” select Pixels
  • 6. In Paint, add color, text, drawings or whatever you like. You can shrink a photo to 32×32 pixels to use as an icon, too.
  • 7. When you’re finished, click File | Save As and give it a name with the extension .ico to identify it to Windows as an icon. You can change the icon for a folder or shortcut to use your custom icon.

COOL TOOL:

http://www.cyberhomes.com/


VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-110713-2603-99

 

Tech Tips for 10/24/08:

WHATS IT WORTH?

Ztail is a handy site that will help you determine what your stuff is worth! Sift through your treasures and head over to Ztail and check it out!

http://www.ztail.com/

 

MIND MAP ONLINE

If you have a lot on your mind, convert it to a map!  Text 2 Mind Map is a web application that converts texts to mind maps. It takes a structured list of words or sentences, interprets it,
and draws a mind map out of them.  You can control colors, fonts and you can even save your mind map!

http://www.text2mindmap.com/

 

OPEN A SHARED EXCHANGE CALENDAR

You can quickly view another person’s shared default Exchange Calendar from the Navigation Pane in your Outlook.  To do so, follow the steps below…

  • In Calendar, click Open a Shared Calendar.
  • Type a name in the Name box, or click Name to select a name from the Address Book.
  • Click OK.
  • The shared Calendar appears next to any calendar that is already in the view.

After you access a shared Calendar for the first time, the Calendar is added to the Navigation Pane. The next time you want to view the shared Calendar, you can click it in the Navigation Pane.

If the other person’s calendar you want to open has not granted you permission to view it, Outlook prompts you to ask the person for the permission you need. If you click Yes, a sharing request e-mail message opens automatically. The message requests the person to share his or her Calendar with you and also provides the option to share your default Calendar with him or her.

COOL TOOL:

http://support.microsoft.com/gp/cp_dst?ION_CL=10_22

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-102416-5319-99

Tech Tips for 10/10/08:

CHANGE PAGE NUMBERS IN WORD

You can change the formatting of your page numbers from the Header and Footer toolbar.

  • From the View menu, click Header and Footer.
  • Click the Switch between Header and Footer option on the toolbar.
  • Select a page number.
  • On the Formatting toolbar, select a new font using the drop down arrow beside the Font box. Increase or decrease the font size using the drop down arrow beside the Font Size box.

WINE ENTHUSIAST?

If you enjoy fine wine, you might want to visit Vinivino- the wine social network!  Vinivino is a wine enthusiast’s community designed to maximize your future wine choices. Easily review the wines you taste, read ratings for new products and exchange information with other members!

http://vinivino.com/index.php

 

TURN OFF INDEXING IN WINDOWS XP

The indexing feature is designed to speed up search functionality, but it can also slow overall performance while it’s indexing files. If you don’t use XP’s search (for instance, if you have a third party desktop search program that you like better), you can disable the indexing feature to enhance performance. Here’s how:

  • 1. Click Start | Control Panel
  • 2. Click Add/Remove Programs
  • 3. Click Add/Remove Windows Components
  • 4. Scroll down to “Indexing” and uncheck the checkbox
  • 5. Click OK

COOL TOOL:

http://www.amazon.com/gp/product/B000FI73MA

 

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-100917-1214-99

Tech Tips for 09/12/08:

BACK AND FORTH WITH YOUR BROWSER

Want to quickly navigate back and forward in your Internet Explorer or Firefox browsing session, but can’t be bothered with actually moving the mouse pointer to and clicking on those Back and Forward arrows at the top of the window? As long as your mouse has a scroll wheel: Just hold the Shift key down and rotate the wheel forward to go forward in your browsing history and backward to go back.

CAPS LOCK ON ACCIDENTALLY?

If you accidentally hit all caps in word, you can easily fix it by following the steps below…

  • Highlight the ALL CAPS text
  • Hit SHIFT + F3

PHOTO ALBUMS IN POWERPOINT 2007

Power point 2007 has an in built feature that lets you create albums within seconds.

  • 1. Click on Insert tab.
  • 2. Click on Photo Album Icon and choose New
  • 3. There you get button, File/Disk which allows you to select images from your hard disk
  • 4. Add them and then you can arrange the sequence by using up and down keys.
  • 5. After this just click on create and your album is ready. You can add notes to suit your needs.
  • 6. You can also add affects, fit your images and others.

COOL TOOL:

http://www.xobni.com/

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-091216-3614-99

Tech Tips for 09/05/08:

INSPECT YOUR EXCEL SPREADSHEET

Your Excel 2007 documents contain a lot more information than just rows and columns of data. They may include tracked changes, comments, private properties, and more. To examine (and clean out) the hidden data in an Excel 2007 document, click the Office button at top left, point to Prepare, and click Inspect Document.

 

IMPORT/EXPORT FAVORITES IN INTERNET EXPLORER

IE has a very easy way of managing your favorite places.  You can use the IMPORT/EXPORT feature.  If you want to transfer your favorites to another computer or just print them out for reference, follow the steps below…

  • 1. Select FILE
  • 2. Choose IMPORT EXPORT
  • 3. Select NEXT
  • 4. Select the action you wish to take, EXPORT FAVORITES, click next
  • 5. Select WHICH favorites to export
  • 6. EXPORT to a file and name that file
  • 7. Open the file and select PRINT or copy the file and IMPORT it to another computer

TURN OFF SCROLL BARS IN WORD

If you rarely use a mouse when you are working within Word, you can turn off the scroll bars so they are no longer visible. To turn off the scroll bars in Word 2002:

  • Within Word, click Options from the Tools menu.
  • Click the View tab.
  • Remove the check beside the Horizontal scroll bar option.
  • Remove the check beside the Vertical scroll bar option.

Click OK.

You can turn the scroll bars back on at any time by repeating the steps described above.

COOL TOOL:

http://www.google.com/chrome/index.html?hl=en&brand=CHMG&utm_source=en-hpp&utm_medium=hpp&utm_campaign=en

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-090514-3708-99

 

Tech Tips for 08/22/08:

 

SMART TAGS IN EXCEL

The Smart Tag lets you enter a series of dates automatically. You can enter an ascending series according to days, months and years.

Select Cell A1, and press Ctrl+;

Click the Fill handle at the bottom right edge of Cell A1, and drag it to several cells in the column.
Do not cancel the selection of the range of dates. Excel creates a series according to days.

Click the arrow in the Smart Tag. Select Fill Months

 

FILL IN THE BLANK WITH GOOGLE

Sometimes the best way to ask a question is to get Google to ‘fill in the blank’ by adding an asterisk (*) at the part of the sentence or question that you want finished into the Google search box. For example, if you type ” * is the capitol of New York”, you will find links saying “Albany is the capitol of New York”. Try it out!

CREATE YOUR VERY OWN CONTACT FORM

Contactify is a fast and easy way to allow people to contact you online. The best part is, you never reveal your email address! Contactify provides you with a link that gives you your own private contact form. (totally free!). Post it on your website, message boards, blogs, or anywhere you like!

http://www.contactify.com/

COOL TOOL:

http://www.pcmag.com/article2/0,2817,2305052,00.asp

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-082216-5241-99

 

Tech Tips for 08/08/08:

 

CHANGE YOUR WORK WEEK CALENDAR IN OUTLOOK

 

The Outlook calendar is set up to display Monday, Tuesday, Wednesday, Thursday, and Friday when you click the Work Week button. However, what if you only work three days a week and you only want those three days displayed in your Work Week?

Adjust your work week using the steps that are listed below.

Open your Outlook calendar.

From the Tools menu, click Options.

Click the Calendar Options button on the General tab.

Select the check boxes beside the days of the week in your workweek.

Use the drop down arrow beside the First day of week box to select the day that you want.

Click OK.

Click OK to close the Options window.

SELL YOUR USED CELL PHONE

 

If you have recently upgraded your cell phone, why not put your old phone up for sale! At cellforcash.com you can select your cell phone model and request a shipping box. In 5 business days, you will receive a postage paid shipping box to send your used phone! They also offer free recycling on older models. Check it out…

http://www.cellforcash.com/index.asp

SORT BY COLUMN IN EXCEL

 

The default setting for sorting in Excel Ascending or Descending order is by row.
To sort by columns, follow the steps below…

From the Data menu, select Sort, and then Options

Select the Sort left to right option button and click OK.

In the Sort by option of the Sort dialog box, select the row number by which the columns will be sorted and click OK.

COOL TOOL:

http://fontstruct.fontshop.com/

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-080816-2234-99

Tech Tips for 08/01/08:

CHANGE THE IMAGE OF A TOOLBAR IN WORD

 

There are many different ways that you can customize the toolbars in Word to meet your own needs and preferences. You can even go so far as to customize the image of a button on a toolbar. For example, if you add a custom macro to a toolbar, you can customize the button for the macro so a graphic appears instead of the macro name.

 

To customize the image of a toolbar button:

Right click a visible toolbar in Word.

Click Customize. Verify that the Toolbars tab is active.

Right-click on the toolbar button you want to modify.

Click Change Button Image from the context menu.

Click on the graphic image you want to use. The image appears on the toolbar button.

Click on Close.

TELL YOUR FRIENDS ALL ABOUT IT!

By adding our unique Tell a Friend button on your website, your visitors can automatically e-mail their friends about your website whenever they find something they would like to share.  It is FREE.

http://www.freetellafriend.com/

 

JUST CLIP IT!

 

 Instead of linking to entire web pages, Clipmarks lets you clip exactly what you want others to see. Their browser add-on lets you save and share what you’re reading on the web with greater precision than is possible with links.

http://clipmarks.com/

COOL TOOL:

http://www.qfxsoftware.com/

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-080110-0349-99

 

Tech Tips for 07/18/08:

 

SORT OUTLOOK CONTACTS BY CATEGORY

Many users are surprised when they discover they can’t search by category. It is possible to sort by category but you need to use the By Category view.  
It works this way because the category field can contain multiple categories (and few would want to sort by the first category only), while each group is made up only of items in one category.
 
PREVIEW FONTS IN THE TOOLBAR WITH POWER POINT

If you’d like to see previews of the actual fonts in the font selection of the formatting toolbar, go to Tools/Customize, click on the Options tab, and click “List font names in their font”, click Close.

PLANNING A TRIP?

Let Yapta help you find the best flights, track prices, and alert you when prices drop so you can secure the best deals on airfare.

http://www.yapta.com/

COOL TOOL:

http://www.windowsmarketplace.com/details.aspx?view=info&itemid=15611

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-071602-5705-99

 

Tech Tips for 07/03/08:

 

SIGN YOUR DOCUMENTS

Word 2007 adds a new document-security feature: digital signing. You can add a signature field to any document, which will lock the file for editing unless the digital signature is deleted. While anyone can delete the signature and edit the file, the signed document is your stamp of approval.  Anyone can break the seal, but then recipients will know you did not have the final say.

NEW FOLDER SHORTCUT IN VISTA

There is quick and easy way to create new folders in Windows Explorer using a series of keystrokes. Instead of going through the motions of clicking the File menu, pointing to New, etc. Simply press F+W+F while holding down the ALT key and a new folder is created!

BOXBE TO THE RESCUE

Boxbe is a service that lets you easily create an email guest list so that you can make sure you receive email messages from people who matter to you. Boxbe’s guest list works just like your IM buddy list or your social network friends page. It contains only those you have added or invited. Boxbe is free and integrates directly with Yahoo! Mail and Outlook or can be used as a public forwarding address.

http://www.boxbe.com/

COOL TOOL:

http://www.ventones.com/make-free-ringtone.aspx

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-070310-5229-99

 

Tech Tips for 6/20/08:

FIT IT ALL IN AN EXCEL CELL

Have you ever wondered how you would ever fit the data you need to record in a single tiny cell? Simply type all the required data, click Enter (or Return), and click the cell again. Then go to Format > Cells > Alignment, choose Wrap Text, and click OK.

CASCADING WINDOWS IN WINDOWS XP

Do you want to see several program windows at the same time?

Right-click the menu bar next to Start,

Select Tile Windows Horizontally or Tile Windows Vertically.

To undo the action, select Cascade Windows.

FREE CLASSIFIED SITE

Try Kijiji for another FREE classified website! 

 http://www.kijiji.com/

COOL TOOL:

http://www.pogobrowser.com/demo.html

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-062016-3239-99

Tech Tips for 6/13/08:

COMBINE MULTIPLE LISTS IN WORD 2007

If you have two or more lists in Word, you can easily combine them into a single list. You do not even have to do any additional formatting because the second list is automatically formatted to match the first one.

To combine multiple lists in Word 2007:

  1. Highlight the list you want to combine with another one.
  2. Press CTRL+X or CTRL+C.
  3. Click the line directly below the list you want to add it to.
  4. Press CTRL+V.
  5. Click the Microsoft Office Button and click Word Options.
  6. Click Advanced.
  7. Under Cut, Copy, and Paste, click Settings.
  8. Select the Merge pasted lists with surrounding lists check box.

FLAG A MESSAGE FOR FOLLOW UP IN OUTLOOK

To flag a message in your Inbox, right click the appropriate message and click Follow-up. The Flag for Follow-up window will appear. Use the drop down arrow beside the Flag to value to select the action required for the message. You can also set a due date, which is helpful, if you need to follow-up by a certain date. Once you have set the appropriate follow-up options, click OK. The message will appear with a red flag beside it.

To remove the message flag, right click the message and select the Clear Flag option.

FREE GOOGLE 411 SERVICE

If your cell provider charges you for 411 calls, why not try Google’s new service. It is FREE! You can ask Google to TEXT the info to your phone, CONNECT you to the number or even MAP it for you!

http://www.google.com/goog411/index.html

COOL TOOL:

http://www.adready.com/

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-061312-5454-99

Tech Tips for 5/30/08:

A QUICK WAY TO SORT EMAIL

  1. A quick way to store e-mail you need to keep is to drag-and-drop an Outlook e-mail message onto the desktop or any folder.
  2. It’s best to sort your e-mail into at least a few different folders, to have some form of organization. If you make them subfolders of your Inbox, you can search through all your messages all at once.
  3. If you’re worried about forgetting to read messages that are automatically filed in folders, remember that Outlook 2003 folders that contain unread mail have a little bolded number after them in brackets such as (3) to indicate the number of messages in the folder that you haven’t read. It’s pretty easy to track so you will probably find this is sufficient an indicator that you won’t forget to check the folders.
  4. Can you have replies sent to a subfolder? Yes. You can write a rule to have messages sent to various folders upon receipt or on sending the message–whichever option suits you. Click on the Tools tab and select Rules and Alerts.
  5. How Rules are applied to incoming e-mail in Outlook 2000 and 2007: If more than one rule applies to an incoming e-mail, the ruled placed in first place takes precedence, or both rules are applied.

RENAME YOUR PICTURES AUTOMATICALLY WITH WINDOWS XP

Unless you really have a lot of time on your hands, I doubt you want to go through the massive folder that contains your European vacation photos and rename them Europe_1.jpg, Europe_2.jpg, and so on down the line. If you’re running Windows XP on your computer, you don’t have to do this. Simply apply this hack to quickly apply a meaningful label to every picture in the folder.

  • First, open the folder and select View > Thumbnails.
  • Click the last picture in the folder you want to rename, hold down the Shift key, and click the first picture; this will select them all.
  • Right-click the first photo, and select Rename from the drop-down menu.

Windows XP will highlight the filename for the first photo, enabling you to give it a descriptive name. After you type in the name, click the white space outside of the photo and watch as Windows applies the name with a sequential number to each picture in the folder.

E-HOW TO DO JUST ABOUT ANYTHING!

What would you like to do? The eHowTM database of over 100,000 articles can help you. It’s the world’s most popular place to find clear instructions on how to do just about everything

http://www.ehow.com/

COOL TOOL:

http://www.pcworld.com/downloads/file/fid,71271/description.html?tk=nl_lg

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-053011-5048-99

 

 

Tech Tips for 5/16/08:

 

EXCEL SHORTCUTS

Ctrl]1 – Open the Format Cells dialog box

[Ctrl][Shift]# – Apply the Date format

[Shift][F11] – Insert a new worksheet

[Ctrl]’ – Copy a formula to the current cell from the cell above it

[F11] – Create a new chart from selected data

[Ctrl] and ] – Select formulas that directly reference the active cell

WHATS A CHUMBY?

A Chumby is a compact device that connects via a wireless Internet connection and gives people a fun, hassle-free way to enjoy what they want most out of the Internet, always on and simply at a glance. And, if you have an account on Flickr, Picasa or Photobucket you can use the chumby as a digital photo frame to show off your favorite photos (or your friend’s photos). You can view public or private photos, or search for specific photos using tags. It is also easy to share your photos with chumby friends – surprise them by sending pictures straight to their chumbys of your latest get-together!

http://store.chumby.com/

FIND EMAIL WITH LARGE ATTACHMENTS IN OUTLOOK

If you are tired of getting messages that your mailbox is over its size limit, try the steps below…

TOOLS

ADVANCED FIND/MORE CHOICES

In the SIZE drop down menu, select greater than and choose a large file size

Click FIND NOW

Once OUTLOOK returns your results, you can save the attachments to a personal file, or delete them, freeing up space in your Inbox!

COOL TOOL:

http://www.thelapstrap.com/

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-051607-3413-99

 

Tech Tips for 5/9/08:

 

PASTE TEXT INTO EXCEL

Do you want to paste text from Word or Internet Explorer into Excel without having it interfere with the formatting in the cell?  Hit F2 so you are in editing mode before you paste.  Then, only the text will come through, not the formulas.

REMOVE YOUR DEAD SITE LINK FROM GOOGLE

Old sites often stay cached in Google’s search engine.  If you own a site that you want removed, you can request its removal using Google’s webmaster tools.

www.google.com/webmasters/tools/removals

IS TIME FLYING RIGHT BY?

If you have been spending a lot of time on a project and want a quick and easy way to track it, let 88 miles figure it out for you!  This web-based service allows you to set up projects and simply PUNCH IN and PUNCH OUT.  You do not have to look at the clock; 88 miles will do it for you!  You can share your time study with other staff members, or keep it for your eyes only.  88 miles even offers a mobile edition!

http://www.88miles.net/

COOL TOOL:

http://www.videx.com/AC%20Site/AC%20Products.html

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-050916-1055-99

 

Tech Tips for 04/25/08:

 

INSERT A LINKED OBJECT FROM EXCEL TO WORD

To insert a linked object or embedded object from Excel into Word 2007:

Open your Word document.

Open your Excel spreadsheet.

Within Excel, select the cells, worksheet, or chart that you want to copy into Word.

From the Edit menu, click Copy.

Switch back to your Word document.

Place the insertion point where you want the data placed.

On the Home tab, in the Clipboard group, click the arrow under Paste, and then click Paste Special.

In the As list, select Microsoft Office Excel object.

Click Paste to insert an embedded object, or click Paste link to insert a link to the object.

WORLDWIDE COLLABORATIVE PAINTING PROJECT

Web canvas is a really fun “infinite” canvas to paint, draw or upload images to!  Anyone with a web browser can visit, use painting tools and add to the ongoing collaboration!

http://www.webcanvas.com/

DISABLE DELETE CONFIRMATION IN XP

Each time you delete an item in XP, you are prompted to confirm your actions. The confirmation prompt ensures that you do not accidentally delete a file. However, in some cases, you may not want to receive the prompt; for example, if you are cleaning up your folders and deleting a large number of files.

If you do not want to receive the confirmation, you can turn this feature off.

To turn off the confirmation prompt when deleting items:

Right click the Recycle Bin and click Properties.

Verify that the Global tab is selected.

Clear the Display delete confirmation dialog option.

Click OK

COOL TOOL:

http://www.pcworld.com/downloads/file/fid,68156-page,1-c,systemresourcestuneup/description.html

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-042510-5944-99

 

Tech Tips for 04/18/08:

 

GOOGLE WILDCARD SEARCH

Searching is easy when you know-even generally-what you are looking for.  However, when the word you are seeking is right on the tip of your tongue, but will not make itself known, what can you do? Use wildcards!

Substitute an asterisk for exactly one word in a Google search. Here is an example, in the search box type:

Pike’s Peak is * feet high

Google will attempt to fill in the blank for you!  Try it out!

CUSTOMIZE YOUR START MENU IN WINDOWS

There are TWO groups of programs on your START MENU.  There are those ABOVE the line and those BELOW.  The programs BELOW the line are recently used programs.  You can remove the recently used programs simply by right clicking on the START button, selecting PROPERTIES, choosing START MENU, CUSTOMIZE, then select CLEAR LIST.  You can also set how many programs that you wish to appear in this menu.  Click APPLY and then OK.  For those programs ABOVE the line, you need to RIGHT CLICK on the program in the menu then select UNPIN FROM START MENU or REMOVE FROM LIST. 

 

SAVE ALL OF THOSE CLIPBOARD ITEMS!

Have you ever copied something while surfing the web and wished you could access it at another time? Control C can help.  Control C is a service that remembers everything you copy, encrypts it and saves it to your account.  All you have to do is log in to your account and provide your password to retrieve the contents of your clipboard!  You can even share your clipboard contents with the community…or not!

http://www.controlc.com/

COOL TOOL:

http://www.moneual.com/htpc/imagine_features.php

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-041721-3035-99

 

Tech Tips for 04/11/08:

 

ADOBE EXPRESS FOR FREE

Adobe Photoshop Express is a brand new web service geared for consumers who want to get their photos online, do some quick polishing-and maybe even some special effects-and finally, share their photos with other people. Photoshop Express is all online and, even better, it is all free.

https://www.photoshop.com/express/index.html?bypass&wf=testdrive

PRINT A LIST OF MEETING ATTENDEES IN  OUTLOOK 2007

Here is a handy tip for those of you who frequently schedule meetings using Outlook 2007. It is sometimes handy to have a hard copy of the names of attendees invited to a meeting, along with the name of the meeting organizer. Although it requires a few steps, you can print this information in Outlook 2007.

Your first step is to copy the names of attendees and the organizer:

Within Outlook, click the Calendar.

Open the appropriate meeting request.

On the Meeting tab, click Scheduling Assistant.

Select the names in the All Attendees list.

On the Format Text tab, click COPY, the names of the meeting organizer and attendees are copied.

Your next step is to paste the names into Word and format them for printing:

Open a new Word document.

On the Home tab, click Paste. The names of the meeting organizer and attendees are separated by either semicolons or commas.

Select all the names.

On the Insert tab, in the Tables group, click Table.

Click Convert Text to Table.

In the Convert Text to Table, dialog box, under Table size, set the number of columns to 1.

In the Convert Text to Table, dialog box, under Separate text at, select Commas if the names are separated by commas. If the names are separated by semicolons, select OTHER, and then type a semicolon (;) in the adjacent box.

Click OK.  

INTERESTED IN FREE ACCOUNTING SOFTWARE?

GnuCash is a free accounting program for home and small business use.  This powerful and flexible program allows you to track multiple accounts, stocks, accounts payable, accounts receivable and so much more!  It even features a reporting package complete with graphical interfaces. 

http://www.gnucash.org/

COOL TOOL:

http://www.microsoft.com/windowsxp/downloads/updates/moviemaker2.mspx

 

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-041108-2226-99

 

Tech Tips for 03/28/08:

CREATE YOUR OWN BLOG

Create your own space on the web with blogger.com.   You can publish your thoughts, upload photos and connect with others.  You can even send photos and posts to your blog from your mobile phone if you choose.  You can set up your very own blog in minutes. 

 

https://www.blogger.com/start

SEND CONTACTS IN OUTLOOK

If you have contacts stored in Outlook that you would like to send to other people, it could not be easier. Just go to your Contacts folder, right-click on the contact you want to send, and then click Forward. A brand-new e-mail message will be created with that contact included as an attachment. Just enter the e-mail address of the people you want to forward it to and click Send.

When the recipients receive the contact, all they have to do is to drag the attachment onto either the Contacts icon in the Outlook Shortcuts bar or onto the Contacts folder in the folder list; it will be added automatically to their contacts list.

CHANGING YOUR  NAME IN EXCEL

When you first install Excel, it asks you for your name so it can personalize the registration for your program. It also writes your name into the user area. This information is used in various places by Excel, such as in the workbook properties area. If you need to change your name, follow these steps:

Choose Options from the Tools menu. You will see the Options dialog box.

Make sure the General tab is selected.

Change the information in the User Name box, as desired.

Click on OK.

COOL TOOL:

http://www.emailaya.com/

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-032817-3715-99

 

 

Tech Tips for 03/21/08:

FILE CONVERSIONS ONLINE

If you’ve ever wanted to convert files without downloading software, then zamzar is the site for you!
Quickly convert documents, images, music and even video!  The service is free for limited use, but you can subscribe to one of their extended plans if you plan to do A LOT of converting!

http://www.zamzar.com/

DOUBLE UNDERLINE TEXT IN WORD

Select the text that you want to underline.

From the Format menu, click Font.

Under All text, click the drop down arrow beneath Underline style.

Select the type of line you want to underline text with.

Click OK.

PRINT A PHOTO PROOF SHEET

A proof sheet is a printout of picture thumbnails. Most photo organizing software allows you to print these out, but for XP users, it’s built into the Window’s Picture and Fax Viewer. Here’s how to do it…

Open the folder that your pictures are in and select “Thumbnail View”.

Hold down the Ctrl key and select the pictures you want on the proof sheet or Ctrl+A to select all.

Right click one of the pictures and select “Preview”. This will bring up the picture in the Window’s Picture Viewer.

Press Ctrl+P to bring up the Photo Printing Wizard. Click Next, Select All or check off the pictures you want then Next again.

Choose your printer then Next.

Select the “Contact Sheet” layout. You’ll see a Print Preview of your contact sheet.

You should end up with a neat printout of all selected photos

 

COOL TOOL:

http://www.piclens.com/site/ie/

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-032021-2836-99

 

Tech Tips for 03/14/08:

 

HOW TO TURN OFF CD’S AUTOPLAY FEATURE

How can you stop Windows XP from launching program CDs?

  • Click Start; click Run, type GPEDIT.MSC to open Group Policy in the Microsoft Management Console.
  • Double-click Computer Configuration, double-click Administrative templates, double-click System, and then click Turn off auto play.
  • The instructions on your screen describe how to configure this setting. Click Properties to display the setting dialog.
  • Click Enabled, and choose CD-ROM drives, then click OK, to stop CD auto play.

This setting does not prevent Auto play for music CDs.

BEWARE OF FRAUDULENT LINKS IN EMAIL

If you are in doubt, do not click links in email!   If you get an email from your bank or PayPal that asks you to verify account information by clicking on a link, beware.  Put your cursor OVER the link and look at the web address that is displayed.  If the address DOES NOT include the domain of the company, it may be fraudulent.  Open a new browser and type in the correct URL to the company and log in to your account that way.  

INSERT A FILE IN WORD

If you have two word documents that you would like to merge, you don’t have to copy and paste, you can simply insert a file…

Open your Word document.

Place the cursor in the open document where you want to insert the second one.

From the Insert menu, click Insert File. If you are using Word 2002, click File from the Insert menu.

Locate the file that you want to insert into your document and click the Insert button

 

COOL TOOL:

http://www.redzee.com/

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-031315-1140-99

 

Tech Tips for 02/29/08:

 

IMPORT RULES IN OUTLOOK

Open Outlook 2007.

From the Tools menu, click Rules and Alerts.

If you have more than one e-mail account, in the Apply changes to this folder list, select the Inbox that you want.

Click Options.

Click Import Rules.

In the File name box, type the path and file name for the set of rules that you want to import. You will have exported them to a file with an .rwz extension.

If you want to import a file that contains rules other than those in the Rules and Alerts Wizard, such as rules that are compatible with previous versions of Microsoft Office Outlook, click the file type in the Files of type list.

Click Open.

WHERE’S GEORGE?

If you have ever wondered where the money in your pocket has been…www.wheresgeorge.com is a necessary site for you to visit!  All you have to do is register, enter the serial number of the bill and if it has already been entered, you can see where it has been!  If not, you can be the first!  The site even shows you reports and maps of the bills travels!  Now THAT is keeping an eye on your money!

http://www.wheresgeorge.com/

FREE 3D INTERIOR DESIGN SOFTWARE

Sweet Home 3D is a FREE interior design product.  The software comes with 75 pieces of furniture, but you can download additional items from their website!  If you always wondered what that room would look like if you moved around the furniture, try it in Sweet Home 3D first!

http://sweethome3d.sourceforge.net/index.html

 

COOL TOOL:

http://www.superantispyware.com/

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-022916-3210-99

 

Tech Tips for 02/22/08:

LISTINGS RIGHT TO YOUR PHONE

Now you can search MLS properties listed by all Realtors in an easy to use map interface!  Property Maps delivers all of the current listings right to your Blackberry or Windows Mobile Smart phone.  Take a closer look…

http://www.propertymaps.com/

USE A HIDDEN TOOLBAR IN POWERPOINT CHARTS

When editing a chart in PowerPoint, you may have trouble selecting the exact portion of the chart you want to change. Instead of clicking around, simply double-click on the chart to activate it, close the datasheet if necessary, and then use the Chart Objects dropdown list that now appears on your main toolbar. Select the chart element you want to work with from the dropdown list instead of trying to accurately click on it.

REFORMAT IN A SNAP

Let’s say you have just finished a document and you decide you don’t like the formatting. Don’t worry, you don’t have to go back and reformat each and every paragraph. 

Follow the steps below:

Click on CTRL + A to select the entire document, or select the portion of the document to be changed.

Then click CTRL + SHIFT + N.

Note:  If you accidentally click CTRL + SPACEBAR + N like I did when I was trying this tip, you get a brand NEW word document and for a minute, you might think you lost your original!

 

COOL TOOL:

http://www.9xmedia.com/products/displays/index.php

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-020815-2308-99

 

Tech Tips for 02/15/08:

FEDEX QUICK SHIP TOOLBAR FOR OUTLOOK

Fedex now has a toolbar that integrates with Microsoft Office to help make your life easier!  Choose the customer’s name from your Outlook address book, and create the shipment.  You can also check rates and track packages without ever leaving your Outlook application. 

http://fedex.com/quickship/welcome.html

CHANGE THE DEFAULT EMAIL IN VISTA

Windows Mail is the default e-mail program used by Vista and other programs. If you use a different e-mail client, such as Microsoft Outlook, you can configure a different e-mail program as the default.

To change the default e-mail program in Vista:

Click Start, Default Programs, and click Set program access and computer defaults.

Type in your administrator password if prompted.

Click Custom under Choose a configuration.

Under Choose a default e-mail program, select the program you want to set as the default.

Click OK.

WINDOWS SHORTCUTS

Ctrl + F5 in Internet Explorer will refresh the web page bypassing cache (all images and external file references will be reloaded).

Windows Key + E will open up a new explorer window

Windows Key + Pause/Break will display the Systems Properties dialog box.

 

COOL TOOL:

http://me.dium.com/

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-020815-2308-99

 

Tech Tips for 02/08/08:

 

RECENTLY USED FILES LIST IN WORD

When working in Microsoft Word, you can see the last four documents that you have opened by selecting FILE.  The last four documents appear at the bottom of the menu.  You can change this feature to include MORE documents OR you can disable the option all together.  Follow the steps below:

Click TOOLS

OPTIONS

GENERAL

Under recently used files, arrow up or down the number of files that you want to appear.

If you want to disable the feature, uncheck the box

NOT SURE WHO OWNS THE NUMBER THAT IS ON YOUR CALLER ID?

With so many people using cell phones, it is hard to tell who is who these days.  You can visit the website below to see if the number is indeed a mobile number and the location of where the account was originated.  For a fee, you can get more information such as the callers name and address.

http://www.reversemobile.com/

CREATE A TASK FROM AN EMAIL IN OUTLOOK

Drag the message that you want to convert to a task to the Tasks button in the navigation pane.  If the message has an attachment, you have to drag that separately. The TASK window will then open, allowing you to select the options that you want.

 

COOL TOOL:

http://www.headsetzone.com/67891-02.html

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-020815-2308-99

 

Tech Tips for 01/25/08:

USING LABELS IN OUTLOOK CALENDAR

Did you know that you can color code certain types of appointments by adding a label to them in Outlook?  When adding an appointment, select from the dropdown box marked LABEL.  The predefined labels automatically add color to your appointment.  You can also change the predefined labels by clicking on the COLOR CODING icon on your calendar toolbar.  Select EDIT LABELS and then type in whatever text you would like to correspond to that color. 

PUT AN END TO UNWANTED CATALOGS IN THE MAIL

Visit catalog choice and make sure you have a pile of unwanted catalogs by your side.  Simply sign up as a member, then search for the catalogs, enter in your information, and let catalog choice remove you from the mailing list!

http://www.catalogchoice.org/

LISTEN TO YOUR WEATHER REPORT FROM YOUR PC

If you like to hear your weather reports, download the talking software, weather aloud.  You can download a free trial version. 

http://www.wugnet.com/affiliates/default.asp?pageid=230/

 

COOL TOOL:

http://www.contentinfinity.com/

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-012511-3356-99

 

Tech Tips for 01/11/08:

USE A HIDDEN TOOLBAR TO SELECT A CHART IN POWERPOINT

When editing a chart in PowerPoint, you may have trouble selecting the exact portion of the chart you want to change.  Instead of clicking around, simply double-click on the chart to activate it, close the datasheet if necessary, and then use the Chart Objects dropdown list that now appears on your main toolbar. Select the chart element you want to work with from the dropdown list instead of trying to accurately click on it.

START THE YEAR OFF WITH A NEW CALENDAR!

Visit the Microsoft website to download some great new 2008 Calendar templates! 

http://office.microsoft.com/en-us/templates/CT101425391033.aspx

 

CHANGE THE DEFAULT FONT IN OUTLOOK

You can change the default font in Outlook 2003 using the steps listed below:

Within Outlook, click Options from the Tools menu.

Select the Mail Format tab.

Click the Fonts button.

Click the Choose Fonts button under “When composing a new message.”

Choose the font settings you want to use.

Click OK to save your settings.

Click OK to close each open dialog box.

Outlook will now use the font you specified when creating a new email message.

COOL TOOL:

http://store.chumby.com/

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2008-011112-3720-99

 

Tech Tips for 12/28/07:

 

LIVE VIDEO STREAMING FROM YOUR PHONE

Qik is a little piece of software that enables you to stream videos directly from your phone to the Web. Use it to stream engaging videos to your friends or clients in Facebook, Twitter, etc. or as your camcorder to capture entertaining and
special moments.

http://www.qik.com/

SORT A FILTERED LIST IN EXCEL

To sort a filtered list, select Data, Sort, then choose the appropriate column from the Sort By control box. Specify the Ascending or Descending option, and click OK.

 

RESIZE YOUR ICON LABELS IN XP

1. Right-click a blank space on the desktop and choose Properties.

2. Click the Appearance tab.

3. Click the Advanced button.

4. Select Icon Spacing (Horizontal) in the Items list.

5. Increase the spacing

6. CLICK OK

7. Right-click the desktop.

8. Choose Arrange Icons By and pick an order (this will cause them to relocate based on the new spacing).

 

COOL TOOL:

http://www.vistaprint.com/vp/holiday07/holiday_calendars.aspx?xnav=TsrItem&xnid=aCalendarsHomeFamily&dng=1061561

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2007-121316-0214-99

 

Tech Tips for 12/14/07

 

FAVORITE LINKS IN YOUR START MENU

Internet Explorer allows you to keep a list of your favorite Web sites. This makes it faster for you to access these sites. All you have to do is click the Favorites button and click the URL you want to go to from the list that appears in the right pane.

Web sites that you access several times throughout the day can link directly to the Start Menu. Opening the Web site is as simple as clicking on the Start button and selecting the link. You no longer need to open Internet Explorer first. To add a favorite to the Start Menu, open Internet Explorer, and click the Favorites button. Select one of the links and while holing down the mouse button, drag the link onto your Start button.

SAVE THAT COLOR INK!

If you want to print a webpage, but don’t want to waste your color ink, follow the steps below:

Under the FILE menu, select PRINT

Click on PREFERENCES

Click COLOR

Put a Checkbox in the Print In Grayscale area

Click OK

 

GOOGLE ALERTS

Google Alerts can be useful if you are looking for current specific information.  You can create a Google alert and receive an email update when something relevant is indexed.  You can even set parameters as to how often you would like your alerts.  You can set up a Google alert by visiting….

http://www.google.com/alerts

COOL TOOL:

http://www.ureach.com/spinvox/

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2007-121316-0214-99

Tech Tips for 11/30/07:

ADD ANOTHER FILE TO YOUR MICROSOFT WORD DOCUMENT

  1. Within your document, click where you want to insert the second document.
  2. From the Insert menu, click Insert File.
  3. In the File name box, locate the file you want locate and then double click it.

TOOLBAR SHAPE IN OUTLOOK 2007The toolbars can move around Outlook, dock or float. You can also change the shape of a floating toolbar and change the size of a docked toolbar. Move any toolbar by selecting the move handle (four dots on the far left side of a toolbar) and moving the toolbar to its new location. For docked toolbars, click on the title bar and drag it to a new spot.

To change the shape of a floating toolbar, move the cursor over one of its edges at the top/bottom for taller, shorter, or left/right for longer or narrower until a two-directional arrow appears.

 

SAVE TIME IN AN EMERGENCY WITH ICEICE is an acronym for “In Case Of An Emergency” and paramedics and emergency personnel are now looking for an ICE contact on your cell phone.  All you have to do is put the word ICE before a contact in your address book on your cell phone for the person that you would like contacted in case of an emergency.  In the unfortunate event that you are unable to dial an emergency contact, an emergency worker will be able to call the right person for you from your phone.

COOL TOOL:

http://www.coolhunting.com/archives/2007/11/earthdesk.php

VIRUS LINK: http://www.symantec.com/business/security_response/writeup.jsp?docid=2007-110915-3903-99

Tech Tips for 11/16/07:

REMOVE STORED PASSWORDS IN VISTA

Vista lets you store user names and passwords so you do not have to enter them each time you use your computer, however, if other people have access to your computer, you might want to remove some of the stored info.  You can do it by…

 

Click Start and type Run in the Search field. Press Enter.

Type in rundll32.exe keymgr.dll, KRShowKeyMgr and click OK.

The Stored User Names and Passwords dialog box will appear.

You can remove an entry by selecting it from the list and clicking the Remove button.

Click Close.

SAVE MEETING REQUESTS IN OUTLOOK

Once you accept a meeting request in OUTLOOK, the request is deleted.  The only way to SEE the contents of the request is to go to your calendar and click on the actual appointment.  You can set up your OUTLOOK so it does not delete this info. 

Open Outlook

From the Tools menu, click Options

On the Preferences tab, click E-mail Options.

Click the Advanced E-mail Options button.

Clear the check box beside the Delete meeting request from Inbox when responding option.

Click OK.

Click OK to close the E-mail Options window.

 

TRANSLATE YOUR DOCUMENT IN WORD

Did you know that you could translate a word or an entire document using Microsoft Word?  It is really easy and fun.  Select TOOLS then RESEARCH.  The RESEARCH tab will then appear on the right hand side of your document.  You can select which kind of RESEARCH from the dropdown box.  You can select TRANSLATION and then select from ENGLISH to whatever language you choose.  Once you hit the GREEN ARROW, a web browser will appear with your document fully translated!  If anyone is interested in the TECH TIPS NEWSLETTER in French or Italian, I have saved a copy!

COOL TOOL:

 

http://grandcentral.com/

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2007-110915-3903-99

 

 

Tech Tips for 11/9/07:

OUTLOOK HOLIDAYS

You can easily add holidays to your outlook calendar! 

Select Tools

Select Options

Calendar Options

Add Holidays

GOOGLE TRACKING FOR EVERYTHING!

Did you know that Google tracks all sorts of things you might not have known about!  Simply add any of the numbers below to the search bar and let Google do the work…

Any tracking number from UPS, FEDEX or the US Post Office will direct you to your tracking info

The VIN number from any automobile will bring up a list of entries including Car Fax reports

An Area Code will bring up the city state of origin

A Product UPC code will deliver all sorts of info on the product!

WORD SHORTCUTS

CTRL + SHIFT + L = Bulleted List

ALT + CTRL + F = Footnotes

ALT + SHIFT + D = Inserts the date

COOL TOOL:

http://www.amazon.com/exec/obidos/tg/detail/-/0596510543/lockergnome

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2007-110915-3903-99

 

Tech Tips for 11/2/07:

 

OUTLOOK 2007 DIRECTIONS

To obtain directions to a specific address in Outlook 2007:

Once Outlook is open, click on your Contacts folder.

Double click a contact.

In the Address section, click the arrow and select the type of address you are looking for directions: Home, Business or Other.

Select Actions then DISPLAY MAP

Outlook will bring up a map with directions to your contact’s address.

SCAN YOUR WEBSITE SEARCHES WITH SCANDOO

Scandoo is not your average search engine.  Scandoo scans all websites and warns you of any that may contain viruses or spy ware!  It is still in its beta stage, but go ahead and give it a try…

http://www.scandoo.com/

 

ADD A WATERMARK TO A WORD 2007 DOCUMENT

Click the Page Layout tab.
Click the Watermark command in the Page Background group.
Click Remove Watermark to remove the Draft 1 watermark.
Click the Watermark command in the Page Background group.
Click Custom Watermark.
Click Text Watermark.
Click in the Text box and replace ASAP with Final Showing Markup.
Click Apply.  Click Close.

COOL TOOL:

http://www.screxpert.com/photo2scr.htm

 

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2007-110219-5154-99

 

 

Tech Tips for 10/19/07:

 

EXCEL SHORTCUTS FOR ALL

F4 repeats the last command or action!

F10 selects the menu bar or closes an open menu and submenu at the same time.

SHIFT+F2 edits a cell comment

KEY FOLDER HOLDS ALL OF YOUR PASSWORDS

Key Folder is a secure password manager that helps you organize and store passwords and other sensitive information you do not want other people to get access to. You can store all kinds of information like web site accounts, e-mail accounts, PIN codes, bank account information, credit card numbers, software license/registration codes and other data that you want to keep secure and have easy access to.

http://www.freedownloadscenter.com/Utilities/Password_Management_Utilities/Key_Folder.html

 

COUPONS AND MORE

Visit this great site to print out valuable coupons.  WOW lets you browse through national franchise coupons, travel, restaurants and even rebates!  The great thing about this site is that you do not have to “sign up” for anything.  Just point, click and print!

http://www.wow-coupons.com/all-printable-retail-coupons.php

COOL TOOL:

http://www.yankodesign.com/index.php/2007/10/19/controlling-in-style/

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2007-101913-0758-99

 

Tech Tips for 09/28/07:

STOP THAT SPAM!!

To decrease your daily dose of spam, select Tools > Options > Junk E-mail and click the High radio button. To eliminate spam completely, select the Safe Lists Only radio button to receive e-mails only from the people you allow. If you are concerned about missing any e-mails, check your Junk E-mail box regularly.

TWEAK YOUR SYSTEM WITH TWEAK MANAGER

WinGuides Tweak Manager enables casual and experienced computer users alike to effortlessly make their computer systems faster, more efficient and more secure! With just a few mouse clicks, you can customize virtually every aspect of your computer, including tweaks for popular software like Microsoft Office and Internet Explorer.

http://www.pctools.com/tweak-manager/

 

LEARN A FOREIGN LANGUAGE

Who said it’s too late to learn a foreign language?  With Mango, you can learn any language you choose for free!  Mango is powered by Flash Player.  You can even take a lesson in Pig Latin!

http://www.trymango.com/

COOL TOOL:

http://www.geeks.com/details.asp?invtid=LED-BELTBADGE&cat=GDT

VIRUS LINK:

http://www.symantec.com/business/security_response/writeup.jsp?docid=2007-092816-1332-99

 

 

 

Tech Tips for 09/14/07:

 

CHANGE AN AUTOSHAPE IN WORD

Once you insert an AutoShape in a document, it is easy to change it to another one. For example, you may want to change a rectangular shape to a triangle. One way of doing so is to delete the original shape and then insert a new one. However, a slightly simpler way is to use the Change AutoShape command.

To change an AutoShape in Word:

Display the Drawing toolbar.

Select the AutoShape you want to change. Handles will appear around the outside of the shape.

Click the draw option Draw on the Drawing toolbar, and point to Change AutoShape. The familiar AutoShape categories will appear.

Select the new AutoShape you want to use.

GARAGE SALE FINDER

Before you head out to rummage through stuff at garage sales, you might want to check out this new site!  You can find garage sales in your area or list your own!

http://zipgarage.com/

 

TAKE THOSE APPS WITH YOU

Now you can carry your applications around with you in your pocket!  Portable Apps is a free site that allows you to download, copy and use applications from computer to computer without leaving any personal data behind!

http://portableapps.com/

COOL TOOL:

http://www.hyperigo.com/

 

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-091417-1141-99

 

Tech Tips for 08/31/07:

FLEX THOSE PHOTOS

Fancy image software is sometimes difficult to navigate.  It is expensive and not always easy to use.  Discover FotoFlexer!  Foto Flexer offers all of the sophisticated tools that you would find with professional software packages and it is all online!

http://www.fotoflexer.com/

 

DRAG AN OUTLOOK FOLDER TO YOUR DESKTOP

You can easily drag any folders from Microsoft Outlook directly to your desktop!  Just follow the steps below…

Pick your folder

Hold down the CTRL key

Drag your folder to the desktop while keeping the CTRL key down

Drop the file on your desktop!

GOOGLE NOTEBOOK

Google has a new Internet Explorer plug in that you can download for free called the GOOGLE NOTEBOOK.  Why should you want to use a google notebook?  Well, here are a few reasons…

You can visit websites and “clip” information that you are looking for and save them to the notebook

You can create multiple notebooks and name them all

You can PRINT your notebook

You can SHARE your notebook with other users and have them collaborate

http://www.google.com/googlenotebook/tour1.html

COOL TOOL:

http://www.pcworld.com/downloads/file/fid,23009/description.html?tk=nl_lg

 

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-082409-5350-99

 

Tech Tips for 08/24/07:

 

SORT YOUR PROGRAMS BY NAME

You can easily organize the programs in your start menu alphabetically.  To do this, follow the steps below…

Click Start

All Programs

Right Click and select SORT BY NAME

BETTER TV ONLINE

Better Homes and Gardens has a great online video section called Better TV!  You can watch “how to” videos on everything from home improvement to relationships!  Check it out; there is something for everyone on this website!

http://www.bhg.com/bettertv/

INSERT A FILE INTO AN EXISTING WORD DOCUMENT

Open your Word document.

Place the cursor in the open document where you want to insert the second one.

From the Insert menu, click Insert File. If you are using Word 2002, click File from the Insert menu.

Locate the file that you want to insert into your document and click the Insert button.

COOL TOOL:

http://www.pctools.com/spyware-doctor/

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-082409-5350-99

 

Tech Tips for 08/10/07:

FREE LEGAL FORMS FOR WORD

Need a legal form, like a lease, waiver, will, bill of sale or permission to use a photograph? Forget the legal document shop – Prolegaldocs.com offers an exhaustive list of downloadable forms in Microsoft Word format. Over 300 forms can be previewed on site, downloaded individually or you can grab the entire collection as a zip archive.

http://www.prolegaldocs.com/

ASSIGN YOUR INSERT KEY TO PASTE!

Within Word, click Options from the Tools menu.

Select the Edit tab.

Click the Use INS key for paste option.

Click OK.

HERE IS YOUR CHANCE TO MAKE IT TO HOLLYWOOD!

Plotbot is an online screenwriter collaboration tool that allows you to express yourself creatively!  You can sign up for a free account where you can privately work on a screenplay or you can post a public project and get the community in to help you!  It’s great for writers block!

http://www.plotbot.com/

COOL TOOL:

http://www.pcmag.com/article2/0,1759,2165119,00.asp

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-062219-0311-99

 

 

Tech Tips for 08/03/07:

FUN TOOL!

Words, words and more words!  The visual thesaurus is a great tool for the wordsmith!  Not only can you view a word in a blossom of other words with similar meanings, but you can also hear an audio of how the word should be pronounced! Check it out!

http://www.visualthesaurus.com/

SEND AN EMAIL AT A LATER DATE

You can have OUTLOOK send your email in the future!  This is a great tip if you want to send out a reminder or if you want to be sure not to forget an important occasion!  Follow the steps below:

Launch MS Outlook if it is not already running.

Create your e-mail message.

With the message still open, click Options in the toolbar.  

Choose Do Not Deliver Before.

Set the date.

Click Close.

Send the message.

One important note…you must have OUTLOOK open and running on the date and time that you want to send that email!

PICTURES FOR BULLETS IN WORD

You can customize your bullets in Microsoft Word.  It is easy to do!  Try personalizing your document by following the steps below…

Under FORMAT, select Bullets and Numbering

On the BULLETS tab, select one of the options

Click CUSTOMIZE

Select PICTURE

Select IMPORT

Choose the photo from your MY PICTURES folder

Click ADD

Then OK. 

If you wish to change the picture bullet, simply select the BULLETS and NUMBERING option from the format menu and highlight a different bullet!

COOL TOOL:

http://www.proveniosoftware.com/

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-080213-5708-99

 

Tech Tips for 07/20/07:

ATTACH AN AGENDA OR NOTES IN OUTLOOK

Attaching an agenda or meeting minutes to a meeting request in outlook is a snap!  If the agenda or minutes are in a file, you can attach the file to a meeting request. In the meeting request, on the Insert menu, click File, and then locate the file you want to attach.

SAVE MONEY ON OVERNIGHT DELIVERIES

Maybe you have a large file that you need to deliver to someone overnight and the file is too large to email.  You can call your local delivery service and pay to overnight your document OR you can visit http://www.yousendit.com/.  You can send files up to 100MB FREE!  You send it also has a paid service that allows you to send up to 2GB with multiple download options.  You can even select to have your document password protected for security!  Check it out!

http://www.yousendit.com/

ADD THEIR PHOTO

Did you know that you could add a photo to an OUTLOOK contact?  Open up OUTLOOK, select CONTACTS and click on the photo icon to add their photo.  It is fun to put a face with a name!

COOL TOOL:

http://www.blurb.com/home/1/

 

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-062219-0311-99

 

 

Tech Tips for 07/06/07:

 

DRAG AND DROP FROM OUTLOOK

When you get an email with an attachment, did you know you could drag and drop that attachment into any folder on your computer?  All you have to do is open the folder that you want to save the document in and drag the attachment right from the preview pane in outlook to it!  It sure beats opening multiple documents and selecting “save as”!

CHANGE AN ICON IN EXCEL

You can customize icons in an Excel.  Follow the directions below…

Place the mouse arrow over one of the toolbars, right-click, and select Customize from the shortcut menu.

Select any icon on an existing toolbar and right click.

WANT A CALCULATOR ON YOUR DESKTOP?

Right click a blank area on your desktop, point to New and click Shortcut.

From the Create Shortcut window, type in “calc” and click Next.

Type in a name for the shortcut.

Click Finish.

COOL TOOL:

http://www.e-zsoft.com/

 

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-062219-0311-99

 

Tech Tips for 06/22/07:

EXCEL Shortcuts

F2: Edit a cell’s contents.

Ctrl-1: Open the Format Cells dialog.

Ctrl-Page Up: Move to the next sheet in the workbook.

Ctrl-Page Down: Move to the previous sheet in the workbook.

Ctrl-Shift-“: Copy the value from the cell above into the current cell.

Ctrl-‘: Copy the formula from the cell above into the current cell.

Ctrl-R: Fill contents of active cell into selected cells to the right.

Ctrl-D: Fill contents of active cell into selected cells down.

Ctrl-`: Toggle between showing cell values and formulas in cells.

Ctrl-$: Set selection to currency format with two decimal places.

STUMPED ON WHAT TO BUY?

If you are looking for that special gift for someone but have no idea where to start, why not visit surprise.com.  You can find the exact gift.  Give it a try!http://www.surprise.com/

PICK A COLOR, ANY COLOR

Get Color allows you to retrieve any color of any pixel on your desktop easily!  Drag the eyedropper tool onto any color and you can see the value immediately.  This handy free tool can save you lots of time and trouble with your marketing efforts!

http://www.sofotex.com/GetColor!—Color-Picker-download_L62491.html

COOL TOOL:

http://desktop.google.com/plugins/i/gdcalendar.html?hl=en

VIRUS LINK: http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-062219-0311-99

 

Tech Tips for 06/08/07:

Who is GOOGLING you?

If you would like to enhance your exposure to search engines and take control over what people are finding out about you online, then you should look into http://www.naymz.com/.  This service is free and allows professionals to create their very own profile page and have a direct influence over the type of information that is returned from a google search.  Naymz even offers a “reputation alert” which will let you know each time your name appears on a new webpage!

http://www.naymz.com/

BACK UP YOUR PC ONLINE!

If you have been looking for a back up solution for your data, why not look into http://www.carbonite.com/.  They offer an online storage solution sure to secure all of your valuable data.  The best part is, they are offering a FREE 15 day trial.  If it works for you, great.  If not, you do not need to purchase their services.

http://www.carbonite.com/

SIMPLE EXPORT FROM EXCEL TO WORD

Nothing fancy.  Just an easy way to get your info from one program to another!

Open your Word document.

Open your Excel spreadsheet.

Within Excel, select the cells you want to copy into Word.

On the Home tab, in the Clipboard group, click Copy.

Switch to your Word document.

Place the insertion point where you want the data.

Press CTRL + V.

COOL TOOL:

http://www.phoneflyer.com/about.html

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-051723-5519-99

 

Tech Tips for 05/18/07:

WHAT WILL THEY THINK OF NEXT?

Get ready for SPOTSCOUT!  Parking for the mobile generation! Spotscout is a service that offers online/mobile parking space information to registered users.  You can log on to their website, register for free and SCOUT for parking spots! That would make you a SPOT SCOUT.  Or, you can broadcast parking spaces…making you a SPOT CASTER!  The next time you are heading into the city for the big game or entertainment event, book your parking space in advance!

http://www.spotscout.com/

ADD A CALCULATOR TO AN EXCEL SPREADSHEET

Open Excel.

From the Tools menu, click Customize.

Under the list of Categories, select Tools.

Scroll through the list of Commands and select Custom (it will appear with a calculator beside it).

Drag the Calculator onto your toolbar.

An icon will appear that you can now use to launch the calculator instead of having to access it from the Start Menu.

Click Close.

LET OUTLOOK REMIND YOU TO REPLY TO AN EMAIL!

You got an email but you do not have time to reply.  You want to be SURE that you do not forget because it is so important.  What do you do?  You let OUTLOOK remind you!

Open Outlook.

Right click the message that you want to configure the reminder for.

Point to Follow-up and click Add Reminder.

In the Due By list, select the date when you want to receive the reminder.

Use the drop down arrow in the second list to select the time of day that you want to receive the reminder.

Click OK.

 

COOL TOOL:

http://www.housefront.com/

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-051723-5519-99

 

Tech Tips for 05/04/07:

OFFICE 2007

Microsoft Office has a whole new look! There is a completely new interface and many extra tools!  You can take a quick tour of Office 2007 and download a free trial version by visiting the website below:

http://office.microsoft.com/en-us/products/FX100487411033.aspx?pid=CL100571081033

CUSTOMIZE YOUR OUTLOOK START UP

You can select which screen launches when outlook starts up!  Maybe you would like to see your tasks.  Maybe you would like to see your calendar. You can have it your way!  Follow the steps below…

In OUTLOOK select TOOLS

OPTIONS

Select OTHER

Choose ADVANCED OPTIONS

Under the General Settings, select BROWSE and choose the appropriate window that you would like displayed at startup

Click OK

SAVE TIME ON YOUR DATA ENTRY

The next time you have a large data entry project, why not try this tip….

Use your computer’s microphone to record your list of data,  then play it back while you are typing!  This will save you the time and energy of having to keep track of where you left off and your neck will thank you!

COOL TOOL:

http://www.amazon.com/exec/obidos/ASIN/B000FS78GQ/lockergnome

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-050416-5153-99

 

Tech Tips for 04/20/07:

 

CREATE A DROPDOWN LIST IN AN EXCEL SPREADSHEET

So you think this is a difficult task?  Think again!  Follow the steps below and you will see how easy it is…

Create a list of entries that you want to appear in your dropdown list in your existing spreadsheet or another sheet of your document

Click on the cell where you WANT the dropdown list to appear

On the toolbar click DATA then VALIDATION

In the ALLOW box, select LIST

From the source window, select the cells where your list of entries appears and highlight them.

Click OK

Copy the cell with your drop down box to any other cells that you would like that box to appear.

WORDINESS IN WORD

You can have Microsoft Word check your document for wordiness.  Why bog down your document with unwanted words or empty phrases?  Check your document for wordiness by selecting TOOLS then OPTIONS.  Select SPELLING AND GRAMMAR and click on SETTINGS.  Under grammar and style, make sure the check box next to “wordiness” is selected. 

ALL THAT SEARCHING

This new search engine will not rest until it finds what you need!  All that will email you new results or you can subscribe to an RSS feed!

http://allth.at/home/welcome

COOL TOOL:

http://www.ronyasoft.com/index.html

 

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-040611-5440-99

 

 

Tech Tips for 04/06/07:

WRAP YOUR TEXT IN EXCEL

When you are working in an EXCEL spreadsheet and you want to type text into a cell, but have it continue to the next line, hit ALT then ENTER at the end of the line.  If you hit ENTER, you will move to a new cell. 

FULL SCREEN MODE IN WORD

Normally, when you edit a document in Microsoft Word, some of the screen is taken up with toolbars, a menu bar, a status bar and your system toolbar/taskbar.  To temporarily hide all of this extraneous information to solely work on your document, click “view” and select “full screen” Everything will disappear except your currently edited document.

START INTERNET EXPLORER WITH NO PLUG INS

If you are experiencing problems with Internet Explorer and you would like to start the program without plug ins (Flash player, etc.) follow the steps below…

Start

Run

Accessories

System Tools

Internet Explorer – No Plug Ins

COOL TOOL:

http://www.thinkgeek.com/gadgets/security/91a2/

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-040611-5440-99

 

Tech Tips for 03/23/07:

 

ORGANIZING YOUR FAVORITES

You might find that your favorites list is getting a bit long.  You can set IE to display only the recently used favorite’s when you click on your favorites tab.  You can still access ALL of your favorites by clicking on the down arrow.  To set up this feature:

Open IE

Select INTERNET OPTIONS from the TOOLS menu

Select ADVANCED

Place a checkmark next to ENABLE PERSONALIZED FAVORITES MENU

Click OK

RENAME  A WORKSHEET TAB IN EXCEL

When you open an EXCEL file, the worksheet tabs are named SHEET 1, SHEET 2, etc.  You can easily rename the tabs by RIGHT CLICKING on the tab and selecting RENAME.   

OUTLOOK TIP OF THE DAY

If you are sending an email to someone and would like to refer to past emails, journal entries, tasks or calendar entries, you can easily manage this task by taking the following steps…

Open OUTLOOK and select a NEW EMAIL

Click on the PAPERCLIP icon and select insert ITEM. 

Outlook will open your OUTLOOK folders

Browse through your folders and select the desired items

Make sure that you have a checkmark next to INSERT AS ATTACHMENT

COOL TOOL:

http://www.mobile17.com/

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-032308-5845-99

 

Tech Tips for 02/23/07:

 

HAVE OUTLOOK EMAIL REPLIES SENT TO ANOTHER PERSON

Create a message.

Click Options.

Under Delivery options, select the Have replies sent to check box.

Type the name of another person, or click Select Names to select from a list.

DRAWING A PERFECT CIRCLE IN POWERPOINT

Even if you can’t draw a straight line on paper, you can in PowerPoint. Just select the Line tool and then hold down the Shift key while you draw the line. For a perfect circle, click the Oval tool and hold down Shift while you draw the circle. And, of course, you can use the Rectangle tool and the Shift key to draw a perfect square.

This technique also works in Word and Excel.

PLANNING A PARTY?

Bestpartyever.com is a great site to visit if you are planning a party of any size.  There are great party ideas, vendor centers, calculators, and to do lists. Take a closer look!

http://bestpartyever.com/

COOL TOOL:

http://www.answers.com/main/download_answers_win.jsp

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-022615-1754-99

 

 

Tech Tips for 02/09/07:

 

WHAT DO YOU DO WITH YOUR OLD CELL PHONES?

If you are storing your old cell phones in a junk drawer somewhere in your office, you can donate them instead!  Make a difference with a charity or a person in need and turn in your old, unwanted cell phones.  There is a wonderful site that features a directory to look up local drop off locations.  You can also choose to donate to specific causes.

http://www.wirelessrecycling.com/home/index.html

 

EXPIRED DOMAIN NAMES

If the domain of your dreams was previously taken, you might be pleasantly surprised if you visit the website below!  It lists recently expired domain names. 

http://expired-domain.bemmu.com/?sort=2&page=0&search=

JOTT IT DOWN

Ok, you are driving and suddenly you remember something really important.  You don’t want to pull over to write it down.  Just pick up your cell phone and JOTT it down!  Jott is a free service that allows you to call an 800 number to transcribe a memo or note and have it emailed to you later! 

http://jott.com/Jott/login2.aspx

COOL TOOL:

http://www.getgspace.com/index.html

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-020915-2914-99

 

 

Tech Tips for 01/19/07:

 

FREE PUBLIC SPREADSHEETS!

Editgrid is a FREE community spreadsheet site.  You can register for free and create spreadsheets that feature REAL TIME UPDATES and collaborations via the internet!  There is no need for special software.  All you need is a javascript enabled web browser and you can start collaborating today! You can also browse editgrid for spreadsheet templates.  You can choose to make your spreadsheets private or public and you can also password protect them!

http://www.editgrid.com/

 

IS YOUR WINDOWS XP UP TO DATE?

Microsoft is constantly releasing updates for Windows XP.  If you do not regularly download updates, you can visit the site below and find out if there are updates available for you! 

http://windowsupdate.microsoft.com/

HOW TO CLEAR YOUR RECENT DOCUMENTS IN OFFICE

When you are working in Microsoft Office, your RECENT FILES are kept in a separate folder on your hard drive.  If you clear your RECENT DOCUMENTS using the system settings (RIGHT CLICK ON START, Properties, Start Menu) it WILL NOT remove the recent files in Microsoft Office.  To remove the recent files in Office, you need to

 

Go to C:\Documents and Settings\<user>\Application Data\Microsoft\Office\Recent   folder

Select all of the files and delete them

COOL TOOL:

http://www.smugmug.com/

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-011917-1403-99

 

Tech Tips for 01/26/07:

 

DIGITAL CAMERA QUESTIONS?

How do you fix “red eye” in your digital prints?  What is the difference between jpeg and tiff?  How do you use photo editing software?  For the answers to THESE and MANY OTHER digital camera questions, visit the site below!!

http://www.basic-digital-photography.com/index.html

 

NEED AN EXPERT?

Visit Expert Village!  Expert Village is an online portal of “how to” videos from experts in every area!  You can select from thousands of videos in many categories.  Are you an expert at something yourself?  You can “register” as an expert and if expert village is interested, they will send a film crew to catch you in the act!

http://www.expertvillage.com/

PRINT NOTES PAGES IN POWERPOINT

 If you’ve prepared a Power Point Presentation, but would like to add a “script” or “notes”, simply go to the view menu and then NOTES PAGES.  You can add any info that you want to the notes section, and then print a copy by selecting PRINT and then choosing NOTES PAGES.  When you are making your presentation, you can follow along with the printed notes pages and read the script that corresponds with each slide.

COOL TOOL:

http://www.pocketmod.com/

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2007-012610-3225-99

 

 

Tech Tips for 01/12/07:

 

GET READY FOR WINDOWS VISTA!

Vista is coming and you need to prepare!  Visit the site below to find out just what you need to do to be ready for the latest operating system from Microsoft!

http://www.microsoft.com/windowsvista/getready/default.mspx

F11 IN OUTLOOK
For a quick and easy way to look up contacts in OUTLOOK, try hitting F11.  This shortcut will take you right to the CONTACT LOOKUP field. 

 

THINKING OF GETTING OFFICE 2007?

You can download a trial version of the software for FREE.  See the latest versions of WORD, EXCEL, POWERPOINT, ACCESS and OUTLOOK!  The site even features tips and tricks as well as upcoming training webcasts!

http://www.microsoft.com/office/greattips/trial/default.mspx

COOL TOOL:

http://www.pcmag.com/article2/0,1759,2071695,00.asp

VIRUS LINK:

http://www.symantec.com/enterprise/security_response/writeup.jsp?docid=2006-122917-0740-99