This video is a tutorial on using the Conditional Formatting function of Excel to automatically color alternating rows, which helps your eye to follow across the row. This can be done manually with the “Fill Color” button, but if you add or delete rows after applying the shading, the whole purpose is defeated.
This how to video will show you how to do draw strokes for kayak angling. This is helpful if you are pulling up to or away from a dock. First, reach out from the hip. The more vertical the paddle is, the more lateral pull you will be able to exert. Now, paddle to the hip. Release the pressure off the blade by slicing out behind you or doing a T stroke. A common problem is pulling in and making the boat turn. This means you are not pulling towards your hip. The type of boat determines the type...
This is a how-to video about measuring the toilet flush volume. This is a handy method to find out how much water is used for flushing your toilet. Here is the step by step technique to measure the water capacity of your toilet.
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...
Making a Elephant Toothpaste Volcano!
This video tells us the method to work with the coordinate plane in algebra. The first step tells us the method to determine the coordinates of a given point on the coordinate plane. For this, go parallel to the x axis from the given point and see where it intersects the y axis. This is the y coordinate. Again, go parallel to the y axis from the given point to the x axis. The point of its intersection with x axis is the x coordinate. Now we have the coordinates and we have to find the points ...
This tutorial teaches one on how to sort a given number of contacts in the Excel spreadsheet so that identical values in the sort appear after one another.
The video answers questions on whether containerized tomato plant need to be replanted, problems with yellow tips of an oleander and spots on a silver berry shrub. The tomato plant may be replanted in a bigger container and staked/caged to avoid wind damage. If planted in the ground, it is recommended to plant it at an angle, up to the first branches because tomato plants are able to set out adventitious roots. The yellow and brittle leaves of an oleander is also identified as the result of f...
In this video Krazyboy shares his method of creating a spiritual bath. Krazyboy suggests that while spiritual baths are often known to help cleanse the soul, you can also imbue it with an intent (such as love, luck, success). The idea behind a spiritual bath is cleansing and white. A nice feature of spiritual baths is being able to customize it, including ingredients that feel right to you. To begin, fill a large bowl about half way with holy water/new moon water/spring water. Next, add a cou...
Martyn Cox show us how to plant spring bulbs. You want to begin with bulbs that are firm, with intact skin. You don't need a garden to grow these; you can put them in a pot. If using a terracotta pot, you need to cover the hole in the bottom with another piece of terracotta, to prevent leakage. Next, you add in the compost, breaking up any lumps. For most bulbs, plant them about three times their depth. The flat side is the bottom. You can plant a few together, but make sure they aren't touch...
Creativity Prompt demonstrates how to turn a yogurt container into a mini-album. First, measure the lid's diameter. Then, cut a corresponding circle from your patterned paper. Use Mod Podge to adhere the paper circle to the lid and seal it with another layer of adhesive. Next, cut a bunch of different 4 x 1 inch strips of patterned paper. Adhere the paper strips to the yogurt container with Mod Podge. Seal it with another layer of adhesive and set it aside to dry. Measure the bottom of the co...
This video provides tips on how to determine whether your Coach purse (or bag) is a fake. In order to spot a fake Coach purse, you have to look at the details closely. If there is a fabric pattern on the front, make sure that the letter is clearly a “C”. If it looks more like an “O” or a “G”, then it is a fake.
This video demonstrates how to make a balloon light saber. For this project, you will need the following: long balloons.
ultimatehandyman shows you how to Rewire a fuse from an older style consumer unit. What you need: fuse from an older style consumer unit, a tester/screwdriver, fuse wire of right thickness1. Use a tester to determine whether your fuse is in working condition or not. Once you are sure it is not working unscrew the screws partially which are found on both ends. 2. Unwind the old fuse wire from the screws and remove. Take the fuse wire that is of same rating as the one you just removed. 3. Inser...
Making your own hoop earrings can be fun and easy. In this video we learn to make gold-filled beaded hoop earrings with some wire, pliers, beads and an empty pill bottle. Take a 6 inch piece of 20 gauge wire and wrap it around the pill bottle. Then you take your round nose pliers and bend the tip of the wire in a 90 degree angle ending in a circle. You can be creative with what you put on for beads. In this video it shows a purple focal bead and 30 plain beads. So you would put 15 of your pla...
Golf Link demonstrates how to identify whether your golf swing plane is correct. The swing plane is the path described by the golf head that controls the direction that the club head is traveling through when it impacts the ball. An on plane swing will have the club head directly traveling towards the target at the point of impact. That and a square face will make a straight shot. If the swing comes inside or below the plane, it will produce a hook shot or a push shot. A swing that comes outs...
In this video you learn how to make tombstones for yard decorations for Halloween. You will need two pieces of plywood. In this video the measurements for the wood are 14 by 24 but this can be altered. Also used are, two spikes that resemble the posts in a small picket fence. Using small nails, hammer the two spikes into you board on each side with about 6 inches in between. These will be what you use to stick the tombstone in your lawn. Using another piece of wood with the thickness of the s...
Clinton Kelly, the lifestyle expert, shows the right way to ‘Set your Buffet Table’ for a buffet party, in this video. He suggests that all the serving dishes and utensils are laid on the buffet table, the night before the party. This will throw some light and give ideas as to how to place the dishes on the table. You could place the plates on one side of the table, the food at the center and the napkins to the other side. You should also decide the heights of the various serving platters, co...
In this video you'll learn how to throw a 'spiked curveball'. With this throwing technique you get the ability to make the ball go either down, sideways, or any angle in between.
George Maestri from Lynda shows how to add interactivity in Google SketchUp Pro using a variety of tools in the program. Adding interactivity allows for added dimension and interaction with an object. The example used in the tutorial was that of a fridge, which after adding interactivity, allowed for the doors and drawers of the fridge to be opened. To utilize this technique, the object's file (without interactivity) should be opened. By selecting the fridge and then going to component attrib...
To do this, there are many ways to approach this problem. One way is to look at the change in Y over the change in X by looking at the points on the graph. Another way is to use the equation Y2-Y1 over the equation X2-X1. In other equations where you are given a graph, you may be asked if the slope is positive, negative, or zero. To determine this, look at the line in the context of moving from left to right along the graph. If the line graphed is going down as you move from left to right, th...
Learn how to cheat on a test and never get caught again! 1. Gather the required materials: pen, tape, and a scissors. The pen required is a special kind of pen found at any local store. The tube of this pen rotates inside the click at the top. 2. Type up what you'll need for the test and print the sheet out. 3. Carefully cut out the printed paper. 4. Take apart your pen, take out the tube, take the piece of paper and simply tape around the tube. Note: the size of the font determines the space...
In this video you can learn how to make great tasting corn chowder. Directions are very easy to follow: 1. Either in stock pot, add olive oil to cool pot - put pot on medium heat. 2. Add bacon and onions and let saute and brown slightly and add garlic, diced ham and cook for two more minutes to heat through. 3. Remove and drain from pot and set aside but reserve fat. 4. Add one tablespoon of the bacon fat back into the pot and add drained fresh corn (remember to save the milk from the fresh c...
To make your own non-toxic Halloween makeup, you need to follow the steps below. The things you need are: 1 makeup remover, 2 soaps, 2 bowls, 4 drops of glycerin, 2 tsp. of solid shortenings, 1 tsp. of white flour, and 5 tsp. of cornstarch. First determine what color of makeup you want and mix together 2 tsp. of solid shortening, 5 tsp. of cornstarch, 1 tsp. of flour, and 4 drops of glycerin in a bowl. Then blend it well and add food coloring, a little at a time, until you get the color you w...
Learn how to tie a perfect bow. To do a basic pony bow, place the gathered hair in the center of the ribbon and tie a single knot to secure it. Making two loops, cross one loop over the other and pull the loop on top through the hole you've created. Straighten out the ends and tighten so the two loops are on top and the two tails on bottom. Make a headband bow. Run the ribbon along the hairline, drawing the ends up on top of your head. Secure a knot and tie a bow. By tweaking the loops out a ...
Michele Knaus, from EatLikeAChef, shows how to prep an artichoke. 1. Remove thorny pieces on the ends with kitchen shears. 2. Remove out-most layer of artichoke leaves. 3. Prep the stem by peeling with a peeler. Peel like a carrot. It is good to leave the stem on because it has a nice taste and it is a good way to tell if an artichoke is done. The stem will bend when tender. 4. To get inside of the artichoke, take the entire top off. Use a large, sharp knife to do this. 5. Gently slide open w...
You will need a snare made of aircraft cable. Snares are relatively inexpensive. Remember that most likely you will only get one catch out of a cable as they kink when an animal is caught.
There is a great cost effective and durable fence option that is available now. It is fence made from plastic PVC. Start by putting a stake in the ground to mark the location of the first fence post. Use a string tied to the first stake to mark the rest of the fence line. Drive stakes in the ground to mark the location of additional fence posts along the string line every eight feet. Dig your fence post holes with a post hole digger or rent a motorized digger. Once you've dug the hole put gra...
Watering requirements for deciduous trees is dramatically different in autumn than at other seasons throughout the year. In the autumn there is less wind, less evaporation, the temperatures are lower and so there is less of a problem with dehydrating the plant. When you plant the tree. Dig a hole and put the tree in the hole. Fill the hole half way full of soil and flood the rest of the hole with water. Let is soak in and then fill it again. This will soak the roots and also the ground around...
A lot of phone numbers these days use letters so that you can remember them easier. For example, 1 800 BEST BUY or 1 800 FLOWERS. On a normal touchtone telephone, you would associate these letters with numbers on your keypad. With a Blackberry, however, this poses a problem. Blackberries do not have the traditional letters above the numbers.. so how are you supposed to dial?
Using acid stains on concrete floors can be cheaper and easier to maintain than laying down tile on your floor. Here, Gaye Goodman shows you how to make acid stains on your concrete floor, a nice, economical way to make beautiful floors. First, you should test on samples of your floor in order to decide which color to use and to determine how the acid stain will look. After covering the bottom of your walls with painter's tape to avoid splashing, mix about 1 cup of TSP to 4 gallons of water. ...
Take a common indoor hanging basket plant and use it to make a great water plant. You take a stem of tradescantia with the roots attached. Wash off all the soil. Put the stem into a vase with rocks and water in it. Anchor the plant stem down in the rocks. Add some charcoal pebbles to inhibit bacteria growth in the vase. The tradescantia will grow roots in the water. To keep it healthy also add some hydroculture fertilizer to the plant about once a month. Also you may want to change the water ...
Not sure how to balance a chemical equation? According to the rules of chemistry, matter must be conserved in chemical reactions. When you balance a chemical equation, you account for all of the matter in the reaction.
With Tim Burton's revival of Alice in Wonderland, throw one of the hottest parties in town with a "mad tea party" themed party. Recreating one of Alice in Wonderland's most famous adventures is a great theme for all kinds of celebrations. Set the scene with these suggestions.
This is an electronic travel authorization system used to gain travel authorization to the United States. There are certain countries that fall under a visa waiver program, meaning that you do not need a visa to enter the US to visit. In that case you use the ESTA system. The countries that qualify in the VISA waiver program include Andora, Australia, Austria, Belgium, Brunei, The Czech Republic, Denmark, Estonia, Finland, France, Germany, Hungary, Iceland, Ireland, Italy, Japan, Latvia, Lich...
Meg Allan Cole from Decor It Yourself shows you an easy way to make your kitchen look amazing by just adding a creative, do it yourself backsplash.
Artichokes can be a delicious treat with a butter sauce or other dipping sauces. You don’t have to be a blue ribbon chef to prepare artichokes. Just keep these few tips in mind.
Looking to be the talk of the town? Do you love gardening and have some time to spare? Build a garden maze and make your yard the neighborhood sensation.
Are your sinuses killing you? There are ways to relieve this pain by applying pressue. Learn to apply pressure to points of the body with your thumbs or fingers to relieve sinus pain.
So, you have an oval face and want a new look? Matching hairstyles and face shapes can sometimes be hard, but here is a video on how to select the best hairstyle that will flatter your oval face.
