Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...
In this Software video tutorial you will learn how to make a book cover in Photoshop. Go to file -> new. Give it a name, set width 900, height 1200 and resolution 300 and click OK. You can change these settings if you like. Go to your paint bucket tool and paint the background black. Then go to layer -> new ->new layer -> OK. Now select the elliptical marquee tool and holding ‘shift’ drag from the top left hand corner and make a circle. Go to your paint bucket tool and paint the circle with a...
This video will show viewers various tips on how to shape your eyebrows depending on the type of eyebrows which you would like. Using a kit called "Million Dollar Eyebrows", which contains an instructional CD which will show you how to perform this technique, the host of this video shows how she uses the kit in order to shape her perfect eyebrows. Using a tool provided in the kit, she shows how to determine the length, height, and width of your eyebrows so that you will have the perfectly sha...
This video instructs the viewer on how to do a powerful Driven Free kick for soccer. First, you will need to come on to the ball and strike it with your in-step. Your in step is the inner part of your foot that is right next to the laces. The most important tip is that when you do strike the ball, come through the ball and not around it! Finish with a hop at the end which will create more power! You'll want to kick the ball just under the center for proper height and maximum power. Kick the b...
This video will teach you how to create a basic logo in Photoshop CS3. In order to create a logo you need to follow this simple steps: 1. Go to File -> New and create a new document with the width and height 500 px. Set the RGB Color and the background transparent. 2. Fill the background with a black color. 3. Create a new layer and create a perfect circle. 4. Select Blending Options and Gradient and use a light red color to fill the circle. Add the text and use some effects for it. The video...
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 ...
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 ...
This video demonstrates how to sew a Victorian skirt. First take a cotton cloth and cut a rectangle piece twice the size of your waist. The length would be depending on your choice of height you require. Hem the top and the bottom of the cloth. Then use elastic thread to create 12 rows of shirring. Each row can be 1/4th inch apart. This is for sure a tedious task but it will look beautiful. Then take a chiffon cloth and cut the same size as your skirt. Hem one side of it and on the other side...
For anyone who is learning geometry and would like to learn or to review how to find the volume of a cone, this is the video for you to watch. The video provides you with both the simple formula for a cone as well as various examples which you can use to practice. The formula for finding the volume of a cone is 1/3 x pi x r^2 x h, where r is the radius of the base circle of the cone and h is the height of the cone.
In this video tutorial the author shows how to find the surface area of a cylinder. He shows a four step approach to solve this problem. First he gives us a formula to find the surface area of a cylinder, where Surface area A = 2 * Pi * R * R + 2 * Pi * R * H, where R is the radius of the base of the cylinder and H is the height of the cylinder. Now he identifies those values and substitutes them in the formula giving the surface area of the cylinder. This video shows how to compute the surfa...
Mark Donovan of HomeAdditionsPlus shows us how to install a towel ring in the bathroom. - Line the ring up on a wall stud.
In part one of her three part instructional video series on setting a cabochon in a bezel, Art Jewelry Magazine associate editor Addie Kidd shows you how to adjust your bezel's height to match your cabochon. This technique is essential for making pendants or any jewelry with a large stone centerpiece. Learn how to set a stone or jewel cabochon by watching this video jewelry-making tutorial.
Three point lighting is the standard used to illuminate a subject for amateur film, video, and even theater application.
Recipe for disaster, or rising to dizzy heights? Lenny and Waz tackle one of the most feared desserts known to man. Follow along as the Crash Test Kitchen chefs show you how to make a souffle in your own kitchen. There is no need to be afraid of this souffle recipe. Bake a homemade souffle.
Know how to get the most out of your new Cuisinart food processor. Get all of the information on the Cuisinart Elite Collection 14-Cup Food Processor. This detailed video tutorial will show you everything you need to know on how to use a Cuisinart Elite 14-Cup Food Processor.
There is nothing more irritating than a dripping tap; it wastes water, makes those nasty marks on your sink, and that constant drip dripping noise can drive you mad. Luckily it's an easy job to fix. If you have one of these modern, easy-to-turn-on taps, it's likely the ceramic-disc inside will need replacing. Watch this video tutorial to learn how to repair a ceramic disc tap yourself.
A sink full of slow draining water, or even worse, no drainage at all, is a sure sign of blocked pipes. Blockages are due to all those scraps of food and crumbs that get down the plug hole everyday. Yuck. Watch this video tutorial to learn how to unblock a sink. You will need a good sink plunger, an adjustable wrench, a bucket, a strong wire, gloves and some disinfectant to finish up. Unblock a sink.
Watch this video from This Old House to learn how to install a radiator thermostat. Steps:
Tim Carter demonstrates why simple pipe scaffolding is an excellent tool to use for outdoor painting projects.
Here is an educational video for ART (Advanced Robotic Technology) Plasma customers. The HDP Plasma SX Profile Cutter is designed for heavy duty manufacturing environments where power, precision, speed, quality low cost, productivity, and durability are demanded by business owners. See in these sixteen videos how it works, from the inside out, and another video on what it actually is.
In this tutorial, we learn how to grow healthy and productive fruit trees. Pest management is an issue with growing plats, so use something that can grow in a small area. Only use disease resistant varieties of trees, so you won't lose any while they are growing. You can grow some trees in a small area so they maintain in their space and they are very active. Make sure you prune the trees once they reach a certain heights and you remove any pests that are around. Use these tips to grow health...
In this tutorial, we learn how to resize photos in Photoshop CS4. First, open up Photoshop and then open up your picture. The quality of your picture will effect the outcome of what it looks like when you resize, so use a high resolution picture for the best outcome. Now, go to image and then image size. From here you will change the width and height to what you need it to be. Then, you will need to click on the boxes at the bottom, click on all of them. When finished, you will save this and ...
In this tutorial, we learn how to create amazing 3D text in GIMP. First, start a new image with the width and height that you want. From here, select the text editor and then type in your text. After this, change the font to what you want and then change the size and color as well. From here, you will duplicate the layer and then go to layer, and then filter. Select the map button and then map the object. Select the text and then show the preview to make sure it's what you want. Change the or...
In this tutorial, we learn how to create text in GIMP. To start, create a new image with the width and height at 600 each. Then, click the text box button and choose a font, font size, and other options open on the window. After this, create the box and for the text and type what you would like into the boxes. Set in the distance you would like on the inner shadow and then choose if you want the edges to blend. Make these fade out and then choose to repeat the inner shadow. When finished, sav...
In this video, we learn how to focus on milonga basic rhythm & phrasing in tango. Use your pattern to focus on the strong beats and dance to the rhythm. Find the one in your dance and have a sense of home base. Be grounded and use height change while you are dancing. Pay attention to the music as you are dancing and stay close to your partner as you are dancing. Keep close contact with them and make sure your body position stays upright, not straying from their side. Have fun while dancing! P...
In this video, we learn how to apply normal maps in 3D Studio Max. First, go to the cylinder button and name it. Then, change the radius and height how you would like them. After this, select "extended primitives" from the drop down menu on the top. From here, enter in the diameter and sides for the round hose and then select the diameter of the cylinder. This will create a cylinder but with the look of a hose instead. Use the bottom toolbar to edit the sizes of the map and then save this whe...
In this tutorial, we learn how to do a side by side video effect in Sony Vegas. First, open up Sony Vegas and open up a couple of clips to your time line. After this, make the two clips the same length by pressing down on the control key and moving them with the mouse. From here, return the videos to the start and then right click the track motion button. Reduce the width and the height to half of what they were before. Then, move the X position of one to -180 and the other to 180. Now both w...
This video tutorial is in the Computers & Programming category which will show you how to build a simple house in SketchUp. Start with the floor plan, draw a rectangular main living space and attach a small extra room. Next you use the push pull tool and pull the house up to as high as you want. You can make it 21 feet. Now draw the roof line in the center of the house along the length and draw the lines for sloping part of the roof on either side. Now grab the center of the roof and lift it ...
In this tutorial, we learn how to install a new mailbox post and box with Lowe's. First, you will need to gather all your tools and a new mailbox. After this, print out directions for the project through the Lowe's website. Now, call 811 to call your utility company to make sure you aren't digging through an electrical line. Mail boxes have a specific height they need to be installed at, so make sure you follow these guidelines. After this, dig out the hold from the ground, then fill in grave...
In this tutorial, we learn how to find the volume of a pyramid. The equation to figure out how to find the volume of a pyramid is 1/3ab x h. When you begin, find the height, length, and square feet of the pyramid, then fill these into the appropriate spots in the equation. Once you find this, you will be able to find the correct number of the volume of the pyramid. After this, make sure you have the correct labels on the answer that you get from the equation you filled out. When finished, you...
In this tutorial, we learn how to fit a road bike. This can be complicated, but it's vital for your cycling experience. First, you want to make sure you are comfortable no matter what. Pedal on the bike in the store to make sure you are comfortable on it. Now, you need to adjust the saddle height by seeing how far your leg goes down and how bent your knees are when the petal is at the bottom of the turn. After this, move the seat forward, back, or up and down. This will maximize your comfort ...
In this tutorial, we learn how to release point in basketball with Tom. If you hesitate or hang, you will lose power in your legs and your ball will go short and flat. When you reach the top of your jump you will want to release your ball to get the most height out of it. When shooting the jump shot, pay attention to what it feels like when you are going to shoot. You want to feel powered up not effortless or underpowered when you are shooting. Time your release and make sure you have a high ...
In this tutorial, we learn how to find the area of a triangle given three points. First, you will need to plot the points on a graph. After this, find the base and the height using the graph. Next substitute into area of a triangle formula and then evaluate. When you finally find the area of the triangle, then you will write down the answer ending it with the units. This is a simple way to find the area of the triangle, you just have to make sure you count correctly and have calculated the ar...
If you are facing any problem to compress videos in Sony Vegas like not in very good quality or big in size etc. then you have to take these steps to get rid of it.
In this tutorial, we learn how to Phantom flip in Halo 3. First you will start up Sierra 117 with two people. Once you reach the point where you are in a tunnel, go through until you go past the fifth row and start to shoot what you see. Now, have someone jump in the phantom while the other grabs the turret. After you do this, you will grab the phantom and be launched into the air. When you do this, you will be able to do a phantom flip and reach new heights! This is easy to do and can take a...
In this tutorial, we learn how to make crystal text in Sony Vegas. First, drag in your clip in the software, then right click on the track area and insert a new video track. Now, go to "custom", then "sony height map". On amplitude, change this to .76. On the first level, change the mode to multiply. Now, drag your text into the second video track and replace the text with what you want to write. After this, change the color and make sure it fits into the screen. You can also make it scroll a...
In this video tutorial, viewers learn how to find the area of a rectangle. The formula for finding the area of a rectangle is: A= b x h. The base is the horizontal bottom lie of the rectangle and the height is the vertical straight line of the rectangle. Whenever working with area, users must square the unit of measurement. To find the area of a square, multiple the side of the square twice (square it). This video will benefit those student viewers who are struggling with math, and are in nee...
In this video tutorial, viewers learn how to photograph with a tilt shift lens. Shooting in a position of height will exaggerate the field, Make sure to lock down the exposure of the camera before tilting. A tilt shift lens allows users to choose where the focal point lies and are able to blur out the image. To maximize the depth of a field, users need to simply turn the lens to change the focal point. This video will benefit those viewers who are interested in photography and have a tilt shi...
In this tutorial, we learn how to build a backyard patio. First, determine the location keeping in mind other buildings and landscape features. There should be a retaining wall around the patio so measure out all the different dimensions. Position a cap block at the highest center location. Then, use a level to transfer the patio height over the proposed location. You will then have to figure out how many blocks you need. When you calculate your digging depth, take into account your foundatio...
The bunnyhop is to BMX biking as the ollie is to skateboarding. It is the most basic means of getting off the ground, and the basis of big airs and most tricks. This video will teach you how to perform one yourself and get your BMX skills off the ground. It may take a while for you to be doing it as high as the narrator in the video, and you will have to develop some serious leg strength to ever equal his height.
