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.
Recently I was watching an Excel product review and noticed the author copy Excel values from a formula into another column. This was fine, but then he deleted the column with the formula. Sound familiar? In this tutorial, Ill show you two faster and easier ways to overwrite formulas with their values. (Includes video demo and sample spreadsheet.)
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.
One bad habit I have is letting my Gmail inbox get too big. I don’t always delete emails as fast as I should. These accrued items tend to be non-urgent items I get on a recurring basis that I haven’t flagged as a priority. Eventually, I reach that tipping point and want to delete these Google emails in mass. There are many ways to delete Gmail items, but here’s one tutorial that requires minimal effort and you can do at your own pace.
Life is full of decisions. Some are easy and require little thought while others require more analysis. In many scenarios, Excel can help by creating a weighted decision matrix. You define the ranking criteria, importance and Excel will do the math and pick a winner from your options. Think of it as your own Excel ranking formula. (Includes Excel decision matrix macro.
Browser extensions are great add-ons when they work. But I ran into a problem where one of them continually crashed when I opened Google Chrome. Worse, because it didn’t load properly, I couldn’t uninstall the Chrome extension in the normal manner. Fortunately, there is another solution to this problem.