In this tutorial, we learn how to inspect bumper damage on a vehicle. On older vehicles, there is a metal absorber filled with fluid, so you would be able to see the amount of damage done. This would be able to tell you how far the bumper went in, and if it hit anything important in the vehicle. In newer vehicles, they are reinforced with a type of Styrofoam on the outside. Just because a vehicle doesn't show damage on the outside, doesn't mean there isn't damage underneath the car. So, alway...
In this tutorial, we learn how to make a microphone blimp. You will first need a shotgun microphone and a power module that attaches to the microphone. There will be low roll off switch on the bottom which is supposed to help with wind noise. Next you will need to build a blimp with a filter you can purchase from a farm supply store. Apply a steel reinforced putty to one side of it, and this will be your end cap. Place your microphone through this and then your microphone will become complete...
To apply glaze putty to your car, after it has been damaged, you will need the following: 80 grit sandpaper, goggles, respiration mask, putty
When using a washer, not only are you trying to clean any filth from your clothes, but also take out any existing wrinkles or imperfections as well. But there may be times when the wrinkles stay after being in the wash for a good amount of time.
If you're cooling and heating system isn't working like it should, you should probably check the blower motor. If you're not getting a good amount of air from your car, you may have to replace it. But what if you don't know how to remove it, in the first place? That's where this tutorial comes in handy. In this video, you'll see how to remove the blower motor for a Saturn S-series vehicle. It's easy to do and will make sure that you have a working A/C or heater when it's time for it. So good ...
Learning a new language can be a fun and educational experience. Not only are you learning another countrie's language, but you will also pick up on their culture as well. In this tutorial you'll be learning how to say two things in arabic. It may seem like a difficult language to learn, but with the right amount of study time, it can actually be picked up pretty easily. So in this video, you'll find out how to pronounce Lam and ra2. So good luck and make sur eyou practice. Enjoy!
If you're looking to get an unlimited number of mini-nukes in the game Fallout 3, this tutorial is what you need to follow. In the video, you'll find out what it takes to make sure you have the most powerful weapon in the game for you to use against the mutants of Fallout 3. It's pretty easy to follow and will ensure that you'll always bring a good amount of pain to any battle. Good luck and enjoy!
In this video tutorial, viewers learn how to make a shiny glass ball in Adobe Photo-shop. Begin by creating a new document with the default size and a transparent background. Then paint the entire background in black. Now select the marquee tool and create a circle anywhere in the background. Now go to filter, click on Render and select Len Flare. Make the lens flare 105 mm prime with 141% brightness. Then go to Filter, click on Distort and select Spherize. Use normal mode and set the amount ...
In this video tutorial, viewers learn how to play a guitar cadence. A cadence is the tension that is created between 2 chords, typically at the end of a phrase. There are 2 types of cadences, perfect cadence and playable cadence. The perfect cadence goes from the 5 chord, to the 1 chord. It has a tremendous amount of tension between the chords. The playable cadence has a soft strum and less tension between the chords. This video will benefit those viewers who enjoy playing the guitar, and wou...
If you're looking to add something that looks old and aged to your home, a door is always a good idea. Now finding a vintage door can take you time and money, but you can easily create one using a few inexpensive items from the store. All you need is a hand-held torch, some stain, and a door. So check out the tutorial to find out more. Good luck and be careful. Enjoy!
Purchasing cheese from the store can be a bit of a hassle and cost you quite a penny. Certain dishes require cheese in order for you and others to fully get a tasty meal. Well, in this tutorial, you won't have to sacrifice a lot of money in order to make something that is cheap to make and can taste way better than the store bought stuff. In the video above you'll find out what ingredients you'll need to make your own mozzarella cheese from home. So good luck and enjoy!
If you've ever caught yourself waking up late and finding that you have a short amount of time to prepare for work, this can suck. But with the help of this tutorial, you'll find out how to make one part of your daily routine much easier. In the video, you'll find out how to apply makeup in the morning quickly and easily. So check it out and maybe it will help ease your worries. Enjoy!
Cooking quinoa is similar to preparing cous cous. Both are grains and both will soak up the water or broth you place them in to become warm and fluffy. If you have never had quinoa before, you should definitely give it a try. This delicious grain is one of the most healthy things you can feed your family.
There are many people out there who spend most of their time downloading torrents or trying to find a way to download them faster. In this tutorial, you'll find a possible solution to donwloading torrents much faster than before. The video shows you how to make uTorrent 1.8.2 download faster on your computer. In order to do this, make sure you have a decent amount of seeders. So good luck and enjoy!
If you've never had sea bass, you may be missing out on a very nutritious and tasty dish. Sea bass contains good amounts of vitamin B6 and magnesium. The only bad side to it is that they contain high levels of cholesterol. So eat sparingly. In this tutorial, you'll find out how to cook sea bass using fennels, garlic, and lemon. So good luck and enjoy!
Over time, a wooden floor can sustain a heavy amount of damage thanks to the weather, heavy foot traffic, and things constanly falling on it. So, it's always a good idea to refinish a floor every few years or so to make sure that it will last longer. This tutorial will show you how to sand and save a wood floor. It's a difficult task, so make sure you have the time and patience to do it. Enjoy!
Calculate the amount of days worked on a given project within MS Excel! Do you maintain work schedules for your projects? Are you manually subtracting weekends and holidays from your project estimates? There's a better way. And this digital spreadsheet tutorial will show you how. For detailed, step-by-step overview on how to easily and efficiently maintain a count hours of labor, watch this free video software tutorial.
If you have done hundreds of loads of laundry you might be in a habit of not measuring your detergent and just pouring it into your washing mashing. Although you may think you are taking a short cut, you might be causing more damage than you think. You could end up with too much detergent in your load and have residue on your clothes and even have detergent build-up in your machine, which can be more costly in the future. There are many ways to improve your laundry technique, some even have a...
You will see a great way to light and set up a blue/green screen for your next video. There are a lot of tips that will come in handy if you want to film on a blue/green screen and don't want to pay outrageous fees to do so. The key in setting up is to block out all outside sources of light so you have just the desired amount of lighting coming just from your own sources and also setting up the screen and stretching it out as tight as possible so you won't see any creases or snags in the mate...
Most people think of compost as something you make out of garden waste, but in this video we learn how a smaller amount of it can be made out of your daily kitchen waste. If you drink coffee and cook at least one thing a day using vegetables, than this video will help you turn that waste that stinks up your trash can into a helpful, eco-friendly gardening aide. And you get to have worms in your kitchen without feeling like you live in a fraternity house in the forest!
During a time when it's more important than ever to watch what you eat, more and more chefs are creating tasty dishes that are easy on the belt but full of flavor. Out of the many diets, one of the most popular is the Atkins diet. It mainly focuses on the amount of carbs you eat and how to limit them. So in this specific diet tutorial, you'll find out how to make Atkins low carb teriyaki stir fry. Ingredients are listed below, enjoy!
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to perform debt analysis with the following input variables: % Down Payment, APR, Years, Points, Extra Fee. See how to calculate Amount to Borrow, Monthly Pay...
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to use a helper cell to remove a time-consuming (expensive) section of your formula to speed up calculations.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll see how a helper column with concatenated fields can dramatically reduce the time a formula takes to calculate.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 9th installment in his "Excel Formula Efficiency" series, you'll learn see two running total formulas, one that is faster than the other.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 10th installment in his "Excel Formula Efficiency" series, you'll learn how to use Manual Calculation for huge spreadsheets so that recalculation only occurs when you want it to occur.
There's nothing like playing outside, especially as a kid. The grass beneath your feet, the blue sky in the air, and the endless amount of possiblity that lies in such a wide open space. This tutorial takes advantage of that space and shows you how to make a simple bottle rocket. Many of the supplies needed are easil found in your home and are usually cheap and inexpensive. So sit back and enjoy! Oh, and please be careful!
In this video tutorial, viewers learn how to create fog using Adobe Photoshop. Begin by importing the image into the program and duplicate the image. Now go to Filter, select Blur and select Radial Blur. Set the amount to 100, Blur Method to Zoom and Quality to Best. Now select the rectangular marking tool and select the sky. Then open the Hue/Saturation menu and set the Saturation to -100. Use the eraser tool to remove the gray from the edges. Now use the paint tool and paint white streaks o...
The video is basically showing how to get a look like Demi Lovato with makeup. The makeup being used is BYS. You Start off with a light Grey make up under your eyelids,then you take the black color makeup and put it under your eyelids where you put your first coat of Grey under and blend them in together. When you use the black color makeup you have to really pad it on, not so much brush it. Then you use the darkest black color and put a light amount under your eyelids. Then finally you want ...
This video shows how to contour and highlight your face. First, sculpt your face using the MAC 184 brush, which is a dual fiber brush, and Sculpt Sculpting Powder. Brush the powder from the forehead down the side of the face and under the cheekbone, then underneath the jaw. For a more contoured look, use the 168 brush, which is a fluffy angled brush, concentrating on the hollow of the cheek, and using more powder.
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 497th installment in their series of digital spreadsheet magic tricks, you'll see a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock) for each store or branch of the company.
return a descending sorted list of country names based on the values in a row using an array formula that itself makes use of Excel's INDEX, MATCH, RANK, COLUMN and COLUMNS functions.
Salt dough can be used like clay for craft. This video demonstrates how to make salt dough. The ingredients required to make salt dough are a cup of salt, two cups of flour, a cup of water and food coloring. Make sure to cover your working surface with old newspaper and use a painting apron as this can get messy. Add the salt and flour in a bowl and mix with a spoon. Then measure one cup of water and add quite a good amount of food color to get the desired color and mix it into the salt-flour...
If you would like to create the look of stitches or sutures on your clay sculptures, you will need the following: clay, a toothpick or sharp implement, and a cutting tool.
In this Fine Art video tutorial you will learn how to understand your lens and its effect on depth of field. The lens in the video has some inscriptions which are interpreted like this. 50mm is the focal length of the lens. The aperture is from f1.4, which is the widest lens opening to f16, which is the smallest lens opening. The higher the number the lesser the lens opening. Aperture determines the amount light that comes through the lens. Aperture also decides the depth of field. With a wid...
In this video, we learn how to make french toast with panettone bread. First, mix 2 eggs with a small amount of milk and orange juice. Add vanilla, brown sugar and cinnamon to the bowl and mix together. Now grab your panettone bread and cut it into thick slices. Dip the bread into the mixture and coat it on both sides letting it soak up for a little bit. Once finished, place bread into a hot skillet for 1 minute on each side, then place in a toaster oven for 2 minutes. Once finished, it's goi...
The first problem that is show is exponential decay. First you will need to create a table with hours and substance left. The next step is to find the trend by noting that we are left with a certain percentage of the substance. One you have the trend you will use this to calculate the amount of substance left in said hours, in this case 6 hours. The following example shows you how to solve exponential growth. It is essentially the same except for the fact that you will be increasing, so inste...
Grapes, raisins and pomolo are placed in jars and spring water is added to them. The jars are tightly covered and left for 5 days to a week; until fermented. The jars are shaken once daily and the lid is opened to allow air to get in. After maturity, where they made fizzing sounds and they started to swell to the top . They are strained and the liquid is put to back into the jars, closed and left for a week. An amount of the liquid is poured out of the jars and flour is placed in each and sti...
In this video tutorial, viewers learn how to speed up a Windows PC using a USB flash drive. Begin by clicking on the Start menu and select My Computer. Now right-click on the flash drive and select Properties. Click on the Ready Boost tab and check Use this device. Select the amount of space and click Apply. Then click OK. To remove the flash drive, right-click on the flash drive and click on Properties. Click on the Ready Boost tab and check Do not use this device. This video will benefit th...
