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
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
This morning I got an email from John Jantsch asking me if I would let you know of his upcoming workshop he’s doing with the E-Myth folks. John is one of the best small business marketing consultants I know. I was introduced to him by the folks at Sphere when I was doing research for an article on their service. Since then, I’ve been an avid listener to his Small Business Marketing podcast. There are many appealing aspects to this seminar including a timely 25% discount he is extending to readers here.
Continue Reading October 24th, 2008
Have you ever wondered what’s replaced your phonebook? People still have a need to find a business, but the data sources and retrieval methods have changed. If you’ve got a business or non-profit, you might want to look into these local directories. You might think of them as internet yellow pages on steroids. All offer a free listing and many have additional services for a fee. Even if you don’t plan to use the pay services, you should verify your business listing is correct. Otherwise, your competitor may profit. (Includes resource spreadsheet)
Continue Reading October 7th, 2008
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Oct | ||||||
| 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 |