Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 57th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to avoid a #NUM! error when changing the formula input numbers for the NPER function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 55th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 remove duplicates tool and the COUNTIF function to count unique records that are greater than $30. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 32nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the MATCH & ROW functions to create a logical test to find the first occurrence of items in a list with duplicates.. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
When being fitted for clothing, it is important to get a true measurement of your waist. On a woman, this can be confusing, as our waists are actually inches higher than where we typically wear our trousers.
You will need to measure your arms if you are being fitted for a suit or dress shirt. In this tutorial, learn how to take a fast and accurate measurement of your arm using measuring tape.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 112th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to solve a common VLOOKUP problem — how to look up approximate values. If the lookup table for the VLOOKUP function is looking up approximate values, the first column of the table must be sorted in ascending order. Learn to love digital spreadsheets more p...
If your wireless card is lost or damaged, you will need to replace it. In this tutorial, learn how to replace a missing or broken wireless card in a Windows based laptop.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 28th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the INDEX, RANDBETWEEN, COUNTA, IF, AND, & VLOOKUP functions together to select a random employee from a list, determine if they have meet the given criteria and then conditionally format the relevant cells according to the result. Learn to love digi...
In this video tutorial, viewers learn how to draw Homer Simpson from the animated shot, The Simpson's. Begin by making a light outline of where the top of the head, sides of the head, ear and neck will be. Then do a light sketch of where the mouth, nose and eyes will go. Make the eyes large and make one eye overlap the other. Also make the nose into a sausage shape and mouth into a lemon shape. The eyes should be overlapped by the nose. Make the top of the ear line up with the bottom of the m...
In this video tutorial, viewers learn how to make a 3D flower pop up card. The materials required for this are 5 pieces of paper, scissors and glue. Begin by folding the paper in half 3 times and then fold down the sides to a triangle. Now fold a bit of the triangle flap up to make a slimmer triangle. Then cut around the top with a half circle shape. When opened, it will be a flower shape. Cut one of the pedals off and decorate it. Make 7 more flowers and glue the points together. Now take a ...
Leo Bancroft with Handbag demonstrates how to straighten your hair with a hair straightener. First, use good clips to section off your hair. Fasten the clip to your hair in a straight line and then fold the excess hair up. Comb through the hair to ensure that you are not straightening any knots. Apply the flat iron to the hair without using a clamping motion. Gently glide the hair straightener over the hair shaft with the comb or brush guiding the hair straightener through the hair. Using the...
The Wood Whisperer demonstrates how we can install hinges on a cabinet without a tape measure, using relative dimensioning. In this example, we use center lines instead of marking the top and bottom of each piece that needs to line up. Using shims at the bottom and top of the door, we center the door on the cabinet to the desired spot. At this point, it's as simple as marking the center lines where you want your hinges to go on both the door and the cabinet frame. Now we can simply attach our...
There are many ways to play acoustic guitar. Often, you will need to learn different styles to enhance your songs. In this tutorial, learn step by step how to apply muted percussive techniques to acoustic guitar playing and get a new sound.
This video illustrate us how to make a vase out of three stamps. Here are the following steps: Step 1; First of all take all the requirements that is paper, stamps, stamp pad, color pencil extra.
heartkayden demonstrates French tips with a newer and sexy flame effect. She leads you through the different steps perfectly starting off by applying a clear nail varnish as a base coat. Next she applies a thick layer of nail varnish, and then uses a toothpick to make the flame design, allows it to dry, After that the white nail polish is applied that is used to give the classical French tip look. But here comes the the flame effect. It is done by using a toothpick to make alternate C's on th...
This video demonstrates the new technique of threading, an alternative to waxing, shaving or electrolysis. Threading uses two threads to pluck unwanted hairs in a fast and painless manner. First the technician will follow the natural arch of your eyebrow removing any stray hairs above the arch. Holding your eyelid slightly taught will allow the technician to remove any unwanted overgrowth underneath your arch, as well as between the eyebrows. Threading is also used to remove unsightly hairs f...
Maximefcom teaches viewers how to play FLAC files in Windows Media Player. First, you will need to open up your web browser. Next, go to the site Xiph. here you should click on the section 'Downloads' to the left. Click on the file that says 'Ogg Codecs for Windows'. Download this, run it and install it. When it is installed, make sure FLAC files are checked. Now, find the FLAC files on your computer that you are trying to play. Make sure it will open in Window Media Player and then play it. ...
In this Home & Garden video tutorial you will learn how to make an accurate boomerang. Material required are 4-6mm thick ply wood or hard board or paper-mache, saw and some spray paint. Search for and download boomerang plans from the internet. The boomerang has three protrusions or handles equally spaced with each protrusion being 14cm long and the diameter of the circle at their ends being 4.5cm. Trace the plan on the plywood and cut it out with a ‘U’ shaped saw. Next draw out the line for ...
Love4Nails shows step by step tips for achieving this look. Begin by choosing a background color. On top of the base, apply white polish. Then apply a smile line on the top portion of the nail as you would when doing a French manicure. Then fill in the nail. If its not perfectly straight its ok because it will be covered. Next, apply glitter polish on the white area of the nail. With the white polish make three dot and use a dotting tool to extend them, creating flowers. With the original blu...
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...
Quadrilaterals are four sided shapes that are closed. They are polygons. Quadrilaterals can be classified broadly in two ways. If the quadrilateral has a two pair of parallel sides then it falls in to the parallelogram category. Further now it can be broken down in to other shapes like square, rectangle, rhombus. If it has only one pair of parallel side then it falls into the trapezoid category. To compute the are of a trapezoid first you need to know the lengths of the parallel sides. Add th...
This video shows you the basics in understanding how to use Copics pens. In this video you'll focus on the basics of coloring. You'll learn the do's and dont's in order to achieve a perfectly colored piece for everyone to enjoy. This is a great video if your familiar with Copic pens or just curious how to properly use them.
Drawing Stewie from The Family Guy on your computer is fairly easy. First you're going to make a horizontal oval, then draw what looks like a football shape just in between those lines. Now erase the excess lines outside of the head shape. Next, insert two circles-fairly far apart on the head-with a slanted line above both for the eyebrows. A small line in the middle pointed towards the right makes Stewie's nose, and a simple mouth is completed with a three small lines at the bottom. Draw two...
The video shows the making of a rose wire anklet for a wedding. The flower guy in the video takes a string a kind of lengthy wire and makes a small round shape in one end of it, then he inserts the other end through the upper front side of the lady's sandal so that the small circle fits exactly in the portion above the toes, then he glues a red rose and a rose leaf and fixes it in the circle with glue, then he puts the other end of the wire around her leg just above the foot, makes about two ...
There are few greater additions to your guitar playing vocubulary than Led Zeppelin's "Stairway to Heaven." This instructional video demonstrates how to play the classic rock song with a few easy steps. Legend has it, that if you play the song perfectly Jimmy Page himself will appear out of thin air and jam with you--not really, but this acoustic guitar lesson is still very much worth your while.
Starting out with a brief summary of what type of pliers to use when making a wire loop with tips on how to prevent markings on wire when using a certain type of plier. This video is used to teach crafters on how to make loops with wires that are useful for many jewelers Making the loop requires 2 certain types of pliers, one called needle-nose plier used to create the loop. Tips near the end on how to fine-tune the loop so it ends off perfectly as well as explanation on why a 45 degree angle...
Learn how to make a perfectly homemade whipped cream by Insightful Nana. Put the bowl and the beater on the freezer to chill. Pour 1 cup of cream into the bowl, whip the cream until it gets firm. Add 3 tablespoons of sugar and a teaspoon of vanilla into the cream, mix it. Whip the mixture together until you get soft peaks. You can use any type of flavors or extracts.
In this how-to video, you will learn how to build your own custom Pochade box for oil painting. You will need 10 feet of 3/4 x 1/2 trim, 1/4 underlayment plywood,, a table saw for squared cuts, a cordless drill, a dowel no smaller than 3/8, a set of hinges and screws, an Allen bolt and nut for triPod mounting, a piece of glass for the palette, gorilla glue water, and chemical proof. Pre-drill everything to make sure the wood does not split. Make sure that when you drill the hole for the dowel...
Learn how to make chestnut paling using a paling machine from Aly May in simple steps. First tie the strings up and down in a wooden pole according to the length you need. Start by placing the wood in between the strings upside down fitting perfectly. Now roll the machine to twist the strings and repeat the same till you get your desired length. You can also use wood with sharpened edges if you want to make a fence. It can be also used for some events but you have to change its length and dur...
Find a nice, heavy and soft mango. Inside the mango there is a large oval pit. By viewing the shape of the fruit you will be able to tell the location of the pit. Set the mango on a cutting board so the pit is vertical. With your chef’s knife cut down the side of the pit and again on the other side of the pit. With the two halves facing each other, take the knife and cut a criss-cross pattern into the meat of the fruit. Make sure you do not press your knife so hard that it cuts through the ou...
This helpful tutorial video demonstrates how to properly cut and clean an artichoke before cooking it. Learn how to do it quickly and easily with minimal fuss. The video covers both the flower and the stem. - First, use a large knife to cut off the stem of the artichoke. You can set it aside to prepare later, if you wish. - Moving about 2/3rd of the way up the flower, cut off the top of the artichoke. - Slice the remainder in half. - Switching to a smaller knife will make the next part easier...
This video demonstrates using Xara Xtreme to align and stitch two images. This is useful for putting together panoramic images. The presenter instructs us to look for similar points in the two photos. Once the points are found see how the images line up. In this case one of the images needs to be rotated. To find the correct rotation the presenter will make one of the images 50% transparent. With the image somewhat transparent he can rotate and position until the images match up perfectly.
This video shows a method of cleaning LP records using steam. He uses a Perfection steamer and a record cleaning machine with vacuums, along with a set of brushes, Disc Doctor cleaner, and laboratory grade water. He uses distilled water in the steamer. He turns the turntable on, applies the cleaner, spreads it with a brush, and applies the steam while the record turns. After the steaming is done, he continues rubbing it with the brush, and turns on a vacuum. Next he runs the steamer of the re...
The video shows us how to sew a straight stitch which is really simple. The needle which is already being threaded and knotted on the other side is made to weave in and out in a straight line. It is done as straight as possible and though the video doesn't show it being done perfectly but its just a demonstration on how the straight stitch works. It is just made to weave in and out along a straight line and is made to end up with the needle on the back side and make a knot. This way you get t...
Work fast and safely in the kitchen and keeping your knives sharp with a steel sharpener. Is important to repeat this regularly, this way we will make our knives live longer, as well as more precision when we use them. Rub the knife over the steel sharpener few times and then cheek with your thumb how is it going.
Denim guru Paul Dillinger shows viewers how to take a pair of inexpensive jeans and give them a celebrity inspired makeover. You will either need to own a dremel tool or borrow one in order to properly complete the technique shown. You use the dremel to give your jeans the perfect fray and help them achieve a more laid back, worn-in look. Jeans like these at boutiques and designer stores can cost hundreds of dollars but you can spend $20 on a pair of jeans and make them look up to date for al...
Michael Weisner demonstrates his method of drawing a Victorian house. He uses a pencil or Sharpie marker, paper, and a T-square to get perfectly straight lines. First he draws the base of the house, and then marks the roof lines. He draws double lines to create the look of crown moldings. He details the first floor first with different widths of markers to show the architectural details. He then adds details to the roofs and crown moldings, and adds a tower with more details. This demonstrati...
Here is a quick and easy way to fold a T-shirt in less than 5 seconds, all in one quick motion. Laying your shirt down on a table or flat surface, simply pinch your shirt with your left hand about halfway down the line of one of your sleeves. Crossing over with your other hand, grab the shirt by the collar and pick up the shirt. After laying down the shirt, you should have a perfectly folded shirt in one quick motion. This technique should be very useful if you ever want to fold your laundry ...
Your first time tying a bow tie can be intimidating. But, you can't wear a clip on tie forever! Check out this tutorial, made especially for beginners, and in less than seven minutes you will have a perfectly polished tie. This video is easy to follow and takes you through every step. Whether you're going to a wedding, prom or some other type of formal gathering.. have fun!
In this video, Dr. Shawnboy gives a graphic demonstration of how to deep-fry a whole turkey in 100% bacon grease. The major problem that is encountered while doing so is that, unlike peanut oil, bacon grease starts foaming almost as soon as the turkey is dipped into it. A very simple solution to this is to keep stirring the grease continuously while bringing up the temperature to the prescribed 350 degree Fahrenheit. It takes about an hour of frying, and the turkey is perfectly done and ready...
