The Zip Code Conundrum

  • September 09, 2013

In Excel, when you have a 0-first digit zip code, it usually shows up as only the last four digits. So, take a Massachusetts zip code like 02201. If you just type that...

Color code legend in Excel

  • July 05, 2013

Q. I’d like to provide a “legend” so people know what the different Conditional Formatting colors mean in Excel. How can I do this?

OneNote for Projects

  • June 24, 2013

We all manage projects of one type of another. Some of us have the advantage of sophisticated software to manage resources, timelines and scheduling. For those of us...

OneNote for Event Collaboration

  • April 30, 2013

It is three days before the event. You are frantically trying to gather attendee lists, catering orders, room arrangements, speaker itineraries, agendas, presentation...

It’s a Date: Excel Meets the Calendar

  • March 05, 2013

There are some powerful math features in Excel that can help you with your date data. First, let's take a look at how Excel interprets dates ...

SharePoint Implementation Approach: Wave Off!

  • February 04, 2013

A successful SharePoint implementation has three characteristics, while other approaches to the project of making it your company's intranet solution can end in doom....

Handy Tips for Handouts

  • January 21, 2013

When most people think about creating handouts for a PowerPoint presentation, they think simply about printing copies of their slides, 1, 2 or 3 per page with...

5 Year-End Outlook Clean-Up Tips

  • November 26, 2012

Delete Fearlessly! Sort by sender, subject or organize by conversation. Delete those that are purely social. Even if you spend 5 minutes a day until the end of the...