I am not ashamed to admit that pivot tables terrify me. I love that pivot tables exist and I am just enough of a data geek that I can pivot data until it throws up faster than a toddler with a corn dog. But only if someone builds the initial table for me. Since I only really need to create a pivot table for myself once a year or so, I have to re-learn how to do it every single time. It’s rarely pretty, there is a lot of cursing and more often than not, I call my friend Jane to do it for me because she is an Excel Whisperer.
The same is true of mail merges in Word. Once a year I spend a frustrating morning printing the same address 40 times on a sheet of labels or managing to get different addresses that don’t line up properly, or the damn template goes missing. Usually the whole thing just doesn’t work and I address them by hand. Read the rest of this entry »