CCC Newsletter

TIPS AND TRICKS

Copy a Word Table into Excel 2007

Move data from a MS Word table into Excel 2007 without having to retype it! Try these simple steps:

Select the rows and columns from your Word document to copy into an Excel worksheet.
On the Home tab, click Copy in the Clipboard group or press CTRL+C. You can also right-click and select Copy from the Quick Menu.
Select the upper-left corner of the Excel worksheet area where you want to paste the Word table. Choose an area empty of data.
On the Home tab, click Paste in the Clipboard group or press CTRL+V (you can also right-click and select Paste from the Quick Menu). To adjust formatting, click the Paste Options icon next to the data you just pasted, and choose between the format applied to the worksheet cells (Match Destination Formatting) or the format applied to the Word table (Keep Source Formatting).
Excel pastes the contents of each Word table cell into individual Excel cells

You may have to clean up the data after pasting it to take advantage of the Excel’s calculation features. View our January 2008 newsletter for helpful tips on how to clean up data!

USE OUR MS OFFICE FOUR AND EIGHT PACKS AND SAVE!

Share these passes with your colleagues for maximum flexibility!

Call for details and Save!

HELP MY WEBMASTER JUST QUIT!

If you change your website's content frequently, use our special software to make the changes without having any web skills. Visit www.cccsolutions.com or call us to learn more.

ONLINE FORMS

Tips for Useable Online Forms

Online forms are a great way to collect employee, member, client, and prospect information. Try the tips below to design user friendly online forms

Short and to the point. Your web audience may not want to give too much information, so limit your questions. Name, email address and 1 more question will do. Ask about viewer interest, for example, to show them that you care.
KISS. Keep it simple, s . . . minimalist—don’t over-design the form. Use standard user interface elements and keep instructions clear and short.
Ensure security. The more personal data you request, the more important this is! Make sure there are non-distracting visible indicators on the form that tells your audience their information is secure.
Provide a clear confirmation message. Once a form is submitted, display a message saying the form was received. A confirmation page giving next steps (“you will receive your login and password in 24 hours”) or an emailed confirmation with detailed purchase information will give peace of mind.

Usable forms mean good data for you and a happy audience! Keep the forms short, ask useful questions and gather critical information in a very cost effective way!

ANNIVERSARY CELEBRATION

Celebrating 5 Years as a Team!

Attend two courses prior to June 30, 2008 and take 10% off the second course tuition!

WEBSITE MANAGEMENT

How Dynamic and Up-to-Date is Your Website?

Will your website benefit from being database driven?

Your site has/displays large amounts of information. Large numbers of member files, account information, product inventories, and price lists become difficult or complicated if displayed as static pages.
Your site’s information changes often. Imagine the work put in to change static web pages each time you have new press releases, newsletters, specials, or price lists! If these changes happen often and regularly, static web pages are certainly not for you.
You display elements in multiple places in your site, and users need easy access to the information. Wherever your audience enters your site, they should be able to access what they need, even large amounts of information.

Database-driven sites allow you to control and change information on your site easily, without any programming knowledge. If you need to update your website frequently, then consider using a database driven website!

Computer Consultants Corporation