Skip to content

Year: 2012

Secondary axis charts in Excel

If you know what a secondary axis chart is, then you know what a challenge it can be to show disparate values on the same chart. This used to be somewhat cumbersome in older versions of Excel, but with Office 2007 and Office 2010 it’s a piece of cake! For those unfamiliar with the term, a secondary axis is useful when you have to display whole numbers and related percentages, like cost, price and profit percentage.

Keep your comments professional

Keep your comments professional, even during a disagreement by avoiding the phrase, “I couldn’t disagree more.” It makes the discussion a personal attack rather than an idea exchange. Instead, say, “I see your point. I also see another side.”

Get a tidy tax credit for housekeeper

Do you need someone to watch your young kids while you and your spouse work? There are usually several options for double-income couples to consider. Don’t forget to factor in the dependent care credit (commonly referred to as the “child care credit”).

Google offers alternative to Excel

Google Docs’ Gadgets feature gives its spreadsheets an edge on Excel for some tasks. Users can create animated pie charts, produce QR codes and more. Helen Bradley of PCWorld explains how.

New manager squares off with toxic employees

Question: After being promoted to human resources manager, I discovered that I have been assigned to the most toxic division in our agency. The employees here constantly gossip, backbite and complain. I’ve heard that this is why the last HR manager left. I would love to play a major role in “cleaning up” this group, but I have to move carefully.  Some of these people have been here more than 15 years and are protected by civil service regulations.  Any suggestions? HR Crusader