Back by Popular Demand: Free 2010 Work Week Calendar This work week calender is based on the badge-sized calendars that my previous employer hands out every year. Please note that this calendar is not ISO 8601 compliant; regardless, you're more than welcome to modify and change the calendar as you see fit. I ...

Wouldn't it be nice if you could export an Excel list of addresses to Google Earth and Google Maps? Thankfully, there are several ways to do this but the only question you need to ask yourself is, "How secure does my data need to be?" Although Google Maps gives you ...

*UPDATE: The calendar has been updated for 2010 and is available for download here: 2010 Work Week Calendar. Several individuals found the 2008 Work Week Calendar useful, so I'm being proactive and posting the 2009 Work Week Calendar a few weeks early. As I mentioned before, this work week calender ...

*UPDATE: The calendar has been updated for 2009 and is available for download here: 2009 Work Week Calendar. Every year, my employer provides badge-sized calendars to help countdown the days until the next holiday. Seeing how giddy my coworkers get when they receive their free calendar, I thought it might ...

Alphabetically sorting a list of names in FirstName LastName format can be simplified by using the Text to Columns wizard in Excel. Unfortunately, you can run into issues when titles, middle names, middle initials, and name suffixes are used. Thankfully, the Team at REsolved LLC sent in this great Excel ...

Here's a relatively simple way to color a cell in Excel using a double-click instead of the toolbar's fill option. The trick is to use some VBA code to color a cell when double clicked then clear it if double clicked again. There are various uses for something ...

Normally, one turns to the line tool in Excel to manually draw vertical lines on a chart. The issue is that these lines aren't bound to the x-axis, so any change to the chart is usually accompanied by manual line repositioning. Thankfully, there's a "hack" that can eliminate ...

As I promised in my previous post, here is part 2 of my 10 Excel Tips to Make Your Life Easier video tutorial. Tip #10 is especially useful if you've ever hated working with strings and string/text functions in Excel. Also, if you haven't had a chance to ...