Have you ever received an Excel file and wondered how it was filtered without checking each column’s data filter? Or, maybe you needed to send a file and show your filters. That was a problem I faced recently when I started with a list of 3200 non-profits for the county. I needed a way for the recipients to see my autofilter criteria at a glance. (Includes Excel lesson file and code.)
Continue Reading November 17th, 2008
This is pretty funny.
[via EngadgetHD]
Continue Reading November 6th, 2008
When doing some resource planning with colleagues, I noticed that my Outlook 2007 Calendar didn’t show any holidays. For this project, I needed to see US and Canadian holidays, but they were missing. Fortunately, I was able to quickly add these items for the next 4 years.
Continue Reading November 5th, 2008
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Oct | Dec » | |||||
| 1 | 2 | |||||
| 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| 10 | 11 | 12 | 13 | 14 | 15 | 16 |
| 17 | 18 | 19 | 20 | 21 | 22 | 23 |
| 24 | 25 | 26 | 27 | 28 | 29 | 30 |