If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...
This how-to video shows you how to use the text substitution feature in Mac OSX. This will make it easier for you to type symbols and fractions. It can also be used to create shortcuts for texts that you use on a regular basis. Go to apple and system preferences. Click language and text and select the text tab. You will see some substitutions already created. To add a substitution, click add and type the text you want to replace. Press tab to add the text you want to replace it with. Save thi...
In this tutorial, learn how to make delicious homemade sauerkraut. Sauerkraut is a tasty tradition, and no summer picnic is complete without this classic topping.
Robert demonstrates how to use Photoshop to give yourself a tan. First, you need to upload your picture(s) into Photoshop. Then pick one to work on. Next, you will need to copy the background to save the original image. On the right side drag the background label to the new layer icon (you can just hit control J). You will then need to select a paintbrush tool. Go up to the tool bar and click on the paintbrush settings to set the hardness at 80%. The master diameter will be adjusted as you wo...
This video is about how to make brown sugar out of white sugar (granulated sugar) and molasses. Brown sugar is not more natural than regular white sugar, it is just white sugar with some molasses added. "Raw sugar" is a more natural form of sugar than white granulated sugar that comes from the sugar cane plant. To make your own brown sugar simply take some white sugar and add some molasses and mix well. The more molasses you add, the darker the brown sugar will be. If you are baking a recipe ...
This video shows how to write the numbers 0, 1, 2, 3 and 4 in Copperplate style. Special marked paper is used, with slanted verticals and regular horizontals, so that the numbers are even in size. The number 0 is drawn slowly, showing how the nib rests on the paper and is drawn anticlockwise. Then the number 1 is drawn, and again the up strokes are thin, while the down strokes are thick. The number 2 is drawn in two steps, starting with the top part. Numbers 3 and 4 follow in a similar fashio...
Eddy Currents are little circles of electricity created when metals are moved by magnets or even when magnets are moved by metals. To understand this practically take a regular piece of cardboard and drop it in between a horse shoe magnet. It drops normally with out being effected by the magnet. This is because the cardboard does not conduct electricity. Therefore it does not cause any eddy currents. But instead if you use an aluminum piece in the same way, it falls very slowly, because alumi...
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...
By jailbreaking your iPod Touch you can take advantage of tons of cool apps that aren't available on a regular Apple grade model. This tutorial will take you through the process of jailbreaking an iPhone 2G, with a very easy, 100% safe method. So, whether you are looking for cool apps or want to use your iPhone with a network other than AT&T or O2, you will need to jailbreak it. Grab your phone and turn on this video for all the tips you need.
In this video tutorial, viewers learn how to remove rust from chrome. The materials required for this procedure are: a few sheets of regular tin foil, some water and an old t-shirt or rag. Begin by crumpling the tin foil into a ball and wet it with some water. Then scrub the rust on the chrome with the tin foil. Continue scrubbing until the rust is removed. Then use the rag to wipe the chrome clean. This video will benefit those viewers who have some rusted chrome and would like to learn how ...
Why use a regular wall clock when you can have an awesome clock make out of spoons that you make yourself? Let your character show through or make a cheeky gift with this clock. You will have to buy a basic boring wall clock. Use the battery of the clock and attach it to a great metal strainer as the mount. Then use cut out a picture for the front ant but the hands back on. Glue some spoons on the back to complete the look, add a mount and your ready to enjoy telling time in a whole new way. ...
In this Food video tutorial you will learn how to make chicken curry or butter chicken using Kashmiri meat masala. Masala means spices. Ingredients are 1-2 tablespoons regular sour cream or plain yoghurt, 11/2 tablespoons Kashmiri Meat Masala, 1-2 tablespoons tomato paste, little bit of ground ginger and chilly, one pound of chicken boneless, curry leaves, cooking oil and one green chilly. Add oil in a pan and heat over low heat, add spice, tomato paste, yoghurt and stir and make a thick past...
In this video, “c” The Makeup Artist demonstrates how to make your eyelashes look long and thick like falsies using only your regular makeup. You will need an eyelash curler and two different types of mascara to give you a fuller lash. She recommends two mascaras that she uses.
In this video Rich explains how to maintain a grout and tile floor. He uses a chemical cleaner which he describes as a "grout-smart type product." For regular maintenance of the floor Rich recommends using only 1oz of the product per gallon of warm water but for really badly stained floors using up to 12oz per gallon of warm water. Rich mixes the chemical into his water then applies the mixture to the tile using an ordinary deck scrubber, he then uses an angled scrubber which has bristles tha...
Lynn Snodgrass shows how to make chimes by using small clay pots and popsicle sticks. You can tie them together by using plastic string or regular garden string. The pots can be decorated with paint or you can apply stickers to the pots. 1. Use the sticks tied with the string as the base that holds the pots together. 2. Thread the string through the opening in the clay pots. The pots will have already been decorated with the stickers and the paint and will already be dry. The next step is to ...
In this video tutorial, viewers learn how to start and set up a free blog. Viewers will learn how to setup a free blog for a charity, make a blog entry, edit and customize a blog and share a blog with their network. A blog is a online journal that provides the reader with regular posts on various topics. Three of the most popular blogging sites are: Blogger, Word Press and Live Journal. When creating a blog, keep the posts short and meaningful. Try to engage the reader. Update your blog regul...
In this video, the user gives some suggestions on how to make at home hair protein treatments. She emphasizes that every good treatment consists of two components: a conditioning element, and a protein element. She suggests eggs, avocado, almond butter and soy milk for protein and yogurt, mayonnaise, nut and olive oils, and honey for the conditioning portion. She explains the importance of including both elements for moisturized hair and also that you should choose ingredients in response to ...
Are you sick of your dogs bad behavior? Such as chewing your furniture, bothering you while eating dinner, barking incessantly, and even stealing your slippers! Dee Hoult shows us how to properly use the 'Kong' toy to prevent all this undesirable behavior. It's simple, you just fill the toy with your dogs regular dog food, soak it with water, and put it in the freezer for 1 hour! Then you give your "Kong Pupsicle" to your dog, who will play with it for 30-45 minutes, getting the food out of t...
To make this recipe you will need leftover bread, milk (evaporated is best, but regular will do), sugar, baking powder and egg. In a bowl, mix together the eggs and the milk. Add sugar, and mix again. Add baking powder, mix again. Now you will put in the bread and mash it all in. Then bake for 25 min or steam in your steamer. It is done when fork poked into center of pudding comes out clean. You can add an optional topping when it is finished cooking. In this video, the person spreads some me...
In this how-to video, you will learn how to groom your dog. Grooming is important for any kind of dog. It is important to find a groomer if you cannot do it yourself. Hair under the arms should be trimmed, otherwise it will become dread locked. It is also important to brush your dog's teeth on a regular basis. You can feed your dog with a brand that is good for teeth care. Purchase and use a brush specially designed for dogs. This will help keep your dog's hair from becoming matted. Teach you...
In this video, the instructor shows us how to perform a reset on an Apple iPhone and iPhone 3g. You will want to perform this when the phone will not turn on or is just unresponsive. To perform this, hold down the top bottom and home button simultaneously for approximately 10 seconds. You should see the power bar come up but keep holding the buttons and the Apple logo should show up. After the Apple logo appears, you can remove your fingers and your phone will reboot. The regular home screen ...
this short video shows how to paint nails in a black, pink, and white art design. The steps are simple and easy to follow. The first thing to be done is a regular black, French tip manicure. Once the black French manicure is completely dry, a pink thin tip nail polish is taken. From the middle of the nail , on the black tip, draw a V mark facing sideward on both sides. The next step is to fill the two "V"s, inside with the pink color. Once dried, with the white thin tipped nail polish, a line...
In this video tutorial, viewers learn how to make a Chinese-style black bean sauce. Black bean sauce is a flavoring most popular in the cuisine of China. The ingredients required for this black bean sauce recipe are: ground pork, dried fermented black beans, garlic powder, chopped garlic, chicken broth, dark thick soy sauce (not regular), sesame oil, oyster sauce and corn starch. This video provides step-by-step instructions and a visual demonstration that allows the viewer to easily understa...
Garden of Imagination demonstrates how to make miniature polymer clay pot pies. Find miniature bottle caps in the scrap booking section of the craft store. You can use a regular sized bottle cap to make a big pie. Roll a piece of ecru clay into a ball and mold it into the bottle cap. Round the top to give it a pot pie shape. Use a small blade to create seared lines into the pie top. Brush mustard yellow pastel to tint the top of the pie. Brush a brown pastel accent on the top of the pie. Bake...
If you've ever experienced problems with applying/getting a fake tan and having mistakes, then this video is going to show you how to cover up those fake tan mistake spots. The solution to this problem is very simple and all you need to do to start is buy any kind of white mint toothpaste. With this toothpaste apply it by hand to the trouble spots of your fake tan, and with the bleach inside of the toothpaste it will fade the tan. Another method is to take a regular lemon and rub it against y...
American Girl Doll earrings are easy to make and here's how we can do it. First, find some sticky-sided jewels (they usually come on a sheet) at any regular craft store. Then you are going to need a roll of what is called zots-they are little blue dots found at any scrapbooking store. Place the sticky side of the jewel down onto the blue dot, lift, and now the zot is connected to the jewel. You can then stick these directly onto the doll's ears and you have American Doll earrings! You can mak...
The clay dries by air and you don't have to put it into the oven. The clay isn't brittle and doesn't crack like some of the other clays. The clay bends really easily and is very transparent. Consider that this air dry clay shrinks. The moisture is premixed in the clay. The shrinkage is handy for someone making larger projects. You can use pigment inks, powdered pigments and paints on the air dry clay just like you would use with regular polymer clay. You can also use cutters and findings on t...
It is a demonstration of a cream blush with a # 130. We will be using a steela convertible collar and a color called camellia which is #1 and is used mostly as a blush which nice and bronzy. You firstly stamp the brush onto the blush and then lightly tap the brush onto your hand first so as to ensure you won't have too much of blush on your face.
In this video tutorial, viewers will learn how to create their own Apple Loops in Logic Pro 9. Logic Pro is a hybrid 32/64 bit digital audio workstation and MIDI sequencer software application. In this video, viewers will learn how to make any regular audio file into an Apple Loop that can be searched in Logic's Loops browser. This video focuses on setting up a workspace, recording with both live performers and digital instruments, editing and arranging, and mixing and mastering a composition...
This six and a half minute long video shows how to fold a square piece of paper into an hollow inflatable box or cube. Even simple origami projects like this one are just about impossible to instruct someone in using words alone, so a video like this one is the perfect way to find out how to do this project. Origami paper would make a nice box or cube, but any piece of paper will do. It is easy to square off a regular piece of typing paper and that works just fine. In just a few minutes you c...
"How to make anything" is going to show you how to create a pocket mod, which is very handy and more elegant then just tearing a sheet of paper and stuffing it into your pocket. This demonstration is going to show you how to create the pocket mod using a regular piece of blank white paper. First, you want to fold the piece of paper "hamburger" style, and then fold each flap back towards the crease. Fold the paper again in half the "hamburger" way and unfold the paper so there's a ridge in the...
Rather than spending money at a professional salon, learn how to get inexpensive highlights at home. This technique will give you a very natural look with no orange tones. You need a product called Jolen. Mix about 1/4 teaspoon of this powder. Pull your hair back and take small sections about 1/4 of an inch thick and apply product to that section. You should make sure to wear regular gloves as you are applying the product. It is okay if the product mixes with other products. Continue this wit...
This video describes the process of cutting glass with a regular pair of scissors. Objects required include a pair of scissors, glass to cut, gloves, a tub, and water. First, fill the tub with water to a proper depth to allow for submersion of the glass. Once the tub is filled, submerge the glass and once the glass is submerged, while holding it, begin to slowly cut the glass with careful and slow cuts from the scissors. It is suggested to not conduct the procedure with haste, take the proces...
This video describes how to cut potatoes in a variety of ways for cooking. Cutting potatoes can be tricky because the regular shape of a potato causes them to roll. To avoid this problem, just cut a sliver off the side of the potato to flatten the bottom. Then proceed to cut the potato in the way that you originally planned to. The video then goes on to explain how to make perfect French fries by cutting the potato a certain way. To do so, start by cutting off the side of the potato to give y...
In this video, Yuri Elkaim teaches three abdominal exercises on a stability ball. First, he demonstrates a variation of the plank exercise, rolling back and forth on the ball, and then two other exercises. Learn tips on how to do these exercises correctly to be safe and avoid injury. You will also learn ideas for an abs workout routine. Learn these interesting and challenging exercises for a stronger core and better defined abs. This video will teach you a new workout routine (or just new exe...
This clip shows you how to replace a regular toggle switch with a dimmer switch on a light. It is easier than you think according to the presenter. There is a box with a green ground wire and two black wires. In dimmer switches, it doesn't matter which way you connect the two black wires; they are interchangeable. Turn the power off. Then unscrew the switch once you have opened the plate. Then you simply connect the two wires to the two wires on the dimmer switch. The presenter shows you exac...
Drawing a manga body on your computer is not that different from how you might draw a regular person. Manga bodies tend be slim and long, having an appearance similar to a person you would say has a light build. The best way to begin is by sketching broad guidelines with a 30% black pencil. After that, you want to draw simple sticks for the arms, then intersecting curves to start the chest and a V for the stomach. Follow the example in this video to see the rest.
You start off with a printed design on your doll. Use regular paper, but you have to print the doll in individual pieces - body, hands, legs, head. You stick those on the front of hard materials like thick card stock or some thick fabric. Now you can putt the doll together and make adjustments. You put the doll together by using small thumb tacks. It's even better if you have ones that have a rhinestone on them. Once you've done the joints, you can also add a little tutu or some fairy wings. ...
In this video Wally Makowsky from Coin Laundry Association shows you how to remove stains with strong solvents. Drop off laundry services use various strong solvents for cleaning stains but Wally Makowsky gives two recommendations. One is Laundry Wetspo which is an excellent general solvent. It can remove lipstick, paint, shoe polish, inks and regular food stains. The other recommendation is yellow go laundry which removes similar stains. Out of the two recommended methods, Laundry Wetspo is ...
Grassvalleyflorist teaches you how to make a fall themed flower bouquet. For this you will need some fountain grass, autumn leaves, English laurel, redwood, oregano and another weed that looks good. Layer all of these together, on top of each other. You can also add some pine cones. Wire in the stems allows the whole thing to stay together. Use ribbons or florist wire. Cut the ends so that the bouquet is not very long. You can also make a bow out of a big piece of material or ribbon. The best...
