You are here

news aggregator

Excel functions: 7 ways to use Text functions to manage data

PC World - Thu, 2017-12-14 06:30

Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources. Fortunately, all ASCII data is easily imported, but the format of that imported data can vary drastically from one source to another.

For example, fields may be delimited, such as  with tabs, spaces, commas, or periods. Aany other characters are all preferable to spaces. That’s because spaces not only exist in between fields, they also separate words within the fields, which makes sorting out the fields a real challenge. That’s where the following Text functions are very helpful.

A. Use the SUBSTITUTE function to replace one string of text with another

Function syntax: The syntax (or sentence structure) of the SUBSTITUTE function is this:

To read this article in full, please click here

Verizon's free NFL streaming deal is good for cord cutters—but there's a catch

PC World - Thu, 2017-12-14 06:00
NFL games will be free to stream on smartphones next year, but watching on TV could still cost you.

Verizon's free NFL streaming deal is good for cord cutters—but there's a catch

Mac World - Thu, 2017-12-14 06:00
NFL games will be free to stream on smartphones next year, but watching on TV could still cost you.

Best iPhone: How to pick the perfect iPhone for you

Mac World - Wed, 2017-12-13 17:34

This guide was most recently updated on December 13, 2017.

Picking out an iPhone used to be easier—just get the newest one with all the storage you can afford. We still recommend plenty of storage, but the choice of which iPhone to get it on isn’t quite so cut-and-dry. Do you want the phone with the best camera, the one with the lowest starting price, or maybe just one with a headphone jack?

There's another major factor that will influence what iPhone you should buy: Apple's latest iPhone release included three (!!!) new models to choose from: The iPhone 8 and 8 Plus (which went on sale on September 22, 2017), and the iPhone X (which landed in stores six weeks later).

To read this article in full, please click here

Microsoft's path to a smarter Bing and Cortana includes tapping Reddit users' opinions

PC World - Wed, 2017-12-13 17:30

Microsoft’s Bing search engine and Cortana digital assistant might not change that much from day to day, but behind the scenes they’re getting smarter—integrating factual insights from more sources, including the opinions of Reddit users.

At an AI-focused event in San Francisco, Microsoft showed off a number of improvements, all geared towards increasing the “intelligence” of Bing, Cortana, and Microsoft Office. 

Why this matters: Calling out some of these behind-the-scenes upgrades helps Microsoft demonstrate its unique attributes, and thus relevance, among the competing AI-based platforms of Amazon, Apple, and Google.

Microsoft

Bing already lets you comparison shop for similar items across the web. Now you can isolate an object in a photo and shop for it.

To read this article in full, please click here

BuyDig has a 27-inch 4K monitor with FreeSync for $350

PC World - Wed, 2017-12-13 14:24

This holiday season you can give the gift of 4K FreeSync gaming, thanks to a deal at BuyDig today. The online retailer is selling the HP Envy 27-inch 4K monitor for $350 when you use coupon code c11710154586 (via SlickDeals).

This IPS display has a 4K UHD resolution of 3840x2160, a 60Hz refresh rate, and a native response time of 14 milliseconds. On the back, it has one DisplayPort 1.2, one HDMI 2.0, one HDMI 1.4, and one USB-C port. It also has a "micro-edge bezel" to minimize distractions for gamers who go for multi-monitor setups.

To read this article in full, please click here

BrandPost: macOS – A Carrier for Windows Viruses

Mac World - Wed, 2017-12-13 13:56

Remember Apple’s infamous “Get a Mac” campaign? If not, you’re not alone. Things have changed a lot since Apple could use malware to capitalize on the higher vulnerability of regular PCs. Today, Mac antivirus software is not only abundant, it’s necessary!

The age-old myth that Macs are immune to malware no longer holds water for two main reasons:

1) With the rising popularity of the iPhone (iOS), the Apple ecosystem has increased tremendously, prompting cybercriminals to also set their sights on Mac users.

2)  Platform-agnostic schemes such as, fraud, spam, and phishing scams are targeting every type of device, from computers, to tablets and smartphones.

To read this article in full, please click here

Try VR for cheap: Windows Mixed Reality headsets are on sale for nearly half off today

PC World - Wed, 2017-12-13 09:27

If you’re interested in trying out Windows Mixed Reality headsets, the time is now. They’re basically half off on the eighth day of Microsoft’s 12 Days of Deals, with savings up to $200 on three separate headsets.

The Acer Windows Mixed Reality Headset (normally $399, now $199), the HP Windows Mixed Reality Headset (normally $449, now $249), and the Lenovo Explorer Windows Mixed Reality Headset (normally $399, now $199) are at heavy discounts. The higher-resolution Samsung HMD Odyssey Windows Mixed Reality Headset still commands a premium. It’s on sale too, but only $50 off at $449. All of the deals include a pair of bundled controllers.

To read this article in full, please click here

Amplify your team's productivity with Droplr Pro -- now over 90% off

Mac World - Wed, 2017-12-13 09:08

Working remotely has grown in popularity among teams in the workplace, but it's not exactly perfect—especially in the realm of communication. Thankfully, Droplr Pro exists to fill in the gaps and keep your team on the same page, and you can get up to three users access for life for over 90 percent off the usual price.

With Droplr, you can streamline communication by simply capturing a screenshot of whatever you're working on, add comments, and send it in a short link (Drop) to your intended recipient—all in a single interface. You can record and share .gifs to show users how to perform a particular task, and you can use the new Boards feature to create and share tasks with team members around concepts, ideas, projects, and more.

To read this article in full, please click here

Pay what you want for 65+ hours of in-depth ethical hacking training

PC World - Wed, 2017-12-13 09:03

Cybercriminals are getting smarter, and companies and individuals alike stand to lose in the event of a cyberattack. That's why demand for ethical, or white hat, hackers is skyrocketing. Skilled in the ways of breaching networks and stealing information, these experts use their knowledge for good—safeguarding networks from attack and keeping everyday users safe. And with the Pay What You Want: The Ultimate White Hat Hacker 2018 Bundle, you can become one for a price you get to choose. 

To read this article in full, please click here

New Amazon Echo Discounted $20 Right Now - Deal Alert

Mac World - Wed, 2017-12-13 08:59

Amazon has a discount of $20 active right now on their all new Echo smart speaker, which features a new speaker, new design, and is available in a range of styles including fabrics and wood veneers. Echo connects to Alexa to play music, make calls, set alarms and timers, ask questions, control smart home devices, and more --
instantly. Echo averages 4 out of 5 stars on Amazon from over 2,200 reviewers, and with the current discount you can grab it for yourself (or someone else) now for just $79.99. See the discounted Echo deal now on Amazon.

To read this article in full, please click here

New Amazon Echo Discounted $20 Right Now - Deal Alert

PC World - Wed, 2017-12-13 08:59

Amazon has a discount of $20 active right now on their all new Echo smart speaker, which features a new speaker, new design, and is available in a range of styles including fabrics and wood veneers. Echo connects to Alexa to play music, make calls, set alarms and timers, ask questions, control smart home devices, and more --
instantly. Echo averages 4 out of 5 stars on Amazon from over 2,200 reviewers, and with the current discount you can grab it for yourself (or someone else) now for just $79.99. See the discounted Echo deal now on Amazon.

To read this article in full, please click here

Apple Photos: What do you need to do to get People to sync?

Mac World - Wed, 2017-12-13 08:00

Apple promised that when we identified people in Photos in iOS 10 or macOS 10.12 Sierra, it would sync and merge this special album’s contents across all our linked devices. Oops! Well, it finally made it into iOS 11 and High Sierra, at least.

Macworld reader Gerry was looking forward to this working, but finds that his various devices never sync up, no matter how long he takes or how much he observes the Photos’ apps instructions to wait.

However, Gerry doesn’t use iCloud Photo Library. He says, “If iCloud Photo Library is required, then nuts!” Have some pistachios, because that feature is required. On every device on which iCloud Photo Library is enabled and you’re connected with the same iCloud account, Apple passes various information related to photos and videos.

To read this article in full, please click here

Should you buy an iMac Pro? Here are the reasons why and why not

Mac World - Wed, 2017-12-13 07:00

Apple’s sure-sellers for the holiday season have been on store shelves for a while now, but for fans of high-powered Macs, Christmas comes early this week with the release of the iMac Pro on Thursday. It’s undoubtedly going to take the crown as the most powerful Mac ever made--and will undoubtedly hold onto that distinction until a new Mac Pro arrives on the scene.

There’s a lot to be said for the iMac Pro. It’s the first Mac with workstation-level processors with a plethora of processor cores (8 and up!) since the Mac Pro in 2013. The Radeon Pro Vega is the most powerful graphic processor ever in a Mac.

If you’re someone who uses a 5K iMac to get work done today, should you consider buying the iMac Pro or not? Here’s a list of reasons why you should--and also a few reasons you might want to keep that credit card in your pocket.

To read this article in full, please click here

MX Sound 2.0 Bluetooth Speakers review: premium PC speakers burdened by average audio

PC World - Wed, 2017-12-13 06:30

Logitech’s MX Sound 2.0 Bluetooth speakers join products including the MX Master mouse, Craft keyboard, and Brio webcam in the company’s premium computer accessory line. At $99, they’re a not-unreasonable upgrade over your PC’s speakers that can double as audio output for your mobile devices, but ultimately their sound performance left us a bit underwhelmed.

Though they’re described as Bluetooth speakers, they are clearly designed for the desktop. Each of the 6.3 x 6.3 x 3.8-inch (HWD) cabinets has a rear-facing bass port that does double-duty as a stand. These give the speakers a 10-degree backward tilt that purportedly puts the listener in an audio sweet spot when they’re sitting at a computer.

To read this article in full, please click here

What is Next Gen TV and when will it launch?

Mac World - Wed, 2017-12-13 06:00
Next-generation TV is coming soon.

Star Wars iPhone cases: Celebrate the release of ‘Star Wars: The Last Jedi’

Mac World - Wed, 2017-12-13 06:00
Disney Star Wars cases

Image by Disney

Disney bought Lucasfilm in 2012, so it’s no surprise that there are Star Wars iPhone cases in the Disney store. These are basic shells cases for the Plus-sized phones. Note that the camera cutout is for the iPhone 7 Plus camera; Disney says these cases fit the iPhone 6 Plus and 6s Plus, which have single-lens camera that don’t require such a big hole.

To read this article in full, please click here

What is Next Gen TV and when will it launch?

PC World - Wed, 2017-12-13 06:00
Next-generation TV is coming soon.

Dell Inspiron 15 7000 Gaming Laptop review: The discrete GPU is the star of the show

PC World - Wed, 2017-12-13 06:00

Dell’s Inspiron 15 7000 Gaming Laptop has a little secret that’s good news for budget-minded gamers. It’s hard to tell from the product information online, but one GPU option for this laptop is Nvidia’s GeForce GTX 1060 Max-Q. Max-Q GPUs manage performance closely to balance heat and noise, allowing powerful chips to go into lighter, slimmer, quieter laptops. The Inspiron 15 7000 Gaming Laptop offers Max-Q in a SKU that supports 1080p gaming and comes in just under $1,000. It’s a great value.

Adam Patrick Murray

Dell’s New Inspiron 15 7000 gets you to GeForce GTX 1060 Max-Q levels for a scant $1,000.

To read this article in full, please click here

How to Fix Your Wi-Fi Network

PC World - Tue, 2017-12-12 20:19

Wi-Fi is everywhere and built into everything. It’s like oxygen for internet access, media streaming, gaming, and all types of networking. And it should just work all the time—right? If you’ve had an average experience with Wi-Fi on mobiles devices, laptops, game systems, and more, you know that while Wi-Fi connections and consistency work correctly nearly all the time, it’s the occasions when it doesn’t that can leave you tearing your hair out.

In this article, I look at a number of common scenarios that cause Wi-Fi headaches and how to solve them, whether you’re running your own network or trying to connect to someone else’s using any platform.

To read this article in full, please click here

Pages

Subscribe to Computer Science aggregator