Tuesday, December 15, 2009

Outlook and Mail

If you are using a Windows PC, you may be using a program called "Outlook or Outlook Express" or curious to know what it is. If you are using a MAC, the equivalent programs to Outlook are called: Mail, iCal and Address Book.

Courtesy of http://office.microsoft.com/en-us/novice/FX10.aspx?ofcresset=1
Outlook is software that lets you not only send, receive, and manage e-mail, but also manage your calendar and contacts, such as friends and business associates.
Moreover, you can also share your calendar with family and colleagues via the Internet.

Outlook is a part of "Office", a suite of products combining several types of software for creating documents, spreadsheets, and presentations, and for managing e-mail.

Tip: Why is it called "Office"?
You might wonder why document creation and spreadsheet software that you use at home are a part of a suite of software called "Office". There is a historical reason for this. Previously, document creation and spreadsheet software were used primarily for work. The software was combined into a suite of software for work so it was called "Office". Since then, personal computers have become popular even in the home, but the software suite, which combines document creation and spreadsheet software, is still called "Office".

Tip: Referring to Outlook
Outlook is usually referred to as "Outlook" in the software screens and help. It is also referred to sometimes as "Microsoft Office", "Office Outlook" or "Microsoft Office Outlook 2007". They all represent Outlook.

Tip: Outlook can manage various information
Of course, Outlook can manage not only your e-mail, contacts, and calendar centrally, but can also manage all the information you exchange using your computer, such as news and blog articles distributed on the Internet and instant message service chat sessions. Additionally, if you add features, you can manage information exchanged using a cellular phone, IP-Phone, and a personal digital assistant (PDA or Smartphone) loaded with Windows Mobile.



Three built-in applications that work as one: Mail, iCal, and Address Book bring the power of Mac OS X to your email, calendar, and contacts. You get elegant, easy-to-use interfaces, lightning-fast searches, and complete integration across the applications and your Mac.

Mail: All your email accounts in one place.
Designed from the ground up specifically for email, Mail offers an elegant user interface that makes it easy to manage all your email from a single, ad-free inbox, even when you’re not connected to the Internet. It works with most email standards and most popular email services, such as Gmail, Yahoo! Mail, and AOL Mail. If you have more than one email account, no problem. Just add all your accounts to Mail and you’ll be able to access everything from one central place.

Betsy
The PC Teacher




Sunday, December 13, 2009

Amazon.com Sells Outerwear

I received an email this morning from Amazon.com that said: "Today Only! Outerwear is up to 75% Off!"

After that brief thought (I didn't know Amazon also sells coats!), I followed the link to find many coats for all members of the family from famous designers at up to 75% off and many items have free shipping!

So I'm forwarding this good news on to you! Here are my picks:

Saturday, December 12, 2009

Google Your Ingredients







While you are prepping for the holidays, don't forget to use your computer's internet connection to help you figure out what's for dinner. You can find some quick and easy recipes if you use certain keywords in your internet search. I like to keep the following items in my pantry or fridge to have on hand: chicken broth, bread crumbs, egg noodles, garlic, lemons, white wine, ketchup, mustard, Worcestershire, herbs and spices, etc. to make it easy to put together most of the recipes I find on the internet.

Using Google.com, conduct an internet search using some ingredients you have in your house.

Try this:

1. In the Google Search Box, type these 4 words: roast chicken lemon garlic

2. Click "I'm Feeling Lucky"

3. As of this writing, the Foodnetwork.com website comes up with a delicious recipe by Ina Garten ("Barefoot Contessa")
If you like the Foodnetwork.com, you can use a specific set of keywords in your Google to only get Foodnetwork recipes in your results. Try this:
1. In the Google Search Box, type these 4 words plus the "site" command:
chicken tomato mozzarella spinach site:www.foodnetwork.com
2. Don't type any spaces after the word 'site' or after the colon.
The results screen will display links only from www.foodnetwork.com

Let's assume you make the chicken tonight and you have leftovers.

The next day, type the following words into your Google Search Box:

1. Type these 4 words: cooked chicken broccoli noodle

2. Press Enter on your keyboard.

3. The results screen displays a variety of delicious recipes.


If you are going to be out of the house during the day, try searching Google for a crock pot recipe.
1. Type these 4 words: frozen chicken broth noodles

2. Yes! That says frozen chicken. You can put boneless chicken breasts right from the freezer (best if pounded thin before frozen) directly into the bottom of the crock pot.

3. I followed the recipe from Cooks.com: http://www.cooks.com/rec/view/0,1612,132190-252199,00.html

4. Once again using the egg noodles from my pantry. Almost all of these recipes call for bacon oddly enough so I'll be buying a package tomorrow.

On many of the cooking and recipe sites you are given the option to print the recipe. Take advantage of that! Keep all your recipes in a 3-ring binder by category (Appetizers, Soups, Snacks, Meat, Vegetarian, Dessert, etc.)

Happy Googling and Happy Cooking!

Betsy
The PC Teacher

Thursday, December 10, 2009

How to Setup a Mailing in Excel and Word


If you're looking to use your computer for tasks that you would normally do by hand, you must try creating an address book in Excel and using it to print address labels in Word.

To create an address book in Excel:

  1. From the Excel window, use the first row to type the names of the column headers (i.e. Last Name, First Name, Address 1, Address 2, City, State, Zip
  2. Adjust the column widths to accommodate long names and addresses.
  3. Type the names and addresses. Be careful here of any typos. The data will appear on the labels exactly as it is typed in Excel.
  4. Save the spreadsheet.
To create the labels in Word:
  1. From the Word window, click on the Mailings tab (Microsoft Word version 2007)
  2. Click Start Mail Merge and choose labels.
  3. Pick the Avery Labels format option associated with the size labels you are using.
  4. Click the Select Recipient button and choose Use Existing list
  5. Navigate to where you saved the spreadsheet created in step 4 above.
  6. Open the spreadsheet and the corresponding sheet.
  7. Click the Insert Merge Field button and pick the fields to layout the label.
  8. Click Update Labels button to make all the labels on the sheet look the same.
  9. Click the Finish Merge button and merge to a new document so that you can check the addresses and spacing.
  10. Click the Office Button and choose print to print the labels.
Your address book that is saved in Excel can also be used to print directly to envelopes or for printing form letters.




Short on time? The PC Teacher does your mailings for you. For only $45 your names are entered into Excel (up to 100 names) and you get the labels to go with it. (50 cents per additional name) You will get your address book on CD to be used with future mailings. Call or email today to set up an appointment.

Betsy Sabatini Coyne
The PC Teacher
bcoyne@thepcteacher.com

Tuesday, December 8, 2009

Take a Byte Out of Storage














When I started working in technology and information systems 22 years ago, my job entailed helping people copy their computer files to an external disk in order for their data to be safe (in case their hard drive ever crashed). In those days (the late 80's), we copied our files to a floppy disk. The disk was capable of holding 1, 440, 000 bytes or what you see abbreviated as: 1.44 MB

Now flash forward to 2009. I'm shopping for holiday gifts and one item on my list is an external hard drive. Staples has a Seagate desktop external drive capable of holding 1,500,000,000,000 bytes or abbreviated as: 1.5 TB

So I thought I'd dedicate today's blog to data storage and how many bytes you get per disk. First let's discuss the abbreviations for disk capacity:

1 megabye (MB) = 1 million bytes
1 gigabyte (GB) = 1 billion bytes
1 terabyte (TB) = 1 trillion bytes

When shopping for computers, either desktop, laptop or netbook, there usually is a hard drive built in. This storage capacity ranges from 900 MB (older computers) to 2 TB (newer computers).

If you are using a Windows PC, you can go to "My computer" on your desktop then right click and go to properties and then a screen will pop up and it will tell you how many bytes your hard drive has.

If you are using a MAC, you can go to your "Finder" then control-click on the hard drive icon and choose Get Info from the pop-up and it will tell you how many bytes your hard drive has.

An easy way to backup or make a copy of your photos, documents, presentations, fliers, brochures, etc., is with a USB drive (also known as flash drive, jump drive, thumb drive). A typical USB drive holds data in multiples of 1 GB. You can purchase a 4 GB drive on sale for approximately $15. An 8 GB drive is approximately $20. Look for manufacturer rebates and sales. You can find them in Staples, Radio Shack, Best Buy, Walmart, or online at amazon.com.



If you are storing photos taken with your digital camera, most likely they are stored on a memory card. A typical memory card holds either 1 GB, 2 GB, 4 GB, 8 GB, 16 GB or 32 GB. Read the instructions that come with your digital camera or camcorder because not all memory cards fit in all camera devices.





A typical CD-R (the type of disk you purchase to 'burn' a music CD for the home or car stereo) holds 700 MB. Depending on how the songs are recorded, this disk can hold approximately 100 minutes worth of songs.




A typical DVD-R (the type of disk you purchase to 'burn' a video or home movie DVD for the home DVD player) holds 4.7 GB. Depending on how the videos are recorded, this disk can hold approximately 2 hours of very good quality DVD-Video.



To learn how to backup your data to any of these disks, call The PC Teacher at 201-327-0830 or email me at bcoyne@thepcteacher.com . Gift certificates available in multiples of $30. Give the gift of joyful learning this holiday season.

www.thepcteacher.com

Thursday, December 3, 2009

Meet a Friend in a Place Between

Meeting a Friend for the Holidays?

If you are meeting up with friends this holiday season and need help finding the best half-way point between your homes, log on to


From their homepage, look in the upper right corner.
Click in the box that says "Where are you coming from?"
Type the city and state of where you live
Click Add
Type the city and state of where your friend lives
Click Add
Click in the box that says "Where would you like to meet?"
Type a keyword such as Starbucks, Dunkin Donuts, Movies, Pizzeria, etc.
Click "What's Between" to see a list of places with addresses and phone numbers.

Have fun,

"Helping You Click with Technology"


Tuesday, December 1, 2009

Free Holiday Music Downloads



Today Only on Oprah.com

Free Holiday Music Downloads - If you're a fan of christmas music and enjoy listening to Mary J Blige, Andrea Bocelli, Jennifer Hudson and Sugarland, log on to www.oprah.com today.

From November 30 at 10 a.m. CT to December 1 at 11 p.m. CT, download Andrea Bocelli's and Mary J. Blige's duet on "What Child Is This" and Sugarland's "Silent Night" for free!

Download Directions:
If you're on a PC, right-click (Mac users: Ctrl-click) on a song link. Internet Explorer users, select Save Target As; Firefox users select Save Link As.

Select where you wish to save the file on your computer, and then click Save.
Once the file has been saved, go to the location where you saved the file and open the file to begin listening.

If you use iTunes, click File then click Add to Library and navigate to where you downloaded the songs. Connect your iPod to your computer and enjoy holiday music on-the-go!

Enjoy!
Betsy Sabatini Coyne
The PC Teacher

Monday, November 30, 2009


Snapfish Coupon

Shutterfly Coupon

To shorten your holiday to-do list, order your holiday cards and copies of photos online.

At Snapfish.com over the next few weeks, use coupon SHIPCHEER at check out and receive free shipping on print and photo card orders of $30 and more.

Prints are 9 cents each! Order prints now and make your friends and family members a scrapbook for the holidays.

At Shutterfly.com over the next few weeks, use coupon SHIP25 at check out and receive free shipping on print and photo card orders of $25 and more.

Thursday, November 19, 2009

Ease the Season - Sending Cards, Giving Gifts with your computer







It's a week before Thanksgiving and on the way home tonight I caught a glimpse of the first set of lights lining the rooftop of a house in the distance. We're on the threshold of the holiday season. No wonder my last few home visits involved getting photographs scanned, mailing labels printed and photos uploaded to the internet.
So I thought I would put together a list of the websites that I use to upload people's pictures then help them to order photo cards, photo books, and prints:
Kodak Gallery - The Kodak photo book arrived as a true 5x7 with a glossy heavy cardstock cover that had a matte finish that felt more like vinyl. Images were as crisp as any 5x7 print you’d get from Kodak. Watch for specials here too. Every now and then Kodak offers a low price on making copies of prints. Great opportunity to make a gift with a special picture frame.



Snapfish - HP’s Snapfish has come a long way, greatly expanding its sizing and binding options, while adding additional customization features to bring a personal touch to your professional published photo book. And the selection of photo cards is outstanding. Once you upload your special photos to the site, you have the option to pick between photo cards from .29 cents each and up.


Shutterfly - Shutterfly combines quality, creativity and versatility to make for an exceptional product. Shutterfly offers more sizing and design options than most other photo book publishers, providing all the tools, embellishments and binding options to help transform those priceless memories into timeless, professionally-crafted keepsakes.

With hundreds of themed and un-themed template choices to choose from, designing and creating handsome and memorable photo books is intuitive and fun.




Viovio - I love this site. They have a portfolio/spiral bound 11 x 14 photo book starting at $20. Make sure you order your book a few weeks ahead of time because they take a little longer than other services but the quality is worth it. If you have a last minute album you need printed, you might want to try Shutterfly. Viovio offers A LOT of different shipping options, but their production time is longer than Shutterfly.


Saturday, November 7, 2009

Add Holidays to your PC Calendar

If your computer is Windows (XP/Vista/7), you may be using a version of Microsoft Office which includes a word processor (Word), spreadsheet program (Excel), slideshow designer (PowerPoint) and personal data organizer (Outlook).

Outlook has a calendar where you keep track of your daily, weekly and monthly appointments. You can also set it up to remember special dates such as birthdays and anniversaries. Outlook doesn't have the list of traditional holidays included but you can set it up to do so. Follow these steps:

By default, Outlook does not display holidays in the calendar. Most people prefer having holidays listed in their calendar for reminders, planning work schedules, deciding upon holidays, and so on. If you want holidays listed, you can add country specific holidays to your calendar.

  1. Open Outlook.
  2. From the tools menu, click Options.
  3. Click Calendar Options.
  4. Click Add Holidays.
  5. Place a check beside the appropriate country/countries.
  6. Click OK.
  7. Click OK to close Calendar Options.
  8. Click OK to close Options.
On a MAC, do the following (yes, we teach MAC at The PC Teacher!):
    1. Go to Apple.com/downloads or use this link: http://www.apple.com/downloads/macosx/calendars/usholidaycalendar.html
    2. For the free download from Apple.com, click the Download button to get the US Holiday Calendar.
    3. Click Subscribe to get the future calendar dates.
    4. Click OK to verify your settings for iCal.