Archive for August, 2014

Job Hunting Tip #18: The Don’ts of Resumes

These four don’ts are the kiss of death on any resume.

1.      Don’t hide important information at the end.    If you graduated Phi Beta Kappa or you won a national championship, don’t list these things under Honors and Awards even if Honors and Awards fall at the end of the standard resume template you’re using.  Make it easy for a recruiter or employer to figure out that you are a superstar.

2.     Don’t overstate your value.  You should be confident; however, don’t let your confidence slip into arrogance.  I generally throw away resumes that state that an entire organization was saved by the 22-year old waiter.

3.     Don’t have typos. Do I even need to remind people that this is a no-no?  You should reread your resume several times as spell-check doesn’t catch the errors like “he” versus “the” or “in” versus “on.”

4.     Don’t be bland.  You get one shot to sell yourself with your resume, so make it count.  Some people worry so much about fitting into the standard resume format that they become one of 100 other resumes that look just alike.  Don’t go crazy and print on perfumed paper, but produce the most professional, eye-appealing resume that you can.  How it looks matters.

Excel Tips: Shading Alternate Rows

Shade Alternate Rows
Looking for a way to simulate that nerdy green-banded computer paper on screen? Look no further. Excel’s Conditional Formatting feature has many uses, and here’s one that’s particularly handy. Conditional Formatting makes it simple to apply cell shading (green or otherwise) to every other row in a worksheet range. For a lengthy list, shading alternate rows can improve legibility.

Here’s how to do it:

•Highlight the range of cells or rows or columns that you want to format.
•Choose Format, Conditional Formatting to display the Conditional Formatting dialog box.
•Select Formula Is from the first drop-down list box, and enter =MOD(ROW(),2)=0 in the second box.
•Click the Format button to bring up the Format Cells dialog box.
•Select the Patterns tab and specify a color for the shaded rows. You’ll probably want to choose a light color, so that the default black text will still be legible. Or, you can go all out and change the text color as well (do this in the Font tab of the Format Cells dialog box). For example, you might select a dark blue background, accompanied by a mellow yellow text color.
•Click OK twice to return to your worksheet.

The best part is that the row shading is dynamic: The alternate row shading persists even if you insert or delete rows within the original range. By the way, if get tired of this new look and want to get things back to normal, just select the range, choose Format, Conditional Formatting, and click the Delete button in the Conditional Formatting dialog box.