CCC Newsletter

TIPS AND TRICKS

Copy Excel 2007 Cell Contents, Not Formulas

When you need cell values generated by formulas in a different worksheet, copying the values often result in reference errors (#REF!) because the formula can no longer find the cells with the original values they work from. For this and other similar predicaments, Excel 2007 allows you to copy the cell values without the related formula:

On the worksheet, select the cells that contain the resulting values you want to copy.
Click on the Copy icon on the Home tab of the Clipboard group.
Select the upper left cell of the area you want to paste the values. Make sure to click to another worksheet tab or another workbook if this is where you need the values to be.
Click on the Paste icon and then Paste Values on the Home tab of the Clipboard group.

You now have the values you need without the confused formulas giving you reference errors!

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.

ADOBE CREATIVE SUITE 3

Adobe Flash CS3 is Still the Champ!

With Flash CS3 now part of the Adobe family, new features and improvements keeps it the best choice for professional vector software for the Web:

Improved integration with Adobe design tools. Import Photoshop and Illustrator files and images into Flash CS3 without needing to convert and name a layer at a time. Flash recognizes Photoshop’s and Illustrator’s layers and symbols and keeps text editable.
A more customizable interface. Flash CS3 menus can be fully expanded, reduced to icon and name, or shrunk to icon only. Choose where to dock the timeline and other panels, or let them float outside the main Flash window while you drag features into the toolbar.
A zippier Flash Player 9. Adobe says Flash Player 9 is 100 times faster than its predecessor, allowing videos and animation to load in less time!
New Java-based compiler and debugger. No need to hunt for your errors—click on a trouble spot in the Compile Errors panel and it takes you straight to the problem code!

Try Flash CS3 and enjoy its new features, including Device Central, which previews how Flash files will run on mobile phones, PDAs, web sites, and other devices!

ANNIVERSARY CELEBRATION

Celebrating 5 Years as a Team!

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

WEBSITE MANAGEMENT

Are DWTs Right for Your Site?

Dynamic Web Templates (DWTs) allow you to create multiple web pages that share the same underlying layout. They allow you to manage your site’s layout, colors and overall design and may be helpful based on your site’s characteristics:

Site-wide changes are done regularly. If you want the option to make site-wide changes without rebuilding from scratch, DWTs can get the job done quickly. Just add a new DWT and change your site’s base layout.
End users regularly make content changes to your site. If multiple authors contribute site content, a DWT will let them add content without impacting the layout and design.
Global changes that affect every page and have to be done quickly. When a change needs to appear on each page (i.e. disclaimers, new taglines, and copyright statements), just change the DWT and the changes will appear.

DWTs can be a great way to manage changes on your site. Check with your CCC specialist to learn if it is the right approach for your organization.

Computer Consultants Corporation