Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 70th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to clean up a bad data set with the TRIM function before building a pivot table (PivotTable) to calculate an average. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
In order to clean and restore your headlights, you will need the following materials: razor blades, tape, liquid rubbing compound, and a power polisher.
This video shows us the method to protect your lens. This can be done by putting the lens caps. The cap for the part of lens going into the camera can be screwed on to the lens. It stops dust from getting on to the lens surface. The front part of the lens can be protected by a lens cap which can be put into the position and pulled out when needed. You can also put a filter on the lens. The filter can be used to protect the lens in case you drop it in the sand and any other similar condition. ...
All ballet shoes eventually get dirty. In this video, learn from one expert how canvas ballet shoes can be cleaned using calamine lotion that is dabbed onto the surface until stains are removed. Keep ballet shoes looking like new with this video conducted by an expert: Nene Ortega is a ballroom dance instructor at The Goddess Store in Hollywood, Florida. Learn more ballet from this expert by searching WonderHowTo! You're only practice time away from ruling the dance floor!
In this video, we learn how to make a homemade facial mask using durian (a southeast Asian fruit). First, grab some peeled durian and pick out the rich creamy pulp (leave the skin out). If you can't find this at your supermarket, try an Asian market. All you need is 1 tsp of this fruit for your entire face, then apply to your clean face. It will go on smoothly on your whole face. Let it soak in for 20 minutes and when it's done your face will feel tight. After this, rinse of your face and pat...
This video demonstrates how to caulk windows. For this project, you will need the following: a tube caulk, a putty knife, scraper, a knife or scissors, paper towels, a long hanger or a nail, a caulk gun, a small plastic spoon or a popsicle stick.
In this video tutorial, viewers learn how to choose the best sippy cups for toddlers. The sippy cup is a spill-proof drinking cup designed for toddlers. Choosing the right sippy cup will help keep both parents and children clean. The best sippy cup for toddlers is one that you can turn upside down and shake without dripping. Make sure that the cup is simple and easy to clean. It shouldn't have may layers. It is also a good idea to buy sippy cups that have caps. This video will benefit those v...
CCleaner is a executable freeware that will help clean up some space in your bogged down Windows machine. This tutorial will demonstrate exactly how to use CCleaner to drastically boost your machine's speed up to 40%.
This video describes how to make a cheap and effective furniture polish from scratch. To start, you should find some sort of dispenser to put the polish in. The video suggests an oil and vinegar dispenser because it works effectively with the furniture polish. Put a funnel in the container to make pouring easier, and add 1/4 cup of organic olive oil (make sure it is organic for cleaning). Then add 1/4 cup of vinegar and 20-30 drops of essential oil. The olive oil will keep the wood looking ni...
94-year-old Clara shares economical and delicious meals from Depression-era American homes. This episode: Dandelion Salad! Dig up dandelions and discard flowers, roots and dead leaves. Soak in clean water and rinse 3 times. Repeat twice more, if necessary. Dry leaves once they are clean. Arrange leaves in bowl. Pour lemon juice and olive oil over leaves. Mix salad with a spoon or your hands. Enjoy! Follow Clara's instructions and you will have a fresh, delicious and very economical salad stra...
This video will show you the advantages of a shower wand and how to install one easily. A shower wand can help you clean the shower and clean pets too. To remove the shower head you will need a strap wrench. You may want to change the shower arm if it has too many scratches; use the handle of a set of pliers. Use Teflon tape when reassembling the fixtures to ensure a watertight fit. The new bracket has a built in holder for the wand.
Ron Hazelton shows how to restore a weathered and worn deck. Twisted boards can be straightened using a notched 2x4 as a lever, then secured with 5 inch screws. Remove popped nails, and replace with longer thicker nails. Use a punch to countersink slightly high nails. Clean the deck with wood soap and a long handle brush, using a pressure washer to rinse. Apply sealer to the dried wood and let it cure, then enjoy your reinvigorated deck.
To solder copper pipes, start by using a sharp blade and scrape the end of the pipe you are going to solder. This will get all the burrs off of the pipe. Next, take some steel wool and clean the pipe so that it is nice and clean and shiny. The next step is to apply some flux. Use a rag to apply the flux to the end of the pipe. You want to make sure that the flux goes all the way around the pipe. After putting flux on the two pieces of pipe, put them together using the fitting. Take the blowto...
Do you have grayed tile grout? Do you spend tons of money on clearners to only leave you displeased? In this video hosted by DIY home guru, Ron Hazleton, learn how to remove discolored, flaky or powdery grout & how to apply new grout and clean the faces of your tiles.
Not sure how to safely clean your wood table without ruining it? In this video tutorial, learn how to properly wipe off your table and how to protect it with a sealant called, Pastewax. This substance dries and does not attract dust making your table look shiny & new, like a piece out of a museum!
One day, your car may break down and you won't be able to afford to hire a mechanic, so what do you do... you look on the web for some how-to vehicle repair videos and become your own car mechanic, that's what. You don't need any advanced training to perform repairs and simple maintenance on your automobile, but you may need a few tools. Invest in the basic tools and you'll be prepared for just about any car malfunction you can think of. These tutorials will help get you on your way, as long ...
One day, your car may break down and you won't be able to afford to hire a mechanic, so what do you do... you look on the web for some how-to vehicle repair videos and become your own car mechanic, that's what. You don't need any advanced training to perform repairs and simple maintenance on your automobile, but you may need a few tools. Invest in the basic tools and you'll be prepared for just about any car malfunction you can think of. These tutorials will help get you on your way, as long ...
One day, your car may break down and you won't be able to afford to hire a mechanic, so what do you do... you look on the web for some how-to vehicle repair videos and become your own car mechanic, that's what. You don't need any advanced training to perform repairs and simple maintenance on your automobile, but you may need a few tools. Invest in the basic tools and you'll be prepared for just about any car malfunction you can think of. These tutorials will help get you on your way, as long ...
We've all used electric irons before to get our clothes crisp and wrinkle-free, but what happens when you use a little too much starch? The bottom hot plate, called the soleplate, accumulates some gunky buildup. Even if you're not over-starching your dress shirts, your Rowenta iron may be getting some gunk on the soleplate, which doesn't produce a perfectly ironed shirt. That's where the Rowenta ZD100 cleaning kit comes in handy. If you get one of these, you could easily clean your iron yours...
In this video, we learn how to deep clean your nails. You will need to have Talika Instant Manicure where you can buy online or in store. This will remove all the impurities from nail and leave them looking clean. To start, remove the packet from the box and pour it into a bowl. After this, pour water into the bowl and dip your fingers inside. Wiggle your fingers in the mixture for around three minutes, then wash and scrub your hands with a nail brush. Get down underneath the nail and in the ...
In this tutorial, we learn how to clean black suede shoes. First, remove all the dirty from the shoes. After this, spray on a lot of shampoo to the shoes, then brush with a suede shoe brush. After this, use black suede dye and spray it all over the entire shoe. Make sure you have plenty of color, so your shoes don't turn out different colors. To finish this up, use a rag to clean off the metal parts on the shoe, then you will be ready to wear them! This method only takes a few minutes and wil...
In order to clean a DVD or a CD with alcohol, you will need the following: a CD or a DVD, alcohol, and cotton balls.
In this Food video tutorial you will learn how to clean and cut a leek for cooking. This is really very easy and simple to do and takes very little time. A leek has a green part at one end, then the white part and the roots at the other end. Never cut the root otherwise, you will not be able to hold it together. Cut off the dark green part. You can use it for stock or soups. Then you got to clean the leek. Holding the root end, make a long slit with the knife, turn it a quarter and make anoth...
In this video, Do It Your Self Central demonstrates to viewers how to clean a dirty penny by using common household products, namely vinegar and iodized salt. He suggests to put 1/2 cup vinegar and 2 teaspoons of iodized salt into a cup. This solution will be used to clean the penny. He demonstrates the power of the solution by holding the penny into the mixture for a few seconds. After only a short time, he shows the dramatic change between the portion that was dipped in the solution and the...
If your diamond ring has lost some its sparkle, it might time to clean it. Diamonds might be expensive, but you can easily clean them with simple household products. Follow the steps in this video and that rock will be shining again in no time!
Lowe's shows you how to tune up your walk-behind mower. Make a difference in how your motor starts by changing the spark plugs and cleaning the filter and lubricating when necessary. To do this you will need a drop cloth, a cleaning brush and work gloves, oil, spray lubricant, air filter and spark plug. Before performing any maintenance, read your owners manual. Ventilate your work area, protect the ground and remove the grass catchers. Disconnect the spark plug so your mower won't start. Lub...
This video shows us how to clean coins using 3 simple products. Pour lemon juice, vinegar, and iodized salt into a small container.
This how-to video shows a great way to save and earn some money at the same time. Almost 7 out of 10 cars on the road has yellowed, hazy, dull looking headlights. Not only does this look ugly and depreciating but also dims the brightness of the headlight at night.
In this tutorial, we learn how to replace the air filer in our vehicle. Remember to do this every 12 to 13,000 miles you drive the vehicle. First, you will need to buy a new clean air filter that fits inside of your vehicle. Now, turn the engine to your car off and open up the hood. Next, undo the clamps around the air cleaner housing and lift the housing up. Now remove the dirty air filter and insert the new one in its place. Now, lower and secure the housing clamps again and you're all fini...
This instructional video demonstrates how to counter steer a remote control vehicle. On two wheel drive remote control vehicles you can retain speed with your vehicle by steering directly into a skid.
This automotive installation tutorial shows you how to install cruise control in a Toyota pickup. For many vehicles cruise control is something that's just there, but if you don't have it in your pickup and want to install cruise control check out this tutorial.
The AFL-CIO's Transportation Trades Division, which represents 32 unions in the US, has successfully lobbied for the removal of 10,000-lb. and heavier commercial trucks from provisions in bills expected to pass that could allow for millions of driverless vehicles on public roads and streets, Bloomberg News reported.
Waymo and Lyft have remained highly secretive about their driverless car programs, but may be forced to reveal a lot about their plans after a judge in a US federal court granted Uber's request to review documents about Waymo and Lyft's partnership.
The auto industry continues to shift into high gear to lay the groundwork for driverless cars with an electric vehicle (EV) emphasis.
The $25 million development alliance Jaguar Land Rover's mobility unit InMotion has formed with US-based ride-share firm Lyft reflects how the British luxury carmaker is leaning towards a fleet service business model for its driverless offerings.
Global design and technology services company Tata Elxsi says it has licensed its advanced autonomous vehicle middleware platform "AUTONOMAI" to a "leading automotive OEM."
One thing you don't see often in the driverless industry are partnerships. When automakers are in the news together, it usually means drama. However, an important partnership between Nissan and Mobileye was announced today. One that has the potential to make driverless cars on the road better and safer.
How many times have you thrown out the remaining cardboard tube from an empty roll of toilet paper? Most of the time, they don't even make it to the recycling bin, and with the average American using over 20 rolls each per year, that's over 6.4 trillion tubes being wasted each year. Yet these small tubes are particularly valuable helpers around the home, especially when it comes to cleaning, so why toss them out?
Video: . Learn how to Clean your scalp with Weave In "without"
I had such a hard time making black beans until I met the slow cooker. With this magic device I was able to make the deliciousness I was after. In this post I look to show you how to make black beans perfect every time