How To: Use the if Function in Excel
Video: . IF function
Alternatively Search Results
News: Interactive 360-Degree Videos Are Now Live on YouTube
There's a reason that YouTube continues to be the most popular video sharing site on the planet—ever since its purchase by Google, they've always made sure to load YouTube up with extra features to keep it ahead of the pack.
News: GravityBox Gets Lollipop Update; Most Features Already Working
The king of all Xposed modules is alive and kicking on Android Lollipop. GravityBox received an update over the weekend that will bring its bevy of UI tweaks to folks who have installed the framework on their Android 5.0+ devices.
How To: Mute Individual Tabs in Chrome Without Leaving Your Current Tab
It's been over a year now since Google introduced a visual way to track down which tabs are playing audio in Chrome, something that was previously only available using third-party extensions. However, they still didn't give an easy option for shutting those tabs up without having to stop what you're doing.
How To: Are Your Chargers Faulty or Slow? Here's How to Test Them on Android
Not all smartphone chargers put out the same amount of current. The adapter in your car probably charges your phone a lot slower than the one plugged in at your bedside, and if you use wireless charging, it may be a bit slower still.
How To: Control Volume Directly from the Notification Tray in Lollipop
If there's one gripe I have with Android Lollipop, it's the new volume menu. When Priority mode was introduced, the stock volume panel was revamped to accommodate it, and somewhere along the way a bit of functionality was lost.
How To: Use the Volume Keys for Page Scrolling on Android
Android's beauty is in its customization; you can have widgets for anything, launchers that look and feel completely different from one another, and fonts you can change at any time. And it doesn't stop at aesthetics—you can go much deeper than looks.
How To: DIY Emoji Halloween Costumes for Singles & Couples
It takes a lot of time, effort, and cash to create a unique Halloween costume that will likely never see the light of day after the 31st. Not to worry: you can do it on the cheap and feel savvy and creative while everybody compliments your ingenuity.
How To: Give Group Messages Custom Names in iOS 8
Waking up to hundreds of text messages in the morning usually points to one thing—group messages. Whether it's your fantasy football league, your work buddies, or just a bunch of bored friends, group messages can leave your iPhone vibrating off the hook.
How To: Bypass Android's File Type Restrictions on Bluetooth File Sharing
Bluetooth has been a staple on every Android smartphone ever since they began taking over our lives. Despite the fact that every device seems to have the ability to share files with one another, there is a limit to the types of files that can be shared between them.
How To: Remove Restrictions from Car Mode on the HTC One
Chances are that you're living in a city and/or state that's banned using your phone while driving, and because of that, many manufactures have added a "car mode" to their devices. In most instances, this mode is simply an app that simplifies your phone to its basic parts so you can navigate, make calls, and play music, limiting the amount of smartphone distractions.
How To: Enable One-Tap App Installation for APKs on Android
I'm always looking for the best apps and services for my Android, and that means sticking strictly to the Google Play Store is a no-go. If you're like me and tend to install a lot of APKs (application files), you're probably tired of seeing the "Install" confirmation that always pops up.
How To: Remove Password Obfuscation from Your Nexus 5 for Easier App Logins
When it comes to passwords, the longer and more complex they are, the better the security. Even professional hackers say so. But if you've ever tried to type in such a password, you've surely noticed that it can be a bit of a pain. Mistype one character, and you're probably going to have to clear the field and start all over again.
How To: Add a Password, Pattern, or PIN Lock to Any App on Your HTC One or Other Android Device
Keeping prying eyes off your device isn't always the easiest thing to do, especially once you lend somebody your phone to make a call. Seems that whenever someone is scrolling through your pictures or checking out your new phone, they always end up somewhere you don't want them be. You could always hover over their shoulder to make sure they're not getting into your texts or photos, but that isn't always possible.
How To: Eat Better by Making Healthy Food More Visible
We tend to assume that eating is mostly a physical act, but the mind has so much to do with the choices we make.
How To: Make the Notification Panel Translucent on Your Samsung Galaxy S4
There's a lot you can access from the Notification tray on your Galaxy S4. Quick settings toggles, brightness controls, and of course, notifications. However, despite the power this simple pull-down gives you, you're still left with a boring, black background for the shade.
How To: Enable the Chromecast Screen Mirroring Feature
At last month's I/O event, Google demonstrated a set of cool new features that were said to be coming to the Chromecast soon. While we may not be able to set custom backgrounds or cast content without being on the same WiFi network just yet, the biggest feature of them all has started rolling out to devices today: Screen mirroring.
How To: Get Custom Lock Screen Widgets on Your Samsung Galaxy S5
Stock Android has come with lock screen widget support for a couple of years now, ever since the days of the first Ice Cream Sandwich build. But for some reason, Samsung decided to remove this feature in the Galaxy S5.
How To: Toggle Auto-Correct On/Off Right from Your Galaxy S4's Keyboard
Auto-correction is a double-edged sword if I ever saw one. It's great because I'd have an abundance of typos without it, yet it's extremely frustrating (and embarrassing) when it doesn't actually work. Just take a look at the very recent example below from Breaking Bad star Aaron Paul. Funny for us, embarrassing for him. I have a particularly difficult time typing on small keyboards (i.e. fat-finger syndrome), so disabling auto-correction on my Samsung Galaxy S4 is a no-go. I'm willing to ris...
How To: Add a “Define Word” Option to the Copy/Paste Menu on Your Nexus 5
Even as a writer by trade, I'm not intimately familiar with every word in the English language. When you're typing something out on your Nexus, sometimes you think to yourself, "Is that right? Am I using the correct word here?" Then, you have no choice but to bring up Google Now and do a search for that word to make sure you're using it correctly.
How To: Show Live Wallpapers in the Recent Apps Menu on Your Nexus 5 or Other Nexus Device
When Google first introduced Android 4.4, the most glaring user-facing change was a new trend towards transparency. The stock launcher, originally exclusive to the Nexus 5, had transparent status and navigation bars and its app drawer added a touch of transparency.
How To: Add Menu & Search Soft Keys to the Navigation Bar on Your Nexus 7
Many of our everyday apps include a menu tab or search bar, like Chrome and Twitter. In fact, a lot of times those are the first things we go for, as search is universal in most apps, and app settings are just about always accessible through the menu.
How To: Theme the Nav Bar on Your Nexus 5 for a Fresh Look
The fact that we own a Nexus means we get to experience the Android interface exactly as Google intended it. But that doesn't mean we can't make a UI tweak here and there, does it?
How To: Increase Pattern Lock Screen Security on Your Nexus 5 with Larger Grid Sizes
These days, our smartphones carry some very sensitive data. From banking app passwords to personal photos, there are many things on your Nexus 5 that you might not want other people to have access to.
News: Samsung Galaxy S3 Getting Android 4.4 KitKat on Sprint Right Now
It's here... Update: May 1, 2014
How To: Turn Your Galaxy S3's Menu Key into a Multitasking Button (Like on a Galaxy S5)
Ever since Android 3.0 Honeycomb, Google has been trying to push phone manufacturers to do away with physical menu buttons. Samsung has been one of the lone holdouts, retaining the menu key up until the Galaxy S5, where they finally replaced it with a "recent apps" multitasking button.
How To: Force Any App to Use Translucent Nav & Status Bars on Your Nexus 5
When the Nexus 5 was released, a new version of Android came along with it called KitKat. In the 4.4 update were some fancy new UI elements, one of the most noticeable being the translucent decor. By that, I mean the status and navigation bars being semi-transparent.
How To: The Essential Secrets for Perfectly Slicing Meat
Knowing how to cut and slice raw meat is a skill all omnivorous cooks need in their arsenal. However, raw meat's limp and gelatinous character can be challenging to work with, especially when you're trying to slice it into symmetrical, attractive sections for a stir-fry or a stew.
How To: Bypass the Lock Screen for Instant Access to the Last Used App on Your Galaxy Note 3
Some of my favorites hacks are the ones that speed up the process of accessing my favorite and most-used apps. So, in this softModder guide, I'll be showing you a super fast way to open those apps straight from your Samsung Galaxy Note 3's lock screen.
How To: Streamline the "Complete Action Using" Dialog Box on Your Nexus 4 or 5
You've seen it a million times. You try to do something on your Android device and a box pops up asking you which app you'd like to use. You could try Photos, Gallery, Drive, Picasa Web Albums...the list is fairly extensive sometimes. And what's worse, after that you have to select "Always" or "Just once". Add it all up, and that's three taps to do something you thought would take just one!
How To: Get the Facebook Paper App on Your iPhone—No Matter What Country You Live In
It was just released a few days, but Facebook Paper has already taken the world by storm. CNET said it was a better way to use Facebook. TIME said it's the future of Facebook. The Verge called it the best Facebook app ever. There's one problem, though...
How To: Fix Auto-Correct When It's Constantly Choosing the Wrong Word on Your Galaxy Note 3
In the midst of furious finger typing on a small non-tactile screen, you're sure to make mistakes—so the majority of keyboards have autocorrect. Generally it works pretty well and is a welcomed feature.
How To: Who Is This? How to Display Full Contact Names in the iOS 7 Messages App
If you're a ladies man like me then this next tip could save you from sorely embarrassing yourself. Here's the problem: You think you are texting Kelly M from New Year's when you're actually texting Kelly F from that one bar. Needless to say this could cause a problem with your relationships.
How To: Text More Accurately by Handwriting Messages on Your Samsung Galaxy S3
I can't say that my handwriting skills are the best, and my cursive is even worse. I mean, I still don't know how to write a capital L in cursive, but who really cares when I do all my everyday writing with a keyboard now. I've gotten pretty fast at typing on my computer, but those tiny buttons on the Samsung Galaxy S3's keyboard is a totally different thing.
How To: Add a Gesture-Based Launcher on Top of Your Samsung Galaxy S3's Current Launcher
I could write about a new launcher everyday, because there are so many options out there for Android users, but one of my favorites it Everything Home. You probably have your own favorite, but what if you could actually use two launchers together, taking advantage of each one's awesome features?
Knife Skills 101: How to Chop, Dice, & Mince Onions Like a Pro
A lot of people hate chopping onions, and understandably so. Their shape and layers make them difficult to handle if you don't have much practice, and even if you know exactly what you're doing, it's a task that usually ends in tears.
How To: Get All the Stock Wallpapers from the Moto X on Your Samsung Galaxy S3
I never really get tired of staring at the beautiful Halle Berry wallpaper on my Samsung Galaxy S3, but occasionally she needs a break. There are literally thousands of different wallpapers to choose from, but since the new Moto X just came out, its stock wallpapers are ripe for the picking. Step 1: Download the Moto X Default Wallapers
How To: Find and Shut Up Those Annoying Music or Video-Playing Tabs in Your Browser
If you're the type of person who constantly uses multiple tabs in your browser, you know how annoying it is when one of them starts playing unwanted music or video.
How To: Break into Almost Any Gun Safe with Straws, Paper Clips, Coat Hangers, and Even Children!
At the recent DefCon conference in Las Vegas, researchers opened many of the top commercially available gun safes with simple tools like a straw or a paper clip, and in one case, just by shaking it a bit. The investigation began after the researchers, Toby Bluzmanis, Marc Tobias and Matt Fiddler, learned that certain Stack-On safes, issued to some law enforcement officials to secure their firearms at home, could be opened simply by jiggling the doorknob.
How To: Discover Nearby Concerts and Music Venues with Apple Maps and Apple Music on Your iPhone
Whether you're staying in your hometown for the weekend or traveling to a nearby or faraway city, live music is always a great option for entertainment — but finding decent music or a good music venue isn't always easy. With new features added to two of its core apps, your iPhone just made it easier to do both.