Varies Based Search Results

How To: Wear a 'kanga' (sarong) in various African styles

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,...

How To: Cunduct a viscous remanent magnetization experiment

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...

How To: Do a Gwen Stefani twisted updo

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...

How To: Use an advanced filter to extract table data in Excel

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.

How To: Achieve a picture-in-picture effect in Apple iMovie

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...

How To: Check if a cell is empty using macros in Excel

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...

How To: Use data validation with a list in Excel

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...

How To: Make a Christmas centerpiece with evergreens & flowers

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...

How To: Summarize data from multiple sheets in Microsoft Excel

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.

How To: Create dynamic sub tables in Microsoft Excel

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.

How To: Extract records that meet certain criteria in Excel

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...

How To: Build a punching bag out of trash

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...

How To: Build a gravity retaining wall

This video shows us how to build a gravity wall with Allen Blocks. In order to do this, place blocks on top of the base course. You want to make sure that the bottom notch is tight against the front lip of the blocks underneath. Sliding them into place removes any present debris. Running bond is ideal; however, if that is not possible, offset them by a quarter of a block. After making sure the blocks are straight, fill the hollow blocks (and 12 inches behind them) with wall rock. Then smooth ...

How To: Caulk your bathroom tub

Joe explains how to caulk the bathroom tub using a caulk gun. You need: - a latex based caulk designed for bathrooms- a damp cloth. Steps: 1. When you start caulking, gently squeeze and move the gun at the same rate as you apply pressure to the trigger. 2. After you've applied the caulk , wipe your finger on the damp cloth and smooth out the caulk with your damp finger. 3. Stop every 12 or 18 inches and wipe your finger on the cloth. 4. Continue smoothing the caulk until you're done.

How To: Do stomach flattening exercises at home

This fitness video shows how to do stomach-flattening exercises at home. Our host, Kathy, Kaehler, informs us that the best exercise is a yoga-based exercise called the plank, because it focuses on your core. Your core is where your abs are. This exercise is best done on soft surfaces. Start out at 15 seconds, and build up to a minute or more. To do the plank, rest on your knees and 1 forearm, with your side facing the ground. Make sure your body is straight. If you want to make the exercise ...

How To: Whipstitch

In this Arts & Crafts video tutorial you will learn how to do Whipstitching. The video demonstrates how to stitch the bottom of a cloth basket to the sides of the basket. A whipstitch is a very basic stitch. Start at one end of the basket; attach the bottom to the sides with a pin. Pass the needle from the inside so that the knot is hidden. All you have to do is taking the thread and whipping it around the edge. At the beginning, give it a bit of binding stitch before stitching the rest of th...

How To: Pack a backpack for Europe as a male traveler

Backpacking through Europe is a great way to see a new country. This video tutorial shows male travelers what to include in a travel backpack and offers insightful tips on enjoying a trip through Europe. As a general rule, you'll want to reach a balance between light packing and thorough preparedness. Create a packing system based on item demand, dividing items into the bottom, middle, and top sections of your bag. Finally, bring a journal to record important information and for writing down ...

How To: Pack a bag for Europe as a female traveler

Backpacking through Europe is an exciting and affordable way to see a new country. This video tutorial shows female travelers what to include in a travel backpack and offers insightful tips on enjoying a trip through Europe. Create a packing system based on item demand, dividing items into the bottom, middle, and top sections of your bag. As a general rule, include clothing that may be easily layered for colder climates.

How To: Make a LEGO bookcase

In this video Tanky shows you how to make a LEGO bookcase. He details each step of how to create a small LEGO bookcase, starting from the base and building one level at a time. He Suggests connecting all parts in the final step in order to ensure the bookcase does not fall apart. He then inserts books into each shelf to create a filled bookcase that displays twenty books on two levels of shelf. The LEGO books fit in well. If you follow the steps in this video you will have a realistic LEGO bo...

How To: Change lenses on a camcorder

Make sure you have the appropriate lens for your digital camera. Look for markers on the lens that correspond with any mark on the camera body. Different brands have different markers. Some have square dots while some have red dots. Line these marks In one hand, hold your camera body firmly pointing to you. While holding it, push the lens button. Firmly hold the bottom of the lens (where the lens meets the camera body), and twist. Some cameras let you twist clockwise, others counterclockwise....

How To: Make herbal capsules with a capsule machine

Mountain Rose Herbs John Gallagher shows us how to make our own quality powdered herb capsules using a machine in this video. You will need three things to do this, your powdered herbs, zero size capsules and a zero size capsule machine. He shows us the parts of the capsule machine so we can follow his instructions. Find a container to put the base of the machine in, pull apart the capsules, putting the bottom part in the bottom of the machine and the top in the top part of the machine, filli...

How To: Cloth gift wrap two bottles using "tenugui" technique

In this video tutorial, viewers learn how to gift wrap two bottles using the chopstick tenugui wrap technique. Tenugui is a thin Japanese hand towel made of cotton. The materials needed for this gift wrap are: a tenugui, chopsticks and two small bottles. Begin by laying the bottles horizontally as the bottom bases touch on the tenugui. Roll the tenugui and fold it up. Tie the ends with a double cross and add the chopsticks in the knot. This video will benefit those viewers who are planning to...

How To: Steady your shots with a homemade fig rig

This video tutorial is going to show you how to steady your shots with a homemade fig rig. The camera is mounted right in the middle of the top bar and it uses the iron as the balancing mechanism. The official fig rig is about $300. But, the one shown in the video will cost you around $10. Cut a PVC pipe about 2 feet in length and glue on two T joints on either end parallel to each other. Now fix the two feet into the T joints as shown in the video. The larger the camera, the longer will be t...

How To: Do Bachata outside turns

In Bachata dancing, there are many turns one must learn in order to master this Dominican Republic based dance. In this video, learn how to do outside turns by starting in an open position with the ladies hands on top of the gentleman's hands. Follow the steps in this video to perfect outside turns with help from a professional dance instructor.

How To: Arrange a Chinese New Year flower table centerpiece

The Flower god gets us all ready for the Chinese New year with a quick and very simple flower arrangement for a table centerpiece. You'll need some good luck bamboo, some ivy, little pieces of ginger and some passion flowers to accent the green. Take some of the ivy leaves and cover the centerpiece base. Cut them short at a sharp angle to cover everything. Next use the good luck bamboo to add height. Cut these at a sharp angle as well so that they will stay secure. The angles help it work as ...

How To: Make a DIY wedding flower centerpieces

A wedding budget can quickly get out of hand as your planning progresses. Things like centerpieces are a major cause of skyrocketing wedding costs. If you have a little time and want to easily trim down the cost of your wedding, think about making your own floral centerpieces. You'll learn how to with this simple tutorial from EZ Bouquet. You'll soon see how easy it is to make a beautiful floral arrangement in an open container and how to secure the arrangement in the base of the container. A...

How To: Work out at home to get rock hard buns & glutes

Darin Steen from Major League Health and Fat Loss Lifestyle demonstrates how to work out at home to get rock hard buns and glutes. You will need a wood floor or a ceramic tile floor that's nice and slick to do the exercises. Lie down on your back on the floor and extend your arms so you have a nice shoulder base. Then, point your toes up, dig your heels in and drive your hips up towards the ceiling. Squeeze your buns and hamstrings for 10 repetitions. On your last repetition, straighten out y...

How To: Make a simple spring themed flower bouquet

In this video it is demonstrated how to make a simple spring bouquet with tulips and daisies. First take a transparent glass pot and fill it with water. Take some green soft thin stem, roll it and put it into the pot to make a base for the bouquet. Take some yellow tulips and put them into the pot in a clockwise manner and put some seeders in between the tulips. Add some lily grass to it so that the bouquet looks bigger. Now add a dragon fly floating at the top. As time goes by, the tulips wi...

How To: Draw a vase with flowers using a colored pencil

Swirloflight teaches you how to draw a vase with flowers using a colored pencil. Start with a regular black pencil to sketch the flowers and base. You want to start off with basic shape and draw only what you need. You will now go to the next part, using the colored pencils. Don't go into great detail and don't be afraid of going outside of the lines while coloring in. The colored pencils are good for creating rich areas of color. After you're done with the vase and flowers, create a blended ...

How To: Line a round cake tin

This film from Woman's Weekly shows you how to line a round cake tin. First you take non stick baking parchment. Fold the paper to double thickness, then rest the tin on top and draw around it with a pencil. After that, then cut just inside the pencil line to compensate for the thickness of the tin. For the sides, you roll the tin on its edge, allowing some extra for overlap and a little extra height above the tin. Make a fold a couple of centimeters from the top and then make some cuts from ...

How To: Perform The Kicker magic card trick

This video shows you how to perform the magic card trick "The Kicker". In poker when you have four of a kind, the fifth card in your hand is called the Kicker card. It's usually meaningless unless you have a tie where it is used to determine the winner. In this trick you learn how to use the kicker card, in this case a 10 of hearts, to find the four aces inside a deck of cards as if by magic. This trick is based on math rather than sleight of hand, once you arrange the deck as you learn in th...

How To: Make drum & bass basslines in Reason 4

This video demonstrates how to design drum and bass lines in a Reason 4 program. This video does not have a speaker rather it shows you on the computer how you would make these lines. Music plays at sometimes but mostly it is various screens and demonstrations of making the base lines. There is text to help you out on the screen. If you follow the steps in this video, you'll be able to create a basic drum line using Reason 4.

How To: Get rocker rhinestone studded nails

The rhinestone studded nails will be more attractive. To make your nails a perfect complement to any acrylic or polished nails use your wildest imagination to make it more attractive. The following steps will help to make beautiful, rocker rhinestone studded nails. The first step is to clean the nail surface where you want the stickers to be placed. The second step is to apply a base coat, and the third step is to apply nail polish color. The fourth step is to peel off the stickers carefully ...

How To: Make Sailor Moon feather & pearl cosplay hair clips

This video is a demonstration of how to make Sailor Moon style hair clips. Start with two alligator clips, six half pearls, craft foam, glue, a pencil and scissors. Draw an outline of a feather shape on the craft foam and cut it out. Trace around the cut-out to make several more and cut them out. Spread some glue on the top of an alligator clip and stick the feathers shapes on in an overlapping design. Put some glue on the back of each half pearl and stick it to the clip at the base of each f...

How To: Make Cricut snow globe card

Cardcrazy09 teaches us how to make a Cricut snow globe card. You cut the base of the snow globe in brown cardboard. You then add a layer of white with dots and snow flakes on top. The snowman is done using the same technique - black cardboard and then a white layer on top of it. You add the carrot nose by sticking it on. When all is dry, add the snowman on top of the snow globe, in the middle of it. You add the acetate layer on top of them. The end result looks like the class on a real snow g...

How To: Make a scallop Christmas tree card with Stampin' Up!

Dawn from "Stampin' Up" shows how to make an adorable Christmas card. She uses cardstock and several shapes to create this cute Christmas tree. A scallop circle hole-punch makes this craft a breeze - you could easily make enough of these cards for everyone on your list. A triangular base and six or seven scallop punches cut into quarters are all that is needed for the body of the tree. A star punch and some small circle punches bring this little tree to life. Your friends and family will want...

How To: Use an extension ladder safely

This video shows you how to safely use an extension ladder. To put the ladder up put the bottom against the wall and walk it hand by hand until the top is against the ladder. Then grab the bottom and pull it out. To make sure the ladder is at the correct angle and stand with your toes against the base of the ladder and stretch your arms out straight. You should be able to grasp a rod. If you can't reach it you should readjust it. Avoid over reaching to the sides.

How To: Make vegetarian tempeh & shiitake mushroom stir-fry

Larry Cook gives the low-down on how to make a nutritious Tempeh and Shiitake Mushroom Stir-fry. Tempeh is an Indonesian based dish made out of slightly fermented soybeans that are shaped into a patty. It can be used as a meat substitute and the mushrooms and asparagus add antioxidants to your meal. You can add extra spices and liquid marinades as shown to jazz up the taste of the Tempeh. Larry also demonstrates how to make a healthy salad that pairs perfectly with the stir fry.

How To: Make homemade ice cream in a blender

This how to video describes how to create tasty ice cream in a home blender! First you gather your ingredients including anything you want in your ice cream. The video suggests you use: 2 cups of cream, 2 cups of milk, some vanilla, and half a cup of sugar. Using this base you can create a tasty vanilla ice cream! After that you simply blend it up for two minuets then stick it in the freezer and you are left with tasty delicious ice cream.