Choices Range Search Results

How To: Make Nerf foam darts fly

Want more firepower for your Nerf guns? Here's an instructional video that shows a simple mod to make your foam darts fly! Increase their range by 25%. Watch this video tutorial and improve your game playing, but please, use caution!

How To: Do the spine twist pilates exercise

Katherine and Kimberly Corp show you how to do the Spine Twist pilates exercise. This exercise is used for slimming your waist and increasing the range of motion of your spine. This is a great exercise for improving your tennis game or golf swing.

How To: Find & extract duplicate records from a data set

This video is about finding duplicate entries in excel sheet. The example excel sheet contains different names. There are around 1000 different names in the sample excel sheet. CountIf(range,criteria) formula has been used to do the comparison and return of results in True or False mode. Type =CountIf( now move your left arrow key, this will generate the formula like =CountIf(A2. Now press Ctrl+Shift+Down arrow, this will select all the available values in the column. Now press F4 to lock it ...

How To: Get your passport

If you are going to travel outside the United States on a ski trip with Skitravel.com, you will need a passport. From Skitravel's website you can click the "get a passport" link. The link will take you to the US Department of State's passport form (the DS11 passport form). On the Department of State's form, you have two choices, a passport book or a passport card. The passport book is good for ten years and you can travel anywhere in the world with it. The second choice is the passport card. ...

How To: FaceTime Forcing LTE Instead of Wi-Fi? Here's How to Fix It

These days, you can FaceTime with family and friends whether you're at home connected to Wi-Fi or on-the-go with mobile data. You may have noticed, however, that your iPhone will sometimes drop Wi-Fi and rely on cellular instead — whether you're placing or receiving a FaceTime call. While that's not an expected result, there is a workaround to get your FaceTime calls back on track.

News: Meet the Honor 7X — Huawei's New Premium Budget Phone

Huawei has been on a roll recently. They just became the second largest smartphone manufacturer in September, passing Apple and trailing only Samsung. Shortly after, they announced their new Kirin 970 flagship SoC to rival the Snapdragon 835, then followed that up by announcing the Mate 10 and 10 Pro. Well apparently, Huawei isn't done with announcements just yet.

Game of Thrones: DIY Lady Stoneheart Makeup Effects for Halloween

Who doesn't love the world of Game of Thrones? Whether you're a fan of the hit HBO show, or can't wait for George R. R. Martin's next novel installment, it's a story loved by nearly everyone. It's an excellent source of inspiration for Halloween costumes too, ranging from the disturbed to the beautiful. Lady Stoneheart, Catelyn Stark risen from the dead, is the perfect scary choice—bloodied, battered, and carrying a desire for vengeance.

How To: Build an ARP Scanner Using Scapy and Python

As you might know, there are a multitude of tools used to discover internal IP addresses. Many of these tools use ARP, address resolution protocol, in order to find live internal hosts. If we could write a script using this protocol, we would be able to scan for hosts on a given network. This is where scapy and python come in, scapy has modules we can import into python, enabling us to construct some tools of our own, which is exactly what we'll be doing here.

How To: Create Japanese Style Landscape

So you've decided to transform your drab backyard into a Japanese Zen garden. You've made the right choice. Yes, tire swings and crab grass can slowly kill the soul. That being said, a bit of planning lies ahead. This article offers a list of How To tips, culled from the Landscape Network and other professional Japanese style landscapers, for planning an effective Japanese style landscape in your home. Step 1: Research.

How To: Pull tricks and pranks on patrons at a pool or billiard hall

The pool hall is one of the most traditional places to meet and socialize with others in both East and West. If your crappy pool skills keep you from enjoying your time out at the pool hall properly, try pulling some of these pranks on people better than you! They range from the extremely simple beat-me-without-scratching gambit and other tricks that defy convenient naming but are hilarious and involve both pool and beer.

How To: Adjust hue saturation values (HSV) in Blender

This clip talks about what Hue Saturation Value is, and how to use Blender and the HSV node to isolate a specific color or range of values from an image. Whether you're new to the Blender Foundation's popular 3D modeling program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free video tutorial. For more information, including detailed instructions, take a look!

How To: Create a fake a HDR effect in Adobe Photoshop CS4

See how to create eye-popping faux HDR (high dynamic range) images within Adobe Photoshop CS4. Whether you're new to Adobe's popular graphics editor or a seasoned design professional looking to better acquaint yourself with the various features and functions of Photoshop, you're sure to benefit from this free software tutorial. For more information, watch this designer's guide.

How To: Perform an upper extremity exam on a patient

This video will show doctors the process of examining the upper extremity of the body. When you exam the extremities or any joints, it's good to have a systematic approach to how you will examine each joint. Learn about the inspection of each joint, range of motion, palpation and strength testing from Eve Bargmann, M.D. When examining the upper extremity, you should start with the shoulder and work you way down to the elbow, then the wrist, and lastly, the hand.

How To: Adjust levels and curves in Adobe Photoshop CS4 or CS5

Maximize dynamic range with Photoshop's levels and curves tool. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from the folks at Britec Computer Systems. This video offers a step-by-step guide on how to adjust levels and curve of a digital image.

How To: Force a function to becom an array in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 39th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how if an array or range is put into a function argument that is expecting a single value, the function becomes an array and delivers an array of values instead o...

How To: Concatenate with criteria in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 316th installment in their series of digital spreadsheet magic tricks, you'll learn how to count & list unique values as well as how to concatenate a range of values with a separator.

How To: Count days excluding Sundays in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 189th installment in their series of digital spreadsheet magic tricks, you'll learn how to count all the days except for Sunday using an array formula for a given date range with a specified start and end date.

How To: Learn knitting basics

In this tutorial, we learn knitting basics. To knit, you will start out by selecting your choice and colors of yarns. After this, you will need to grab two knitting needles and then make a slipknot from the yarn with your finger. Attach this to one of the needles and then start a chain one on this. From here, you will continue to wrap the thread around the needle and then squish it all together. Then, take the other needle and wrap it into the first part of the thread. Then, continue to work ...

How To: Make a Kufi cap with Threadbanger

In this tutorial, we learn how to make a Kufi cap with Threadbanger. First, grab a thick black jersey material and your added material of choice. Cut the fabric in a circle pattern to make the size of your head. Then, cut the band material for 3 inches longer then your head measurement. Fold the material and create the bands with thick cardboard. Once you do this iron the bands down and then fold the added material down as well. Adhere the piece pieces together while still folded, then sew th...

How To: Set random themes in Gmail using your current location

There a ways to personalize your Gmail experience, and one of those is picking personalized Gmail themes which make emailing funner. But if you're not sure what kind of theme you want to use from all the available Gmail theme choices, there's an option called "Random" which provides you a random theme based on your geographical location, and will change when in a different location.