Author: Dave Farquhar

How to change an AT&T U-Verse wifi password

Dave Farquhar ISPs
How to change an AT&T U-Verse wifi password

AT&T’s default wi-fi passwords aren’t the worst I’ve seen, but they aren’t super-secure either. So here’s how to change an AT&T U-Verse wifi password. The same trick works with AT&T Fiber, since it uses the same residential gateways.

Read more

Is there a virus on my phone?

Dave Farquhar Android, security
Is there a virus on my phone?

Is there a virus on my phone? Or your phone? I can’t know for certain, but probably not. Here’s what to do if your phone says it has a virus and wants you to visit a web page or pay someone money.

I’ll tell you what you really need to do, and I’ll even show you a neat trick so you’ll see fewer of these messages. And none of this will cost you anything, either.

Read more

Does retail count as sales experience?

Dave Farquhar Careers
Does retail count as sales experience?

Does retail count as sales experience? I think it depends, but there are certainly ways you can make it count. Here’s how.

It all begins with knowing the products the store sells, and knowing what makes one product different from another.

Read more

Countif example: Data analysis with Excel

Dave Farquhar Office
Countif example: Data analysis with Excel

The lowly Countif function is one of the most useful tools for data analysis you’ll find in Excel and other spreadsheets. It’s also not all that well understood, I find. Knowing how to use it sure has made my job much easier since 2013, so I think there’s a chance it will help you too. Here’s a Countif example to show you how to use it.

Read more

Inherent risk definition

Dave Farquhar security
Inherent risk definition

Sometimes you’ll hear insurance professionals, banking professionals, computer security professionals, and other people who deal with risk talk about inherent risk and its counterpart, residual risk. If these are unclear to you, or you just need a refresher, you came to the right place. Let’s take a look at a simple inherent risk definition and example, as well as residual risk.

Read more

How to accept all changes in Word

Dave Farquhar Office, Software ,
How to accept all changes in Word

Every couple of months or so, we have to collaborate at work on a Microsoft Word document and submit it without all the distracting markup in it. And it seems like it always takes four of us half an hour to re-figure out how to accept all changes in Word and remove the comments. This applies to Word 2007 and all newer versions.

Sometimes I also find the tracked changes and other markup causes weird problems, and the fastest way to make them go away is to get rid of the markup.

So I figured it might help someone. This is something that either takes you 30 seconds or 30 minutes. If you don’t do this every day, it’s likely to take too long. This is for those of you who can’t do it in less than 30 minutes.
Read more

How to create a stacked bar chart in Excel

Dave Farquhar Office, Software , ,
How to create a stacked bar chart in Excel

My boss’ management is clamoring for metrics. They want to know, at a glance, what we’re doing and how far along we are. Sounds like a job for stacked bar charts in Excel to me. So here’s how to create a stacked bar chart in Excel.

Figuring out a way to track our progress was fairly easy. Figuring out how to make Excel display that chart in a meaningful fashion… Well, that took about five hours. I’ll try to make it easier for you than it was for me.
Read more

CPU vs core, or core vs processor

Dave Farquhar Hardware ,
CPU vs core, or core vs processor

Here’s a good question I heard the other day: What’s the difference between a CPU and cores, or the difference between the number of CPUs and the number of cores in a system? The CPU vs core or core vs processor distinction, it turns out, is subtle.

As far as the operating system is concerned, there is no difference, but I’ll explain why. For you, there might be a difference.

Read more

Wrist pain from typing

Dave Farquhar Health , ,
Wrist pain from typing

I’ve had a long history with wrist pain from typing, brought on by carpal tunnel syndrome or repetitive stress injury. People sometimes as me to elaborate, so I’ll elaborate on beating carpal tunnel. I was able to beat it without surgery, and you may be able to as well.

It’s something I struggled with off and on for a good 10 years. Mostly off, in recent years, which is good. At one point, it was so bad I wasn’t able to unload my dishwasher, because I couldn’t grip the plates long enough. It was career threatening too. Read more

Cleaning NES games and consoles

Dave Farquhar Retro Gaming , , , , , , , , , , , ,
Cleaning NES games and consoles

Anyone old enough to have played with an original Nintendo NES knows the problem: You plug in the cartridge, turn on the system, and get a blank screen and the power light blinks at you. The schoolyard fix is to take out the cartridge, blow into it, then put it back into the system. Then, with a little luck, you can play your game. The trouble is, that’s just a short-term fix. In the long run, it makes the problem worse and eventually the system can’t play games at all. The solution is to clean them. Here’s a process for cleaning NES games.

Read more