Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 69th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Excel's Auto Fill tool.
In this Home & Garden video tutorial you will learn how to fix a small hole in your drywall. This video is from www.fixitfromhome.com. The cheapest way to fill a hole is to get some dry wall compound, a plastic knife, sponge and a small brush. Take a little bit of the compound on the knife and fill the hole. Press it slightly so that no gaps are left inside the hole. If the rest of the wall has a texture, to match it with the texture, clip the end of the brush, make it damp and just brush the...
How to make deviled eggs while avoiding common mistakes
We’ve all had the problem of a toilet that just won’t stop running. You can fix this problem yourself with a few tools from the local hardware store. The part that is causing the excess running is an old fill tube and stopper valve. You will want to shut the water off to your toilet and then flush the toiled to drain out the water. You will have to unscrew the supply line so that you can replace the fill valve. The process only takes a few minutes and it will save you money from wasted water ...
This video illustrates us how to repair spalled concrete. Here are the following steps:Step 1: First of all take cement and sand'Step 2: Mix it in the ratio 1:3 that is cement one part and sand three partsStep 3: Now add water and mix the mixture well.Step 4 : Now apply this mixture for filling the spalled concrete.Step 5: Polyurea can also be used to fill the crackStep 6: Let the repair work done dry.Step 7: After around 28 days apply a water proof primer on the repaired work to prevent furt...
Long Island Ice Tea is one of the most famous cocktails known around the world. To make one, first fill a glass with ice. Then pour about 20 milligrams of gin, 20 milligrams of white rum, 20 milligrams of tequila, 20 milligrams of vodka, and 20 milligrams of your favorite clear liquor. Add the juice of half a lemon (about 20 milligrams of lemon juice). Using a cocktail shaker, shake the cocktail about 3 or 4 times. Put a strainer over a glass filled with ice, and pour the cocktail in up to ab...
This video tutorial by Tasktutorial shows you how to create a simple swatch in illustrator. Select the star tool, draw a star and select the path and scale it down as shown. Change the fill color to white, the stroke color to black and the stroke weight to 2 points as indicated. Select the rectangle tool and draw a background for the star, bring to back, change the fill color to blue and de-select the stroke as directed. Align the shapes using the align tool and select both paths and bring in...
The type or text you usually include in your artwork in Photoshop does not need to be in solid color. In this video you will learn to fill type with a photo in Photoshop CS2. Spice up your next artwork with this cool trick!
In order to create 3D lettered signs in lights, you will need to first create an object. Open Illustrator. Type your letters on the page. Adjust the font to the style you would like. Click on "effect". Then, click on "3D". This will allow you to rotate the image for the angle that you will want to see it at.
Webcartoonist shows us how to draw cartoon pirates. Begin with crown of the hat (based on Long John Silver from "Treasure Island"). Start with half-moon shape. The pirate carried a parrot on his shoulder. Begin the parrot's comb, eyes, & head about level with the brim of the pirate's hat. Directly under brim of hat, near center, draw pirate's eyes & nose. Beginning from side opposite the parrot, fill in pirate's facial features. Draw pirate's coat. Add pirate's sleeve, with cuffs & ornamentat...
Use the AutoFill feature in Safari to quickly fill in web forms for sites that you visit again and again and save time when logging in. Form entry data is stored in your address book contacts, and from information you have filled out in web forms before. You can see the passwords used by AutoFill in the OS X keychain, and you can also specify and limit general access to those passwords.
You've got yourself a new Samsung Galaxy Tab and you want to start filling up your contact book, but you don't know how— This video will breakdown the easy steps to adding those new contacts in the Android OS. Simply hit APPLICATIONS, then CONTACTS and select the ADD NEW CONTACT icon (looks like a +) in the bottom left. Fill in all the relevant information and click DONE to save the contact.
As any habitual baker knows, the cake making process doesn't end when you pull out the piping hot masterpiece from the oven. From there, you have to level out the cake - shaving off any areas that are jutting out or not fitting the shape you desire - and also add layers of icing filling.
In this video we learn how to deal with cravings on a raw food diet. If you are having strong cravings, you can sometimes give into it or stand up to it. To help you avoid this, try to fill the void with something else. Try to relax, hang out with a loved one, or watch a movie. This will help you feel happy and fill the void. Usually you are just craving the emotion that food is giving you, not the actual food. So, figure out what the emotion that you need is and start to fill that into your ...
If you have children who are still your dependents and have been living in your household for at least half of the year, and have their own social security number, you can actually get a major tax credit with a simple worksheet. In this video you will learn the requirements for the tax credit and also how to fill out the worksheet and calculate your credit.
One of the new features of Adobe Photoshop CS5 is the content-aware fill feature. For instance, if your photograph was taken at an angle, but you want to level it out without losing any of the image, this tutorial will demonstrate how you can achieve this effect.
In this video, we learn how to draw a funny cartoon bird in CorelDraw X4. Start out by opening up CorelDraw and using the pen to sketch out the shape of the bird. There is no set way to draw this, just be creative with the drawing. Add in the hair, eyes, beak, and body to the bird. Give it crazy eyes that are different sizes and wacky colors. Fill in the bird with different colors, also filling in the colors of the eyes and adding in details to the beak. Continue on to fill in details and col...
In this video, the editors at Good Housekeeping Magazine teach us how to decorate for the holidays quickly and easily. The first decoration you can do is to make a Minora. To do this, you will first take a glass candle holder and fill it up with green rocks until it's 1/3 of the way full. After this, place a tapered candle in it and keep filling with rocks until the candle stands straight. You can also purchase clear bulbs and fill them with a sprig of greenery and red beads. After this, clos...
In this tutorial, we learn how to draw abstract watermelons. First, draw a circle, followed by wavy lines coming out of it just like the sun. Next, draw half watermelon shapes all over the picture you just draw. Now, fill in the picture with yellow circles on the inside of the circle shape. Use a dark yellow/orange for the second half of the circle to the bottom. After this, use the orange to fill in half the wavy lines and then use red to fill in the other half and make large half watermelon...
In this video tutorial, viewers learn how to draw a vampire. Begin by using the paint bucket tool to fill the entire background in black. Then start drawing the vampire in transparent blue. Sketch the outlines of the face and draw curves for the guidelines of eyes, nose and mouth. Now erase half of the face and fill it in black. The other half of the face is filled with tints of blue and purple airbrush. Finish by adding the details with opaque shades of blue, purple and white pencil lines. T...
In this tutorial, we learn how to fill out a Canadian permanent resident application. Before you start, make sure you have all your personal information with you. After this, begin the application by filling out all the different sections. You must answer every question on this application or it will be deemed incomplete. You will be asked your address information, employment information, family information, and many other things. When you finish you application, you may be asked to provide a...
In this clip, learn how to fill your own piping bags and ice cupcakes freehand that are so beautiful that everyone will assume you bought them at a bakery. Follow along with this step by step and get started icing like a pro.
If you're finding out that your dishwasher is not filling correctly, there may be a slight problem. Before you look up or call a professional, try out these helpful troubleshooting tips. They may help you save money and it could be an easy fix. Enjoy!
If you have a front load washer that won't stop filling, then you have a problem on your hands. Not only can it make the floor slippery, but it can also cause damage to your home as well.
A common problem that some homeowners face is a washer that won't stop filling with water. This can be a big problem and lead to water damage for floors and can cause people to slip.
Learn how to sculpt a miniature jelly-filled charm out of polymer clay with this free video art lesson. While this tutorial is best suited for those with some familiarity of polymer clay sculpture, novice sculpters should be able to follow along given a little effort. For specifics, including step-by-step instructions, and to get started crafting your own mini polymer clay donut charms, watch this sculpture tutorial.
There's nothing like a delicious bowl of fruit to fill your body with energy and nurtrition. Now learn how to fill your walls full of energy and nutrition with help from this Hawks Vs. Pigeon Production. In this free drawing tutorial, learn how to draw a bowl of fruit.
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 how to easily fill in your eyebrows. Start with naked eyes and ungroomed eyebrows. First groom your brows with a clean mascara wand to give yourself an idea of how you want your brows to look. Next, using a brush with eyeshadow of your choice start to fill in the bottom of your brows. Follow the direction of your brow at the bottom. Move the brush back and forth, then upwards towards the middle. You'll see a slight powdery line. Next, repeat the same process at the top of you...
Robert demonstrates how to quickly insert formulas into Excel. To create a sum, highlight your selected cells and press the sum key. Expand the formula by clicking on the fill handle. Double click on the fill handle to expand the formula. To sum vertical columns, highlight all the cells and click the sum button. Press and hold down the control key for another shortcut to work in accordance with the auto sum button. You can also select the average for the area. You can also select the area and...
This video is about how to paint your nails with a colorful checker art design. The first thing that you will have to do is to apply the hydrating base coat on your nail. After putting the hydrating base coat on your nail, get a piece of paper for you to place the black nail polish. After placing the black nail polish on the paper, use the dotting tool and place a series of zigzags on the nail. The next step is to fill in the zigzags depending on the color you want. After filling in, make a s...
In this video, Alice demonstrates how to make a crest necklace using simple things. For making this necklace she collects some materials such as oblong shaped rock or polymer clay, some paints, a computer print of a cullen crest and so on. She uses the ordinary black paint to paint the rock completely. Next, she collect a computer print of a layout for the culler crest and carefully cutout the shape and using craft glue she stick it on the painted rock to see it fit. she takes some white pain...
In this how-to video, you will learn how to make and decorate cookie pops and bright bouquet cookies. First, you must have your cookie already baked and ready for decoration. Take a star tip and decorate the cookie in a zig zag formation with the icing. Go around the edge until it is entirely complete. You can do a straight star if you want instead. Once that is done, fill in the inside for the center with another color. Fill in the empty area with the icing used for the edges in spots. Conti...
This video goes back to basics, using regular pencil, pen and colored pencils to create a manga female figure. He begins by drawing basic lines and shapes of the torso with pencil, then adding legs, arms and marking the joints. He adds detail to the body and fills in the shapes of the muscles. He then adds the head shape and fills in the facial details and hair before adding detail to the hands and fingers. He continues with the clothing, before going over all the lines with a black ink pen. ...
Most older toilets have older-style fish and ballcock for toilets. But they are prone to fault, like running and constant water. Replacing them with a newer-style fill valve will save water and frustration now and later on. Watch this plumbing video tutorial to learn how to replace a toilet ballcock with a fill valve. It's a little more efficient and it's pretty straightforward, so see how to replace your valve!
Here's the secret to making a perfect pie crust for your holiday desserts. You can fill this crust with all sorts of fruits, nuts and filling. This recipes requires a pastry blender and uses shortening. Water varied based on the humidity of the kitchen.
Make your balloon "un-popable"!!! The trick is to fill the balloon with water so that it will absorb the heat and keep the rubber balloon surface cool. The flame will pop any balloon that is just filled with air. Cool science experiment trick to show off.
LastPass is a free password manager and form filler that makes your web browsing easier and more secure. This video tutorial presents a simple demonstration of new Form Fill feature from LastPass. Take a look.
Try this southern favorite from Paula Deen. Follow along as she makes easy fried apple pies. This cooking how-to video is part of Paula's Home Cooking show hosted by Jamie Deen, Paula Deen. Paula Deen, owner of Lady and Sons, a famous Savannah restaurant, is Food Network's resident southern chef. Step inside her kitchen and discover delicious food that's both uncomplicated and comforting. Try her recipe for fried apple pies.
With Keynote in Mac OS X, you can fill a shape with any picture from your iPhoto library. You can even add animation, or styles, to that shape and feel free to swap out the picture at any time. In this video Keynote tutorial, you'll learn how.