New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 26th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE.
This video tells us the method to partition the external hard drive for Time Machine. This process consists of a couple of steps. In the first step, go to 'Finder'. The second step involves clicking on the 'Applications' option on it. After choosing the 'Applications' and go to the next step involving going to 'Utilities'. Choose 'Disk Utility' from the options displayed. This step will open a new window. Choose the hard drive on the window opened after choosing 'Disk Utility'. Click on the '...
In this Software video tutorial you will learn how to make a winking animated GIF in Adobe Photoshop. Select a photograph of two eyes and duplicate the layer. Now copy the top eyelashes and paste them on top of the bottom eyelashes. Go to the eye drop tool and select a dark color. Then go to paint brush, choose a brush with size 1 and select darken in the ‘mode’ dropdown menu. Reduce opacity to 50%. Now darken the lower eyelashes as shown in the video. Then go to healing brush tool and se...
In order to get a ripped lower and upper chest, without going to a gym, you will need something to prop your knees up. You can use your bed or a chair. To recreate your incline and decline chest press exercises, a modified pushup substitutes for it. Watch your posture and your spine alignment, when you are doing them.
This video illustrate us how to draw Disney's Mushu from Mulan. Here are the following steps: Step 1:first of all draw a oval representing the face and then from the face raw double "S" to form the body.
In this video, we learn how to put eyeshadow onto a picture using PhotoShop. First, open up the program and open your picture. Click on layer then new the click layer again.On the new layer put as blend mode "multiply". Make the opacity 50% and choose a color. Then select the brush that is the right size for your picture. Next, you will be able to brush the mouse over the eyelid and put eyeshadow onto the lid of the eye. You can change the intensity of the eyeshadow by changing the opacity hi...
PeteMcCormack2 teaches viewers how they can live off the grid! First, you will need shelter, heat and water! And possibly some electricity. You need head so you can use a high efficiency wood stove. You always need to have water so you can use a well or a water pump. Also, for a pump you will need power, you can use solar power for this! You can also use a pressure tank. This way of life does not necessarily cost much and with self installation it will lower the cost also. All you have to do ...
Drawingnow.com shows us how to draw and colour a jellyfish. First make an outline of the body of the jellyfish by drawing a dome with verticl sections like a parachute or an umbrella. Join the sections at the bottom of the dome like a skirt. Colour the background blue in three sections from top to bottom. Darker blue is used for the top-most section, a medium blue used for the middle section and a lighter blue for the lower section. Next colour the umbrella mass of the jellyfish in a blue ton...
This video illustrates how to draw a cartoon boys face in Adobe Photoshop.Here are the following steps:
In this how-to video, you will learn how to create a drawing of a palm tree setting. First, you will need two pieces of paper, charcoal, and cotton. Use the one piece of paper to add charcoal to your cotton. Next, cover the piece of paper you are using for the drawing with a wash of charcoal. Next, use an eraser to create images of clouds. Next, draw the palm tree with the charcoal on the lower half of the paper. Add as many palm trees as you feel necessary. Finish the drawing by doing the fi...
The Voda Phone Help Center's video provides you how to hints and tips to get your email onto your Blackberry Storm. This video will help you send and receive emails. To receive emails, click the main message button, which looks like an envelope, you will then see you inbox where all your messages are stored. Next if you wish to send a message, click the compose button in the lower left hand corner and select which type of message you want to send. Enter in the email address in the top box, wh...
In this video tutorial, viewers learn how to make floating text on water. Begin by importing the water image into the program. Begin by selecting the polygonal lasso tool in the toolbox and select the top of the water. Once you have made the selection, right-click on it and select Layer via Copy. Then select the text tool and type in your text. Create a contour to make the 3D and give the text a light color. Then place Layer 1 over the ext layer and use the selection tool to place it behind t...
This video illustrate us how to draw a face. Here is the procedure for the following: Step 1: First of all take a sheet of paper and start by drawing a oval representing the outline of the face.
In this tutorial, we learn how to find the best wedding dress for your body type. The rectangle or oval shape body doesn't have a well defined waist line, so you will need a dress that draws attention to the hair and face. A pear shaped body is where the bust and wast are smaller than the lower half of the body. You will want to select a wedding dress with ruffles or shoulder pads to draw attention to the top half of your body. A triangle shaped body has a large bust. You will want to select ...
This video illustrates how to draw Bowser from Bowser's inside story. Here are the following steps: Step 1: First of all take a sheet of paper and pencil and start drawing the character.
Kengi shows us how to make kielbasa and cabbage, in this video.Take two kielbasa susages and cut into small pieces.Take a cabbage,cut it into halves and then slice both the halves into strips.Heat a skillet and add some oil to it.Put in the sausage pieces and some sliced onions.Cook until the sausages attain a brown colour. Once the sausages are browned add the cabbages to it.Spread the cabbage slices on top of the sausage.Cover the skillet with a heavy lid, lower the heat and let it cook.Onc...
Try to use the same brand of spray paint throughout the project, read the instructions, follow them. Different brands may have different instructions, this is why we advise against mixing brands. Begin by lightly sanding your project with 600 grit sand paper, anything lower can potentially scratch your project. Use a sturdy tape to cover the parts you want to leave unpainted. Use a very light coating of primer, sand it with 600 grit sand paper (lightly). To add 'special effects' to the job, u...
Suzanne Tracht makes a lovely lemongrass consomme for matzo ball soup. She starts with 2 whole chickens and throws them into a pot full of water with celery and some lemon grass. The lemon grass is prepared by crushing it with the back of a knife. She next adds a lime leaf, ginger, and a coarsely chopped onion. Finally, she adds garlic, red chilies, and white parts of leeks. She puts the pot onto the stove and brings it to a simmer. She is careful to lower the heat so it maintains a simmer an...
In this video tutorial, viewers learn how to make organic ghee. Users will need 4 sticks of unsalted organic butter, saucepan and a strainer. Begin by adding the 4 sticks of butter into the saucepan and heat it over an oven. Once the butter has melted down, lower the heat. When the sizzling of the butter stops, the ghee will be finished. Once the butter has stopped sizzling, pour it through a strainer to catch any excess butter. This video will benefit those viewers who enjoy cooking and woul...
This video illustrate us how to apply competitive cheer leading tournament makeup. here are the following steps:
Tut Teacher shows that if you're going to edit alot of pictures, learning to change your eye color in Photoshop is helpful.Go to Photoshop and open "human eye", zoom in and it gives more room to work with. First, go to your lasso tool, hold down and click. You can click and drag or click along the outside edge. Set to 6 pixels, more or less depending on the image. Make sure you don't click on scanner..it'll make the image go crazy. Keep clicking along the edge there'll be a symbol on the circ...
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 204th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and EXACT functions in an array formula to add the sales for a sales representative where lower and upper letters matter (i.e., are case sensitive) in the criteria (conditions).
In this video we are shown how easy it is to complete the finishing join on a quilt binding. Just before the final join 6 inches of binding should be left over at the beginning and the end, while the rest of the binging should already be sewn down. The two ends of the binding should overlap by at least 6 inches. You will then need to cut the thread and remove the quilt from the machine, then measure the binding width and overlap the two pieces and cut off the excess binding to match the width...
This video illustrate us how to draw professor E. Gadd in Mario paint. Here are the following steps:Step 1: Draw a circle and within the circle draw another circle at the center.Step 2: Now from the periphery draw another circle so that half of the circle is in the circle and the other half on the outer part of the circle .Step 3: Now draw another circle another circle in similar manner on the opposite side.Step 4: Now draw three circles within the two circles drawn so that they form a hazel,...
This video illustrate us how to create a Megan fox inspired hair style. Here are the following steps:Step 1: First of all shampoo and condition your hair.Step 2: Now take the hot iron curler and curlers .Step 3: Now part your hairs and take your lower partition and curl it on the curler.step 4: Similarly part down the other hair and roll it on the curler.Step 5: open all the partition and curl it on the roller. Leave it on for at least twenty minutesStep 6: Now open the curlers and comb it li...
JdudeTutorials explains how you can remove zits, blemishes, and other unsightly skin problems, from pictures using Adobe Photoshop. He begins by opening up a picture of a female's lower face. Left click on the stamp on your toolbar, and select the Clone Stamp tool. You will see a small circular cursor. He explains that you should find a skin tone on the picture that matches the skin surrounding the troubled area. He holds the alt key on his keyboard and left clicks the spot that most resemble...
This video is a demonstration of how to fold a stylish hijab the way it's done in Egypt. Start with the undercap, and use a pashmina for the hijab and a few straight pins to help hold it in place. Take one end of the hijab and fold it over to make a triangle, making the tail longer or short as you like. Lay it over your head so the open point of the triangle is at your forehead. Pin it to the underpiece at the sides. Let the short side hang down. Wrap the long end around under your chin and u...
This video is a tutorial on sewing both polybraid elastic and lastin elastic. Polybraid is a very sturdy fabric elastic, while lastin is a thin, clear, very stretchy elastic, good for use in diapers. It is important to buy name brand lastin elastic to ensure good quality.
This video gives tips on how to count calories in order to take responsibility for the food that you eat and your weight. Pick a daily calorie count for each day. Set a goal. That goal can be anywhere. You can set it at 1200 or 1800. It doesn’t matter. Weigh yourself regularly.
This video tutorial in Autos, Motorcycles & Planes category will show you how to wash your car's engine bay. Open the hood and check the temperature by touching with your hand and a thermometer. If it is cool enough you can proceed. Look over the engine bay to see if there is any area that needs more attention. Then spray the cleaning solution and use brushes for cleaning the areas that you can reach. Softer brush for areas that are painted and hard one for powder coated surfaces. Then use wa...
In this video tutorial, viewers learn how to lower the impact of their back rolls when wave-boarding. This video provides 4 steps that will help the user have a lighter impact when they fall off a back roll. The steps are: air back roll, inside out back roll, one wake back roll and wake to wake back roll. When first attempting each of these back rolls, the objective is to rotate as much as you can and not to land it. Once you have more experience, practice landing each one. This video will be...
Brightstorm explains how to use definite integrals to find area. There are two basic area problems: one in which the area lies between the function and the x-axis, and one where the area lies between the two functions. In the first case, if the curve lies above the x-axis for x=a to x=b, the definite integral returns the area. If it lies below the x-axis for x=a to x=b, then the definite integral returns a negative area. In the second case, we assume that f(x) is the higher curve and g(x) is ...
In this video tutorial, viewers learn how to make an animated GIF file using Adobe Photoshop. Begin by opening the program. Then click on File and select New. Choose the size of your image and click OK. Now create your picture or text image. Once finished creating your image, click on Window and select Animation. Now click on the button on the right side of lower window and select Make Frames from Layers. change the time of each frame to 0.5 sec. Now edit it and save it. This video will benef...
In this video tutorial, viewers learn how to get bigger and ripped arms with kettle-bells. This video provides three different exercises involving the kettle-bell. The exercises are: gunslinger, triceps extension and push-ups. For the gunslinger, stand up with knees bent and feet slightly wider than the hips. Now shrug your shoulder as you raise the bell. Then point it out and return to the starting position. For the triceps extension, go on your knees and raise the bell straight up. Then low...
TouchSmart demonstrates how to edit or delete tiles on your HP TouchSmart homepage. Editing and deleting tiles is a useful way to keep your homepage up to date. To edit a tile, first tap the personalize button at the bottom of the screen. Then, tap the pencil icon next to the shortcut that you would like to change. Edit the information for the tile as desired. Tap the okay button when you are finished editing your tiles. To delete files, tape the pencil icon next to the tile that you would li...
In this video tutorial, viewers learn how to do the Shawn Michaels and Ric Flair turnbuckle flip wrestling move. Begin by running towards the turnbuckle and grab the middle rope with both of your hands. Make sure the your lower back makes contact with the top turnbuckle. Flips your legs over and make sure that you land on the left side. to practice for this move, do some handstands on the middle rope and slowly flipping yourself over to the left side. This video will benefit those viewers who...
In this Outdoor Recreation video tutorial you will learn how to put a fly fishing rod and reel together. Steve shows you how to do this. Every reel has a reel seat and most fly rods have a slot under the grip into which one end of the reel seat slides in. At the lower end of the rod, push the ring over the reel seat and tighten he screw on the rod. This should be nice and tight. Before your fishing, make sure it is tight. To put the rod together, take the next segment of the rod and push it i...
Mac users might be unwilling to ever trade in their beloved computers for a PC, but they might still want or even need to run certain Windows applications. Thanks to Boot Camp, you can install and run Windows on your Mac.
The artist begins by sketching house the outline of the face and body using a pencil. Then he begins to form the eyes, nose, hair and ears, and applies a gray mask to the face which is then covered by the tan coloring of the woman. The lower body is applied with a lighter mask which is converted to the white furry coating of the coat. The drawing is then smoothened out showing us the main features of the realistic woman. Using the software and computer graphics that he uses, the hair, eyes, a...
This informative video will teach you of the types of food you should include in your diet to fight against cancer. 1. In general whole grain and fiber intake help the body to fight breast cancer and other cancers. 2. Amongst the benefits of a diet rich in fiber and whole grain there is the fact that there are lower levels of insulin involved, they have anti inflammatory properties. This helps to fight cancer. 3. Oats, in particular, are a rich and unique source of anti oxidants for your body...
