Jan 23, 2008
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 be a good idea to give all readers of this blog a similar gift!
First, some bad news...
Since ...
Dec 24, 2007
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 ...
Nov 6, 2007
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 ...
Jun 8, 2007
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 ...
Dec 23, 2006
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 ...
Dec 21, 2006
An average day for me goes something like this:
Roll out of bed, shower, then rush to work like a bat out of hell.
Get to work and start my computer, then open up Excel and work on a spreadsheet.
Head out for lunch around Noon.
Get back to the office, then open up ...