This video is about finding duplicate entries in excel sheet. The example excel sheet contains different names. There are around 1000 different names in the sample excel sheet. CountIf(range,criteria) formula has been used to do the comparison and return of results in True or False mode. Type =CountIf( now move your left arrow key, this will generate the formula like =CountIf(A2. Now press Ctrl+Shift+Down arrow, this will select all the available values in the column. Now press F4 to lock it ...
Michelina shows how to make Mexican Skulls with Sugar. You'll need a plastic skull mold, sugar, Meringue Powder, water, paste or powder food coloring, and powdered sugar. Add ingredients which would be 3 teaspoons meringur powder and r teaspoons water. Step Two: Mix ingredients. using your hands, make sure ingredients are well blended. Step Three: Fill your molds. Step Four: You'll need to wipe off the excess sugar. Make sure the top is smooth. Step Five: Flip your skulls over on a cut out pa...
This video shows how to style your hair based on the Final Fantasy video game character Yuna. First you will need to spray your hair with a root gel spray, which is a spray that gives your hair texture. Then blow-dry your hair upside down.
In this video tutorial, viewers learn how to dress to flatter their body shape. The female body has three key physical inflection points. These points are: the chest, waist and hips. There are four basic body types. These body types are: apple, pear, hourglass and banana. The apple shape has a full face, broader shoulders, fuller breasts, undefined waist, narrow hips, flat rear ends ans shapely legs. The pear shape has slender neck, narrow shoulders, narrow back, small or medium bust, defined...
In this how-to video, you will learn how to troll large live bait in your kayak. Use a circle hook and attach it to your rod with a small loop knot. This will allow the live bait to have a natural presentation. This means you must troll slowly. You must have slight tension on the string. The bait must have a natural feel when it picks it up. This means there should be no resistance when it grabs the bait. Use a big casting reel with it out of gear and the clicker on. This means the button is ...
This tutorial demonstrates how to make Ninja stars out of 2 pieces of lined notebook paper. Lined paper make your star look cooler and help you keep track of your folds. Fold you paper into five equal sections with a small section left over at the top. This is about five and a half lines per section. Next fold over one corner of the edge that is farthest away from you and then fold over the corner of the opposite edge. Set this paper aside. Repeat the process with your second sheet of paper e...
Michelle Stewart of BodhranExpert.com demonstrates to viewers how to treat the skin on a Bodhran drum. The skin on this particular drum is made of goat skin and, much like your own skin, must be treated with a skin-conditioning treatment in order to maintain proper moisture.
It is important to know how to keep your cooking and baking ingredients fresh. Many have either an expiration date or a "use by" date on the containers which should be followed. Shortening can turn rancid if it is kept in a warm environment. To keep it from going bad it can either be stored in your refrigerator or in a sealed container in a cool, dark, dry place. Sugar doesn't generally go bad, but it can develop moisture which causes lumps to form. If this happens then you can usually either...
This video tutorial from easycomputercoach shows how to easily attach pictures to email addresses. In Windows XP you can send pictures resizing them in the process, in case you have large file sizes.
1. Collect all the materials need to create the ramen noodles clay. These are the polymer clay (color light yellow for noodles and green for green onion) ,FIMO Deko Gel, the mini plate, mini metal stick or needle, cutter, scissor, and toothpick.
BettyCrockerTV shows viewers how to make pull-apart football cupcakes! First, you should cook cupcakes, and then arrange the cupcakes on the platter. Start with three rows of three cupcakes. Next add two on each side! Then add one on the end to finish this off. Now it should look like a football. Now to frost, you should not frost each cupcake. Instead, pipes frosting on to all of the cupcakes in the shape of a football. It should take 2 cups of frosting. Now, after piping frosting onto the c...
This video is about how to prepare grilled gammon steaks with pineapple. So the first step that you will have to do is to wash and dry up the gammon steaks. Then put a little bit of alt season in it. Then place a little amount of oil in the pan to prevent the gammon from sticking. After wards, with the use of a pair of scissors, snip the fat edges of the gammon. In a bowl, place a couple of spoonfuls of honey. Then pour the juice of the lemon and a spoonful of mustard as well. Also, add a sma...
Rayann shows us techniques to make macrame designs using hemp for the creation of fun, interesting jewelry designs. She shows us four techniques. First she introduces us to the half-knot using four strands of hemp. The right-hand strand is brought across the others in the shape of a backwards four, while the left-hand strand is brought behind the others and through the loop created. A series of half knots will result in a spiral design along the length of the jewelry.
In this video, Steven Raichen demonstrates how to make a quick and delicious meal of Argentine "gaucho grilled" filet mignon with grilled eggplant and peppers. In his travels around the world, Raichen became fascinated with the rich, slightly smoky flavor of steak cooked in the traditonal Argentine method, and decided to find a way to replicate that flavor quickly and easily. To do this , Raichen uses a traditional wood-burning grill from Grillworks (to purchase, contact Grillworks at 202-758...
In this video Dr. Carlson demonstrates the properties of light. Light is like a wave and it is also like a particle, which means that it comes in small packets. To demonstrate how we know that light behaves like packets of energy, he uses LED’s in different colors and a sheet of phosphorescent paper. When light with a high enough energy shines on the paper it will cause the paper to glow.
This video shows you how to make marzipan roses and rose buds when cake decorating. Cut disks with cutters. You need two sizes, small and large. Cut 5 of each and roll a ball of marzipan. Make this into a cone. Flatten out the disks to make them thin. Wrap these petals one by one around the cone. Squeeze the bottom and bend the petal edges out. If your fingers stick then rub them in a little corn starch or cornflour. Always use an odd number of petals. Pinch the flower head off the base and m...
In this Electronics video tutorial you will learn how to repair the LCD screen on the HTC Tilt. Remove the stylus pen, back cover and the battery. With a T6 torque screwdriver, remove the three screws. Using a safe pry tool, pry off the top part of the cover. Take out the small piece of rubber as shown in the video and remove the screw below it with a Phillips screwdriver. Then remove one screw on top left corner with the T6. Using the safe pry tool, release the clips and lift off the next la...
First of all you need a long hair brush and a teeth hair brush. You may also use a band for adding glamour. Start by spreading the hair on the front of the head. Now go one inch behind and then take a lock of hair and then comb it and then start back-combing it to the front. Repeat this process taking different locks of hairs at the top and then back-combing them in sections. So you get a hair line on the top of the head which divides the hair into two parts. Now you have to comb the back por...
This shows how to use live trace on Adobe Illustrator to make a vector image. First, you need to open up Adobe Illustrator. Then go to file and select New and adjust your size to letter. For orientation you can choose to have it landscape if you want. Once you have your blank work space you will want to get a saved image. Go to File and click on Place and locate your image. Adjust the size of the image if you need to. Click on the image and then go up to the tool bar to click on the live trac...
In order to make Fabric Paper Rosettes, you will need the following: decorative fabric paper, scissors, glue, and jewel embellishments.
This video shows how to make a rotating SWF logo in Photoshop. Choose any desired logo that will be used later in the SWF file. Save the logo to the desktop. Use any kind of editing pogram. Make sure we only have what we want showing the area coloured with small squares is invisible. Open any version of Adobe Flash. Create a new "Actionscript 2" file. Then set workspace size to 240X320 and background color to match the picture we choose before. Make sure we select Flash Lite 2.0. Then go to F...
In this Arts & Crafts video tutorial you will learn how to make an 18-unit curler kusudama with origami. Kusudama is a Japanese paper ball that is made out of a large number of smaller shapes glued together. This video will show you how to do this without the need to sew or glue to join the pieces. Take a small piece of square paper and fold it diagonally across both diagonals. Then fold it in half from both sides. Now fold in from the center as shown in the video. Then curl up all the four c...
FoodNetworkTV shows you how to make Beef Empanadas from leftover Salisbury steak! First, you should beat one egg in a bowl. Add in 1 tablespoon of cold water to this as an egg wash. Next, spread some flour onto your counter. Now, divide chilled pie crust into six pieces. Roll each piece into a ball, flatten, and roll out with a rolling pin into 3-4inch circles. Use a small bowl to cut out a perfect circle. now, fill this dough with a tablespoon of your meat and moisten the edge of the dough w...
In this Arts & Crafts video tutorial you will learn how to make flower arrangements on a card. To make this you will need punched out pieces of flowers, snowflakes and leaves of different shapes, sizes and color. You will also need some small size paper flowers, glue dots and cards. To make flowers, you can take a rose and twist the wire stem around a paintbrush to give it a curly shape. Then put a glue dot below the rose and attach it to a punched out snowflake. Take some punched out branche...
This video describes the steps on how to make Origami claws. These paper claws are very sturdy and don't break easily.
This is a video tutorial showing its audience how to draw an anime mermaid. The first step in drawing an anime mermaid is to gather your supplies. For this drawing you will need a photoshop type of program. Next you can open up the program. First you will need to open a new window and color it white. Then you can begin drawing. Then you can draw the head and the eyes and mouth first. Next you should draw the body. Next you should draw the mermaid's fin with your drawing tool. When you are fin...
In order to make a Silicone Ring Mold you should first get a small plastic container. This will be your mold box. First, you should cut the bottom out of the container. Next, use double sided tape to stick the ring down to the base of this. Next, secure the mold walls to the base. Now, mix the silicone mix in a separate mixing cup. Make sure you mix this thoroughly until the color is uniform. Now pour the silicone into the mold in a fine stream on the side of the ring, this will help prevent ...
In this how-to video, you will learn how to create a hairy clay figure. You will need to mix basic clay to do this. Rub the clay into a ball and then shape it into the body of the creature. Do not work the clay for too long, as it will harden faster. Use matches to form the eyes. Once the form is complete, move on to the hair. Use a different color clay for a great visual effect. Make the clay into long strings. Once they are done, cut them with a clay knife to form small dots. Rub these dots...
The video presents "How to start your own Clothing Line Business". The steps include getting the financing, designing the prototype outfit/s, producing the line of clothing, promotion and sales. A good way of financing for a small business such as this is to sell your idea to family, friends and even colleagues. Research and prepare the business plan for your clothing line and be passionate about it in your presentation to convince them to fund your business. The next step is to get the produ...
In this how to video, you will learn how to make your own compost heap. Compost is nature's own living fertilizer. It can be purchased at stores, but you can also make it yourself. This can be started in any weather and at any time of the year. Tree trimmings, grass clippings, food scraps, coffee grounds, saw dust, and even dryer lint can be used for compost. Any mix can be used. The critical ingredient is oxygen. Coarse and soft mixes should be used. Water is also important. You want living ...
This is a how-to-video which demonstrates techniques to find the median of number in a series. This demonstration takes the following example.
In this how to video, you will learn how to re-size any image in Photoshop to submit to Alamy. You will need the file to be 48 megabytes and uncompressed. First, open the image in Photoshop. At the bottom, you will see the current image's file size. Now go to image and image size. Increase the size by two or by five percent. Make sure re-sample image and constrain proportions are selected. Make sure bicubic smother is selected at the bottom of the window. At the top of this window, you will s...
By watching this video, you will learn how to create your own art journal. Begin by cutting pieces of heavy weight cardstock 5" by 8". After you have cut all your sheets, fold them in half. If you want a defined crease, you can use a bone folder. Next, poke small holes in the crease of each sheet. Start at the center and then poke one every inch above and below the center hole. Then using a regular running stitch, sew through each hole of a single sheet. Once you reach the bottom hole, bring ...
This how to video shows you how to take apart an HTC 8525 and replace the LCD screen. First, remove the SIM card and the battery. Next, remove the screws in the back. Using a pry tool, slide it along the edge of the phone at the bottom to release the clips. Once they are released, remove the back piece. To remove the motherboard, release the ribbon connector with the pry tool. Carefully lift the motherboard from the case. Remember that it is still connected to a ribbon that must be released. ...
In your Mac computer the size of the dock by default is very small. It makes it difficult to recognize the icons. However you can change a couple of preferences to make it more usable. To do this click on Apple. Form the menu select the dock option and select 'Dock Preferences' from the sub menu. This brings up the Dock preferences window. Here you can change the size of the dock using the size slider bar. You can also set the magnification to the desired level. This changes the magnification...
In order to make a brushed metal effects in Photoshop you should first go to your gradient tool and select a dark grey or a black and click okay. Shift and drag your mouse to create the gradient. Next, go to filter, Noise, and then add noise and change the percent to 40% and click okay. Now, go to blur and ocean blur and change the angle to 0 and distance to 100 pixels. Now, for the sides to look like brushed metal, crop those sides out. Now you have a metal effect. To make a screw, click on ...
The idea of finding the area under a curve is an important fundamental concept in calculus. Consider a function y = f(x). Now the area under the curve is to be calculated. The area under a curve problem is stated as 'Let f(x) be non negative on [a, b]. Find the area of the region lying beneath the curve y = f(x) and above the x-axes, from x = a to x = b. Note that finding the area under a curve will imply that you are dealing with a non negative function. The way to approach is to divide the ...
This video is about how to make a puppet dragon out of household items. First, a piece of card stock paper is cut in half the long way. Next, you must take an empty 18-pack egg carton and cut off a strip of egg slots. Using a stapler, the two pieces of paper are connected long ways, with the egg strip stapled on top of it. This forms the body. To make the head, a small cardboard box is stapled to one end. A smaller cardboard box (about half the size of the one already used) is glued on top. F...
With Windows Media Center, you will have the ability to watch videos, live TV, and listen to music on the XBOX 360 without having to use your computer. You’ll need to have the following things: A PC equipped with Windows Media Center, your XBOX 360, and a fully functional high speed home network. On certain Windows 7 or Vista machines, Media Center is already included. (If not, it can be downloaded from Microsoft) A wired network is preferred for the best connection, although a wireless netwo...
Krazyboytx shows viewers how they can use spell Florida water. You can use Florida Water to cleanse your alter and for your candles. First, you will need a camfur block. Use one of the four pieces of the camphor block and put this piece into a zip-lock bag. Crush this camphor block up into the zip lock bag to get small crystal pieces. Fill up your bowl as much as you can with one block. Next, pour in some of your Florida water up to about it covering the stones. Put this on your alter until i...
