Before we dive in...
Excel Macros for Beginners
Allen Wyatt, a friend of mine, has been publishing his ExcelTips newsletter since 1998. If you've ever asked me an Excel question there's a very good chance I've pointed you to his site.
He's opening the doors to his "Excel Macros for Beginners" course today, and it's awesome! He's prepared a free four-video series and overview to the course that you should check out, particularly if you are new to the whole idea of creating your own macros.
Allen's offering "early bird" pricing -- 20% off should you decide to sign up for his course -- for only a limited time. When you register for the course, you get 24/7 access to all materials -- and there's a boat load -- for a full year. Plus, Allen personally provides support for the first 6 weeks of the course.
Check out the course. You've got nothing to lose and an entirely new skillset to gain.
Oh, and in the spirit of full disclosure, you need to know that I do make a small commission if you decide to join Allen's course. Now, you know I don't recommend just anything, and as I said above I've been pointing people at Allen's work for years. His course has the quality and value that makes me very happy to recommend it without hesitation.
Go have a look. Remember that you've only got until May 10th take advantage of the early bird pricing.
Is It Time to Start Using an Adblocker?
One of the positions I've held for as long as Ask Leo! been around is that adblockers are fundamentally wrong. They prevent sites that depend on advertising from making the revenue they need to survive.
Let's be clear about one thing up front: this isn't about greed. This is about survival. Many useful websites exist solely because of the advertising revenue they're able generate. If that goes away, the sites go away. Rarely does advertising on small- and medium-sized sites cover more than the basic costs.
If you consider viewing advertisements the "cost" of consuming the content you want for free, then blocking those ads can rightfully be considered theft. You're using the content without paying the price.
That's been my position for years.
But, at the risk of being hypocritical, I'm starting to change my mind. And the advertisers have no one to blame but themselves.
Success is their downfall
My position to date has been that if you don't like the advertisements on a site, then don't visit that site. "Vote with your feet." Go to another site that has less annoying ads, or pay for a site that has as an option to remove ads1.
There are sites with useful information that I don't visit, reference, or point people to, simply because the advertising on those sites is so bad.
However, voting with your feet doesn't solve the underlying problem. Because ads are so ubiquitous, so many web sites use the same ad networks, and so many ad networks use the same techniques, it's become nearly impossible to find alternative sites that actually meet the criteria of less-annoying ads.
You can run, but you can't hide.
Manipulation is their downfall
For many years, one of the techniques used by advertisers in the tech space was to make their ads look like download buttons. Visit a site to get the latest download of your favorite image-burning software, and you'll see half a dozen nearly indistinguishable DOWNLOAD buttons, only one of which is the "real" download button you want. The rest? Ads.
My sense is that this has improved somewhat, but the problem remains: ads don't always look like ads. They try to manipulate visitors into thinking the ad is part of the content. This is why it's important to learn to recognize ads.
Manipulation also appears in another guise called "sponsored content". This is content someone pays to place on a web site.2 Sometimes it's obvious, but often it's indistinguishable from the site's own content. What you think is a legitimate recommendation or evaluation of a product may really be an article written by that product's creator. In other words, it might be an ad.
Tracking is their downfall
As long-time readers know, I'm not terribly concerned about the tracking that results in ads "following me" around the internet. But I know they concern some. To many, it feels like an invasion of privacy, and to others, it just feels creepy.
The problem, of course, is that the technique works. Ads that follow people are effective. And because they're effective, more and more advertisers and advertising networks use the technique to sell more of whatever it is they're selling. As more and more advertisers use it, more and more ads start "following" you. Even though it really is benign, the result is that the internet feels creepier and creepier.
As an advertising-supported site, it also means I have even less control over what ads appear here. The ads that "follow" you might have nothing to do with technology, or anything I've ever even heard of. You may see ads here for all manner of things, for good or bad.
Malware is their downfall
Honestly, the final straw breaking my adblocking back is malware. It doesn't happen often, but we've definitely heard of situations where an ad isn't an ad at all, but rather a conduit for installing malware on your machine.
This can happen for either of two reasons:
- An advertising network, or the software it uses to display ads on your machine, gets hacked into displaying malicious ads.
- An advertising network has insufficient safeguards in place, and advertisers are unintentionally allowed to display ads that are malicious.
The reason this concerns me is not because it's common — it's not — but that it's almost completely out of your control.
I've long taught that you can't get into trouble if you only visit reputable sites. But now, if that site happens to use an ad network that's somehow compromised, that's simply not true. And there's no way to know beforehand.
My Ask Leo! compromise
As a website owner, I know adblockers are inevitable, and in the face of malware, they're more and more difficult to argue against.
If you visit Ask Leo! with an adblocker turned on, in place of the ads I normally use to pay for the site from Google's Adsense program3, you'll see a static image asking you to consider becoming a patron to help support the site.
I know other sites – particularly news sites – get more aggressive, often showing a pop-up to visitors using an adblocker. I've seen a handful go so far as to actually block access completely if you're using an adblocker.
How do I know this?
Because for the last few months I've been test-driving an adblocker.
What adblocker to use?
I really, really, wanted to be able to use Privacy Badger from the Electronic Frontier Foundation. As its name implies, it's focused not on ad blocking, but on maintaining your privacy. Its approach is heuristic, meaning it looks for website behavior that looks like tracking and blocks it. As it turns out, there's a high degree of overlap between advertising and tracking techniques, so it functions as a relatively effective ad blocker as well.
Sadly, it's pretty close to an everything-blocker or everything-breaker. The problem is that Privacy Badger is quite aggressive, and many techniques used to detect tracking are valid for other purposes as well. For example, a technique I use here on Ask Leo! — to speed up the site by using a content delivery network — is detected as tracking by Privacy Badger. As a result, visiting Ask Leo! would result in a jumbled mess on your screen.
Yes, you can whitelist things, but so many sites break, and it's such a frustrating exercise to try and figure out what to whitelist (would you know to whitelist med.askleomedia.com and img.askleomedia.com to get Ask Leo! to work?), Privacy Badger is simply a non-starter for the average computer user.
Give it a try if you like, but expect lots of things to break.
What I've settled on is uBlock Origin (not to be confused with uBlock). Technically, it's not "just" an adblocker; in their words, it's "… a wide-spectrum blocker … default behavior of uBlock Origin when newly installed is to block ads, trackers and malware sites". It's a browser add-on that runs quietly in the background as web pages are displayed. It's lightweight, has a good reputation, and doesn't break too much.
Unfortunately, it does break some things. But the mechanism to whitelist, or temporarily whitelist, a site in order to make it work is simple and effective. (Click the uBlock Origin icon in the browser, and then click an "off" icon.) And it's quite configurable.
More to the point, after running it for a couple of months (in Google Chrome, but there are versions for FireFox as well) my browsing experience was not seriously impacted, except for the occasional "we see you're using an adblocker" message. Rarely did I need to whitelist a site I was visiting, and that was easy and quick.
Where do we go from here?
Internet advertising is broken.
Between sites plastered with ads, the perception of privacy issues, misleading and manipulative advertisements, and the risk — however small — of malware, it's hard to say anything else.
Advertising has also enabled the varied and rich experience that is the internet today. Without ads, a significant number of the sites you rely on daily — perhaps even most of them — simply wouldn't exist.
As a website owner, I have to be pragmatic to keep my site and service afloat. Ads allowed Ask Leo! to come into being, and ads in some form will certainly be here as long as I can envision. At the same time, I'm not taking any draconian actions against those who choose to use adblockers — I get it, I really do. In my case, I simply explore other ways to pay the bills, be it books, services, or direct patronage.4
As an internet user, I've become much less averse to financially supporting the sites and services I use that give me value. Be it subscriptions, purchases, or patronage, I believe it's important to put my money where my mouth is. If advertising is broken — and it is — then these same sites and services are almost certainly dealing with the same kinds of issues I am.
I know how the sausage is made, and it takes money to turn the crank.
Related Links & Comments: Is It Time to Start Using an Adblocker?
My favorite mount:
Wuteku UltraSlim Magnetic Cell Phone Holder
How Does Secure Delete Work?
We've long been told that when a file is deleted, its contents are not actually removed. Instead, the space the file formerly occupied is marked as "available" for another file to be written to later. Until that overwrite happens, the original, deleted information is still there.
This is the basis for many undelete and other data-recovery utilities. It's also why most of those utilities recommend you stop using your disk if you accidentally delete something.
But what if you really want it gone? That's where a technique called "secure delete" comes into play.
Continue Reading: How Does Secure Delete Work?
Are There Hidden Files that Save Every Keystroke I've Ever Typed?
This is a relatively persistent family of questions that comes around from time to time, particularly in times of concern about individual privacy.
There are several misconceptions in the question.
Further, those misconceptions are based on kernels of truth, which means I can't just say "that's wrong"; instead, it's more a case of "it's not like that — it's like this".
Let's see if I can clear up the confusion. To do so, we'll need to talk about keystrokes, loggers, hidden files, erasing files, and really erasing files.
Continue Reading: Are There Hidden Files that Save Every Keystroke I've Ever Typed?
The Ask Leo! Tip of the Day
A feature exclusively available to Ask Leo! Patrons Bronze level & above.
- Tip of the Day: "They" Will Never Call You
- Tip of the Day: Copy Only Updated Files Using XCOPY
- Tip of the Day: Minimize and Restore Programs Quickly Using the Taskbar
- Tip of the Day: Windows Calculator
- Tip of the Day: Selectively Delete Cookies Using CCleaner
- Tip of the Day: Using Quotes in Search
- Tip of the Day: Take Microsoft Updates Too
More Ask Leo!
Become a Patron
Books - Business - Glossary
Facebook - YouTube - More..
Leo's Other Projects....HeroicStories Since 1999, HeroicStories brings diverse, international voices to the world ' reminding us that people are good, that individuals and individual action matter. Stories - new and old - are published twice a week.
Not All News Is Bad - Each day I look for one story in the current news of the day with a positive bent. Just one. And I share it.
leo.notenboom.org - My personal blog. Part writing exercise, part ranting platform, it's where I write about anything and everything and nothing at all.
Help Ask Leo! Just forward this message, in its entirety (but without your unsubscribe link below) to your friends. Or, just point them at https://newsletter.askleo.com for their own FREE subscription!
Newsletter contents Copyright © 2017,
Leo A. Notenboom & Puget Sound Software, LLC.
Ask Leo! is a registered trademark ® of Puget Sound Software, LLC