To sum by color in Excel 2013 (and previous versions) you must create a VBA Module. Don’t worry, it sounds scarier than it is. Follow these steps to create a new function called SumByColor to your workbook. Press ALT+F11 to open Visual Basic for Applications Click Insert | Module Paste in the following code: Function…

I had a document full of employment start dates in column “A” and end dates in column “B”. Wanted column “C” to calculate length of time in the following format: “1 Year, 2 Months, 3 Days”. I didn’t find a function for it in Excel (I even searched in “Help”). So, I did it the hard way:…

I got my PSP for free BECAUSE it looked like the one above. What happened is that it got sat on, dropped or something like that. I saved it from the trash can, spent $25 on a new screen, and became the owner of a PSP. Yay! I’ll explain exactly how to fix it. It’s…

I broke my car window a couple years ago. Well, first the button to make it go up and down broke. I didn’t know that at the time. So, I brought it to my local Ford dealership and asked if they’d look at it. They said “Sure, it’ll be $180 to diagnose it and at…