In this Autos, Motorcycles & Planes video tutorial you will learn how to inspect hail weather car damage. Paint loss dent repair is the most common method used for this purpose. The first thing to do is to count the number of dents based on half dollar, quarter, dime and nickel size. All you need to do is to place the coins over the dents and count how many dents are there of various sizes. Once you have this information, you are on your way to handle the hail loss assessment correctly. If th...
In this clip, you'll learn how to perform a number of easy, powerful mat-based Pilates exercises. With Pilates, as with any physical fitness system, a basic mastery of proper technique is essential for both maximizing the effectiveness of your workouts and avoiding accidental injury. Whether you're looking to slim down or merely tighten up your core, you're sure to be well served by this home fitness how-to from the folks at Balanced Body Pilates. For complete instructions, give this free exe...
In this tutorial, we learn how to cheat the airbrush system when applying makeup. The OCC makeup trial is great for someone who is just getting started as a makeup artist, and doesn't have an airbrush system. You an use this makeup with a nice brush, depending on which one works best for you. You can go from light to full coverage with this makeup, and play around with the colors until you find the one that works best for your skin. If you have a friend with different skin tone, you can split...
In this tutorial, we learn how to draw Aladdin and Jasmine. Start by drawing Jasmine, draw her hair on first, then start working on her face and head. Add on her earrings, eyebrows, and mouth. Make sure to pay attention to details and use a picture as a reference to what they should look like. Fill in Jasmine with the colors she wears in the movie, and then start to work on Aladdin. Draw in his hair to start, then make sure to draw on his hat on the very top of his head. Draw his face, giving...
In this tutorial, we learn how to build a subwoofer out of cardboard. You will need to buy SonoTube, which is giant cardboard tubing. It comes in a variety of different sizes, so you can find one that will be around the same size as your subwoofer. To make the casing, you will need to use a saw to cut the tube to the size you need. Make it a snug size, but make sure it's not too small or you will have to start all over again. Use caulk and glue to stop any leaking air from getting out of your...
If you like tying different things just for show or to use, then you're going to love this next tutorial. This video will teach you how to easily make a paracord ladder strap. It looks really cool and seems easy to do, but it could take some time to finish. It's created using a variety of different colors and is sure to make others go, "Wow." So check it out, pay attention, and good luck!
This is a quick tutorial on setting up a nodes-based texture for 3D volumes in Blender 2.5. Were you aware Blender 2.5 includes a cloud generation script? See how to use it with this video guide. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including step-by-step instruct...
If you live in an area where the winter months can leave a toll on your home, it's important to prepare before the first drop of snow hits. This is important because not only will you have a home that is safe for you and others to live in, but it will also make sure that you don't have to worry about paying for damages to your home afterwards.
In this clip, learn all about prosopagnosia, otherwise known as "face blindness". This condition is rare and occurs at different levels of severity, usually as the result of autism or brain damage. Recently, Amanda Green graduated from high school in Minnesota despite her inability to remember or recognize people.
We're all for natural beauty, and we think you look great with or without makeup, but there's one thing we are a stickler about: eyebrows. There's no girl out there with the perfect set: they're either perfectly shaped but too sparse, thick enough but evocative of Groucho Marx, or too light for anyone to see.
Have a WordPress blog? Make some money by adding some advertisements. You can easily do this by using the AdRotate plugin for WordPress. It's super easy to install and even easier to use.
See exactly what you want to know for the flash game RuneScape. Runescape, like most RPG's web-based or otherwise, has many challenging quests to perform. This video features a detailed walkthrough of one such quest, Buyers and Cellars. Watch this video and your confusion on how to complete this quest will disappear.
The late and great Alexander McQueen was a true fashion innovator, coming up with quirky style trends that we could only imagine in our wildest dreams. Whether it was humped armadillo shoes (video Lady Gaga in "Bad Romance") or butterfly headpieces that obscured a person's face entirely, he spoke to us like a prophet from another world.
Agedashi tofu is a delicious Japanese vegetarian dish that definitely overcomes tofu's reputation in many Western minds as flavorless goo. This detailed video teaches you how to make the tofu itself and a delicious oil-based sauce to go over the top of it. After you try this dish, you'll never have another mean word to say about tofu!
Gnocchi may be challenging to pronounce, but eating this oddball potato-based member of the pasta family is seldom a challenge since they are so delicious. This video demonstrates how to prepare a ricotta cheese gnocchi with a pea and mushroom sauce. It is light and delicious, yet filling. A wonderful spring dish for any at-home chef.
The t-shirt is arguably the most basic part of modern Western fashion. Billions of people around the world wear them every day for ease and comfort. This two-part video will teach all you sewing fans out there how to sew your own t-shirts at home. You can then use these techniques to make other t-shirt based garments like t-shirt dresses and whatever other t-shirt-like clothing that you can imagine. The fabric is the limit!
Warhammer 40,000 and other collectible-miniature-based table-top games have created a generation of people who love painting and playing with tiny figures. If you are into the game or any of it's ilk you've probably had an idea for a piece that you would like to create from scratch. This video from Storm the Castle shows in great detail how to make your own miniature figures out of rubber that should stand up to anything you've bought from Games Workshop. Model on!
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a budget with formula inputs in an assumption area and formulas. Then do what-if analysis by saving and showing scenarios. Also see how to save variables...
Flash is a great piece of software that has been around for some time. It's easy to use and can add some much needed character to a potentially boring web page. This video tutorial will show you how to make a preloader for your website. If you don't know what a pre loader is, it's basically an animation showing you that the computer is thinking and gathering all the information needed to open up a new page or play some sort of video or song. It's a great way to let your viewers know that ever...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 46th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the DOLLAR, VLOOKUP, INDEX and MATCH functions and a previous bracket commission formula trick to calculate total commissions when you have variable commissions paid out. Learn to love digital spreadsheets more perfectly with the tricks outlined in t...
This video is about Annual percentage Rate(APR) and the Effective APR rate.The video begins with an example of a credit card which has a APR rate of 22.9% and daily periodic rate of 0.06274%.You can get the APR rate by multiplying the daily peiodic rate with 365, which in this case will be 0.06274*365 which is equal to 22.9.If you convert the daily periodic rate into decimal values , it will be 0.006274.So for example, if you have 1 dollar in your balance on day 1, on day 2 you will owe 1.000...
This video shows the method to style a heart shaped hair on a little girl. In the first step, do a zigzag part on the hair and pulling the sides to a pigtail. Part the hair till the ear before tying the pigtail. Wet the pigtails and put some pomade on it to make the pigtail stiff. Take a pigtail and divide it into half. Make sure that they are stiff. Twist the two parts of the pigtail and make a heart shape. Now clip the hair at the base using a pigtail holder. Repeat this process for the oth...
In this video Kandee will show you how to create the perfect fast, and easy faux hair do. First start by blow drying the top of your hair going from the front and sides up and to the back. Next take a comb and start teasing it by brushing from the base up going from the back of your head to the front. Once you have it properly teased start take you hair in sections and pull them up and then bobby pin them down going from front to back. Finally tease up the back and hair spray to finish!
Several Tanzanian girls demonstrate how to tie a kanga (an African sarong). The first method is to wrap the kanga around the waist and tuck the end in at the waist to secure. The second method is to wrap the kanga into a cylinder to use it as a base for carrying a parcel on the head. Another way to wear the kanga is to wrap it around the neck like a shawl or wrapped under an armpit and tied over the shoulder for a fancier look. To wear the kanga as a scarf, fold it into quarters the long way,...
In this Education video tutorial you will learn how to conduct a viscous remanent magnetization (VRM) experiment. The purpose of this experiment is to measure the VRM decay vs time. You have to take two Orbo rotor magnets and mount them on a base. Mount two samples of the ferromagnetic tore used in the Orbo motor for the stator coils on a rotating disk. The disk can be rotated by a simple brushless motor. When the ferromagnetic core moves in front of the static magnet, an optical sensor detec...
This tutorial shows you how to set up the high voltage wiring for your RC kit. Although this is not a basic step for putting together your RC vehicle, it can be used to help make things easier. Be careful though, this can mess up your ability to use a remote control. So pay attention and enjoy!
Kandee, a makeup, artist demonstrates a Gwen Stefani up do that was from an Elle magazine cover. Rub hair paste into your hands and smooth it through your hair. Then section crown to forehead and twist it counterclockwise until it starts curling up. Keep twisting and wrap it around into a tight knot. Use a bobby pin to secure it at the base. Then take another section of hair and repeat. Split the bottom section of hair that is left asymmetrically and twist each of those sections halfway and t...
Make your transition into the Hip-Hop world a tad smoother with help from this free lesson. Hip-hop dance is a form of dance that can be seen on the streets or in the studios, and its incredibly important to listen and move with the beat of a song. Discover the importance of paying close attention to the music when hip-hop dancing with help from this free lesson.
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 244th installment in their series of digital spreadsheet magic tricks, you'll learn how to use advanced filtering to extract records from a database (table or list) based on 1 criterion (criteria) and place reesults on a new sheet worksheet.
This video will show you how to take advantage of one of Apple's iMovie advanced editing feature, picture-in-picture effect. This feature allows you to embed either another video, or images into a base video. To enable this valuable tool in iMovie, go into the iMovie preferences by clicking on "iMovie" in the top left hand corner of your screen. Under the General tab make sure "Show advanced tools" is selected. Import a video from your event library by dragging it into iMovie and selecting pi...
In this brief instructional video, you'll watch as a nail expert shows you one of her best custom designs finished by using foil wrapping paper. This is great for people looking for something new and trendy that will add a little bit of pop to their already polished look. Be sure to pay attention to the many tips and tricks that this nail designer drops, otherwise you'll be headed for disaster! Remember, to make this nail-art work, your foil wrapping paper will have to be cut into very thin s...
Microsoft Excel is used to store and work on data by storing them in rows and columns in tables. You can use a macros to check if a cell is empty. To do this you have to know two short cuts. The first is the VBA Window short cut which is Alt + F11 and the other one is View Macros short cut which is Alt + F8. So open an Excel spread sheet and insert some data into a small table. Now create a macro for this tutorial. You can use and IsEmpty() functions to check if a cell is empty. Use this func...
This video shows you how to idiot-proof a data set in Excel pretty much. It demonstrates how to enable data validation in a cell, so that when you type something in it must be in a predetermined list or will not work. Start by typing in your data table in a second tab. His example is a date, then information about certain employees based on that day. To enter the data validation menu, click the cell you want to use and then hit ALT+D+L to bring it up. Go to settings, then under the Allow menu...
This video will help you to make a Christmas centerpiece with flowers and evergreens. The materials required are a plastic centerpiece tray, floral foam, two candles, two candle cups and wired wooden pegs. Flowers like red carnations, white cushion chrysanthemums, red and white pixie carnations and roses can be used for this arrangement. Evergreens used are cedar, pine, princess pine, and variegated holly. The foam is placed in water in the tray. The candle cups with the candles are placed in...
If you don't want to spend an extra $130 to get 3G for your iPad, you can use the app MyWi to tether your iPhone's 3G connection to your iPad. This video shows you the easy way to tether your iPhone's 3G or EDGE Data Connection to your iPad, or any other Wi-Fi enabled device. So skip paying the extra dough and get a 3G connection for free! Be careful, as this can drain your iPad's battery!
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 506th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize data from multiple sheets. For example, you'll see how take checkbook register data from multiple banks accounts and summarize it based on account names.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...
Get creative this weekend and start a new sewing project! In this five-part video tutorial, learn how to sew a stylish vintage frock! Why pay those ridiculous prices on eBay for vintage goods, when you can sew them yourself in the comfort of your own home? Learn all you need to know about sewing this adorable clothing piece in this series of five how-to videos.
In this video, Danny Lipford will show you how to make a punching bag with trash found at a construction site. First, a circle of plywood is cut out about one foot in diameter (in this video, a bucket is traced in pencil over the plywood). This is for the base of the punching bag. A large piece of PVC pipe is used for the center of the punching bag, which carpet padding is wrapped around to makeup the main part of the bag. Finally, duct tape is wrapped around the whole thing. Out of these ver...