Delectable Range Search Results

How To: Reorder Profiles & Reset Matches in Tinder

The modern age of techno-dating has made an interesting landscape for social interactions when there is some modicum of romance (or lust). For those of us born before the internet evolved into the prolific monster it has become, we first met our love interests face to face. Today, however, apps like Tinder have changed the introductory stage, for better or worse.

How To: Use the SUMPRODUCT function in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the very first installment in his "Excel Formula Efficiency" series, you'll learn about the basics of Excel's SUMPRODUCT function — why some people use double negative and why other use times one.

How To: Make beef phat (or pad) thai

Today Itkman is going to demonstrate how to make Beef Pad Thai. Begin by chopping garlic and bean sprout into small chunks (not minced). Next chop young green onion into one inch sections. Next chop the chili into small chunks roughly equal to that of the garlic. When ready place a 12-inch frying pan onto the range and turn the heat to medium-high. Add one tbsp spoon of cooking oil. Shift the pan to allow the oil to completely coat the bottom and then add the garlic. Allow the garlic to cook ...

How To: Throw a great baby shower

Baby showers are a great time to bond with your girlfriends and help out new mommies. In this tutorial, learn some helpful tips to ensure your baby shower goes smooth and everyone has a fantastic time: especially the guest of honor!

How To: Change your NAT to OPEN with a Linksys router

This is a Computers & Programming video tutorial where you will learn how to change your NAT to OPEN with a Linksys router. Go to your browser and type in 192. 168. 1. 1 and that will take you to the basic set up. The authentication dialog box comes up. Type in ‘admin’ for the username as well as the password. These are default settings. In the Linksys page, go to ‘applications and gaming’ and on the Port Range page fed in these information. Your application you can name anything. Start 80, E...

How To: Make granola bars with a quick, easy recipe

HealthyCook teaches viewers how to make healthy but easy granola cereal bars! You can use oatmeal oats, grains and all different types of oats (You don't only have to use just one kind). Choices range from jumbo oats, barley flakes, rye flakes and ordinary oatmeal oats. Gluten free choices are barley flakes, brown rice flakes (in small quantity), millet flakes and finally quinoa flakes. Use 100 grams of softened butter and mix it in a large bowl. Add in 75 grams of dark molasses sugar and mix...

How To: Choose a bicycle helmet

In this how-to video, you will learn how to choose a proper bicycle helmet. They are the most important safety equipment a cyclist owns. Picking the right helmet starts with understanding what a helmet consists of. The micro shell is the thin tough layer that covers and protects the interior of the helmet. It absorbs the impacts of the helmet. The adjustable retention system consists of 2 straps. The chin strap goes across your chin and the other goes across the back of your head. The vents a...

How To: Draw cartoon faces

In this tutorial, we learn how to draw cartoon faces with Eric Merced. First, start off by drawing a round circle, but keep the pencil light and make a bunch of marks. Then, draw a line over the face to mark where the eyes will be, then draw in the hair and ear. Darken your pencil when you draw the things that will stay, such as the eyes, nose, hair, and eyes. Draw a couple lines for the neck, then shade in. For a different face, draw a line as the center of the face, followed by three other ...

How To: Record and use macros in Microsoft Excel 2007

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 52nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to record and use macros in Microsoft Excel 2007.

How To: Use the INDEX & MATCH functions 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 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the INDEX & MATCH functions.

How to Play Battlefield: Bad Company 2 - Ch. 12: Airborne

This is it. The last one. The last mission in Battlefield Bad Company 2. Airborne. This is where you and your unit finally find the scalar weapon. If you're scared of heights though, this might be the most terrifying mission of all, with a freefall plummet down to the Earth's surface. Yo have to shoot and kill Kirilenko when you're falling, too, so don't panic. Watch this video walkthrough to learn how to complete the Airborne mission in Bad Company 2 on the PS3.

How to Play Battlefield: Bad Company 2 - No One Left Behind

Things are really heating up now with that the Russians are putting on the pressure in Battlefield Bad Company 2. This time your helicopter gets hit by an RPG and you need to put it down and make your way through the clearing in the jungle. Destroy all the M-Com Stations, and nobody can die. Watch this video walkthrough to learn how to complete the No One Gets Left Behind mission in Bad Company 2 on the PS3.

How to Play Battlefield: Bad Company 2 - Sangre Del Toro

The first thing you need to do in this mission on Battlefield Bad Company 2 is to hop out of the copter and get in the sand buggy and head to your marked location. You'll need to locate and head to each station on the map: Bravo Base Station, Charlie Base Station, and Alpha Base Station. After that, complete the Triangulation Point. Watch this video walkthrough to learn how to complete the Sangre Del Toro mission in Bad Company 2 on the PS3.

How to Play Battlefield: Bad Company 2 - Snowblind

Make your way to the crash site in this mission on Battlefield Bad Company 2. You'll need to protect the crashes satellite from RPGs and enemy fire. Then you need to destroy yet another M-COM Station, so make sure you're ready. Watch this video walkthrough to learn how to complete the Snowblind mission in Bad Company 2 on the PS3.

How to Play Battlefield: Bad Company 2 - Crack the Sky

Crack the Sky in this mission on Battlefield Bad Company 2. Use the minions on the helicopter to to take care of your enemies below, and once you kill them all, the copter will drop you off where your real mission starts. Make sure to destroy the M-Com Station. Watch this video walkthrough to learn how to complete the Crack the Sky mission in Bad Company 2 on the PS3.

How to Play Battlefield: Bad Company 2 - Upriver

In Mission 4 (Chapter 3) of Battlefield Bad Company 2, you need to first take care of the sniper. You can only fire the sniper rifle during the thunder, or you'll automatically lose the mission. So make sure you have sniper sensibility in this mission. Watch this video walkthrough to learn how to complete the Upriver mission in Bad Company 2 on the PS3.

How to Play Battlefield: Bad Company 2 - Heart of Darkness

This is the third mission in Battlefield Bad Company 2 called the Heart of Darkness, where you need to follow your unit through the ruined village. But first you have to survive the helicopter ride with the hippy pilot. You need to destroy the M-COM stations to succeed in this mission. Watch this video walkthrough to learn how to complete the Heart of Darkness mission in Bad Company 2 on the PS3.

How to Play Battlefield: Bad Company 2 - Operation Aurora

At the very beginning of Battlefield: Bad Company 2, you and your squadron are floating down a river behind enemy lines. At first, you're just watching and learning, then you finally gain some control and learn how to use your weapons and make your way around the battlefield. Watch this video walkthrough to learn how to complete the prologue Operation Aurora in Bad Company 2 on the PS3.

How To: Choose and place a fire extinguisher

Bob and Leslie of the Washington Township Fire Department demonstrate how to choose the right fire extinguisher for your home. Fire extinguishers come in a large range of sizes so be sure to choose one that you can easily handle. If it’s too heavy you won’t be able to use it properly. Fire extinguishers are labeled according to the type of fire they are used on. A is for ordinary combustibles such as wood or paper; B is for flammable liquids such as gas, grease or oil; and C is for electrical...

How To: Make a quick bow in the wilderness

John Campbell, from azbushman, demonstrates how to make a quick bow and arrow in the wilderness by collecting natural materials and constructing them with cord. He starts by finding seep willow (also called coyote willow) that grows in clumps near rivers. He cuts ten willow sticks and ranges their lengths from about five feet down to about one foot, each a couple of inches shorter than the next.

How To: Create drums sounds using Reason's Thor synthesizer

Create drums sounds using Reason's Thor synthesizerYou can use the Thor synthesizer to make a kick, snare, hat and clap sound.Kick:Use the analog oscillator with triple wave form octave3. Set the source to mod envelope 45 destination oscillator 1.Use a very short attack to K and release time. You get the short effect of pitch. Try different oscillator types to get different textures.Snare: Use the same basic patch that we created for the kick. We will keep it as the basis for most patches for...

How To: Achieve good soldering joints

Learn how to solder wires with this video. Clean the area to be soldered, scraping the wire down to bare metal and then wiping it clean with alcohol or acetone. Use rosin-core solder for electronic applications. This solder normally comes in coils. Tin (coat with solder) the soldering tip first: Wrap one or two inches of solder around the tip while the iron is cold; set the iron to the solder's temperature range; and allow the solder to melt. Clean the tip with a sponge. Set the soldering too...

How To: Write your novel scene by scene

If this is your first novel or you want to make a better one then this video will give you good advice on how to write fiction character for a great novel. The animated animals and people in this video will give you some great advice to improve your novel.

How to Walkthrough Bayonetta: Ch. 8 - Route 666

Complete five verses in this level of the Xbox 360 game Bayonetta. In Chapter 8 - Route 666, prepare for some hard battles. The first verse fight takes place on the back of a moving truck. There are two enemies with health bars on the same truck where you start. On other nearby vehicles you'll find minor enemies with ranged weapons who will shoot at you. If you fall off the truck you'll be killed. For more info, watch the whole gameplay.

Walkthrough Assassin's Creed 2: Mission 51

Infrequent Flier: Fly through this episodic mission and take control. As you take flight, immediately pause the game and check out your map. You can see the locations of all of the fires in the city, as well as the target to the far, far southeast. If you make a simple beeline for the target, the Palazzo Ducale, you won't get the updrafts you need to maintain your height and infiltrate the fortress. Instead, you need follow the trail of fires that lead you east and then north before finally t...

Walkthrough Assassin's Creed 2: Mission 24

Fox Hunt: When you trigger this mission, you're asked to find a particular man among the crowd in the village square that's marked in green on your map. Use your eagle vision and only the guy you're looking for will glow gold (guards glow red, everyone else is darkened out). When you find the man, approach him for a quick, puzzling cut scene.