[June 1, 2010]

I had the occasion recently to visit my old grade school which will be closing at the end of the school year. What a walk down memory lane! My how we have progressed! Computer labs and art centers, music rooms and bands! It made me feel good that the children are receiving a better education that I got although I had the best that was available in my day. That tour through my old grade school made me ponder all the advances that come with time and technology. I resolved to try and stay ahead of the curve with it as much as I am able. Time is such a precious commodity; we are constantly trying to cram everything in that we can! This life on earth is but temporary and I will try do learn and do as much as I can along the journey.

I am happy to report that I have been keeping my resolution about exercise. I have been averaging between six and twelve thousand steps a day. My favorite part of the day is my early morning walk - what a great way to start your day before all the rushing and hustle and bustle.

The quote for the day is: Savor your friends and friendships; you never know when you will lose one...

Please join me now in welcoming Pearl, Steven, James, Stephen S., Edwin, Dennis, and Susan, as the latest premium subscribers to Carol's Word Bytes Newsletter. Welcome to the family! If you know someone who struggles with an application in Microsoft Office, like Word or Excel, do them a favor and tell them about our newsletter. They will always thank you for it!

Let's get to the tips now!

Carol's Signature

Table of Contents

Tell a Story With Pictures in MS Excel 2007 - Have it your Way!

Edit Sticky Notes in Adobe Acrobat 9 - So easy!

Find Duplicate Records in MS Access - Why waste time with doubles?

Word 2007 audio course buy word 2007 audio course

Tell a Story With Pictures in MS Excel 2007

One of the most dramatic additions to MS Excel 2007's Conditional Formatting menu is icon sets. These icon are pictures that you can assign to data values for quick data analysis. The icons range from stop lights to flags to check marks and x's.

Suppose you want to set up an icon set that only values greater than or equal to 100 display an icon.

Follow the steps below to learn how:

  1. Select the cells.
  2. Click on Home | Styles | Conditional Formatting | Icon Sets.
  3. Select any icon set.
  4. With the range selected, click Home | Styles | Conditional Formatting | Manage Rules.
  5. MS Excel will display its Conditional Formatting Rules Manager dialog box.
  6. Click Edit Rule to display the Edit Formatting Rule dialog box.
  7. Change the first icon setting to When Value Is >= 100 and specify Number as the Type.
  8. Leave the other icon settings as they are.
  9. Click OK.
  10. Click New Rule and choose this rule type: Format Only Cells That Contain.
  11. In the bottom section of the dialog box, specify Cell Value Less Than 100.
  12. Click OK.
  13. Place a check mark next to Stop If True for the first rule.
  14. Click OK.

The first rule checks to see whether the value is less than 100. If so, rule checking stops, and no conditional formatting is applied. If the value is greater than or equal to 100, the second rule applies. This rule indicates that values greater than or equal to 100 are displayed with an icon.

Pretty cool huh?

Return to Table of Contents

LaptopToys.net
Laptop Toys - Laptop Cooling

Edit Sticky Notes in Adobe Acrobat 9

To edit a sticky note in Acrobat 9, follow the steps below:

  1. Click or double-click the note icon to open the pop-up window.
  2. Edit your text to your liking.
  3. When you are finished, click the Close box in the upper-right corner of the pop-up window or click anywhere outside the pop-up window.
  4. Use the Properties toolbar or the shortcut Ctrl + E to change the text formatting, color and any other note properties.

It is a fairly straightforward task.

Bookmark and Share

Return to Table of Contents

Find Duplicate Records in MS Access

Follow the steps below to learn how to find duplicate records in your MS Access database:

  1. Click the Create tab.
  2. Click Query Wizard.
  3. Click Find Duplicates Query Wizard.
  4. Click OK.
  5. Click the table in which you want to find duplicate information.
  6. Click Next.
  7. Click the field that might contain duplicate information.
  8. Click Add.
  9. Repeate steps 7 and 8 to add any other fields you wish to the query.
  10. Click Next.
  11. Click any other field to display in the query results.
  12. Click Add.
  13. Repeat steps 11 and 12 as necessary.
  14. Click Next.
  15. Key in a name for the query.
  16. Click Finish.

There you have it!

Bookmark and Share

Return to Table of Contents

Included in the Premium Newsletter:

  • Display Column Headers on a Slant in MS Excel
  • Create Contacts from a Distribution List in MS Outlook
  • Find and Replace Trick to Add Text in MS Word
  • Linking MS Outlook Items
  • Reset Spelling and Grammar Check in MS Word
  • Use the Scroll Button on your Mouse for History

Shouldn't you be a premium subscriber?? With a premium subscription, you get more than double the content and NO advertising! Plus, most instructions come with clear screenshots! With your premium subscription you also receive access to an archive of five years of newsletters and deep discounts on all books and tutorials I publish!! So what are you waiting for? Sign up today!

Carol's Corner Office members receive the premium edition of the Word Bytes Newsletter. To become a member click HERE.