Unique Solution Search Results

How To: Fix any reception issues with your iPhone 4G HD

So.. you spent 200, 300 or even 600 bucks on your new iPhone and now you have no reception! It seems as though Apple was so busy developing cool new apps for it's latest creation that it forgot about the fact that its.. oh right.. also a PHONE. If your new iPhone 4 cuts out every time you hold it, check out this clip. This tutorial will offer some awesome tips and speedy solutions to this annoying problem. So, if you are about to run up to Cupertino and tell Steve Jobs where he can stuff his ...

How To: Use FREQUENCY array functions in MS 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 and Mr. Excel, the 627th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create, edit and otherwise work with FREQUENCY array functions.

How To: Make cheap homemade cleaning solution for your PC

Are you sick of spending a ton of money on not so great cleaning supplies? Well, if cleaning the screens around your home are the problem, check out this tutorial. In this video you will learn how to make a super effective cleaning solution for your TV, PC, laptop, iPod screens, etc for about a dollar! This couldn't be easier to do, and your screens will be clear and shiny in no time.

How To: Create a nested unique list via a pivot table in 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 250th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a unique list of customers within a unique list of sales representatives using a pivot table (PivotTable).

How To: Make "hot ice"

In this video tutorial, viewers learn how to make "hot ice". Users will need sodium acetate. Begin by putting the sodium acetate into a pan. Add a small amount water to the sodium acetate. Heat the mixture on a stove until the sodium acetate has dissolved. Pour the solution into a container. Do not pour in any undissolved crystals. Put the container into the freezer or refrigerator for a while. When the solution cools down to room temperature, take it out. Touch the sodium acetate and it will...

How To: Wash windows the easy way

Ron Hazelton shows you an easy an effective way to wash windows. In a warm bucket of water you add one tablespoon of dishwashing solution, a scrubber with sleeve is used to apply the solution to the window, and dried with a professional quality squeegee. Each step is shown and explained in full detail to ensure the best possible completed outcome. After watching this video and walking yourself through the steps a few times you can wash a good sized window in about a minute.

How To: Make polymer putty with household materials

In this tutorial, we learn how to make polymer putty with household materials. You will need: borax, white glue, water, 3 plastic cups and spoons, and food coloring to color your putty. Now, dissolve 4 tbsp of Borax in 2 liters of warm water. Then, prepare equal parts of glue and water together. To make this, you will need 2 parts of the glue solution to 1 part of the Borax solution. Once you mix these together, you can add in some food coloring to it. Pour this into different cups to make di...

How To: Look up a picture 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 and Mr. Excel, the 42nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to look up a picture in Excel. See a VBA solution and a formula Solution using the INDIRECT function and named ranges.

How To: Solve inequalities by using addition and subtraction

Khanacademy teaches us how to handle simple inequalities (less than or more than). In an equation, we usually have one solution. In problems involving inequalities, there is a whole set of answers. For instance, x minus five is less than 35. The answer for x is a whole series of numbers that when five is taken away from it, is less than 35. This equation is handled like any other equation involving an equal sign. We add five on both sides of the equation and the answer for x is any number tha...

How To: Make a hamburger meatloaf

Do you like hamburgers, but feel that hamburgers at restaurants are too unhealthy and not a long term solution to your cravings? Well, this video is your solution. In just 10 minutes, viewers will be taught how to make their very own hamburger meatloaf. Using nothing but basic and simple techniques, the viewers could have tasty and healthy hamburgers in no time. Highly recommended to any person who likes to cook, enjoys a healthy lifestyle and most of all, likes hamburgers.

How To: Troubleshoot and fix broken windshield wipers

If your windshield wipers don't come on when you turn the switch, then try out the solutions in this video! First, check to see if there's a blown fuse. If that's okay, next check the power going to the wiper motor. You have to take the wiper arms off to get to the motor. Watch Scotty Kilmer in this video for all the remaining troubleshooting tips for broken windshield wipers.

How To: Get Oh, Baby! a unique super sledgehammer in Fallout New Vegas

At some point you'll find yourself in Jacobstown, a town filled with civilized Super Mutants and their counter parts, the Nightkin. You'll be asked by the local human doctor to check out Charleston Cave to find out why the Nightstalkers have been developing a natural stealth field. In the cave, however, lies a unique weapon called Oh, Baby! which is a unique super sledgehammer! In this video you'll get the location of the hammer and some info on the stats for the hammer itself.

How To: Make sure entries are unique in Microsoft Excel 2010

Looking for a way to ensure your entries are unique in Microsoft Excel 2010? This clip will teach you what you'll need to know. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, watch this free video guide.

How To: Use OpenAppMkt to get more apps for your iPhone or iPod Touch no jailbreaking

If you want to get more apps for you iPhone than those offered by the standard store, but are still intimidated by jailbreaking despite the fact that it has recently become legal, this video offers a solution for you. It will show you how to get and use an app called OpenAppMkt to get more apps for you iPhone or iPod Touch without needing to jailbreak it and access the Cydia app store!

How To: Make your iPhone 3G or iPod Touch 2G with iOS 4 run faster

If you haven't bought a new iPhone or iPod Touch since the 3G and 2G models of those respective devices, iOS 4 has probably been a major problem for you. It slows down those devices mightily, but there is a solution. This video will show you how to adjust some basic settings in your phone or MP3 player to make it run the new operating system faster and allow you to keep enjoying you device as you have for years.

How To: Cook and grill a whole chicken with Bobby Flay

Tired of having plain old roast chicken the way mom used to make it? Bobby Flay has the solution that is sure to get you excited about chicken all over again. This recipe for a grilled whole chicken will bring great new flavor to your bird. Don't forget to flatten it out first for a faster, smoother cooking process.

How To: Clean a dog's ears of dirt and wax

Your mother used to remind you to wash behind your ears now make sure you keep your dog in tip top health and clean their ears too. Dogs depend a lot on their hearing but can build dirt and wax in and around their ears which can be irritating or lead to infection.

How To: Make a matchstick stand up on its head

Is it magic or is it an illusion? See for yourself when you watch this video tutorial on how to make a matchstick stand up on its head. There's an easy solution to this magic trick, easier than you think. You don't need to be a magician to perform this match standing on its head trick. Anyone can do it!