How To: Use the if Function in Excel
Video: . IF function
Distinctive Usage Search Results
How To: Enable the Charging LED on Your Nexus 6
The Nexus 6 has an AMOLED screen that uses virtually no power to display black pixels. To take advantage of this feature, Google included an Ambient Display notification system that shows a black and white version of your lock screen when you get a new message. As a result, the Nexus 6 doesn't use an LED light to notify you of new incoming messages like most phones.
How To: Add a Data Traffic Meter to Your Nexus 5's Status Bar
Carriers really suck, don't they? We constantly have to monitor our data usage, even though many of us are on "unlimited" plans, which, in reality, will just be throttled to a slower 2G or 3G connection when we hit a certain download threshold.
How To: Tiny Apps Is a Complete Floating Multitasking Suite for Android
With Android devices getting bigger by the year, you'd think there would be a native multitasking solution by now. While Samsung and LG have included such features in their customized builds of Android, the stock base that manufacturers start with still doesn't include multitasking support.
How To: Add Custom ROM Features to Your Stock Google Play Edition HTC One M8
The switch from Dalvik runtime to ART in Android Lollipop has rendered the Xposed Framework useless until a new version is released, but Xposed isn't the only way to mod a phone.
How To: Get Floating Bubble Notifications for Any Android App
Notifications are an integral part of our day-to-day smartphone usage. They allow us to easily see and act upon all of the latest information that comes our way. Well, most of the time, that is.
How To: Access Your Calendar & Full Schedule Faster Using Your Mac's Menu Bar
While it's much quicker in Yosemite, the Calendar app for Mac has never been as fast as I'd like. If my schedule is really full, it can sometimes hang when first opening the Calendar.
How To: Get Android Alerts for When Your Favorite Websites Update Content
The problem with striving to be on the bleeding edge of what's new for your smartphone, or really anything else in life, is having to constantly check websites and forums for new content. And with lots of that browsing happening on our phones, the aimless page loading and refreshing is not just annoying when there isn't new content, but can lead to wasted data usage, not to mention time.
How To: Fix Cell Service & Touch ID After Installing the iOS 8.0.1 iPhone Update
The official release of iOS 8 was highly anticipated, but the truth is it may have been a little premature on Apple's part. Since its debut only a week ago, plenty of bugs and issues have been reported across the various compatible iPhone models.
How To: Everything You Need to Know About iOS 8 for Your iPad, iPhone, & iPod Touch
Now that you've updated your iPad, iPhone, or iPod touch to iOS 8, there's a lot of cool new things to explore. If you felt a little overwhelmed from all of the detailed information available in our Coolest Hidden Features of iOS 8 post, then I've got a simple breakdown of all of the new features available with quick links to their walkthroughs and pictures, if available. Watch the short video roundup, or skip below for the list.
How To: Block Apps from Logging Your Data on Android
With root access, you're granted greater control over your device, allowing you to do things that your Android system wouldn't allow otherwise. Things like installing Xposed mods are made possible with root, but other advantages address performance and security, like stopping your Android logging, which is exactly what we'll be going over today.
How To: Send Encrypted Self-Destructing Messages on Your Galaxy Note 2
In February of this year, the Higher Court of Berlin ruled that Facebook must follow strict German data protection laws, which Facebook's terms of services and privacy policies circumvent.
News: Yahoo's Aviate Launcher Is Now Open to All & Better Than Ever
When Yahoo! purchased the home screen replacement app Aviate back in January, many were wondering if the internet giant intended to continue development of the launcher or if the transaction was just another acqui-hire.
News: Samsung Galaxy S3 Getting Android 4.4 KitKat on Sprint Right Now
It's here... Update: May 1, 2014
Heartbleed Still Lingers: How to Check Your Android Device for Vulnerabilities
Unless you've been living under a rock with no internet connection, it's safe to say that you've heard of the Heartbleed flaw that allows practically anyone with the right knowledge to steal your personal information, such as passwords, credit card numbers, and e-mail addresses using OpenSSL.
Updated: How to Fix the Rapidly Draining Battery Issue on Your Nexus 5
Update (March 18, 2014): Skype has issued an update to their Android app, and among other things, has "fixed" the runaway camera process issue by creating a workaround...and that's about all we know. No details were provided, but with the considerable uproar over the bug, let's hope it's been squashed for good.
How To: Get Adaptive App Shortcuts on Your Nexus 7's Lock Screen
There are a gazillion lock screen apps available on Google Play, but the majority of them are subpar and not worth your time. However, in my opinion, there is definitely one out there worth your time—one that constantly learns and adapts to what apps you use when and where to determine which shortcuts to give you.
How To: PIN-Protect Mobile Data & Wi-Fi to Prevent Procrastination & Unwanted Charges
Normally, "restricted access" is something you despise. No one likes to be told they can't do something, especially when it comes to the Internet. Unfortunately, having web access at all times can not only eat away at your wallet, but make your day less productive overall, so some sort of moderation is needed.
How To: Make the Huge Samsung Galaxy Note 3 Easier to Use with Your One Tiny Little Hand
One of the more challenging things about using the Samsung Galaxy Note 3 is the ability to use it with one hand, due to its enormously large (but wonderful) screen size.
How To: Extend Battery Life by Seamlessly Managing Wireless Radio Connections on Your Samsung Galaxy S3
You don't need to be a robot to be overly concerned with battery life, especially if we're talking about Terminators, which have nuclear or hydrogen fuel cells that keep them running for years straight. It will be a long time before smartphones get that upgrade, so in the meantime, we have to figure out how to make them last more than a couple hours in a single charge.
How To: Pick Up a Better Wi-Fi Signal on Your Samsung Galaxy S3
Having trouble getting a strong Wi-Fi signal on your Samsung Galaxy S3? Does the signal drop out on you when changing rooms? Frustrating, isn't it?
How To: Clean Your Crystals?
Hello! Today I would like to share a few words about cleaning your crystals. It could be a whole collection or the first shiny object you have ever bought. Here are some hints,...
How To: Play the didgeridoo
Often considered the world’s oldest wind instrument, the didgeridoo originated among the Aboringine tribes of Australia. It looks like a simple wood tube, but by vibrating their lips, players can produce harmonic resonances which result in the instruments distinctive droning sound.
News: Comparing the Best International Data Plans from All Major US Carriers
Traveling abroad can be a hassle. Between the flight, hotels, food, and the languages barriers, it can be a lot to manage. There's one tool you have that can help with all of this — your smartphone. Fortunately, nowadays, you don't have to change your carrier to continue using your phone.
How To: Use the XML Schema tools in NetBeans 6.0
Watch this video tutorial to learn how to use the XML schema tools, which enable you to create, visualize, and edit XML schema in NetBeans 6.0. With these tools, you can visualize relationships between schema elements and use queries to find usages. You will also learn how you can easily create XML schemas by example. You will see how to navigate large schemas in the Design View, and you will learn how to visualize and edit multiple file schemas.
How To: Unblock applications on Facebook
This video tutorial from agseo presents how to unlock applications in Facebook social internet network. For more detailed information go to www.agseo.blogspot.comTo unblock Farmwille and other applications on Facebook social network login to your Facebook account.From top menu Account drop-down list select Privacy Settings.Then select Applications and Website from the newly opened window.Select Blocked Applications (click on Edit Blocked Applications button).A list of all blocked applications...
How To: 14 Tips Every New TikTok User Should Know About
By now, there's no way you haven't stumbled upon a TikTok video, whether it was on Facebook, Instagram, Twitter, or YouTube. Just watching these addictive short-form videos is enough to make you want to join up and make your own, and when you do, we've got some tips that will help get your TikTok account in order.
News: Epic Games Files Legal Action to Stop Augmented Reality Startup Nreal from Using Name in the US
Augmented reality startup Nreal was a hit at this month's CES event, with some even calling the device a worthy challenger to the Magic Leap One.
How To: 8 Easy Ways to Enjoy Eating Octopus
The octopus is famous for its bulbous head, enormous eyes, and four pairs of long arms. The stuff of legends and nightmares, octopi have been featured in stories, artwork, and meals galore. But how do you eat this distinctive looking, bilaterally symmetrical sea creature?
How To: 7 Android Customizations That Will Make You Love Your Phone Again
Remember that feeling when you first took your smartphone out of the box, powered it on, then proceeded to futz around with it for the rest of the day non-stop? If you've owned your device for more than a year, chances are, that scenario is a distant memory by this point.
How To: 5 Amazing Ways to Bake with Coconut Oil
I remember the first time I used coconut oil; the whole kitchen was filled with a fragrant aroma that reminded me of the tropics. After learning it was a healthier alternative to traditional cooking oil—not to mention a great source of the good-for-you saturated fat—I was hooked.
How To: Sour Patch Recipes Your Kids'll Go Crazy For
In my opinion, there is no candy greater or more timeless than Sour Patch Kids. They're the ultimate treat: sweet and refreshing, yet sour and tangy. These contrasting flavors are what make Sour Patch Kids perfect for the people of all ages—especially your kids. So let's make dishes that incorporate this awesome candy into your cooking rotation!
SPLOIT: How to Make a Proxy Server in Python
NOTICE: Ciuffy will be answering questions related to my articles on my behalf as I am very busy. Hope You Have Fun !!!
Weird Ingredient Wednesday: Cook with Lapsang Souchong Tea
Like cigars and whiskey, Lapsang Souchong tea is an acquired taste. Some people never get over the pungent, tarry flavor and intense smell of the beverage, but using it as a rub, marinade, or other seasoning is totally smart. The tea adds a smoky yet not overwhelming flavor to dishes of all kinds. With it, you can easily get barbecue-like results for meats and vegetables, all without breaking out the grill. Lapsang Souchong tea smells like a dry campfire and tastes like a smoked sausage cooke...
Advice from a Real Hacker: How to Know if You've Been Hacked
It seems like every day now that we see a new headline on a cyber security breach. These headlines usually involve millions of records being stolen from some large financial institution or retailer. What doesn't reach the headlines are the many individual breaches that happen millions of times a day, all over the world.
How To: Rename Almost Any App on Your Samsung Galaxy Note 2
Changing an app's name on your home screen is not something you can do on stock Android or TouchWiz, but it should be. If you think of it merely from a customization angle, sure, it's not a big deal, but having the ability to alter an app shortcut's name can do wonders for cleanliness and being able to distinguish from similar icons.
How To: 9 Ways Your iPhone Can Help You Be More Productive When Working from Home
With stay-at-home orders for most of us in the US because of the new coronavirus, many of you are likely struggling to be productive and efficient when working from home. Unless you've worked from home before, it can be challenging to separate work from personal life throughout the "workday." But your iPhone can help make the transition easier and more successful.
How To: Make YouTube Default to HD Resolution Always on Your Phone
To reduce stress on internet bandwidth during the COVID-19 pandemic that the novel coronavirus is causing, Google decided to set YouTube's default video quality to 480p. That said, even when you could stream at HD quality without adjusting anything, you still couldn't switch the default to whatever you liked. We have a few methods on hand to help you change that.
News: Hulu Follows Instagram's Viral Sensation with Branded 'What Should I Watch' Lens on Snapchat
The "what (blank) are you" augmented reality filters on Instagram have become so popular that more and more Hollywood giants are following the augmented reality-powered social media meme train, with the latest example coming via Snapchat.
How To: Prevent Samsung's Shady 360 Storage Cleaner from Phoning Home to China
Samsung, like other OEMs, partners with third-party companies to include their apps on Galaxy devices. For example, Microsoft pays Samsung millions to pre-install certain Office apps. But one of these partners might not be on the up and up.