In this video the instructor shows how to use the Round function and also format numbers in Microsoft Excel. Normally while calculating formulas in Excel, the formatting of numbers can get you into a lot of trouble and to get around this problem you need to use the Round function. To do this take some sample data in a Excel work book and apply any formula that you want on the data to arrive at some calculation. Now because of this formatting some times you can arrive at a wrong result as show...
Basic instructions on how to troubleshoot the heater blower motor of a Saturn S-series. The heater blower motor is located behind the glove compartment of your vehicle. Disconnect the negative and positive power supply. (The black wire is usually the negative.) Using a multimeter set on the Ohm scale, use the positive lead and test the black wire. To check the purple wire for current, use your ignition key and turn it to the run setting, turn the heater power to full power and set the multime...
This is a great instructional video on how to make Filipino style chicken curry. The ingredients required are chicken pieces, fish sauce, celery cut into pieces, coconut milk, ginger, garlic, potatoes simmer, red bell pepper and curry powder. First put potatoes into the frying pan and fry them. Now fry the chicken too. Now put garlic, ginger and onion into frying pan and fry them. Now add fried chicken to this. Add fish sauce and curry powder. Now mix the ingredients evenly. Add one cup of wa...
Flowering bulbs require some few common tools before planting such as compost or peat moss, work gloves, fertilizer, garden trowel or bulb planter and the garden bulb of your choice. During the spring season you can plant tender bulbs such as, irises, gladiolus and elephant ears. In terms of fall plantings you can plant bulbs such as tulips, daffodils, hyacinths and crocuses which could give a beautiful bloom in the spring. In general the blooms will last till three to four weeks, bulbs such ...
The proper steps to close your swimming pool. The temperature in your region will be the key deciding factor on whether to close your pool or not.
This how-to video is about how to make homemade ginger and garlic paste. This video is provided by Anuja and Hetal, and they explains us the simpler method of preparing ginger and garlic paste which is used in most of the Indian dishes.
Here is the procedure to prepare a whipped / Float soap.
Finding Linux hard to handle after using Windows? Well this should help, here is how to install software on Linux. Start off by clicking on application launcher. Here go into applications, then into 'system' where you should find software management. In this program go straight into the settings and then edit software sources. Under 'downloadable from internet' make sure every option has a check against it. Now press the software management tab on the side. Now this is where you can get which...
This how-to video is about how to bake and frost a carrot cake. Ingredients required:
This how-to video is about demonstrating the Leidenfrost effect with methyl alcohol and a penny. To demonstrate the Leidenfrost effect the following items are required:
Watering requirements for deciduous trees is dramatically different in autumn than at other seasons throughout the year. In the autumn there is less wind, less evaporation, the temperatures are lower and so there is less of a problem with dehydrating the plant. When you plant the tree. Dig a hole and put the tree in the hole. Fill the hole half way full of soil and flood the rest of the hole with water. Let is soak in and then fill it again. This will soak the roots and also the ground around...
Not sure how to balance a chemical equation? According to the rules of chemistry, matter must be conserved in chemical reactions. When you balance a chemical equation, you account for all of the matter in the reaction.
Looking to get an FHA loan? The Federal Housing Administration, FHA for short, provides mortgage insurance on loans made by FHA-approved lenders throughout the U.S. Here's how to get your FHA-insured loan. Learn how to get one with help from this video.
• Start by warming and relaxing the lower back of the person you are looking to massage. Warm some massage oil in your hands, and spread it evenly over their lower back.
Did you know you can use your iPhone as a portable modem for your other devices? The first thing you need to do is set up Internet tethering on your phone. This is not difficult and requires only a jailbroken iPhone and a computer to do. Some hackers charge over $20 to tether your phone, and with this video, in a few simple steps you can accomplish it for free.
Have a tee shirt that has lost all of its spunk? Instead of letting it linger in the closet for the rest of its life, bring it back to life with a makeover. A T-shirt doesn't just have to be a T-shirt! See how to turn a tee shirt into a sleeveless top in this video from GiannyL.
The first thing you have to do make a movie is to click on Start and go to windows Movie Maker. And then click on Import media to edit the video which you want. And then drag the selected video to Time line at the bottom. If you want to make your movie for less than a five seconds or so click on the Trim and drag it to your left hand side. When your done with that click on file menu and click on publish movie. You can name your file and can also choose the destination you want and then click ...
Nexus is a pre-approved trusted traveler program that allows approved people expedited travel between Canada and the US. The card is available to US and Canadian citizens or permanent residents who travel by air or land between the two countries. Anyone traveling between the two countries must have their own Nexus card including babies. The Nexus card is considered a privilege by both the US and Canadian governments. You must have a clean record with both the Canadian Border Services and The ...
Don't have the perfect scarf? Sometimes you can't buy perfect, sometimes you have to make perfect, so create your own cozy scarf! Can't find the right material, color, or style? No problem, design your own. See how to make a a cozy scarf in this video from GiannyL.
Wearing a seat belt while in a car can save your life. Do you know how to adjust and properly use it? Learn how to drive safe and use seat belts properly (Ford DSFL). A professional driver explains how to fasten your seat belt properly.
What do you know about braking in an emergency situation? If you're not even sure what kind of brakes you have on your car or truck, then you need to do some research. Learn how to drive safe and deal with emergency stops (Ford DSFL). A professional driver explains the differences between braking with Antilock Braking Systems (ABS) and standard braking systems.
Driving a vehicle is a big responsibility and road safety is paramount. Improve your driving skills by using your most important tool -- your EYES! Learn how to drive safe and always look ahead (Ford DSFL). A professional driver explains why it's important to look where you want to go, not at an obstacle, when you're driving.
When you're on the road, you want to be in control of your vehicle. The only way to be in control and improve your driving skills is by having good hand positions and correct and comfortable seating position. Learn how to drive safe with a good hand and seat position (Ford DSFL). A professional driver gives this important tip about seating position.
Looking to make a special scrapbook? You've got the "scraps"—now you need the book. Before you rush out and buy the first flashy binder that grabs your eye, put a little thought into what you really need.
Cleaning a toaster can be tricky if you've never done it before, but this appliance only requires a little bit of your time to keep it clean, safe, and functional.
Thinking it's time to give up the juice? If your need to drink has become a problem, quit. This lifestyle change requires planning and ferocious self-discipline, but everyone has it in them.
Usually those "dry clean only" tags mean one thing: dry cleaning bills. Why sacrifice wearing silk, suede, or other fine fabrics when knowing just a few clothes care tips can save you tons of money on dry cleaning.
Have you been noticing a small stench trailing throughout your home? Is you teen going through "changes" and you don't know how to approach them? Follow these tips to keep your home and teen smelling like roses.
The first thing that comes to mind when your car is stolen is: ####!! However, once calm, cover these bases when your car is stolen to notify relevant parties and help ensure vehicle recovery or replacement.
If you're not an everyday woodworker, then building a deck may be a challenge for you. But it's not as hard as it might seem. If you follow all of the required steps for deck building, you'll have one of the best ones on the block, and be pretty darn proud of it, too!
Want to impress some friends? This magic trick requires no sleight of hand, just a bit of setup. Using the Magicard application, you can make your iPhone mysteriously identify the card placed against it.
Broken AVI video files are your worst nightmare. Nobody wants to watch a video and find out it's corrupted and not working anymore. But there could be a solution on Linux. This computer operating system could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to fix broken AVI files with DivFix++ on Ubuntu Linux.
Whether or not you're an aspiring magician or just curious, this trick is great to learn. It requires only one prop and only involves a very slight modification.
Superman is one of the greatest and most known superheroes out there. Developed by DC Comics, Superman has seen the world… as in comics, television, newspaper strips, video games, movies, radio serials, etc. See how to make a Superman costume in this video from GiannyL.
Whether you want to save money by making your own clothes or you just enjoy working with fabrics, choose the best sewing machine so your projects turn out great.
Breaking a lease is almost always considered a legal breach of contract, even if a tenant has a good excuse. Here are some exceptions to the rule
Eagle Lake Woodworking, hosted by John Nixon, offers great do-it-yourself guides for building your own furniture, especially in the American Arts and Crafts style, and turning your garage into an amateur woodshop. Search Eagle Lake on WonderHowTo for more carpentry tutorial videos. From Eagle Lake Woodworking on this specific lesson:
Elegant fashion is easier to come by than many assume. This tutorial shows you how to sew your own simple V-neck women's tunic with added flutter sleeves. You don't even need a pattern, just a few torso measurements for your wearer!
If you want to stop telemarketers from calling, use this guide and try a multi-pronged approach. You Will Need
Professional camera cleaning is expensive and usually more than you need. Follow these simple steps to keep your lenses clear and smudge-free.
