Designing a tattoo sleeve is a challenging and important task for any tattoo artist or recipient, as they are huge, expensive, nearly impossible to hide and, like all tattoos, with you forever. This four-part video demonstrates the sketching and inking of a sleeve design with a a biomechanical theme. It is unmeasured and would need to be refined and drawn again before it could go on a body, but is a good place to start.
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.
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 6th installment in his series of Excel name tricks, you'll learn how to use the Names & Wildcards with the COUNTIF function. Specifically, see how to search through a list of addresses and count just the ones on Birch Street in this free video lesson.
If you're having some microphone troubles on your Ubuntu Linux system, this video might help you troubleshoot and solve the broken mic problem. This is about fixing the microphone input specifically. This tweak should fix it.
This video shows how to grow pineapples at home. First, take a pineapple and slice off the top. Next, cut off all the meat from the top of the plant. Then start to peel all the bottom layer of leaves off the plant. Once the plant is well pruned, place it in water for about 2 weeks. You'll see new roots grow in the water. Once there is a healthy root growth structure the plants are ready to be transplanted. Then you'll put the plants into a pot. The transplanting part of the process will be fo...
In this video tutorial, viewers learn how to make swirled chocolate heart cake decorations. Users will need a heart shape cookie cutter. Brush some oil inside the cookie cutter and some butter one the outside. Then press on some wax paper on the outside of the cookie cutter to create mold. Now pour in some melted white chocolate and fill in the heart shape. Now add the chocolate. Using the sharp point of a knife, swirl it around the chocolate to create a swirl design. Place the cake into the ...
Believe it or not, you are more likely to hurt yourself or others with a dull knife. Not only are sharp knives better to cut with, they are much safer to use. When you are fishing, the fillet knife is one of your most important instruments. In this tutorial, you will learn how to sharpen your knife on the go and keep your instrument in tip top shape. In order to sharpen a fillet knife, place the blade of the knife in the "V" of an Accusharp tool before following the blade off the table. In th...
In this how to video, you will learn how to dismantle an Xbox 360 vision camera. First, take off the sticker on the bottom with a knife. Next, unscrew the the screws on the bottom. You should note that the sticker is really easy to place back on. There will be two screws revealed once the sticker is off. Unscrew these to access the inside of the camera. The bottom plate will come right off now. There are two more screws holding the inside of the camera. Unscrew these to entirely dismantle the...
In this Food video tutorial you will learn how to make pan-seared tuna steaks over spinach and lentils. Start with a bowl of fresh baby spinach. Take juice of half a lemon, ¬º cup olive oil, them together, taste to see that it is OK and pour it over the spinach. Mix it and your salad is ready. Put the stove on medium heat and heat up a pan. Take a pound of Tuna steaks, brush them lightly with olive oil and dredge them through sesame seeds. Now put them over the hot pan and cook for 2 to 2 ¬O ...
In this video tutorial, viewers learn how to make a ribbon covered pinch clip. The materials required for this hair clip are 4 1/2" x 3/8" of ribbon, glue gun and an alligator clip. Open the pinch clip and place the ribbon inside it. Align it to the clip so that it is straight. Then apply some hot glue onto the surface of the pinch clip and then fold the ribbon to glue it. Alight the ribbon to the top of the clip and flatten the ribbon. Now apply some more glue on the ribbon and push it into ...
In this Hobbies & Toys video tutorial you will learn how to modify a Nerf Big Bad Bow to shoot farther. Open up the front part of the shell by removing the screws. Make sure the spring on the launch piece stays together and pull out the barrel. Then dismantle the white restrictor piece and drill a hole in the center for more airflow as shown in the video. Now cut off the orange barrel as close to the wall as possible with a pipe cutter and sand it off. Take an extra piece of CPPC pipe and ram...
This video illustrates us how to paint Hello Kitty on your nails. here are the following steps: Step 1: First of all collect all your requirements in one place that is nail paint in various colors ,nail art pen, primer, and toothpick.
In this video, we learn how to use the Cool Noodle Tool to make noodles make from thai coconut, auzzhini, jicama, daikon radish and yellow squash. First, grab a half of a coconut and your noodle tool. Take your tool and scrape the inside of the coconut and you will have coconut noodles in no time! Do this for all of your different vegetables, whichever you prefer. Place all of your vegetable noodles into a large bowl and you can now prepare these with any sauces that you prefer. This tool mak...
In this video, we learn how to make homemade Kefir Ginger Ale. First, you will need a 2 qt jar of filtered water and add in 1/4 c of honey into it. Mix this together until it's combined and the water is a yellow color. Now add in milk kefir grains that have been soaked in ginger. Next you will add ginger and tumrick that have been chopped up and add into the jar. Also add a squirt of lemon and lime, as well as a piece of coral calcium. Place the top back onto the jar and let it sit for at lea...
This video is about determining the right camera for the tripod.The video begins by explaining the ways of doing this, that is by ensuring that the camera is neither too large nor too small for the tripod and also by ensuring that the tripod is able to withstand the weight of the camera.When the camera is placed on the tripod it should be a right match for the base ply of the tripod and should not be lager or smaller than the base ply.This video is excellent for those who want to select the r...
In this how to video, you will learn how to create a spiked hair style for guys. You will need mousse, hairspray, a comb, and a blow dryer to do this. First, make sure the top of the hair is long. First, get some mousse and rub it into the top of the hair. Next, use a comb at the front of the hair. Keep on running your fingers through your hair until you are satisfied with the spikes. Next, take hairspray to hold the hair style in place. Lastly, dry your hair with a blow dryer. Your hair styl...
In this video tutorial, viewers learn how to make decorative wreaths from garden plants. Users will need a wreath thorn. Users may choose to make the wreath or purchase it. Then add on some greenery such as bay leaf. Now place the greenery onto the thorn wreath and secure it by wrapping it 3 times around with wire. Continue doing this for the rest of the wreath. This video provides a visual demonstration for viewers to easily follow along. This video will benefit those viewers who are interes...
This video shows you how to milk a cow with your bare hands. Wipe the udder with alcohol based wipes, to make sure it is clean. Place your stool at the side of the cow, towards the back end. Remove a little wax from the teats before starting. Squeeze the teats firmly with a regular motion. A cow should be milked twice a day. If the udder is pendulous then use a flatter pan rather than an milking bucket. The richness of the pasture will determine how much milk the cow delivers. Rainfall and th...
In this tutorial, we learn how to make homemade pecan pie. First, whisk 3 eggs and put into a large mixing bowl. Next, add 3/4 c of sugar, 3 tsp vanilla extract, 1 c dark corn syrup, and mix thoroughly. After this add 2 tbsp melted butter and mix it together again until it's all combined. Once it's well combined, add 1 3/4 c of pecans and mix together until pecans are well combined and covered in liquid. Now, preheat your oven at 350 degrees and place this mixture into a pie crust. Cook for a...
In order to install Windows 7 from a USB drive, while you are running XP, you will need a pen drive. You will also need a Windows 7 DVD and a pen driver.
In this video tutorial, viewers learn how to do the Hey Moshi dance. For the first movement, place both hands up to the mouth while popping in the right knee. Then bring the right arm straight up down the middle while popping in the left leg. Now switch to the opposite side by bringing the left arms straight up down the middle while popping in the right leg. Then bring the right arm out while popping the left shoulder. This video will benefit those viewers who enjoy dancing and would like to ...
In this video tutorial, viewers learn how to do a hair transplant them self. Users will first need to let their beard grow 2 months or more, depending how fast their facial hair grows. The beard should be long and thick. The materials needed for this are glue and hair clippers. Begin by shaving off all the facial hair. Now evenly apply some glue on the bald spots and place on the pieces of facial hair. This video will benefit those viewers who are balding and would like to learn how to do a h...
In this how to video, you will learn how to make bag tags. You will need a tape runner, embellishments, elastic, a plastic bag, letters, cloud 9 rain dot eyelets, a trimmer, bits of card stock, and hole punches. First, cut the card stock and make it a square shape. Next, decorate the card stock with embellishments and the name of the child it is for. You can use the adhesive to stick these on. Next, cut more card stock and wrap it the piece around the decorated card stock. From here, place th...
In this how-to video, you will learn how to dismantle an 80GB Microsoft Zune and remove the hard drive. You will first remove the cap at the end. Remove the screws at the bottom. Next, unclip the sides, top, and bottom of the Zune. You can use a prying tool to help you with this. Do this slowly, as you might damage the Zune. Once you can remove the back cover, you will have access to the internal parts of the mp3 player. Remove the tape holding the components together. Next, remove the screws...
In order to make a Cuttlebug Smoosh Card, you will need the following materials: card stock (at least 3 different prints or colors), a ruler, distress tool, double sided tape or glue, distress ink, watermark stamp pad, decorative accessories, and scissors.
In this video tutorial, viewers learn how to do the shuffle dance. This video will teach users how to do the Running Man, the T, kicks and spins. To do the Running Man, pivot one foot back as you lift the other foot up. Then place the lifted foot down and push the other foot back further. It looks like a robotic way of walking. To do the T, pivot one foot from heel to toe as you continuously stomp n the floor with the other foot. To do kicks, it is the same concept as the Running Man, except ...
In this video, Bill shows us how to make a prawn stir fry. First, heat up an electric wok and add in 2 tbsp of canola or peanut oil. Then, add in a small bag of frozen prawns and cook until thoroughly cooked. Once finished, remove the prawns and place into a separate bowl. Once you're done, clean your wok and add in another 2 tbsp of canola oil and any vegetables you prefer. Once the vegetables are cooked until soft and tender, add your prawns back in. Mix these together and then add in your ...
This video illustrate us how to apply competitive cheer leading tournament makeup. here are the following steps:
In this how-to video, you will learn how to fix scratched games with a simple solution. You will need a few rags, alcohol, and a surface to place the disc on. Take the rag and pour a tiny bit of alcohol on to it. Next, put the alcohol away. Take the cd and rub it with the rag. It should be rubbed all around the entire cd. Take a dry tissue and rub the cd. Make sure all the alcohol is removed. Your disc should now work with no problems. This video offers a good solution to all your scratched g...
This video shows how to make a studio softbox light for under 20 dollars. It is made with items found around the home or easily acquired. The author takes us through the process in a step by step manner. It starts with a cheap camera tripod upon which a plastic electrical outlet strip is attached using either a screw or strong plastic adhesive. An electrical plug with a light socket attachment is plugged into the strip to allow the light to be attached. A small cooler with a hole cut in the b...
This video will show you how to prepare a Homemade Pot Roast. For this recipe, you will need: mushrooms, onions, zucchini, Brussels sprouts, oven roast bags, potatoes, carrots, wine, garlic, 1 can stewed tomatoes, McCormick Pot Roast in a Bag seasoning packet, and a pot roast.
In this video, Steve Kim shows us how to make a simple morning protein shake. You will need a blender, glass, oatmeal and protein powder for this. First, place a cup of water into the blender along with around 5-6 ice cubes, crush this together in the blender. Next, add a scoop of protein powder and a 1/2 cup scoop of oatmeal. Put the lid back on the blender and blend on low for about 30 seconds, slowly pick up the speed on the blender and blend until it's well mixed together. After this, pou...
This video tutorial in Hobbies & Toys category will show you how to build a magic rollback can. For this you will need a can with lid, rubber band, weight, tape, sticks and scissors. Make a hole in the center of the lid of the can and also on the bottom of the can. Attach the rubber band to the weight with the tape as shown in the video. Pass one end of the rubber band from inside the can through the hole in the bottom of the can and put a stick to hold it in place. Pass the other end of the ...
Kat demonstrates how to make spicy Thai red curry chicken. First, chop two bell peppers, potatoes and a carrot. Place a pan over medium high heat. Add coconut milk to red curry paste in the pan. Once the curry paste has dissolved, add minced garlic, one tablespoon of fish sauce and one tablespoon of brown sugar. Add a half a cup of water. Then, add the chicken and the chopped potatoes, carrots and bell peppers. Cook for five minutes. Then, add softer vegetables like mushrooms, onions, green o...
In this how-to video, you will learn how to play "Twinkle Twinkle, Little Star" on a recorder. The first note you have to play is a D. The D note is made of a G. This means three fingers on the top, and three fingers on the bottom. The left hand will be on the top. Play an A note by letting go of the bottom four holes. Do this transition over and over until you feel comfortable with this. Next play the next note by only holding one finger on the top hole. Next, play the last note by placing f...
In this video, we learn how to cut a line using paint onto your walls. To do this you will need walls, a paint brush and your choice of paint. Make sure you get just the right amount of paint onto your brush and place the bristles against the wall right next to the corner of the wall. Slide it down making the line as straight as possible. Keep going until you have a line all the way down the corner, making it very straight and neat. Do this on both of the walls and you will a have professiona...
Love4Nails starts off with pink, silver, and black nail polish. First choose one of your colors to create a French tip manicure. She next takes the silver polish, starts at the bottom and creates a swirl around the nail. Swerve the silver in a way that it covers the French tip part of the nail. Then get the pink glitter and apply only on pink polished area. Place black rhinestones on the swirled area of the nail. Because you're using the pink glitter polish, if you choose not to add rhineston...
In this video, we learn how to fold a bandanna. First, place your bandanna flat, then fold it diagonally. Once you've done this, you will have an upside down triangle. Now, fold the top of the triangle down as many times as you desire, it can be as wide or as thin as you want. Now, you should have a rectangle with a triangle hanging out from under it. You can now tie the bandanna around your head, butting the triangle part around your mouth. Tie a knot behind your head tight enough to where i...
