ncol

ncol

How do can I filter email addresses in Excel 2007/10

  1. From the Data menu, select Filter and then AutoFilter. This will add a drop-down list box to each of your columns.
  2. Click the down arrow control in the top right of the column containing your email addresses.excelemail1
  3. From the drop-down menu, select (Custom…).excelemail2
  4. In the Custom AutoFilter dialog, enter in two filter criteria using the “does not contain” selection. Make certain to use the Or radio button option.excelemail3
  5.  Click OK.

Once you click OK, Excel will show the emails that don’t have either the @ sign or a period. These are the problem records. You can either delete them or try to make corrections. The rules aren’t perfect as you may still get some incorrect ones slip through such as anne.h@examplecom. In this example, both the period and “at sign” are present, but it is still invalid since a second period is needed between example and com.

After doing this exercise, I did see some other patterns. For example, some people would type some combination of “do not send email”. This tends to happen if the input form doesn’t do field validation. Other times, the reverse would happen where people used “shift 2” or [at] instead of the “@ sign”. This is a tactic some people use online to prevent email bots from scraping their address.

Shamoon virus alert upgraded

http://usat.ly/16ljBjG

Shamoon virus alert upgraded

Virus’ seemingly anti-American creator still at large; copycats are a concern

Blackberry Messenger moves to iPhone and Android

Lots of news around BlackBerry in today’s roundup. Not only is BlackBerry expanding the popular Messenger service as an app for Android and iOS, but it also is giving Messenger a social-media twist with BBM Channel http://news.cnet.com/8301-33692_3-57584462-305/blackberry-messenger-jumps-to-iphone-android/

Thank you!

mainthankyou

We would like to thank the residents of Vance County for voting NCOL.NET best ISP and computer company! We work hard to give our customers the best possible service and always with a smile. Please feel free to contact us at 252-492-4317 or www.ncol.net!

Outlook Web Access with Internet Explorer 10

If you experience issues in Internet Explorer 10 logging in and accessing emails with Outlook Web Access try the following:

Run Outlook Web Access in Internet Explorer compatibility view and see if it helps.

a: Click Tools  present at the top right corner in internet explorer.
b: Now Select Compatilbility view with the Website opened.

Thank goodness for plain old Excel

Google apps work for the average user but for complicated spreadsheets or place with no Internet, thank goodness for plain old Excel. http://news.cnet.com/8301-1023_3-57576290-93/my-google-spreadsheet-fail/

Digital VoIP Phone Systems

Is your business looking to take advantage of the Internet for calls and teleworkers? Do you work from home or remotely and need access to all the features of your office phone system?

NCOL.NET is a licensed and trained partner of Allworx Systems. Allworx phone systems are loaded with features that small businesses need and big businesses take for granted, including features that cost extra on other VOIP hybrid PBX systems. And unlike phone company services such as voicemail or call forwarding, with an Allworx VOIP hybrid phone system, you don’t pay extra every month! With all digital handsets, an web interface for easy adds, moves and changes, Allworx and NCOL.NET can reduce your monthly phone bill and support costs.

http://www.ncol.net/phone-systems-2/

Best tech gifts for mom

http://usat.ly/10wzDEm

Surf report: best tech gifts for Mom

For the lovely woman who always put you first, we have a few gift suggestions.

To view this story, click the link or paste it into your browser.

Snapchat research

http://decipherforensics.com/index.php/blog-landing-page/56-snapchat

Snapchat images recoverable

In the digital world, few things are ever truly deleted or destroyed. Not if you have the money to get them back. That’s why one company is making hay out of a new service Thursday that offers to recover Snapchats — those supposedly self-destructing pics beloved by teens and twentysomethings — from the recipient’s phone. For a cool $300 to $500 per device. http://mashable.com/2013/05/09/snapchat-recovery-android/

Hey, check this out from CNN:

Keep your taxes off my Internet
http://www.cnn.com/2013/05/07/tech/web/internet-sales-tax-comments/index.html

Senator demands DOJ, FBI seek warrants to read e-mail

Last month, Sen. Mark Udall and a handful of other privacy-focused politicians persuaded the IRS to promise to cease warrantless searches of Americans’ private correspondence.

http://news.cnet.com/8301-13578_3-57583743-38/senator-demands-doj-fbi-seek-warrants-to-read-e-mail/

Senator demands DOJ, FBI seek warrants to read e-mail

Last month, Sen. Mark Udall and a handful of other privacy-focused politicians persuaded the IRS to promise to cease warrantless searches of Americans’ private correspondence.

http://news.cnet.com/8301-13578_3-57583743-38/senator-demands-doj-fbi-seek-warrants-to-read-e-mail/

Google Aims To Patent Policy Violation Checker, Potentially Revolutionizing Email Snooping

BEWARE!!! Google Aims To Patent Policy Violation Checker, Potentially Revolutionizing Email Snooping http://huff.to/13ZlQVa

Hey, check this out from CNN:

Smartphone maps behind wheel are illegal?
http://www.cnn.com/2013/04/08/tech/mobile/ban-smartphone-map-apps/index.html

According to a judge in California it is.

A comprehensive guide to Google Analytics

Do you know what’s driving leads/sales to your website? Google Analytics can tell you.
The trouble is many small businesses struggle to get Google Analytics set up, let alone use it to pull out meaningful data. This easy to follow guide will take you through the set-up process and help you understand how your website’s performing.

http://www.simplybusiness.co.uk/microsites/google-analytics-guide/

Symantec – File System Auto-Protect is malfunctioning

File System Auto-Protect is malfunctioning

http://www.symantec.com/docs/TECH102962

symantec

Try these Steps as well.

1) Go to services.msc

2) Stop all the symantec services

3) Open task manager

4) Kill rtvscan.exe and smc.exe

5) Again, restart the service

6) If that does not fix, repairing from add/remove programs should fix the issue.

WordPress Secrets that Enterprise CMS Vendors Don’t Want you to Know

http://inspirationfeed.com/wordpress/tips/wordpress-secrets-that-enterprise-cms-vendors-dont-want-you-to-know/

25+ WordPress Newsletter Plugins

Email marketing may taste a bit old fashion right now when everyone talk about social media marketing. However, it is not to be underestimated and still counts as one of the most important online marketing channels.

http://wpbriefly.com/2013/04/wordpress-newsletter-plugins/

Cyber attack on daily deal site

http://usat.ly/1214yE2 Cyber attack on popular daily deals site The attack impacts 50 million customers of the daily deal site.

5 things this week in tech

http://usat.ly/11ZIg5N

The week in Tech: 5 must-know things

Here’s what you need to know about the week in Tech.

Hackers send bogus tweets from ’60 Minutes’ account

The Twitter accounts for CBS News programs “60 Minutes” and “48 Hours” were used by hackers earlier today to send out messages accusing the U.S. of aiding terrorists, the network confirmed.

http://news.cnet.com/8301-1009_3-57580604-83/hackers-send- bogus-tweets-from-60-minutes-account/

Security certificate problem trips up Bing Web site

A security certificate problem triggered warnings not to use Bing over a secure Web connection Friday, and Microsoft said an issue with network service provider Akamai is to blame.

Browsers displayed prominent error messages and warnings at about 9 a.m.

http://news.cnet.com/8301-1009_3-57580459-83/security-certificate-problem-trips-up-bing-web-site/

eBay CEO enlists users’ aid to defeat online sales tax bill

http://news.cnet.com/8301-1023_3-57580648-93/ebay-ceo-enlists-users-aid-to-defeat-online-sales-tax-bill/

Vudu resets user passwords after hard drives lost in office burglary

Video service Vudu began warning users today that it has instituted a systemwide password reset following an office break-in last month.

A burglary March 24 resulted in the loss of hard drives that contained users’ sensitive personal information, including names, e-mail addresses, postal addresses, phone numbers, account activity, dates of birth, and the last four digits of some credit card numbers, Vudu Chief Technology Officer Prasanna Ganesan informed customers in an e-mail. He said no complete credit card numbers were stolen because the company does not store that information.

http://news.cnet.com/8301-1009_3-57578766-83/vudu-resets-user-passwords-after-hard-drives-lost-in-office-burglary/

Raspberry Pi Inventor Sets Out To Change The World With $25 Mini-Computer: via HuffPost

Raspberry Pi Inventor Sets Out To Change The World With $25 Mini-Computer: via HuffPost

If you ask Eben Upton what he does for a living, he will simply say that he “designs chips,” but with his charity the Raspberry Pi Foundation,he’s actually changing the world — and, in essence, the future.

Upton started his career as a physicist before becoming an engineer, and later a computer scientist. He eventually got his MBA, and in addition to working at companies like Intel, IBM and Broadcom, he became a teacher. That’s when he realized there was a problem

http://huff.to/17gTTYS

Six Android apps you’ll thank me for (you’re welcome)

As a reviewer of Android apps, it’s my role to sniff out what’s hot and interesting on Google Play. I make it a point to try out apps old and new, as well as big-name apps, apps from startup shops, and everything in between.

http://reviews.cnet.com/8301-19736_7-57553312-251/six-android-apps-youll-thank-me-for-youre-welcome/

As PC sales tank, what’s Microsoft’s Plan B?

When market analyst IDC last week noted the sharp 13.9 percent quarterly drop in worldwide PC sales, it placed much of the blame on the “radical” user interface changes of Microsoft’s new Windows 8 operating system.

 

Users the interface bulky and hard to navigate. Was this to radical of a change?

 

http://news.cnet.com/8301-10805_3-57579503-75/as-pc-sales-tank-whats-microsofts-plan-b/

Rule your computer with a laser beam.

Rule your computer with a laser beam http://www.cnn.com/2013/04/12/tech/innovation/orig-ideas-laser-keyboard/index.html

Why You Shouldn’t Upgrade to Windows 8 Yet | TechNewsDaily.com

http://www.technewsdaily.com/8336-windows-8-upgrade-pros-cons.html

5 Windows 8 Apps to Bring Back the Start Menu

http://blog.laptopmag.com/5-windows-8-apps-to-bring-back-the-start-menu

To copy the window or screen contents

To copy the window or screen contents

To make a copy of the active window, press ALT+PRINT SCREEN.
To copy the entire screen as it appears on your monitor, press PRINT SCREEN.

Note

To paste the image into a document, click the Edit menu in the document window, and then click Paste.

See how Group Policies are applied

Run gpresult /v

GPRESULT, or otherwise known as Resultant Set of Policy Queries is a tool used to provide client end information of Group Policy settings.
The utility ships with all current versions of Windows and is used to aid administrators in troubleshooting group policy problems. The policy is very similar between all versions of Windows, however Windows Vista and Windows 7 requires elevation.

The commands below are examples that i use frequently.

Windows XP

This provides verbose log of current logged on user on local PC

1 gpresult /v > gp.txt