Fake virus alerts that appear in your web browser appear to be on the rise. The objective of these alerts is to have you buy a service you don’t need. There are ways you can spot these annoyances and get rid of them.
Recently, a friend asked about fixing an Excel spreadsheet where the subscriber name was in 1 column. He wanted the name separated so he could send a personalized mailing. This is not the first time this question has arisen. The key to solving this problem is to parse or split the data using the Text to Columns feature.
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.)
Sometimes it’s too easy to rely on built-in proofing tools to catch mistakes. Spellcheckers are great for misspelling, but what if your typo resulted in a word that is spelled correctly? There is a feature in Microsoft Word that can help prevent embarrassing mistakes.
Excel allows you to sort you sheet by lots of ways. One less obvious way is to sort items by color. This is handy if you apply a background color to a cell or different font color. This tutorial explains how to do the sort.
Do you find you’re seeing more browser push notifications? Some of these are quite useful, but others are a result of me clicking to allow something in my haste. This week, I hit the tipping point. Each time the little box would push out from the right side of Chrome, I’d want to smack it. While that might make me feel good, the better solution was to change my browser settings.
Have you ever had one of those days where you couldn’t remember what you just read? Or, you find yourself working longer, but your productivity is declining. There are many reasons why we’re not effective. Currently, I’ve been bombarded by distracting construction noise. It’s not easy to control your work environment, but one helpful service I found is called Focus@Will.
Ever had the situation where you need to go back to a web page you visited but can’t recall the URL or site? This happened to me this week. I knew the site name, but not the specific page. My attempts to find it using the site’s search didn’t work well. I couldn’t recall the right words and got too many results. And then I remembered I could find the page using my browser history.
Today, many of us are time-starved. We have too many things to do coupled with too many distractions. This can be a hindrance to learning. It’s at these times that we look for solutions that help us stay even or ahead. One problem area for me was reading. I didn’t want to give it up, but I felt like I didn’t always have time to complete a book, let alone process it.
Snagit is an exceptional and reasonably priced screen capture program that works on many platforms including mobile. It fits the sweet spot between simple graphic programs that don’t allow enough features and very expensive programs that add overhead and expense.