I know we’re sick of security warnings, myself included. But have you ever thought of your printer as a security threat? A recent article by Tenable, a network security firm, referenced some unexpected issues with a line of Hewlett-Packard (HP) printers including the default settings. Regardless of your brand, I would be inclined to check your printer settings. The reason is that automatic updates may not be enabled.
VLOOKUP is one of the most popular spreadsheet functions with spreadsheet wizards. It allows you to lookup needed values and use them elsewhere in your spreadsheet. This tutorial will show you step-by-step how to use the function with the accompanying file.
Many of us have been conditioned to block pop-ups in our web browsers. I do this because most of them are intrusive and hinder me from reading. The problem is sometimes you need pop-ups as they are part of the site. This happened to me when I was going through an online course. Fortunately, Google has a way to selectively allow pop-ups in these cases.
We’re living in an interconnected world which offers a lot of conveniences. We can use Google, Facebook, OAuth to connect us to online services and apps. The downside is that there are more “bad actors” trying to trick us and gain access to our info.
Ever had one of those great photos that you wanted to share or upload only to find out there was a file size restriction? Your grand photo was too big. Professional photographers and designers know how to get around these barriers, but for others, this can be a nightmare. Fortunately, there are some easy and free online resources that reduce image file sizes.
This Excel tutorial shows you how to build a worksheet using dependent lists. In other words, the selection you make from one list defines the options on the next list. For example, if you select California from one list, the next list filters your selection to just California agents. Includes sample Excel worksheet.
Recently, I met a friend who looked stressed. He returned home from work only to find out that someone had broken into his online accounts. Naturally, he was concerned about the data, but also the amount of time it would take to fix the problem. I told him an easy way to reduce the risk of account breaches is to use something called “two factor authentication” or 2FA. But, it has some issues if you’re not careful.
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.)
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.
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.