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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply custom number formatting as well as how to conditionally format dates and weekends using a TRUE FALSE formula with the AND and WEEKDAY functions.
In this video tutorial, viewers learn how to make a homemade carrot face facial mask. The materials required are 2-3 large carrots and 4 1/2 tbsp of honey. Begin by peeling the carrots and cut them into round slices. Now boil the carrots until they are soft. Then mash the carrots and mix it with the honey. Apply the mask gently on the skin and relax for 10 minutes. Then rinse it off with cool water. This video will benefit those viewers who are beauty and skin, and would like to learn a home ...
In this video, we learn how to make a homemade facial mask for acne prone skin. First you will want to clean your face and make sure it's dry. You will need healing clay, water, a bowl and spoon. Now take 2-3 tbsp of healing clay and add desired about of water, mix together until you have a paste that's not too watery. Now you can apply your mask avoiding your eye and mouth area. After waiting for 10 minutes or until the mask is fully dry, you can wash the mask off with lukewarm water. Pat dr...
This video illustrate us how to make roast beef stew. Here are the following steps:Step 1: First of all take the beef and wash it properly.Step 2: Take onion, tomato, coriander and red chilies and cut them in small pieces.Step 3: Now take the beef pieces and apply curd, ginger paste, garlic paste and salt on these pieces and leave it to marinate.step 4: Now arrange these pieces on a microwave safe grill rod and arrange the cut onion tomato and coriander on the pieces.Step 4: Now set the micro...
Paint A House demonstrates how to roll paint the ceilings in your home. To roll paint your ceilings, first paint the edges of the ceiling where it meets the wall. Then, make sure you have enough paint on your roller. Raise the roller to the ceiling, making sure that you stand to the side and a little bit backed away from the paint roller. Move the roller across the ceiling in a sideways motion. Don't walk forward with the paint roller to apply paint to the rest of the ceiling. Instead, back u...
With rainfall comes unwanted plant growth in the form of weeds. Here's how to identify and control them. First is Nutsage which has a glossy green leaf, triangular stem and the rhizome sends up new plants whenever you cut away at it. Next is jungle rice which is an aquatic weed, from areas where there is a lot of moisture. It can be identified by it red/purple chevrons. Use herbicide to take them out before they get too large. Next is pigweeds, to get rid of it you can use weed killer or a ho...
Layers are very important component of Photoshop. Without knowing how to use the layers correctly, one can not utilize the maximum what Photoshop offers to designers and digital artists. For a beginner, this video provides a good basic knowledge about Photoshop layers. Layers enable you to arrange different parts of a picture and manipulate them without effecting the content of other layers. Layers are added by using layers panel. Each layer is named accordingly. We can change the order of la...
This video talks about protected mode for internet explorer 7 and Windows Vista. The person tells you that protected mode helps protect your computer from types of spyware. It is not the best solution and they tell you one should not rely on this alone. By default protected mode is on. You want to make sure it hasn't accidentally been disabled. To check your settings, double click on the area on the bottom of the screen that says protected mode. The security tab will pop open. Look to see if ...
This illustrate us how to make paper mache mirror. Here are the following steps.Step 1:Take a piece of cardboard and make two circle on it with two different circumference.Step 2: Now cut through the outer circle as well as the inner circle to obtain the rim.Step 3 : Now take a sheet of cardboard and cut it in shape of a flower.Step 4: In the center of the sheet place the rim.Step 5: Now along the petals of the flower stick a pile of rounded newspaper.Step 6 : On this newspaper and cardboard ...
In this video, the instructor shows us how to make a homemade honey and banana facial mask. First, you want to make sure your hair is all the way pulled back and out of your face. Also, make sure your face is clean. Peel your banana and chop it into pieces, place into a bowl. Mash up the banana and then add in a spoonful of honey to the mixture. Mix this into a paste. Next, apply to your face and leave it for 15 minutes to harden. After this rinse your face with warm water and then pat your f...
This video demonstrates how to do anti-differentiate functions with radicals in calculus. To simply problems, try to substitute. For example, in the problem, the integral of x times the square root of x plus 2 dx. You can substitute w for everything underneath the radical: i.e. x + 2. When you simplify, it becomes: the integral of x times the square root of w dw. Now, you need to get rid of the x, which you can do with a substitution: w – 2 = x. Now, plug in the values and simplify it.
Beau Nelson gives tips and a demonstration on eye brow make up. He says that brow trends change often, but right now the style is to have a more full looking brow. To accomplish this, he says that the first thing you need is a good brow brush. To the brush you apply a shadow color that is a shade or two lighter than your hair color. Start with just a little shadow on the brush, you can always add more. Brush upward for the inside half of the brow, and outward on the outside half of the brow. ...
This artist shows how to quick paint/draw Obi-Wan Kenobi utilizing his mouse and pc. He starts out with a rough sketch of his character, making a black outline of his figure. He then goes back over his initial sketch with blue lines, cleaning up the lines, making them smoother. Once the blue lines are completed, the first black line sketch is erased and the blue lines smoothed out even more! Piece by piece, color is applied to each part of the character. It is placed roughly at first but smoo...
In this tutorial, Car Care Products shows us how to clean and condition leather car interior. For this you will need leather shampoo, a soft bristle brush, a clean soft microfiber clothe and leather conditioner. First, take your leather shampoo and spray it onto your seat. Then, take your soft bristle brush and work the shampoo into your seat, make sure to get into crevices and on the side panel. Now, wipe the solution off with your clothe, making sure you don't leave wet spots. Finally, appl...
This video will show you how to enable JavaScript, accept cookies, and allow pop ups in Microsoft Explorer. The first thing you will need to do is to go to tools on the menu bar, then choose options, and choose the security tab of the new window that will pop up. To enable JavaScript click custom level, scroll all the way down until you see the scripting section, make sure that all three radio buttons are set to enabled, and finally click ok. To enable cookies, go to the privacy tab and make ...
Love4Nails starts off with pink, silver, and black nail polish. First choose one of your colors to create a French tip manicure. She next takes the silver polish, starts at the bottom and creates a swirl around the nail. Swerve the silver in a way that it covers the French tip part of the nail. Then get the pink glitter and apply only on pink polished area. Place black rhinestones on the swirled area of the nail. Because you're using the pink glitter polish, if you choose not to add rhineston...
In this video, the instructor shows us how to make a facial mask using coffee grounds and egg whites. First, take an empty bowl and place a 1/4 cup of coffee grounds into the bowl. After this, add an egg white to the bowl. Now, mix up the coffee grounds and egg white until they are well blended. Now, apply mixture gently to your entire face, avoiding the eye area. Once you have it placed on your face, let it set for about 10-20 minutes or until dry. Your face will start to feel tighter and yo...
In this video tutorial, viewers learn how to set up Virtual DJ with two separate sound cards. Users may choose to use a proper PCI or USB sound card. Begin by the USB card. The drivers will already be on your system. Now open the Virtual DJ program and open the Settings. In the Sound Setup tab, click on the Output drop-down menu and select HEADPHONES. Next, click on the Sound card drop-down menu and select 2 CARDS. Now click on Apply and OK. This video will benefit those viewers who enjoy mix...
This video is about Wet Felting Wool Over Soap .The materials required small sized soap bars, a towel, hot water and wool batting which is sheep's wool that has been washed and dyed. Now take a thin piece of the wool and lay it over the soap. Thin layers help the felting process and these layers are wrapped around the soap in vertical as well as horizontal direction. Now apply hot water to the bar and rub it over the wool. Keep doing this for a couple of minutes and then leave the bar to dry....
This video illustrate us how to prepare snares. Here are the following steps:Step 1:Take a wooden block and drill a hole in the corner of the block.Step 2: Now take a metallic wire and make a loop out of the metallic wire .Step 3: Now bind this loop with a binder and hook the loop to the wooden board.Step 4: Leave out some cable free and this loop gets tighter a the trapped animal tries to move. the more force applied the tighter the loops get.Step 5: Now place the snare along the fence or th...
This video, which was made at Peopleprint Community Media in Rochdale, teaches how to easily silk screen print a t-shirt in only four minutes! First, design the artwork to be used for the print, then print it on acetate. Next find a clean screen. Put some emulsion in a coating trough and slowly and steadily coat the screen in emulsion. Then dry the emulsion in a dark room and expose the screen to light. Next wash the screen with water and the artwork should become visible. Mask the exposed ar...
In this how-to video, you will learn how to make jewelry using cord in less than four minutes. Corrine Bradd shows you how to easily do this. First, take a satin braid and tie it in a knot. Trim the excess off with scissors and take a cord end. Place the knot inside the groove and then clamp the cord end with a pair of pliers. Turn it around and do it again for the other side. These cord ends come with a loop on top for further use. These look great on jewelry such as charms. You can use a sl...
This video demonstrates how to matte down your pointe shoes for a recital or performance. For this, you will need a makeup brush and a container of translucent loose face powder. You may cut the powder in half, adding baby powder to it. This will lighten the powder a bit.
This video shows viewers how to remove permanent marker from the top of a compact disc without damaging it. In order to do this, you will need some hand sanitizing gel and some facial tissues. Apply some gel onto the marks you want to remove by squeezing the gel out from the bottle. Rub the gel in a bit with your fingers. Take a facial tissue and wipe it gently around the CD, using it to remove the gel and the marker from the top of the CD. The marker will now be entirely removed from the top...
This video demonstrates how to wax your car or truck. Make sure that your vehicle is clean in advance. For this project, you will need the following: McGuire's Cleaner Wax, applicator pad, and towels.
Creativity Prompt demonstrates how to make a hybrid board book. First, select printed paper of your choosing. Cut off the excess paper with a cutting blade and crease the paper for the spine. Fold and burnish the paper. Apply a generous glue stick layer to a recycled board book and adhere the paper to it. Burnish the paper with a brayer to strengthen the adhesion. Let the glue dry and trim off the excess paper. Cut the rest of the paper for the board book pages. Cut out photos and titles for ...
Bob Harris of decorative concrete institute explains how you can remove your tiled or carpeted flooring for a concrete substitute. He suggests when your removing carpeting that it can be very heavy and advises you to hire someone who can lift and carry it out, or rent a dumpster for easy take away. He states that after the carpet is removed you'll need to remove the adhesive from the floor. You can do this by stripping or grinding, and at other times the use of harsh chemicals may be needed. ...
In this video Rich explains how to maintain a grout and tile floor. He uses a chemical cleaner which he describes as a "grout-smart type product." For regular maintenance of the floor Rich recommends using only 1oz of the product per gallon of warm water but for really badly stained floors using up to 12oz per gallon of warm water. Rich mixes the chemical into his water then applies the mixture to the tile using an ordinary deck scrubber, he then uses an angled scrubber which has bristles tha...
How to speed up your internet connection
Angela and Shane from I Am Fashion Weak demonstrates how to bleach and paint splatter your own jeans. All you need to bleach your jeans is bleach and a measuring cup. If you bleach black jeans, you can get tan and gray shades. A bathtub is a safe place to bleach your jeans. Crinkle the jeans and pour the bleach over the crinkled spots until it changes into the color you want. After you bleach the jeans, wash them and dry them. You can also use a sanding technique to give the jeans a distresse...
Lynn Snodgrass shows how to make chimes by using small clay pots and popsicle sticks. You can tie them together by using plastic string or regular garden string. The pots can be decorated with paint or you can apply stickers to the pots. 1. Use the sticks tied with the string as the base that holds the pots together. 2. Thread the string through the opening in the clay pots. The pots will have already been decorated with the stickers and the paint and will already be dry. The next step is to ...
To throw a clay pottery fruit bowl, place a lump of clay on the potter's wheel and wet it with water. Use the foot pedals to spin the wheel while shaping the clay with your hands. Draw the clay up and then use your thumbs to create an indentation in the center of the clay. Apply slight pressure and the clay should assume a bowl form. Use water as necessary to create the right clay consistency. Draw the clay up to make the bowl walls thin. While shaping the bowl walls with one hand, create a r...
This video shows the viewer how to calculate friction in a body that it is not accelerating. The simple answer is that the force of friction will be equal to the force needed to maintain the constant speed. This means that is you pull a wooden block along a carpet at a constant speed and a Newton meter between you and the block measures 5 Newton’s then the force of friction between the carpet and the block is exactly 5 Newton’s. If the object is accelerating then this rule does not apply.For ...
In this video, we learn how to make a facial mask for oily/dry skin with natural ingredients. First, take a bowl and place a half of a banana in it, smash the banana in the bowl until it makes a paste. Now, take a 1/2 of a lemon and squeeze the juice into the bowl. After you mix this together, add 1 tbsp of honey into the bowl. Mix this all together very well until it makes a paste. After this, apply the paste to clean skin. After about 10 minutes, rinse this off and pat your skin dry.
In this video, we learn how to speed up a computer and change desktop settings. First, right click anywhere on your desktop. Then, select "properties". Once you are in "properties" there are several tabs you can click on, click on "desktop" on the top. Once you click on this you can change your background, icons, home page, internet options, colors and more. By selecting "screen saver" you can choose "Windows XP" to make your computer perform quickest, also make sure your monitor has proper p...
In this Hobbies & Toys video tutorial you are going to learn how to make deadly homemade bolts. Take a pencil and remove the ferrule from the end of the pencil. Make sure to pull it off completely so that you expose the flat end. Then take three pieces of electrical tape and tape them on the pencil and on to each other so that they form three wings. Now take a tack pin and with the help of nose pliers and pliers break off the rear end. Apply some hot glue to the ferrule end of the pencil and ...
In this video, we learn how to remove acrylic nails easily! First, you can cut down the acrylic nails using fingernail clippers if you want to keep your natural nails the same length. Next, take a drill or buffer to remove the shine from the acrylic. After this, put acetone on a cotton pad and place on nail, then wrap the nail in foil. Repeat this for all nails then leave on for one hour. Next, you should be able to easily remove the acrylic. Make sure you buff off any excess material then ap...
This video explains how to paint nails with a cobalt blue and flower dot design. The first step taken before applying the paint is to do a white wash manicure. The instructor begins by covering her makeup sponge in a dark blue color and then makes many small dots along the whitened part of the nail. The instructor then makes many more small blue dots along all of the boarders of her nails. After the blue dots have dried a white coloring is used to make flower pedal like designs within the blu...
This video shows you how to clean a CD or DVD easily.First of all, you need toothpaste. Apply a thin layer of paste to the whole surface of the disk and spread it evenly. Let it dry for about 5 minutes. After the 5 minutes have past, clean the whole disk at a sink, and make sure you get all the paste off. Wipe off the disk with a towel, but be careful not to make any scratches while doing so. You could try wiping from the middle of the disk to the exterior. The disk must be dry before using i...
This is a software demo. This Mac software allows you to play a song or music or audio track and reduce its speed without affecting the pitch. Select a guitar riff or chord sequence, loop it, and speed up or slow down that loop so it runs faster or slower, without changing the pitch. The program has some sound editing functionality, like EQ, but is mainly a tool for changing a recording's speed. Import a track from iTunes, or directly from a CD, adjust the speed, apply the optional equalizer ...
