In order to Find, Replace, and Sort, using MS Excel, become familiar with your home tab. When you click on Sort, it will give you the opportunity to sort in different ways: e.g. alphabetically. If you accidentally shift your table, you can undo it by using Ctrl + Z. Custom Sort will allow you to be very specific in the way you want your data sorted. You can add or remove a filter with the same drop down menu, in order to be even more precise.
In this how to video, you will learn how to change hair color in a photo using GIMP. First, download and install the program. Open it and find the image you want to change. Next, zoom in to get a full view of the hair. Now you should go to the paths tool. Highlight all around the hair to select it. Once this is done, go to select and select From Path. Marching ants should go around the selection. Now, go to colors and select Color Balance. Adjust the color sliders to change the hair color. On...
This video shows a recipe for pear-ginger upside-down cake. First, brown sugar, butter, and corn syrup are melted together in a sauce pan. The mixture is removed from heat and vanilla is added before stirring; this mixture will serve as the glaze for the cake. The glaze is evenly spread into a cake pan. Next, chopped pecans and sliced pears are added to the cake pan. The video then makes use of a spiced cake mix that has been prepared according to the directions with the exception of the addi...
The video describes to make wire hoop earrings. Take a steel metal of anything and take a eighteen gauge wire and wrap a few length of it around the taken piece of metal which is cylindrical in shape. Cut the wire at the desired part and remove from metal.The wire takes the shape of a standard spring. Again cut it into two or three pieces. Hold the wire again and straighten the edge and after that once again bend it down holding at the place where bent begins. Put some on it to design and the...
In order to prepare Ratatouille Nicoise with Roasted Vegetables, you will need the following: tomato sauce, zucchini, egg plant, fennel bulb, olive oil, red and yellow peppers, and a whole garlic bulb.
Sandra Lee in this video shows how to make triple orange angel food cake. She takes a pack of angel food cake mix in a bowl and adds the juice of mandarin oranges with water to it. A tablespoon of orange zest is added to the bowl and mixed well. This goes into a pan sprayed nicely and generously with cooking spray. Half a can of the mandarin oranges are popped into the cake batter. This is baked in a pre-heated oven to 350 degrees. The uneven top of the cooked cake is removed. The rest of the...
In this video, we learn how to tie a surgical knot in someone's mouth. First, you will push through the gum into the tooth root, you will do this with surgical string and two surgical pliers made for this. Then, you will push the needle and thread through on the other side of the tear until you can tie a knot. Tie this knot several different times until both sides of the tear are closed. Once you have both sides closed, you have successfully tied a surgical knot. This is easily done when the ...
In this Home & Garden video tutorial you will learn how to make a concrete obstacle. Materials required are cement, 1 big receptacle, 1 small plastic receptacle, a cup for measuring, a spatula, 1 mold, WD40, paper towels and protection mask. Wear the mask, spray WD40 on the small receptacle and the mold, and wipe off with paper towel. Pour two cups of cement in the big receptacle, add one cup of water and mix slowly with the spatula. You can add more cement, water and make it to a watery cons...
This video tells us the method to decorate an angel food cake with cranberry garnish. Cut the cake into half horizontally by using a serrated knife. Remove the upper portion of the cake. Mix together half cup of raspberry jam and two teaspoons of orange peel. This mixture is spooned over the top of the lower portion of the cake. Put the top of the cake back on the lower portion. Take 8 ounce of whip topping and apply it to the outer portion of the cake. Now, take frozen cranberries and thaw t...
Here we will demonstrate how to measure the volume of a balloon. A balloon is not a straight edged polygon shape, usually, so the mathematical equations get that much harder, on the flip side, it may be a spherical or ovalish shape, but measurements with math alone are detrimental due to the uneven sizes of the balloon. Here is how to do it properly. You will need a bucket, preferably, to hold water, a larger container than your original bucket, and a measuring container. Place the bucket ins...
Following are the steps to describe how-to make small decorative bowls using polymer clay at your home:
In this how-to video, you will learn how to get more out of your spray cans. This is useful if you want to make the most out of the money spent on these purchases. These spray cans are very useful for painting objects that would be harder with the traditional bus. First, follow the directions on the spray can. It should say to turn it upside down and spray it until it runs clear. This keeps the tips clear. If the can is old, you can carefully remove the tip from the can and drop it in paint t...
Nick Spadaro shows how to make a fire with a fire piston. This device creates fire by compression, just like a deisel engine. You can find these online. Lubricate the gasket with just about anything, including chapstick or animal fat. Then put it in and make sure you have a nice fit. Pick your tender, preferably birch tender fungus, a nice spongy material. Put it in the piston, and put the piston on your leg. Your going to want to strike the piston sharply, straight down, so as not to break t...
In this Computers & Programming video tutorial you will learn how to format/partition an external hard drive on a Mac. This is really very easy and simple to do and takes practically no time. Click on spotlight search and look for disk utility. That will bring up the list of hard drives. Click on the external hard drive and click ‘erase’. Then on ‘security options’ select ‘zero out data’ and click OK. This will remove everything from the hard drive. Your external hard drive is now...
In this video you will learn a simple and fast way to cut a pineapple into small chunks. Begin by cutting off both the top and bottom of the pineapple. Then cut the pineapple in half from top to bottom, rotate the pineapple 45 degrees and cut again so that you have eight long wedges. Take each wedge and set it on the cutting board skin side down. Cut in two small pieces but don't go all the way through the skin. Finally, pass the knife along the bottom of the wedge removing the skin. Repeat t...
This video describes how to make an easy-to-prepare black bean hummus. One cup of black beans is first added to a food processor. Next, a lemon is cut in half and the juice of half of the lemon is squeezed into the food processor. Some white winer vinegar is then added to the food processor as well. One clove of garlic is then crushed and peeled before being given a rough chop and being added to the food processor. Salt and black pepper are next ground into the food processor. The final ingre...
Rebecca from OffWhiteLiving shows a quick, easy way to cook collard greens. First remove the ribs from the leaves and chop them into bite-size pieces. Heat some butter and olive oil in the skillet. The greens need to be cooked in some type of fat since they have a lot of fat-soluble vitamins, including vitamin K, which is an important anti-clotting vitamin. Not to mention it makes them tastier. Put the greens into the pan and coat them with the butter and oil. Keep the heat low. A little know...
In this how to video, you will learn how to open a locked zippered luggage bag. This is very useful if you plan a trip and forget the key to the lock of your luggage bag. All you need is a normal pen. Remove the lid of the pen. Apply pressure in between the zipper. Once you get through, slide the pen all the way around to open the luggage. This will open the luggage and you will have access to the entire inside. Once you are done, you can close it back with the pen or the zipper. It will be u...
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 video Jack in the Net shows how to grow your own pineapple using just the crown. Find a nice firm, strong pineapple with no brown leaves. With a very sharp knife, cut straight through about an inch down from the crown. Then trim the flesh all the way around, leaving only the solid round core in the middle, being careful not to cut into the crown. The roots will grow off of the crown so all the fruit needs to be removed.
The video shows how to pan for gold using the backwash and tap method. Take about a quarter cup of Georgia concentrate and add to a panning tray (looks like a shallow bowl with ridges). Add some water to cover and gently move the mixture around to wash off the lighter sand and dirt particles (gold is heavier and will sink to the bottom). Resettle the mixture at the bottom and start over, continuing to wash off the sand until you start to see specks of gold along the side. Keep resettling the ...
In this video tutorial, viewers learn how to speed up a Windows PC using a USB flash drive. Begin by clicking on the Start menu and select My Computer. Now right-click on the flash drive and select Properties. Click on the Ready Boost tab and check Use this device. Select the amount of space and click Apply. Then click OK. To remove the flash drive, right-click on the flash drive and click on Properties. Click on the Ready Boost tab and check Do not use this device. This video will benefit th...
This is a tutorial about cooking chicken in a oven Portuguese style,that is chicken a Moda do Alentejo.You require 1 whole chicken cleaned and cut to pieces,1 1/2 kg potatoes sliced,1 large green pepper sliced,crushed chillies or ginger,2 onions with the skin sliced,20 garlic cloves with skin,1 full cup of olive oil,pepper and salt to taste.Pre-heat the oven at 220 deg for 15 mins.Now take the oven tray put the potatoes spread it, on top of it lay the chicken.Put the green pepper,crushed chil...
True's Owner Maintenance Video Series shows us how to set the defrost time clock on a True freezer, and also how to cut the shipping band on the compressors of all larger freezers. The time clock is behind the grill at the base of the unit, behind a gray box. There are instructions in the inside of the lid for setting the time clock and for setting the defrost settings, and the video goes through the entire process, as well. Next, the man shows how to remove the shipping band protecting the c...
Squirrelod shows you how to put together a shock assembly or a shock absorber on a Factory Team remote control car kit. He takes us through building the piston - shaft, dampener, nuts and over rings step by step. Practical tips and tricks involved in building up the shaft and the recommended oil used are presented. This is not something that should be done in a hurry since time is needed to let the oil settle thus removing any air bubbles in the piston. Although the instructions for different...
Liv Hansen with Betty Crocker TV demonstrates how to make pancakes in fun shapes that kids will love. Make sure to pour your pancake batter into a squeeze bottle for better control when creating your pancake shapes.
In this Family video tutorial you will learn how to make a spiral sun catcher. Take a contact paper and draw a spiral on it starting at the center and drawing out wards. Now remove the backing of the contact paper and lay it down sticky side up. With markers, color in the spiral. Then take the contact paper and lay it on top of the backing and smooth it out. Now cut along the line of the spiral with scissors. Tie a piece of ribbon to the inside end of the spiral and now you have a spiral sun ...
In this video, we learn how to toast walnuts to place into your favorite recipes. First, you want to put the walnuts on a single layer of a baking sheet so they bake nice and evenly. Now, place the walnuts in a preheated 350 degree oven for about 7-10 minutes until they are golden brown. When finished, remove from the oven and let these cool. You can now place these walnuts into any recipe you like! This will bring out the most flavor that is in your walnuts and taste much better than using u...
In this video tutorial, viewers learn how to make molded paper. The materials required are toilet paper and stamps. Begin by wetting the toilet paper under some water and lay it down. Use about 10 layers of 2 ply toilet paper. Now press the stamp onto the wet toilet paper and then press down on the stamp with a towel or cloth. Remove the stamp and heat dry the toilet paper. Now let the toilet paper dry fully overnight or half of the day. This video will benefit those viewers who are intereste...
Sandra Lee shows how to make pecan cinnamon angel food cake the easiest way. The ingredients used for this recipe are 8 ounces of whipped cream cheese, half a cup of chopped pecans, 2 teaspoons of cinnamon, 2 tablespoons of brown sugar and an angel food cake. The cream cheese, pecans, cinnamon and brown sugar are mixed in a bowl to make the filling for the cake. A one inch top of the cake is cut and set aside. The core is removed from the cake to make place for the filling. The cored pieces o...
In this Fine Art video tutorial you will learn how to make your own duct tape dress form. This video is from www.thunderlily.com. The materials you will need for this project are an old t-shirt, duct tape, strips of fabric to put around your neck and arms and a pair of gloves. Wear the old t-shirt and stand upright. Tape around the chest and waist to keep your shape as shown in the video. Add extra fabric around the neck. Then tape all over the t-shirt and cover the entire t-shirt. Then remov...
In this video, we learn how to control flies around your home with Rick Steinel. The common house fly can be found everywhere in the house and are full of disgusting germs. We can now make a type of liquid that attracts flies and kills them. These are safe for humans so it won't hurt your home or you. This liquid can also be placed inside of a container which will collect the flies outside, before they have a chance to enter your home. They are also very easy to install and it's very easy ins...
HolidayKitchen.tv shows us how to make a perfect pie crust. It's easy and costs just pennies. You will need a food processor and the following ingredients: 1 C flour, 2 tsp sugar, 1/4 tsp salt, 1/4 C chilled butter, 1 Tbls chilled shortening, one egg yolk, and 2 Tbls water. Follow the directions in the video for exact blending. When the mixture pulls away from the sides of the bowl and clings together, you can remove it to a new bowl. Cover and chill for half an hour. Flour your work surface ...
POP3 stands for Post Office Protocol, a way in which you receive mail on the internet, paralleling how mail is received in your mailbox. To set up your POP3 for Outlook, go to tools, click “view or change existing e-mail accounts’ and press next. You’ll be able to see a list of your current email accounts that you can change or remove. When you select an email and press change, you’ll be able to see the account in detail: the email address, the POP3 and SMTP server information, and th...
In this video, Anthony from Gazelle GadgetLab shows you how to replace the trackball or make it like new on many Blackberry versions, the BlackBerry Pearl, Curve, and 8800 series. This simple procedure is used to clean up your trackball when it starts malfunctioning. What you need is basically some alcohol or lens cleaning solution, air can, a tool to pry with and some cue tips to clean with. First, take the silver ring off the area which holds in the trackball with the prying tool. After pop...
Rick Steinau with Ask the Exterminator demonstrates how to prevent yellow jackets from nesting in your home's walls. In mid to late summer yellow jacket populations increase. Yellow jackets can find spaces in the veneer or in cracks in bricks or siding. You can hear scratching noises in your walls as the wasps move. Observe wasp activity late in the day when they return to their nest for the night. Treat reachable holes with pesticide dust and a bellows. Leave the hole open to let the wasps f...
CadNYC demonstrates how to open the Nike iPod sensor casing. Replacing the iPod Nike sensor battery is easy and low cost with a few simple steps. First, place the sensor in a vice clamp and saw off the casing using a very thin hacksaw blade. then, open up the sensor compartment to have access to the battery. You can now remove the battery and replace it with another battery which will cost about two dollars. After you replace the Nike iPod sensor battery, use a strong adhesive to glue the cov...
This video gives instructions for making Chicken Korma. There is no audio but the instructions are on the screen and the demonstration is easy to follow. The ingredients in this dish are chicken breasts, oil, curry base, cream, grated coconut and sugar.
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 ...
1. Go to Control Panel from the start menu and select Uninstall a program. 2. Start Menu>Control Panel>Uninstall a Program
