welcome

Click here

Monday, December 20, 2010

How to create Business Letterhead in WORD 2007 and 2010?





















letterhead is the heading at the top of a letter paper. It usually consists of a company name and the company address. It can also contain a company logo and other contact information.
Microsoft Word offers the ability to create a letterhead. Furthermore, it allows you to create the font and style of your choice. The letterhead can be saved as a template so that it can be reused for additional letters. In this step-by-step picture tutorial, you will see how to create a letterhead in Microsoft Word 2007.
What you will need for this tutorial?
è  Microsoft Word 2007
Step1:  Open Microsoft Word 2007
Step 2:  Enter the information that you want to include in the letterhead. Let's create a letterhead for a company named XYZ.
Step 3:  After you have entered all the information you wish to include in the letterhead, you can now format the information so that it looks like a letterhead. You can format the letterhead according to your requirement.




Select all or part of the entered text that you wish to format.
Now choose the font style and size according to your requirement.
You can further choose to align the text according to your requirement. You can choose to keep the font to the left of the page, or center-text it or you could even choose to right-align it.
If you wish to remove the spacing between the lines, then you can simply change the style and select No Spacing from the Styles box.
If you wish to separate the letterhead from the rest of the body such that a line stretches across the page just below the letterhead, you can easily do that from the Paragraph box in the Home tab as well.
Simply click on the Borders drop-down button and select Bottom Border from the drop-down menu.
Here is how your separated letterhead should look like after the inclusion of that border line.
Step 4:  Microsoft Word gives you the option to save you letterhead. Once you have formatted the letterhead according to your requirement you can save it as a template and simply open the template again when you want to reuse it.
The instructions that follow explain how to save the letterhead as a template, so that it can be reused in the future as well.
1.     Click on the Office Button on the top left hand of the Microsoft Word window.
2.     In the menu, hover your mouse over Save As
3.     In the right pane of the menu, click on Word Template.
Once the Save As window opens, enter a name for your letterhead template. Be sure to select the Templates folder from the left pane of the window. Click on Save to save your letterhead.
Step 5:  Although we are done creating the letterhead, this step is included to illustrate how to access the letterhead that we just saved as a template.
Open Microsoft Word 2007. Click on the Office Button, and click on New. From the left side of the New Document Dialog, click on My Templates.
Now choose the template you just created and click on OK.
You will now have a new document based on the letterhead template that you just created.

How to add background picture to Excel 2007 spreadsheet?






















You can insert a picture in Word, PowerPoint or Excel 2007 very easily. Many people know how to insert a picture in Excel 2007 spreadsheet but they don’t know how to add background picture to Excel 2007 spreadsheet. Excel 2007 spreadsheets largely consist of numbers, charts, tables etc. You can give your personal creative touch to your work on Excel 2007 if you add background picture to Excel 2007 spreadsheet. After you add background picture to Excel 2007 spreadsheet, you will be able to make it look less boring and much more interesting. Follow these easy and simple steps to add background picture to Excel 2007 spreadsheet.

Open the Excel spreadsheet to which you would like to add the background picture.

Select Page Layout from the ribbon.



Click on Background.


The Sheet Background window pane will appear. Choose the graphics or image you want to add as the background.






Click on Insert at the bottom.





You have successfully added a background image to your Excel 2007 spreadsheet! You can change the colors as well as the font to suit the background picture. It is recommended that you select a very light or a very dark colored picture so that the data on the foreground stands out.

Computer keyboard shortcut keys

Quick links
Shortcut keys ABCs
Shortcut keys help provide an easier and usually quicker method of navigating and using computer software programs. Shortcut keys are commonly accessed by using the Alt (on IBM compatible computers), command key (on Apple computers), Ctrl, and/or Shift in conjunction with a single letter. The de facto standard for listing a shortcut is listing the modifier key, a plus symbol, and the single character. Or in other words, "ALT+S" is telling you to press the Alt key and while continuing to hold the Alt key, press the S key to perform the shortcut.
In addition to the shortcuts listed on this page, users can find the shortcut keys to their most popular program by looking for underlined letters in their menus. For example, in the picture to the right you'll can notice that the "F" in File has been underlined. You will then know that you can press the Alt key and F to access the File menu (Note: Some programs require the user press and hold ALT to see the underlined characters). Finally, as can also be seen some of the common features such as Open (Ctrl+O) and Save (Ctrl+S) have shortcut keys assigned to them.
As you begin to work with shortcut keys you will notice that several applications share the same shortcut keys. We have listed many of these keys in our basic PC shortcut keys section.
Note: Users outside the United States or users using a foreign copy of a Microsoft Windows or Microsoft application may not be able to get all the below shortcut keys to perform the function listed below.
Basic PC shortcut keys
The below basic shortcut keys are a listing of shortcut keys that will work with almost all IBM compatible computers and software programs. It is highly recommended that all users keep a good reference of the below short cut keys and/or try to memorize the below keys. Doing so will dramatically increase your productivity.
Shortcut KeysDescription
Alt + FFile menu options in current program.
Alt + EEdit options in current program
F1Universal Help in almost every Windows program.
Ctrl + ASelect all text.
Ctrl + XCut selected item.
Shift + DelCut selected item.
Ctrl + CCopy selected item.
Ctrl + InsCopy selected item
Ctrl + VPaste
Shift + InsPaste
HomeGoes to beginning of current line.
Ctrl + HomeGoes to beginning of document.
EndGoes to end of current line.
Ctrl + EndGoes to end of document.
Shift + HomeHighlights from current position to beginning of line.
Shift + EndHighlights from current position to end of line.
Ctrl + Left arrowMoves one word to the left at a time.
Ctrl + Right arrowMoves one word to the right at a time.

How can I check my web page for errors?

Question:

How can I check my web page for errors?

Answer:

There are dozens of services available that are capable of checking your website for errors. Below is a listing of some of our favorite free online services.
General website / HTML checks
  • Silktide Nibbler - Fantastic free online service that gives you a good complete overview of your website with an overall score.
  • Total Validator - Great service that allows you to quickly check for various errors such as HTML errors, spelling errors, total load time, and the ability to create a screen shot of what the page looks like in other browsers.
  • Feng-GUI - Great service that allows you to upload a picture of your home page or other pages and generate a heat map of where the visitor's eyes aremost likely to go first.
  • W3C markup validation - The source to go to check HTML, XHTML or other markup language you use on your web page for errors.
  • Google Webmaster Tools - A must for any Webmaster. With this free service you can quickly identify any page or links with errors, scan for malware, find pages with short or missing titles, find duplicate meta tags, and much more.
  • IE NetRender - Great online service that allows you to easily see how your page is displayed in different versions of Microsoft Internet Explorer. This is really helpful if you need to test your web page in an older browser such as IE6, which had a lot of compatibility and other issues with CSS.
  • HTML Tidy - Simple and easy to use online tool that allows you to quickly identify any HTML errors you may have on your page.
CSS checking
  • W3C CSS validation service - Fantastic service that will display any issues errors or compliance warnings you have with any CSS code.
  • CSS Compressor - Although not a service to validate for errors this is a great tool to use after your CSS code has been verified. Using this tool you can shrink your CSS file to help the overall load time of every page that links to the .CSS file and decrease the overall amount of bandwidth you use.
Speed test
  • WebPagetest - Our favorite tool for testing a web pages load time.
  • Pingdom Tools - Fantastic service that gives you a good and easy to read overview of how long it takes for something to load on your web page. Keep in mind most web site visitors only spend a few seconds on each page they visit.
  • WebSiteOptimization - Another great service to find how much time it takes to load your web page and what you can do to help decrease the overall time it takes to load it.
  • Web Page Content Compression Verification - Great tool to quickly test an individual page or element on the page (such as a .CSS or .JS file) to see if it's being compressed before being sent using gzip.
Accessibility
  • Colorblind filter - Fantastic page to see how your page would look to someone who has colorblindness. This is an easy way to make sure that someone with colorblindness whose visiting your site is not going to miss something because your color scheme is bad.
  • HERA - Great page to quickly verify if everyone regardless of any disability can view your page they may have.
  • html2txt - A great method of converting your HTML page into a text document. This is helpful because many accessibility tools for the blind will simply convert pages to text, using this tool you can get a good idea how someone who's blind may read your page.
Mobile-readiness
  • mobiReady - By far the best site and service for checking how compatible your website or blog is when being viewed on a mobile device. This service not only gives you detailed information on why your website may or may not work but also gives live demos on how the page will load on different mobile devices.
Analyze
  • Google Analytics - Fantastic free service offered by Google that gives you full details of the visitors visiting your website, what browsers they're using, where they're leaving, what they searched for, and much more. After making sure your website has no errors having this services is always a good idea to help identify any other problems the above services may have not identified.
Checking a Blog
If your page is a blog consider running it through Is My Blog Working? to check to see if the blog is working and get other technical details about it. This can give you additional details about your page as well as anything you may want to change or add to the page.
Test
Having friends, family, and co-workers viewing your website is a great way to make sure your website not only works but works on different types of computers. Other services like fivesecondtest is also another great free way of testing the overall appeal of your site.

Online tools to rate and grade your website or blog

Question:

Online tools to rate and grade your website or blog.

Answer:

There are hundreds of online tools and services that can be used to help rate and grade your website or blog. Below is a listing of a few of our favorite services cable of doing this. Run your site through each of the below suggestions to see where your page ranks and any suggestions that could help improve upon those rankings.
Website Grader
Fantastic service that gives you an extensive report and overall website grade. This service takes into account several different factors that help increase the overall popularity of a web site and blog as well as your sites overall social media impact.
Nibbler
Nibbler report for www.computerhope.comNibbler is not only a great service to give you an overall rating on your website but also provides you with an extensive report of was to improve your overall site rating.
Alexa
Another great service that allows you to not only view traffic ratings and information over time but also allows you to compare your site or blog with others. This is an easy method to compare how your site is doing against your competition.
URL Appraisal
Finally, why not take pride in how much your web site is worth with the URL appraisal service. This service takes into account several different factors such as the age of the domain, the Google PageRank, traffic details, and search engine links to calculate what the estimated value of your site is.

    Top 10 Facebook tips

    Below is a listing of our top 10 tips for the popular social networking website Facebook.
    Hide users, games, polls, etc.
    It quickly gets annoying seeing some users posts, game invites, polls, etc. Hovering your mouse to the right of the post and clicking the Hide button as shown below can hide any post. Once this button is pressed you'll be prompted with the option to hide that user or in the case of a Facebook application the option to hide that application from ever showing up on your profile.
    Hide Facebook users, games, polls, etc.
    To unhide someone or unblock an application click the Edit Options link in the bottom right corner of the news feed as shown below.
    Facebook unhide friends
    Greasemonkey and FB Purity
    Although Facebook does not allow the ability to hide friends getting new friends messages, friends becoming fans of something, and some application messages they can still be hidden with browser add-ons. If you're running Mozilla Firefox, Chrome, Opera, or Safari we suggest installing the Facebook Purity add-on.
    Update your privacy settings
    Click Account in the top right corner of the Facebook window and then click Privacy settings to adjust who is capable of seeing what on your Facebook profile. We highly recommend going through all the privacy settings to verify your privacy is properly protected.
    Anything that is not set to friends only or friends of friends can be seen by anyone searching on the Internet. Below is a few things we recommend for most users.
    1. Under Search in Privacy settings uncheck Public Search Results. This will prevent users from finding your account and profile picture in search results such as Google
    2. Under Application settings, make sure you're only allowing applications you want to have access to your information. Applications that you grant rights to can have access to your Facebook profile information.
    • If you're curious to see how a program or web page connect to the Facebook API can see your profile see Tip135.
    Use the Facebook top bar for navigation
    Facebook navigation
    Knowing how to properly navigate is vital if you want to get the most out of Facebook. Below is a brief description of each of the available options in the top bar as shown above.
     Home (facebook logo) - Clicking this logo will take you to your wall (News Feed) that shows all friends recent posts.
    Friend requests - If any friend requests are waiting to be approved this icon will show a notification of how many friends are waiting for approval. This icon can also be clicked when you want to view any friend recommendations or search for friends on Facebook.
    Messages - This section allows you to send and receive private messages between one or more people you're friends with.
    Notifications - Any time a friend or Facebook application creates a new post you'll be notified in this section. Clicking this icon will show all recent notifications. If you wish to change what is capable of sending you notifications including any Facebook applications or games click the See All Notifications link at the bottom and check or uncheck what you want to be notified on.
    Search - Finally, the search box in Facebook can be a powerful tool that can be used to quickly find any current friends or people on Facebook. In addition searching for terms such as a company name, product, sports team, music band, etc. will find fan pages and groups that can be joined.
    Modify your account notifications
    Keep your e-mail and/or your cell phone clean by updating or eliminate Facebook notifications or keep more up-to-date by adding new notifications. Facebook notifications can be added and removed by clickingAccount link in the top right corner, then Account Settings, and then clicking the Notifications tab.
    Top News and Most Recent
    Facebook News and most Recent
    By default Facebook will display your wall postings in the News format, which means it only displays posts it believes are most relevant to you. These results are based on your past interaction with your friends. If you want to see every post made by all your friends that are not hidden click the Most recent link in the upper right section of your news feed as shown in the above picture example.
    If you want to adjust who shows up manually click the Edit Options in the bottom right corner of your news feed.
    Facebook unhide friends
    View High School work friends
    If you've added your High School and/or previous Work locations to your profile, quickly see all classmates and co-workers on Facebook by clicking the link in your Info tab under your profile.
    Quickly change profile picture
    Your profile picture can be quickly changed to any other picture by visiting your profile, hovering the mouse over your current profile picture, and clicking the Change Picture link that appears in the top right corner of the picture.
    Don't post private information on friend's walls on in comments
    When you make a post on a friend's wall or in any of their comments realize that any of their friends are going to be able to see that post. If you wish for something to remain only between you and a friend send them a Facebook message instead.
    Suggestions and random friend invites
    As you get more friends on Facebook it will begin making friend, groups, and fan suggestions. These are suggestions made by Facebook and not your friends. Unless these are something you're interested in they can be ignored.
    This same rule can be applied to people who may want to be your friend that you don't know. If you don't know someone don't accept his or her friend invite. Once someone becomes your friend they'll have access to any information your friends are capable of seeing.
    Tag your Facebook friends in your photos
    Always make sure to tag any of your Facebook friends that are in pictures you upload. However, never tag someone who is not in the picture. When someone is tagged in a photo that picture is automatically added to that persons profile and is a great way to share pictures with all friends.

    Top 10 unknown Google tricks

    Below is a list of our top ten Google tricks many users don't know about.
    1. Definitions - Pull up the definition of the word by typing define followed by the word you want the definition for. For example, typing: define bravura would display the definition of that word.
    2. Local search - Visit Google Local enter the area you want to search and the keyword of the place you want to find. For example, typing: restaurant at the above link would display local restaurants.
    3. Phone number lookup - Enter a full phone number with area code to display the name and address associated with that phone number.
    4. Find weather - Type weather followed by a zip code or city and state to display current weather conditions and forecasts for upcoming days.
    5. Track airline flight - Enter the airline and flight number to display the status of an airline flight and it's arrival time. For example, type: delta 123 to display this flight information if available.
    6. Track packages - Enter a UPS, FedEx or USPS tracking number to get a direct link to track your packages.
    7. Pages linked to you - See what other web pages are linking to your website or blog by typing link: followed by your URL. For example, typing link:http://www.computerhope.com displays all pages linking to Computer Hope.
    8. Find PDF results only - Add file type: to your search to display results that only match a certain file type. For example, if you wanted to display PDF results only type: "dell xps" filetype:pdf -- this is a great way to find online manuals.
    9. Calculator - Use the Google Search engine as a calculator by typing a math problem in the search. For example, typing: 100 + 200 would display results as 300.
    10. Stocks - Quickly get to a stock quote price, chart, and related links by typing the stock symbol in Google. For example, typing: msft will display the stock information for Microsoft.

    View two windows side-by-side using Smart Window

    Smart Window or Snap, allows the user to view two windows side-by-side in Windows 7 without having to manually re-sizing either window.  This is also useful if you don't want to use Alt-Tab between 2 windows. If you are running a different version of Windows such as Windows XP or Windows Vista and want a similar feature see Tip138. Below is an example of what this looks like in Windows 7.
    Windows 7 Smart Window
    1. Click and Drag on the top title bar of the first window so your mouse pointer hits either the left or right side of your screen. Let go of the window when you see the outline of the window re-size to ½ of the screen.
    2. Then choose the other window you wish to view on the side of the first window. Click and Drag the 2nd window to the opposite side of the screen until the mouse pointer hits the side of the screen and resizes to the other ½ of the screen.
    These steps can also be done using the Windows key and the right and left arrow keys by doing the below steps.
    1. While pressing the Windows button on your keyboard, press either the Right or Left arrow.  This will move the open window to either the left or right portion of the screen.
    2. Choose the other Window you wish to view to the side of the Window in step one.  When using the Windows key for this step, as described in step one above, use the opposite (right or left) arrow button that you used in step one.
    There are three different ways to get out of this view, below are some of the different methods this can be done.
    1. Click and drag the window so the mouse pointer hits the top of the screen and let go.  This will put the window back to regular size.
    2. If you just want to view one of the minimized windows that was in side by side view, simply click and while holding the mouse button down shake the window you wish to view and it will minimize all other widows to the Taskbar.  To reopen windows that were minimized by this step, simply click and shake the window you are using again, and they will re-appear.
    3. Press the Windows key on your keyboard, and at the same time, press either the up arrow or the down arrow.  The up arrow will maximize the screen; the down arrow will put the screen to minimize.

    Top 10 free PC programs everyone should have

    There are millions of free and open source projects available, many of them better than any commercially available product. Below is a short listing of what we think is the best out there, broken down into ten categories.
    Anti-virus and malware protection
    Most PC users realize that they need some type of protection on their computer or may have an installed anti-virus program from their computer manufacturer. What most don't realize is that there are free programs that are just as good and in some cases better than the commercial products. Below are our recommendations
    Anti-virus program: Avast! or AVG
    Malware / Spyware protection: Malwarebytes
    Backup solutions
    There are dozens of free and commercially available backup programs for computers. Unfortunately many of those backups are stored locally, meaning if your house were to catch fire, get robbed, or if you simply lost your backup discs all your data would be lost. This is why when dealing with important data we suggest users use online backup services.
    Online backup solution: Mozy * or Dropbox
    * Free 2GB of online backup for personal use
    Browsers
    Although Microsoft Internet Explorer comes pre-installed on Windows computers. There are several excellent free alternatives that everyone should try. These free alternatives can often be faster, have more options, and in many cases be more secure than Internet Explorer.
    Internet Browser: Mozilla Firefox or Google Chrome
    Compression utility
    When downloading files on the Internet you'll eventually encounter a .zip, .rar, or other compressed file. Dealing with these files can be easy with our below free file compression utility.
    File compression utility: 7-zip
    Disc ripper and creation utility
    Creating an audio or data CD/DVD, ripping the data from an audio CD, or creating a CD from a .ISO file can also be done freely using our below free recommendation.
    CD burner / ripper utility: CDBurnerXP
    E-mail
    E-mail is yet another service that can be done freely. Most users today use online e-mail solutions like the one listed below. However, for those still using an e-mail client such as Microsoft Outlook we strongly suggest one or both of the below suggestions.
    E-mail client: Mozilla Thunderbird
    Online e-mail: Gmail
    FTP, SFTP, and SSH Utility
    Users who maintain their own web page or need to upload / download files to or from a server will have to use an FTP utility and/or a SSH client. There are many commercial programs capable of doing this but our below free recommendations beats them all.
    FTP client: Filezilla
    SSH client: Putty
    Image editor, paint program, and picture organizer
    There are many great free solutions for editing, creating, and organizing your images on your computer. Many of the alternative programs capable of doing these types of tasks can be several hundred dollars, but all of the below programs are completely free.
    Image editor: GIMP
    Paint program: Paint.net
    Picture organizer: Google Picasa
    Multimedia
    There are dozens of different multimedia programs with different capabilities and limitations. Below are our top free multimedia programs for watching video files and recording audio.
    Audio editing and creating tool: Audacity
    Video and DVD Player: VLC
    Office Suite
    An Office suite such as Microsoft Office is often one of the most expensive programs that a user can install on their computer. Why install these expensive programs when there are free solutions that are just as good.
    Office suite: OpenOffice

    Top 10 keyboard shortcuts everyone should know

    Using keyboard shortcuts can often cut the time it takes to do something on a computer in half. Below are our top 10 keyboard shortcuts we recommend everyone memorize and use.
    Ctrl + C or Ctrl + Insert
    Copy the highlighted text or selected item.
    Ctrl + V or Shift + Insert
    Paste the text or object that's in the clipboard.
    Ctrl + Z and Ctrl + Y
    Undo any change. For example, if you cut text, pressing this will undo it. This can also often be pressed multiple times to undo multiple changes. Pressing Ctrl + Y would re-do the undo.
    Ctrl + F
    Open the Find in any program. This includes your Internet browser to find text on the current page.
    Alt + Tab or Alt + Esc
    Quickly switch between open programs.
    F1
    Open help for the program you're in.
    Ctrl + P
    Print what's currently being viewed in programs such as Microsoft Word or your Internet browser.
    Ctrl + Left arrow / Right arrow
    Move the cursor one word at a time instead of one character at a time. If you wanted to highlight one word at a time you can hold down Ctrl + Alt and then press the left or right arrow key to move one word at a time in that direction while highlighting each word.
    Ctrl + Home / End
    Move the cursor to the beginning or end of a document.
    Page Up / Space bar and Page Down
    Pressing either the page up or page down key will move that page one page at a time in that direction. When browsing the Internet pressing the space bar will also move the page down one page at a time.