One of my favorite quotes comes from Yogi Berra who said “You can observe a lot by just watching”. In this case, I was watching someone work with Excel and doing various tips to make the spreadsheet more usable. In fact, I’ve written about many of those tips. I suggested to my co-worker that he could reduce steps by using Excel Tables. And no, I’m not talking about pivot tables but something simpler and equally powerful. (Includes sample Excel file.)
Back in the old internet days, people rarely changed email addresses. Today is a different story with people changing jobs and having multiple email addresses. Sometimes email programs don’t want to let go of the old addresses and keep displaying them for us, which can present problems. I’ll skip the embarrassing parts and show you an easy way to remove stale addresses from the Google’s auto-complete list.
I recently attended a meeting where an agenda item was to review a Microsoft PowerPoint presentation. One bullet point showed a daily cost of 37 cents. Several people wanted the bullet point to show 37¢. Others commented that there is no way to use these symbols as the cents sign since they weren’t on your computer keyboard. This got me thinking about the different methods you can insert special characters in Windows .