How To: Use the if Function in Excel
Video: . IF function
Construct Circles Search Results
How To: Hide All Desktop Icons with One Click on Your Mac
Cleaning the clutter off of your desktop every so often is a great idea. Unfortunately, that doesn't mean that you're actually going to do it. Whatever the reason, you may not have time to get everything organized, but luckily there is a way to temporarily "clean" your desktop in a hurry.
How To: Why 'Whipping' Cooked Pasta in Sauce Creates a Perfect Dish
Most cooks know they should stir pasta a few times while it's cooking, for obvious reasons: as the noodles cook, they release a glue-like starch that makes them stick to one another. Stirring prevents them from clumping together in an unwieldy, inedible mass. Now Mark Bittman in The New York Times discusses a great technique from Italy that helps you produce a plate of tender, toothsome pasta evenly coated in rich sauce every time, but it involves stirring the pasta at the end of its cooking ...
How To: Use Your iPhone's Entire Screen to Surf the Web Distraction-Free
An app with overabundant features can make it more customizable, but too many options can also be overwhelming, even on a mobile web browser. If you're tired of Safari or Chrome on your iPhone, try out Frameless from developer Jay Stakelon, a simpler web experience using just the essentials.
How To: Engineer a No-Slip Sandwich
Most of us know how to make a sandwich, but how many of us know how to make a sandwich correctly—i.e., so that the slippery ingredients like tomatoes and cucumber don't come gushing out the other end when we take a bite?
How To: This Hidden Trick Lets You Create App Groups for Multi-Window Mode
By now, Samsung's Multi-Window Mode is a pretty well-known feature. With other manufacturers now recreating this functionality in their own flagships, like LG, it's safe to say the feature has been a hit with consumers.
How To: Set Chromecast Background Images as Your Android's Wallpaper
Google's Chromecast streaming device is a marvel of functionality and form. Even with powerful features such as screen mirroring and collaborative party playlists, it's the device's idle screen that first catches the eyes of most folks.
How To: Truth or Dare + Spin the Bottle: Play These Classic Party Games Right on Your Android Phone
Classic party games like Spin the Bottle and Truth or Dare, immensely popular in the '80s and '90s, seem to have been long forgotten and abandoned by today's youth. Today, new forms of party games are all the rage, a prime example being Cards Against Humanity. Yes, CAH is hilarious and fun, but the classics can still be appreciated, as long as we catch them up to the times.
How To: Use Notification Glance on Google Glass
You may not have noticed it, but Google snuck a new feature into Glass recently. Called Notification Glance, this feature lets you view new notifications by simply looking up at the screen.
How To: Get Android L's Navigation Bar on Your Nexus Running 4.0+
If you want to try out some of the new features in Android L, but can't run the developer preview on your Nexus—or simply don't want to—there's still hope. You don't actually need to be running Android L to try out some of the new improvements.
News: Worst Kept Secret Ever? Full Specs Leak of the New HTC One
After a lengthy video and a series of leaks got us a good look at what we can expect from the new HTC One, codenamed M8, the guys over at GSMArena have brought it full circle.
How To: Change Your iPhone's App Icons to Any Shape You Want in iOS 7
More and more, our phones are becoming an expression of us. Whether it's the device we choose, the case it dons, or the ringer it bellows, we like to personalize. Unfortunately, there's not much you can do beyond cases and ringers on your iPhone, unless you jailbreak.
How To: Do a Polka Dots Nail Art Design
Nail Arts are a current new rave among the contemporary fashionistas. Make your nails look highly fashionable and appealing by following this plain and simple steps tutorial. Polka dots Nail Art Design is super cool and looks brilliantly charming on your sleek hands.
How To: Add a Pulsating Battery Energy Bar to Your Samsung Galaxy Note 3
Long before Windows Phone hit the scene, Windows Mobile was the operating system for Microsoft's older brand of smartphones through the early 2000s. But due to its clunkiness and inability to keep up with modern features, it was scrapped in 2010.
Blackphone: The Answer to NSA Snooping
Every day it seems like new information comes to light about how the National Security Agency creeps into our lives. Knowing that they can backdoor into our seemingly private devices is a scary thought, whether you have information to hide or not.
How To: Get These Badass Circular App Icons to Round Out Your iOS 7 iPhone or iPad's Home Screen
Rounded rectangle icons are so 2007. Sure iOS 7 tweaked them a bit, but with the clean new approach to design that software is taking today, they're starting to look dated. Today I'm going to show you how to go full circle with your iPhone's icons, and the results are actually pretty awesome.
How To: Make a Christmas Tree
How to make 3 different Christmas trees. Brighten up your home this Christmas with a beautiful homemade Christmas tree or three!
How To: Delete & Forward Individual Texts & iMessages from Conversations in iOS 7
Back in iOS 6, deleting individual text messages in a conversation was just a matter of tapping the edit button on the right-hand corner of the thread, selecting which texts to delete, and then pressing delete.
How To: Do Smokey Eye Makeup
There is nothing more stunning than accentuating eyes with smokey makeup for a special occasion. Here's a tutorial for you on how to get smokey eyes for a stylish evening or a sophisticated day look in less time. Great for beginners.
How To: Make a Homemade PVC Rocket
This homemade hairspray-powered PVC rocket takes less than an hour to construct and only costs about 20 dollars to make. Check out my video below for the step-by-step instructions on building your own backyard rocket, and follow the written guide below for reference.
How To: Do Prime Factorization
What Is Prime Factorization? Prime factorization is finding prime numbers that, when multiplied, equal the original number.
How To: Suspect Someone Is Using Your Computer? Catch Them in the Act with Just the Click of Your Mouse
There are many ways you can protect your computer from unwarranted access. For instance, you can use Lockscreen Pro to lock your Windows 8 computer and then have the program snap a photo of the culprit using your webcam.
How To: Do Cute Studded Nails
This is a very easy nail design that I did quite a long time back, and I decided to post it here today because I thought it really deserved to be shared !
How To: Make Your Own Auntie Anne's Pretzels at Home
As a kid, I remember begging my mother almost every single time we went to the mall to buy me a pretzel from Auntie Anne's. Now, whenever I pass one of those little blue and white stands, that delicious, buttery smell instantly takes me back to being an impatient four-year-old who wants a pretzel right now. The only bad thing about Auntie Anne's is that you usually have to deal with annoying places like malls and airports to find one. Wouldn't it be nice if you could just whip some up at home...
How To: Turn an Old Metal Slinky and Coat Hanger into a Bird Feeder
While the heyday of the Slinky may have been a few decades ago, I still think it's one of the coolest toys to ever go to market. Not to mention it probably has the best commercial ever created.
How To: Make a Super Cheap Pinhole Lens Filter for Your DSLR Camera
There are tons of ways to make your own pinhole camera out of everything from a juice box to a pine nut. If you have a DSLR, you can make a DIY pinhole lens for it for just a few bucks. David O'Sullivan over on DIY Photography made this one using a cheap body cap and an aluminum can. Here's how to make your own. David put up a template you can follow to make things easier, so start off by downloading it, then use a ruler to draw a line directly through the center of the body cap. Cut out the ...
How To: Create a Light Painting Vortex Using a DIY Reusable Steel Wool Cage
There's no shortage of uses for steel wool, but the majority of them tend to be on the pyromaniacal side, like DIY fireworks. This trick by Mike Mikkelson is no different—it uses a homemade reusable "wool cage" to create a spinning vortex of light, like in the photo below. You can do this with just a piece of steel wool on a cable, but Michael wanted something he could easily reuse no matter how many shots he took, so he built a small cage to house the steel wool out of chicken wire, a small ...
How To: Make Your Favorite Song Last Forever with Infinite Jukebox
The first album I ever bought with my own money was Nirvana's MTV Unplugged in New York. It featured mainly lesser-known songs and covers, but was on constant repeat on my Walkman. While the whole album was fantastic, there was one song that stood out the most to me—"The Man Who Sold The World." The song (originally written by David Bowie) kept me under a spell, which had me replaying the song over and over and over and over. As I got older, I found myself sharing this relationship with a han...
How To: Make a Tiny "Small Wrap Up" Braid
Hello! Today I would like to introduce a simple tiny braid - so called the small wrap up. I recommend it to every person who wants to prevent the hair from falling onto the face. It is suitable especially for the people who have long or medium sized hair and very delicate skin. And for all who just want to quickly bind together some hair.
How To: Build Your Own Projection Microscope with a Syringe, Laser Pointer, and Drop of Water
Have you ever wondered what sort of microscopic critters are floating around in your water? Well, you can find out with just a few bucks worth of materials and a laser pointer. Really. That's all it takes to build your very own homemade laser projection microscope, aka a water drop projector.
How To: Fold a Simple Dragon Head
During my early elementary school years, origami was my go-to pastime. When it came to learning about it in art class, I ventured out well past the basics that were being taught.
How To: Use Google+ Events
Since its inception, Google+ fans have been clamoring for Google Calendar integration. Today, Google+ has launched something better: Google+ Events.
How To: Apply your makeup to get rid of undereye circles
Using makeup is the best and fastest way to get rid of undereye circles. In this tutorial, learn how to erase a late night in the morning with the right type of makeup for your skin type. This process is quick and looks great. You don't need to wear a lot, just the right type. So, check out this tutorial and look fresh faced everyday.
How To: Make a 3D lemonade cup card with Stampin' Up!
Dawn Griffith creates a cute card with a 3D lemonade glass embellishment from start to finish. Create a template by making a rough sketch of an 8 ounce paper cup onto a piece of white cardstock and cut it out. Take the template and either trace it onto a piece of vellum cardstock and cut it out, or use Dotto adhesive to attach the template directly to the vellum and then cut around the shape. Score each side at about 1/4", fold on the score lines and trim the overlap at the top. Apply sticky ...
How To: Massage data in Houdini 10
Get a crash course on HScript Expressions, Variables, and Attributes in Houdini 10. If you don't even know what this means, then you probably need to check this video tutorial series out. Understanding how to massage data in Houdini is key to giving yourself the creative edge and allowing you to unleash mind-blowing visual effects. This 18-part video series covers a variety of simple yet essential weapons in your arsenal including Global, Standard and Custom Variables to Math and String Modif...
How To: Create sexy leopard print eyes
Create sexy leopard print eyes. Fresh Face: Start with what I call a fresh face, which is your clean slate for all of your looks. A fresh face is after you have put concealer and foundation all over the face or only where needed, which ever you prefer. Also groom the eyebrows at this point, if needed, to avoid smudging shadow or liner while trying to groom. Apply a generous amount of loose powder to the eye to catch little stray make-up pieces. Shadow base: Apply a shadow base to give a good ...
How To: Play the Comets and Craters iPhone tower defense game
Need a new iPhone app? Check out Comets and Craters, a new iPhone tower defense strategy game. These ten video tutorials cover all of the gameplay troubles you may have. Steve explains the features and gameplay to help you get the most out of playing Comets and Craters on your Apple iPhone. For those more seasoned Tower Defense players, the video's also provide some insight regarding scoring, upgrades, plus Tower and Enemy capabilities.
How To: Create a magical enchanted dagger in Photoshop
Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to create a magical enchanted dagger in Photoshop.
How To: Warm up the arms for softball with stretching
Your arms are a very important part of softball, this is why it is important to warm them up properly. In this sports how-to video, Farmington (MN) HS head softball coach Heather Ballstadt demonstrates arm stretch drills to warmup for throwing. Start the arm stretches with big arm circles going forward, to loosen your shoulder joints. Do fifteen rotation and then move the arms in the opposite direction.
How To: Swing dance
This how to video teaches some intermediate swing dance moves. Learn how to do a Lindy circle, skip-up, tuck turn and underarm turn with this dance tutorial. These steps are a fun way to jazz up any swing dance. Watch this how to video and you will be swing dancing in no time.