PC Notes 1/7/14

By

 
PC Class Notes for 1/7/2014

ESC - Cancel messages or strange windows that appear on the screen.

Using Excel to create a contact list
1) Create headings in the first row (1) of each column (A,B,C,D,etc)
i.e. A1=Full Name, B1=Street Address, C1=City, D1=State, E1=Zip
2) Fill in each contact's information below

Start using your email address book for saving mailing addresses and phone numbers. As our devices, smartphones and tablets, are being unified with our email accounts having that information in one place makes things easier.

Downloading your email address book contact list into excel
1)Open your address book from the web
2)Look for export
3)Choose as CSV (comma separated values)
4)a new file downloads
5)open the file and the information will appear in Excel

Creating labels with a contact list in an excel or csv format in Word
1) Open Word
2)Click Mailings/Mail Merge
3)Click Start Mail Merge
4)Choose the type of label
5)Choose Select Recipients
6)Find and open the contact list saved in your computer
7)Click Address Block
8)Confirm that your contact list fields are matching up correctly and all the necessary information is displayed
**if not click Match Fields and match the needed field with the column heading
9)Click Update Labels to add the Address Block to each label
10)Choose Finish and Merge
11)Choose Edit Individual Labels
12)View and confirm your labels are correct
13)Print 

Jason Dare
Computer Trainer
415/240.4843
learn@sfct.net
1617 Balboa St.
San Francisco, CA 94121
www.sfct.net

Popular posts from this blog

AOL Attachment instructions

By
Sending Attachments in AOL Email   Create the email to whom you want to send the attachment to by completing the to:, subject:, and message body Click "Attach File" below Locate the file you want to send as an attachment Click "open" Click "Send Now"   Sending Multiple Attachments in AOL Email   Create the email to whom you want to send the attachment to by completing the to:, subject:, and message body Click "Attach File" below Locate the file you want to send as an attachment Click "open" Repeat step #2 for each additional attachment Once all the attachments have been opened/added to the email Click "Send Now"   Opening an attachment in AOL that contains multiple attachments in one ZIP file/attachment   Open/Read the email message Double Click on the icon below the message text that resembles a file fol
Read more

Defragment the files that are bogging down the computer using Smart Defrag

By
Defragment the files that are bogging down the computer using Smart Defrag 1. Go to google.com 2. Type in the search bar, smart defrag and then press enter 3. Click on the first (unpaid) result which should be iobit.com 4. Click the link “download now” 5. The page will change click in the middle “download majorgeeks” 6. Wait for the page to load and you will be prompted to save or run the file you are downloading 7. Click “save” if possible choose the desktop as the location where you want to save the file 8. Wait for the file to complete downloading 9. Next, is installing the program into the computer 10. Locate the file you downloaded, on the desktop of in my documents/downloads 11. Double click to open the file 12. Follow the prompts next, yes, agree, etc 13. Upon completion of the installation, click finish 14. Smart defrag will open 15. Click analyze to check the status of your computer 16. Then click start defrag to improve the speed of your computer If you run
Read more

Backup Quicken to a Flash Drive

By
Backup Quicken to a Flash Drive 1. Insert the flash drive into the computer 2. Wait for the computer to detect the drive (a window displaying the contents of the flash drive may open) – Drive is identified by the letter E: or F: etc. 3. Open Quicken 4. Go to the “file” menu and choose “backup” 5. A window displaying the path of where the backup will be saved will appear The path should be to the E: or identifying letter of the flash drive 6. If not…you need to direct quicken to where to save the backup 7. Click “browse” 8. Find and click on “my computer” 9. From the list that appears click on the E: or identifying letter of the flash drive 10. Click OK and the window will close displaying the new path for where the backup will be saved 11. Do not check add the date to the filename to save space and reduce confusion between different backups or for multiple backups check add the date to the filename 12. Click OK 13. The screen will flash and upon completion a window will
Read more