|
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.) |
|
Learn more...
|
|
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. |
|
Learn more...
|
|
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) |
|
Learn more...
|
|
Fall is my favorite season and for some reason it brings in the most reader questions. This year is no different except that there was one dominant question that was asked in many ways. It has to do with how to block websites. The interesting part is that no age group or gender was excluded. I’ve got four solutions that don’t require you part with any funds. |
|
Learn more...
|
|
Recently, I attended an industry summit that had an expert’s panel where people provided their best tips. One Excel tip involved filtering cells with a certain number of words. A nice tip, but it left some attendees wondering where Excel’s word count function was. The program doesn’t have this feature, but you can get the answer by creating an Excel formula to count words. (Includes sample Excel worksheet and formula) |
|
Learn more...
|
|
I often get questions from readers asking how to keep current or track certain topics. The answer often depends on what you’re trying to monitor and how you want the alerts. The two free notification services I use are Google Alerts and ZapTXT. |
|
Learn more...
|
|
Sometimes you don’t realize how much you appreciate a feature until it breaks. One example is Outlook hyperlinks in an email. It’s so convenient to click the link in the email and have the correct web page open. What I dislike is when a hyperlink in Outlook doesn’t work and I get some error or no action. Below, I’ve listed 3 solutions to this link problem. |
|
Learn more...
|
|
