Year End Search Results

How To: Make it through Vault 34 alive in Fallout: New Vegas

In Fallout New Vegas, if you've done the "Come Fly With Me" quest, or if you've done any adventuring out into the north eastern part of the Wasteland you may have come across Vault 34 on your way to the strip. Vault 34 is infested with Ghouls, the former residents of the vault, turned into hideous creatures from the intense radiation. But this isn't your only worry, there's also a constant ticking of radiation during your stay, so unless you're packing Rad-X and RadAway, your trip won't end w...

How To: Understand polyatomic chemical formulas

This is a video tutorial in the Education category where you are going to learn how to understand polyatomic chemical formulas. When writing the formula using polyatomics, the same cross-over rule applies. 1st identify the metal and non-metal. Then you write the symbols, write the charges, cross-over the charges from top to bottom, remove the charge and simplify the numbers and remove the 1s. for example, iron (II) phospahate. The "ate" ending implies that phosphate is polyatomic. The symbol ...

How To: Find all shops, unlock all strikers in Scott Pilgrim vs. The World

Scott Pilgrim vs. The World has become a multimedia empire, and the game for the Playstation 3 and XBox 360 is fun and deep. This video will show you how to unlock the two hardest achievements in the game: Gourmet and Chaudown. Gourmet requires you to buy every food item in the game, and to that end the video show you where to find every store in every level. Then you'll learn how to unlock Mr. Chau and Mrs. Chau as strikers to get the Chaudown achievement.

How To: Make Italian timpano baked pasta pie

In this video, we learn how to make timpano. First, you will need meatballs, sausages, chicken, cheese, peas, pasta, and vegetables. You can prepare the dough yourself or you can purchase it from the grocery store if you don't have time. Place the dough into a large spring form pan, then prepare your meats. First, layer penne pasta into the bottom, then layer chicken breast in slices on top of that. After this, place on meatballs and frozen green peas. On top of this, add on cut up sausages, ...

How To: Make a Fast Rope for Climbing, including an eye splice

Generations of Americans have struggled to climb up normal ropes in gyms across the nation. If only they had this stuff. Fast rope is a thick braided rope that makes climbing a hell of a lot faster and easier. This video will show you how to make it in three parts: first making the rope itself, then making an eye splice for it, then whipping and fusing the end of the rope. This is great stuff to have for any serious climbing trip or survival situation.

How To: Beat the Tactical Command Challenge with flawless gold ranking in StarCraft 2

Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...

How To: Get the achievement Cash Reward in The Outlaws mission in StarCraft 2

Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...

How To: Complete the Path of Ascension Challenge with a Gold rank in StarCraft 2

Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...

How To: Use the SUMIF function with an array 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 694th installment in their series of digital spreadsheet magic tricks, you'll learn how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If you need to sum by year from transactional data the SUMIF and YEAR functions cannot be used together. Instead we can use the SUMPRODUCT function.

How To: Wrap a gift so it comes out perfect every time

In this video, we learn how to wrap a gift so it comes out perfect every time. Start off by unrolling the wrapping paper out on a flat surface and cutting out a large square. After this, place the box upside down onto the wrapping paper. After this, meet the two ends to the middle of the gift and tape it down. Next, start to crease the edges of the sides down and flip the gift over. After this, push the top of the sides down, then tape it. Push the sides and bottom up and then tape it togethe...

How To: Play the Adam Sandler song "I Wanna Grow Old With You" on ukelele

The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "I Wanna Grow Old with You," made famous by Adam Sandler at the end of The Wedding Singer, on ukelele.

How To: Win playing the Protoss race in StarCraft 2

Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...

How To: Play as the Terran race in StarCraft 2

Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...

How To: Play and win as the Zerg race in StarCraft 2

Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...

How To: Successfully attack with any race in StarCraft 2

Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...

How To: Use the Nydus Worm to harvest resources in StarCraft 2

Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...

How To: Get more megapixels and wider angles with a DSLR

Everyone who has a digital camera, no matter how high-end, wishes that they had more megapixels and wider angles at their disposal. Do you want to increase your megapixel count without buying a really expensive camera or camera parts? This video will show you some tricks for taking pictures with more megapixels and wider angles without buying a nicer camera, which will make your photos look better and make your work more professional. You will need Photoshop, but if you're serious about photo...

How To: Make a retro ray gun prop for film or costumes

It's funny how unevenly the real world keeps pace with science fiction. Smartphones have capabilities that Gene Roddenberry never imagine a portable device could have, but guns still use tiny powder cartridges to launch hunks of metal at things. The phasers, ray guns, and blasters of Star Wars, Star Trek, and other sci-fi works have yet to appear. Don't let that hold you back! This video will show you how to make a cool retro ray gun prop that you can use with a Halloween costume or in a film...

How To: Create a glowing particle dust effect in Photoshop

Photoshop might be the best software out there for creating effects on text and other still images. This video will show you how to create one really cool effect in Photoshop on a title. The creator calls this a glowing particles dust effect, and that sounds about right. The end result is words that are surrounded by a unique cloud of glowing particle dust. It looks really cool, and should really spice up your website or film titles.

How To: Chop up an onion without tears

In this video tutorial, viewers learn how to cut an onion without crying. Users will need to cut out the bulb of the onion. Begin by cutting out about 1/3 of the entire diameter of the onion. Cut it around the root part of the onion and take out the bulb part of the onion. Then remove the brown layer of the onion and cut down from the end point to the root point of the onion. Continue cutting the onion to your desired cut. This video will benefit those viewers who are interested in cooking, a...

How To: Use procedural modeling to create a rock in 3DS MAX 9

The noble rock may not seem like the most fun thing to create a 3D model of. They are a useful example though because their basic shape and lack of movement make them manageable for beginners to work with while their many facets and textures present fun areas to work with. This video will teach you how to use procedural modeling and texturing to Create a 3D model of a rock using 3D Studio MAX 9. The end result looks positively stony, and the lessons you learn here will help you with all your ...

How To: Model particle dispersion in 3D Studio MAX

The teapot dispersion method is a standard technique for teaching particle dispersion in 3D Studio MAX. This three-part video seeks to use the infamous example to explain particle dispersion as effectively as possible. It explains basic particle systems and material animation properties, and by the end you should be able to model a 3D teapot turning into a million little teapot particles.

How To: Mod your XBox 360 case

The XBox 360 is expensive and powerful. Does yours not do enough for you, or do you just want to give it a cool new look? Mod it! This three-part video will teach you how to do a pretty intense case mod on an XBox 360 step-by-step, the end result of which is an X-shaped plexiglass window in the side of your XBox. Looks cool, stays cool, all in all, a very cool mod that you should try next time you're feeling bold enough to take a saw to you 360!

How To: Unclog a toilet in 11 seconds like a pro plumber

In this video tutorial, viewers learn how to unclog a toilet in 11 seconds. Users will need a plunger. It is recommended to use a pleaded plunger, instead of the regular plunger. When clogging a toilet, the rubber of the plunger is filled up with water, pushed down and squeezes out the pressurized water. The force from the pressured water will remove the clogging of the toilet. Slowly place the plunger into the water and let it be filled with water. Align it with the toilet hole and then push...

How To: Make a Michael Jackson Lego minifigure

Do you still think that Michael Jackson is the King of Pop, even in light of the many controversies that surround the end of his life and his untimely death? Do you also love Legos? The show your love for both. This video will teach you how to make a custom Lego minifigure that resembles Michael (Michael from the "Beat It" music video to be exact) using only paint and some hobby tools. Memorialize the King of Pop in a special using the instructions from this video.

How To: Make a Lego minifigure of the Terminator

The Terminator is Arnold Schwarzenegger's most famous character, and arguably the most popular cinema cyborg of all time. This two-part video features detailed instructions for making your own very small terminator out of two Lego figures, one skeleton and one normal, and some basic hobby tools. While it may seem like a lot of work to make, the end product is really, really cool.

How To: Make Optimus Prime out of Legos

Optimus Prime is one of the most famous and highly respected of all cartoon robots. Express your admiration and demonstrate you skill with Legos by using the instructions in this four-part video series to build a model of the leader of the Transformers. It is very elaborate, and requires many pieces, but the end result is very cool, and should justify not being taken apart for other Lego projects for a long time.

How To: Perform a full chest exam on a patient

When you're examining a patient's chest, you start out by simply looking at them— by inspection. It will be hard to count the respirations visually on a healthy person's chest because it moves so little, but in a patient with respiratory distress, the chest might be overactive and strain may show in the neck muscles. Eve Bargmann, M.D., will also teach doctors about palpation, percussion, and auscultation of the chest and back.

How To: Play lead guitar licks like Angus Young from AC/DC

Angus Young of AC/DC is one of the true icons of rock guitar, both for his style on stage and for his amazingly simple but awesome-sounding blues rock licks. This video teaches you how to play six very cool such licks on electric guitar (did you think you were going to play Angus on acoustic? Come on.) quickly and easily. It breaks the licks down at low speed so that you can practice, practice, practice them until, even as a novice guitar player, you end up shredding just like the legend hims...