Proper Pick Search Results

How To: Use the Micrsofot KIN One smartphone

Whether you're the proud owner of a Microsoft KIN One smartphone or perhaps just considering picking one up, you're sure to benefit from this free video tutorial, which presents a complete overview of the phone's various features. Specifically, this video demonstrates the unit's Phone, Spot, Loop and Theme functionalities.

How To: Skin a squirrel the right way

Viewer be warned! This video series is not for the faint of heart! If you think you can handle the contents inside, then you're about to get an in depth lesson on the proper way to skin a squirrel. This three part video series will show you how to skin a squirrel.

How To: Properly write business e-mails

Now, more than ever, many companies rely on using emails to send bits of information around faster than normal. Not only does it save paper, but allows work to get done faster than it ever has. But, if you don't know how to write a proper business email, it can be tricky. That's why this tutorial will show you how to write them so you don't have to worry about a lack of professionalism. Enjoy!

How To: Make an awesome Christmas wreath

Are your wreaths looking a tad shabby? Make your own Christmas wreaths this holiday season with help from Mary Fletcher Jones and materials readily available at any Michael's craft store. To complete this beautiful wreath, you will need the following items:

How To: Find an item's relative position via MATCH in MS Excel

hether 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 43rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the MATCH function to find the ordinal position (relative position) of an item in a list.

How To: Use the CHOOSE function in Microsoft Excel

hether 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 46th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use MS Excel's CHOOSE function.

How To: Use Microsoft Excel macros securely

hether 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 52.5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about macro security. For more information on how to use macros safely, watch this free video guide.

How To: Speed up conditional formulae with VLOOKUP in MS Excel

hether 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 35th installment in his "Highline Excel Class" series of free video Excel lessons, you'll see an efficient IF function formula get beat by an even more efficient VLOOKUP function formula.

How To: Calculate taxable earnings given a ceiling in 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 34th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a formula that will calculate the taxable earnings for a payroll period when there are ceilings (hurdles maximum) for taxable earnings (above which ...

How To: Use conditional summing 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 9th installment in his "Highline Excel Class" series of free video Excel lessons, you'll see three examples using the SUMIF function to do conditional summing.

How To: Use Excel's SUMIF, RANK & IF functions

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 30th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the SUMIF function to add with one criteria, the RANK function to rank highest values to lowest values (one to five) and the IF function to assign a bo...

How To: Add across sheets in Excel with 3D cell references

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 8th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add across sheets using 3-D cell References and the SUM function.

How To: Make a decorative tin for your mom on Mother's Day

Are you struggling to get mom a unique gift this Mother's Day? Do you always get her flowers or chocolates? Break out of the "same old, same old" and make a decorative tin for mom shown here in this video. By picking up just a few materials from your local craft store, you'll be one step closer to creating the best homemade gift mom has ever received!

How To: Use bobbers for deep sea fishing

Bobbers are a very important part of fishing. Bobbers allow you to keep track of your line and know exactly when you catch something. In fishing, a bobber keeps the bait on the surface and away from the bottom, and when a fish bites the bobber will pull down. In this tutorial, find out how to set up a fishing rod to use a bobber with help from a fishing trainer.

How To: Backpack and camp with healthy food

Just because you are not at home is no reason to abandon your healthy eating lifestyle. In this tutorial, you will learn all about planning healthy meals and snacks while you are on the go. Discover how to pack your backpack with the right, lightweight snacks and maintain proper nutrition when out and about. Of course, when planning caloric intake and healthy eating for a backpacking trip, it's important to create a backup plan in case something doesn't go according to plan. Learn about carry...

How To: Apply the distributive property in math

To solve simple algebraic expressions you have to use different properties. Distributive property is one among them. To apply distributive property in a algebraic expression multiply each term inside the parenthesis by the outside term. In this way you are distributing the outside term to all the inside terms and removing the parenthesis. Hence it is called distributive property. After multiplying add the like terms to simplify it further. Care should be taken to ensure the proper sign change...

How To: Select a camera tripod that fits your needs

In Part 6 of a series of video clips, `ClickHerePhotography` gives tips on how to select the right tripod for various outdoor environments and conditions like snow, rain (hail and thunderstorms), mud, dirt (dust) and waterbodies (river,streams or oceans). It is important to use a sturdy tripod designed to withstand the elements. After using the tripod for the day, it is essential to clean it. For instance, sand or salt water will weardown the legs of the tripod if left for long periods of tim...

How To: Prepare a Crested Gecko Diet

In this video, we learn how to prepare a meal for a Crested Gecko with Wally. The complete nutrition for gecko's is the two-part MRP pre-packaged meals. All you have to do for these is mix with water. These are the only meals that combine all proper nutrition for your gecko and avoid killing insects that don't last long and don't provide all nutrition they need. These packages come in two parts that can be store in Ziplock bags that will last for 6 months when stored in the fridge. Not much e...

How To: Cut a glass bottle with a string

This video describes the process of cutting a beer bottle in half. First a piece of string is tied around a glass beer bottle to gauge the proper length that the string should be. Next, excess string is cut off and the tied string loop is slid up and off of the bottle. Next, the cap of a bottle of nail polish remover is unscrewed and the cap is filled with nail polish remover. The string is then wadded up and dipped into the nail polish remover for a couple seconds. The string is slid back on...

How To: Play "Smoke on the Water" by Deep Purple on guitar

How classic is "Smoke on the Water" by Deep Purple, right? It's one of the greatest classics of all time! And now, you can learn how to play this hit on your acoustic guitar by yourself. Impress anyone who's listening with this rockin' tune. This tutorial will show you exactly how to play "Smoke on the Water" with your guitar, from finger placement to the proper chords.

How To: Have a PH balanced diet

In this tutorial, we learn how to have a balanced PH diet. This type of diet assists the body in proper metabolism and helps it fight diseases. For this, you will need: a food diary, pH strips, foods with low acidity and alkalizing beverages. Make sure you consult your physician before starting any new diet. You will first need to start a food diary showing what effects your body's pH balance. Use the pH strips to see what type of foods effect you the most. Change your diet to eat foods that ...

How To: Set a table the proper way

This video teaches us the way to properly set a table. You will require a couple of things for this purpose. These things include a table with a table cloth and napkins. These should be kept at one side of the table. Then take salad forks and dinner forks. Arrange these in the center. Take knives and spoons. Arrange these besides the forks on both the sides. Take bread and butter plates and arrange them above the salad and dinner forks. Put glasses above the spoons. Put bread and butter knive...

How To: Create a bootable Windows 7 repair disc on a USB drive

In this how to video, you will learn how to create a system repair disc on a bootable USB flash drive without having to burn a CD for your Windows 7 system. First, plug in your USB drive and create new folders in it. Name the first folder boot and the second sources. Next, open a command prompt and type in the cd c:\recovery, dir /a:sh, and so forth as shown. Once you have typed in the proper commands in the prompt, eject the flash drive. Restart the computer with the drive plugged in. Boot f...

How To: Throw a football the correct way

In this video, we learn how to throw a football the correct way with Steve Hand. First, get a good grip on the ball using your throwing hand. Put your hand on the laces, not the spaces. Now, get the proper foot position by squaring your feet with your shoulders. Put your weight on your back food then step into the throw. Finally, cock your back and step into your throw and release the football. Make sure you keep your elbows to the side of you and they are not facing too far down or too far u...

How To: Shoot a soccer ball

In this video, we learn how to shoot a soccer ball the proper way. First, set the ball up to your dominant foot. Then, place the non-kicking foot around 6 inches to the right or left of the ball. Now you will aim to make solid contact with the laces of the shoe. Next, try and make solid contact with the laces of your shoe. Doing this will make sure the shot is powerful and not spinning. Also, aim to keep your foot as vertical as possible when making contact, which will send the shot low and a...

How To: Practice food safety on a camping trip

Before you make that extended camping trek out into the wilderness, there are a few things any self-respecting camper should know how to do. And one of those things is how to safely feed oneself. With this free video guide, you'll learn how to practice food safety when roughing it in the wild.

How To: Light your own web show

In this how-to video, you will learn how to light your web show. This is important as it will make your web show look more professional. Proper lighting allows you to see your face, eyes, and the colors of your shirt. If there is not enough light, you cannot see yourself as well. You will also look dark and grainy. Too much light will cause your face to look too hot. Backlit lighting will cause your face to be too dark because the light is in the background. This is why background lighting is...

How To: Perform a military push-up

In this how-to video, you will learn how to do a military push-up. This will work your chest muscles. Get into push-up position. Get on your hands and toes. Make sure the shoulder, elbow, and hand are aligned. Your back should be straight and your abs should be tight. When you go down, breathe in. Your nose will hit the floor. Breathe out when you go back up. The motion should last for about a second. Do these for as many push-ups as you can do. Your chest should be over your hands while you ...

How To: Do krooked grinds on a skateboard

In this video Jarvis from Skate Warehouse will demonstrate how to do a proper crooked grind. Starting by riding up to your obstacle pay attention not to come in at a parallel angle. Next pop an ollie to hit the obstacle, aim for a spot on the rail slightly ahead of yourself before slamming your nose on it and rotating slightly. After grinding the length of the rail push forward and lift up with your back foot to level the board before the dismount. Keep in mind to bend the knees and use your ...

How To: Control tail spin on a PicooZ mini helicopter

To begin in controlling the tail spin on your helicopter you need to turn your helicopter on and then turn the controller on. On your controller there are two trim bars. If it begins spinning to the left, tap the right trim; likewise, if it begins spinning too much to the right, tap the left trim. Unfortunately there is no memory in the PicooZ helicopter, so every time you turn on the helicopter you have to trim it. In the example video the helicopter needed to have the trim bar pressed 12 ti...

How To: Traditionally fold a bandana

In this tutorial, we learn the proper way to fold a bandana. This is a traditional way, not a rapper or gangster style. First, lay the bandana flat and make sure there are no creases in it. Next, fold the bandana into one big triangle. After you've done this, fold the top point down and keep folding down until you've made a large and thin rectangle. Now, flip it over and you can tie the bandana around your head. Tie it in the back of your head and place it across your forehead, now you've got...

How To: Use Virtual DJ with a laptop, DJ|iO & a mixer

In this brief video tutorial, the host show you how to mix songs and DJ using Virtual DJ. He recommends that you use a laptop with a minimum of four gigs of ram, have a version of Virtual DJ 5.0 or higher, have a mixer readily available, and have your own DJIO machine with the proper drivers and installation discs. You'll also learn how to solve a few common problems you may encounter with this software. This video is very informative for everyone who is interested in learning how to DJ using...

How To: Set up Virtual DJ with two separate sound cards

In this video tutorial, viewers learn how to set up Virtual DJ with two separate sound cards. Users may choose to use a proper PCI or USB sound card. Begin by the USB card. The drivers will already be on your system. Now open the Virtual DJ program and open the Settings. In the Sound Setup tab, click on the Output drop-down menu and select HEADPHONES. Next, click on the Sound card drop-down menu and select 2 CARDS. Now click on Apply and OK. This video will benefit those viewers who enjoy mix...