Having a great storm water drainer attached to your home is not only important for preventing any damage to your home, but can be used to save on utility costs. Without a drainer, water can seep under your home and potentially damage your foundation. But it's an easy problem to fix and will make you glad you did.
If you live in an older home with windows that are aged, it's a smart idea to make sure they're sealed correctly. Doing so can not only result in a loss of energy in your home, but prevent cool or warm air from entering your home. It's a great and easy way to save on costs.
Calling someone to come out and repair your washing machine, can cost you quite a bit of money. So avoid having to call someone and do it yourself! With this helpful tutorial, you'll find out how to repair your washing machine's pump, motor, and couplers all in one video. You'll also find out how to remove the body of the machine as well as other parts. So good luck and enjoy!
In this clip, actress Julie Crisante explains some of the hardships you might have when you uproot and make the move to Los Angeles. Make sure you are ready for the major adjustment you will be facing. Los Angeles is an incredible city - it is beautiful, the people are friendly and always fun - but moving as an actor can be difficult for some. A lot of actors wind up leaving in their first year when faced with the cost and competition. Stay focused and stay in LA with these helpful tips from ...
In this clip, learn how to set up the HTC EVO's Hot Spot app. This app is very useful and by using it you can connect up to 8 other devices to your 4G internet via tethering and use your phone as a wireless modem. This app will cost you an additional 29.99 a month but if you are an Internet junkie, it will be worth it. So, follow along and watch this step by step for setting it up.
The iPhone has some pretty awesome video capabilities. Whether you are working with Cycorder from a jailbroken 2G or 3G, or Apple's own video camera in the 3GS, you will get pretty great picture resolution in a handy pocket size. In this tutorial, learn how to create your own tripod, on the cheap, for use with your otherwise handheld device. This will help you keep your image steady and stable and take great shots.
The iPad is a great looking device, but its very easy to get sticky, gooey fingerprints all over it very easily. Everything on the iPad is done with touch, so it is inevitable that it will get dirty quite quickly.
How to pick the right RAM for your computer
Digital copies are being used more and more on DVD and BluRay releases. They may cost a little bit more, but they are so worth it. After you transfer the movie's digital file into iTunes, you can easily make a copy to play on your Apple iPad. This video will demonstrate exactly how to transfer a digital copy movie to an iPad.
One way to update your living space is by installing new tiles. This video tutorial shows key strategies with tiling projects in your home. By planning material quantities you'll able to estimate the cost of your project. This instructional offers helpful tips on tile care, trimming and cutting, and how to safely use snap cutters and wet saws.
Accessorize your outfit with a pair of adorabe handmade upside down heart earrings! Why shell out tons of cash to walk down the street in style, when you can make your own accessores at home for half the cost!? In this two-part video tutorial, learn how to make wire wrap upside down heart earrings step by step.
Don't want to spend the 39 bucks for the iPad Case from Apple for your brand new iPad device? Well, the iPad costs enough, so why spend even more money when it's not necessary?
This video tutorial is going to show you how to steady your shots with a homemade fig rig. The camera is mounted right in the middle of the top bar and it uses the iron as the balancing mechanism. The official fig rig is about $300. But, the one shown in the video will cost you around $10. Cut a PVC pipe about 2 feet in length and glue on two T joints on either end parallel to each other. Now fix the two feet into the T joints as shown in the video. The larger the camera, the longer will be t...
Many people will agree that their favorite meal to go out for is crab legs. With this video from Chef Jason Hill from CookingSessions.com, you can learn to cook crab legs at home for a nice dinner that costs a lot less than going out to a fancy seafood restaurant. Instead of the typical boiling method, we see how to cook them on the grill! He also explains how to make homemade garlic butter using butter, garlic, rosemary and thyme.
JoAnn from Emerald City Elegance Paper Crafting demonstrates how to make a double accordion photo album. It's a cute and fun way to display your photos, and it's made simple with JoAnn's easy instructions. She takes us through the step-by-step process, indicating the proper tools and measurements needed to make this item. By following the steps in the video, you'll have yourself a beautiful little homemade photo album, made at a fraction of the cost of buying one from the store.
A Cheftips for cooking the best of the meat "Pork Ribs". It is considered that the pork ribs are the most affordable dish to feed a crowd at minimal cost. This video demonstrates the Hawaiian-style pork ribs recipe made with the use of pineapple juice and minced ginger. First he starts out by cutting the pork ribs and boils it on water. Then he mixes the ingredients garlic, ginger, sauce, honey, spreads it on the grills and throws it on the grill. If you are a rib lover, then you've got to lo...
Using blue tape and a dental bib during tattooing to protect a portable tattoo armrest from ink and blood. The process of protecting the armrest is simple. This process would prevent ink from being transferred to another person or even onto their clothes. Using the dental bib you place it over an armrest and use blue 3m tape to secure the dental bib. Once this is done you are ready to start tattooing. Very cost effective and efficient way to protect an armrest and others.
Beef has many primal sections; the chuck, ribs, short loin, sirloin, round, flank, short plate, brisket, shank, and beef is rated by the USDA. Prime has the most marbling, followed by Choice, then Select, which has the least.
After seeing many posts online about dry ice removing car dents, we put it to the test. It worked pretty well. The heat versus cold forces the panel of the car to constrict and suck out the dent. This is great for avoiding ridiculous costs of auto paint and auto body repair companies. DIY dent repair is as cheap as buying some dry ice. You can also look into using canned air (Dust Off) as it has a similar effect.
So you want to make a film, and in that film you want to have a sword, but you can't buy one, not to mention real ones are pretty dangerous. Your insurance costs will go through the roof! Well, here's you solution. Check out this helpful two-part video tutorial on how to make your own prop swords, which means less dangerous swords. Actually, they're made out of metal, so you still might just somebody with them yet.
Follow these step by step instructions to learn how to hack a vending machine, giving you two Cokes for the price of one. You and your friends will love this cool vending machine con. Never go thirsty again. Just check out this instructional video and start hacking vending. Machines nowadays are SO smart that they know you haven't received your drink and give your money back. Humans nowadays are SO smart that we can make ourselves not receive drinks we paid for, get our money back, and then b...
Find out how to use the powerful search functions in WonderHowTo. Learn how to refine your search to specific categories and subcategories.
In this tutorial, we learn how to use the groove function in Ableton Live 8. A group settings consists on points along the timeline where hits sit. If you have something with no groove applied, it will sound robotic. By adding a groove, you will shuffle around the midi from the hard quantized parts. This will add more human element to the audio. There is a button on the left with two lines that show the library with options you can use. You can also apply this to other clips, scroll through t...
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 706th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use the LEFT, SEARCH and TRIM function to eaxtract numbers from a text string that can then be used in a calculating formula.
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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...
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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.
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 679th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS functions.
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 670th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with one criterion. This is a lookup problem where you want to return multiple records from one lookup value. This formula is not an array formula because it...
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 652nd installment in their series of digital spreadsheet magic tricks, you'll learn see how to create Boolean Logic formulas for AND and OR Logical Formulas. See Logical Truth Tables for AND and OR. Also see how to create array formulas in two different ways: the SUMPRODUCT function (DON'T have to use Ctrl + Shift + ...
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 658th installment in their series of digital spreadsheet magic tricks, you'll learn see how to use the COUNT & COUNTA functions correctly. COUNT counts numbers. COUNTA counts non-empty cells.
In this video tutorial, viewers learn how to access every Windows 7 setting at once. Users will need to download the Windows 7 in a Box program provided in the video. Once downloaded, simply click on one of the functions (Functions, Folders, Internet Settings, Programs, Tools and Settings) on top of the window and select the option that you wish to use. This program will organize all the Windows 7 settings into an easy to comprehend layout. This video will benefit those viewers who use a Wind...
Recently purchased a brand new digital SLR? Learn how to use your camera's functions properly by watching this tutorial on how to use your picture control settings on your Nikon digital SLR.
New to trigonometry? Learn how to calculate cosine, sine and tangent with this lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how t...
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 605th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF function to fill in column with missing values then use Paste Special Values to create the final column with correct values. Also see three methods for Paste Special Values.
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 595th installment in their series of digital spreadsheet magic tricks, you'll learn how to resolve a problem that the DGET function and advanced filter have with criteria and duplicates. See how to switch to either the VLOOKUP function or not criteria for advanced filter.
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 588th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine whether an employee is exempt from a tax using a VLOOKUP in an IF function, and if not use a second VLOOKUP lookup query to look in tax tables to look up and calculate the tax
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 48th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP, ISTEXT, ISBLANK, OR and IF functions in one formula to look up a time value. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 228th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHAR (10) function to add hard line returns (forced wrapped text) to a text formula created with the ampersand (&) and concatenation tools.
New to 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 Excel tutorial from ExcelIsFun, the 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create th...
New to 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 Excel tutorial from ExcelIsFun, the 248th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the PERCENTILE and QUARTILE functions to calculate percentiles, quartiles and deciles in basic statistics.