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.
As the holidays approach, I’m getting requests from readers for gift ideas. Instead of doing one-off replies, I thought I would publicly answer. Most people probably expect me to answer with some sort of cool gadget or tech toys. But sometimes the best gifts are the ones that better you. And I’ve got three recommendations, but one is expiring.
Calm is a mindfulness app that introduces you to meditation through a wide variety of audio programs and guides. The service is available through the web or a dedicated app for Android and iOS. Additional programs and features are available for paid subscriptions.
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.
SSD got my interest several years ago when my web host started switching from traditional hard disk drives (HDD) to the newer solid state drives. Despite the expense, they realized the advantages outweighed the disadvantages. There were 4 benefits I could see by switching. Overall, the project took less than an hour if you exclude the cloning time.
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.
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.)
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.
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.