The Samsung Galaxy S5 display can be replaced by most do-it-yourselfers with some basic mechanical skills and a few inexpensive tools. The good news is that once you replace your display assembly your screen will be good as new with no bubbles or dust on the inside. The replacement part is a bit pricey but that is a good percentage of the cost involved with manufacturing this device. Below is a video showing the entire process from start to finish. It's best to turn on your volume for the nar...
To flip, or not to flip, that is the real question. When you're nervously standing over the stove or grill, what do you do with that steak before you?
Wondering how to get long hair naturally? How do you grow your hair? In this video Rachelle and Sam give you 10 tips to get those long locks naturally!
Learn how to play Graves as a ranged carry in League of Legends with this Champion Spotlight from Riot Games. In it, you'll learn what items, armor, runes, and masteries to get on Graves so that you can do the most damage.
The Titanite Demon boss fight in Dark Souls is pretty frustrating, but this IGN guide makes it easy. You'll want to use range to take him out, so try using your bow and arrow or magical spells. Defeating the Titanite Demon will provide you with the Demon Titanite item. Go figure.
Minecraft 1.8 has introduced Enderman to tons of blocky servers all over the world. If you're looking for ways to fight against Enderman or just avoid Enderman all together, take a look at this walkthrough on how to do both. Be sure to grab an Ender Pearl so that you can half their attack range!
Bastion is an indie game available via the XBLA or on the PC. If you're trying to earn first prize in the Slinger Range proving ground challenge for dueling pistols, you may be having a hard time. It's fairly difficult, but by spamming the mouse button and shooting fast, you should be able to walk away with first prize.
If you're looking to hook up your iPhone 4 to a TV, this video will let you know how it's done. Turn that 3.5 inch screen into a 40" monster with this helpful how-to.
In this video, beauty and makeup guru Michelle Phan shows us how to achieve a gorgeous Gothic Lolita look inspired by a range of things, from anime to dolls. You, too, can get the same doll-eyed look by following along with this video.
Killzone 2 is the latest iteration of one of the Playstation 3's only reputable exclusive series. It's a great shooter, and has many guns that are well-balanced and each offer distinct advantages. If you want to master the game, you'd better know how to use each one properly. This video will teach you everything you need to know about the Helghast StA-14 rifle, a semi-automatic but powerful rifle for medium-range combat.
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 1st installment in his series of Excel name tricks, you'll learn to use names in formulas and functions as well as how to edit them. See how to name a cell or range of cells with this free video lesson.
Nachos are a great snack food but did you ever think you could eat them for dinner? Well, in this tutorial, Betty shows us how to make her chili cheese nacho casserole, and it is so tasty you may never eat 'normal' nachos again! This is a great way to get rid of that stale old bag of Tostitos in your pantry and turn it into something fantastic. Ready? Vamenos!
Caramel popcorn is a great American tradition - whether you are at the ballgame or the movie theatre, everyone loves this tasty treat! In this tutorial, Betty shows you how to make this sweet and salty staple at home, fresh out of the oven. So, grab a blanket, your favourite flick and cuddle up on the sofa with this delicious snack!
You can never have too much mac & cheese! In addition to her fabulous creamy stovetop recipe, Betty unveils her fabulously gooey baked recipe in this tutorial. This dish has a delicious sharp cheddar bite to it and a crispy crustiness that is to die for! Impress your friends with this very easy and very tasty recipe.
"From the 1930s through the 1950s, the looks of various movie stars defined vogue magazine. From Mary Pickford's baby-doll face to Audrey Hepburn's cat-eyes eyeliner. The '60s ushered in a slew of makeup fad and the heavy eyeliner look remained through the late '70s and '80s, with wide color ranges entering the wearer's palette."
Characters in Japanese manga tend to have very expressive mouths, ranging from a smirky little line on one page to a giant "O" mouth on the next page. In this video, "Miki Falls" manga creator Mark Crilley shows how to draw mouths the manga way. And we won't just learn to draw one sort of mouth, we'll learn four different styles.
Watch this science video tutorial from Nurd Rage on how to make potassium permanganate with Dr. Lithium with potassium nitrate and manganese dioxide.
By using LEDs that only put out a little light the eyes can be lit in dim room light but still appear white, the moment the eyes are in shadow they glow bright red. Watch this video tutorial to see how to make glowing LED creature costume eyes for your film or costume project.
Around 1000 cases of vulval cancer are diagnosed every year in the UK, mainly in women who have been through the menopause. However, there are also a range of other vulval conditions that affect all women – highlighting how important it is to self-check your vulva. Although it may seem daunting if you haven’t self-checked before, Dr Dawn Harper’s guide will show you exactly how to conduct the check – so grab that mirror! Watch this video tutorial and learn how to perform a vulval self-examina...
Unless you're a high-schooler building a nuclear fusion reactor, the hardest part of a science investigatory project often is coming up with a good idea. You want it to be cool yet feasible, novel but still useful.
In this video, we learn how to play the cello with range and clefs. With the cello, you have the C string, the G string, the D string, and the A string. This is just like the viola and violin, just an octave lower. You will read in three different clefs. The tenor clef looks similar to the alto clef but the middle C is in the middle of the clef. As you get above the staff, you will get to treble clef. The main clef will be the base clef, but try using the treble clef for a melodic tune that s...
As a Zerg, you'll be facing Terran armies, time and time again. But how do you beat them? How do you beat a Mech unit? This video will give you some strategic advantages to defeating a Terran Mech army unit as a Zerg in StarCraft 2: Wings of Liberty. For the Zerg, positioning is your largest factor in winning a battle. Can you surround, flank, can you sneak in, can you drop on them? Any of those allow your shorter ranged troops to close the gap and get into range of your enemies troops faster...
In order to clear the cell content in Excel, using a macro, you will first need to have a table. If you don't already have a spreadsheet, you will need to create one with random numbers. Next, highlight some numbers, by clicking one box and dragging in order to select a number of boxes. Click Alt + F11.
In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.
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 15th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with tables in Excel 2007. Specifically, you'll see the following:
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 3rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to name a range of cells; how to use names in formulas;
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 219th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function so a macro to create a pivot table will work even when new records are added.
Microsoft excel is a powerful tool used to work with numbers and data by filling them down in rows and columns of a table. Excels also supports macros, which are small scripts to automate certain functions. In Microsoft Excel you can select entire rows and columns using the range property. You can also use macros to select individual rows and columns as well as multiple variations of rows, columns, and individual cells all at once. In Excel a horizontal line of data is called as row and a ver...
1.Here 10-50 and 300-400 numbers are taken for example to generate the random numbers within the limit in Excel. We using the command of "randbetween" for generate the random numbers and we won't get the decimal or fraction values.2.Now type "=randbetween(10,50)" which means to generate the random value between the bottom value of 10 and top value of 50 and click enter now we will get 11 as random generated number.3.Do the same thing for 300-400 as "=randbetween(300-400)".You will the 303 wil...
Sure, you can buy Rice Krispies or something similar - but making your own puffed rice at home is not too difficult, and is much healthier! This techinque works with any starch. Fully cook your rice, and then dry it out (it usually needs about 24 hours to dry completely). Then take an oil with a high smoke point (such as canola oil) and heat it in a wok. Pour your rice into a strainer, and then submerge in the oil for a few seconds.
We love ponytails - for yoga class. They're ridiculously easy to throw together, which is why they're great for on-the-go hair management. But just because the ponytail is a practical, functional look doesn't mean you can't dress it up and wear it to formal occasions like cocktail parties and work.
Having short hair is both a blessing and a curse. Short hair is a LOT easier to maintain than long hair, but at the same time there are fewer options for styling.
Even if you were born with luxurious flaxen strands so gorgeous they'd put spun gold to shame, it's still important to maintain a haircare routine that continually moisturizes and cleanses your strands to keep them in tip top shape.
You know how sometimes you'll look up a recipe from a famous chef, and then when you take a gander at the ingredients list it looks longer than the last "Harry Potter" book? Complex, "high art" dishes sometimes do requires what seems like a million ingredients - and precise stirring and heating times - to accomplish.
In this tutorial, we learn how to cook delicious earth friendly trout. First, throw 4 tbsp butter in a saucepan and then juice 2 tbsp lemon juice. From here, grab some fresh chopped Italian parsley. Once the butter is a golden brown color, it will be finished melting. After this, you will turn the heat off and then take 1/2 tsp and spread it on your boneless rainbow trout. Then, sprinkle on salt and pepper and place under a preheated hot broiler for a couple of minutes. Trout cooks very fast,...
If you've been wondering how to clean your silver, this video will show you a simple way to do it using products you have laying around. To do this, you will need baking soda, aluminum foil, hot water, and your dirty silver of course. First heat up water so it's close to boiling, not just hot water from the sink. Pour this into a large bowl to fit your silver, then grab sheets of heavy duty foil. Place the foil into the large bowl along with a few cups of baking soda. After this, place your s...
There are as many ways to curl hair as there are ways to do a smoky eye. While your basic tools are the same - curling iron, flat iron, or hair rollers - there are so many different techniques you can employ to create your desired look.
In this video, we learn how to make hip hair accessories. First, you will need some little cut out shapes, flowers, bows, bobby pins, and hair barrettes. Now, grab your bobby pin and heat up a hot glue gun. Put the glue onto the bobby pin, making sure to avoid gluing your fingers. Put it on the side that doesn't open so it's on the back of the pin. Then, quickly glue on whatever you would like to be on the pin. After this, let the pin dry and you can wear it in your hair. This will save you m...
In this tutorial, we learn how to make tamarind red chili pickles. This is made by grinding up ripe red chilies with tamarind. After you do this, you will make sure the combination is well combined by stirring again with a spoon. When this is finished, heat up a skillet with oil and then sprinkle spices into the oil, allowing them to simmer for several minutes. Then, spoon the mixture into the oil and brown on both sides until it is finished. Serve when it's done cooking, then pair it with yo...
Whether you're making summer barbacue or preparing a plate of nice, juicy ribs for Thanksgiving dinner to sit alongside your turkey, it's important to know how to grill ribs right in as little time as possible.
