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?

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...

How to Pivot a Pivot

  • October 15, 2012

For those with nice clean simple datasets to work with, this might seem like a silly thing to want to do. For those of us who deal with some monster-sized data exports,...