Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 42nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn ten tricks involving the LOOKUP function:
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the very first installment in his "Excel Formula Efficiency" series, you'll learn how a custom function (i.e., a user-defined function) can speed up calculations.
When you begin a hobby like custom framing or any other type of art involving glass, you will need to know how to safely cut and shape glass without breaking it.
This video involves beauty tips on how to get rid of chapped lips. The video starts out by listing items needed to take care of chapped lips; the first item listed is chap stick. The video specifically recommends a chap stick that has SPF protection. The other items needed are a tooth brush and a clean towel. The video next explains to rub chap stick on your lips. Next, a tooth brush is used on the lips in circular motions to remove dead skin cells. The purpose is to allow your lips to heal m...
In this how to video, you will learn how to teach your dog to retrieve. First, you should teach your dog the a regular retrieve. You will toss the object so that the dog sees where it lands. Next, give it the command to retrieve. Next, attempt the semi blind retrieve. This involves tossing the object, allowing your dog to see where it has gone. Next, distract the dog for a bit before giving it the command to retrieve. The full blind retrieve should now be attempted. This is done by hiding the...
This video tells us the method to remove Trojan Virus from the computer. This can be done in a couple of steps. The first step involves the downloading of a specific application from the web. We have to search this application in Google. Type 'malwarebytes' in the search engine and press enter. Go to the third result starting with 'Malwarebytes Anti-Malware'. Click on 'Download Now' on the resulting page. Open the application and select 'Perform quick scan'. This will scan the computer for Tr...
Break out the conga dance at your next party or special occasion with help from this free lesson. The conga dance is a celebratory dance that many do in a line involving three steps and a tap to the side. Get tips and tricks on how to stay away from having two left feet with a pro: Rosario Nene Ortega is a ballroom dance instructor at The Goddess Store in Hollywood, Florida. Learn more dance moves from this expert by searching WonderHowTo! You're only practice time away from ruling the dance ...
Get your hips out and start learning how to hula with help from this free lesson! Hula dancing is a traditional folk dance of the Hawaiian islands, and it is similar to belly dancing in the hip and stomach isolation it involves. Learn about the proper techniques for hula dancing from a pro: Rosario Nene Ortega is a ballroom dance instructor at The Goddess Store in Hollywood, Florida. Learn more dance moves from this expert by searching WonderHowTo! You're only practice time away from ruling t...
Starting from the beginning is a good thing when it comes to entering the world of break dancing. A beginning break dance move involves getting into a crouch and moving into a type of running position. Find out how to move the feet to complete this break dance move with help from two experts & a free lesson.
If you're entering into the world of break-dancing you'll soon discover there are varying levels of skill. In this video, learn how to do some break dancing moves geared towards beginners with help from two dance experts. A basic break dance move that a beginning dancer can do is the top rock, which involves crossing, turning and coming out. Learn how to do all of the steps of beginning break dancing moves with help from this free lesson.
Watch Southwest Lawn and Garden's John white and Dr. Bernd Leinauer Discuss the importance of Bermuda grass lawn fertilization and the correct techniques involved. You'll learn how to interpret the meaning behind the fertilizer label, and why a complete fertilizer, including nitrogen, phosphorus and Potassium. Along with how to calculate much fertilizer to use per square foot, You'll learn how each important nutrient helps your lawn, and why having the correct balance is so important. Most im...
This particular video demonstrates a method to wax your snowboard. This method of waxing the snowboard does not involve use of iron. It is done using a large piece of wax and a piece of cork. Firstly we need to rub the piece of wax over the surface of the snowboard. Hard rub is required and one ball jay is the most efficient. After rubbing for some time we need to polish the waxed using a large round piece of cork. After polishing for some time you will discover a shiny looking snowboard read...
This video shows the method to install 'Installous' on your iPhone and iPod Touch. The first step involves opening up 'Cydia' on the iPhone or iPod Touch. After opening Cydia go to manage and then go to the option of 'Sources'. The resultant window will show an option named hackulo.us. Add this cydia.hackulo.us to the source. The resultant window which opens shows various sections. Find the section of Hackulous in the window. Go to the Hackulous section and find the option of 'Installous'. In...
In this video Christy Ruffner will show you the process involved in harvesting worms for shipment. The container used in the video is an oil changing pan. The pan is filled with worms and bedding. Simply rake your fingers on the top of the bedding and remove the worms to another pan. You need to feed and water the worms properly. Then, the worms will be congregated on the upper portion of the bedding. Once all the worms are separated, weigh them and then add an equal amount of bedding. If you...
This Zappos video shows how a girlfriend can wear her boyfriend's clothes. There are several different looks a girl can go for while wearing her boyfriend's clothes. One of the most popular is to have a "rocker" look. This involves wearing your boyfriends jeans but cutting the hem and pairing them with a pair of black booties, you can also wear this with one of his t-shirts tucked in on one side. Another look is to wear one of his plaid shirts with black skinny jeans and black booties with a ...
One of the most important features on the jerk bait is the front end diving lip which is used to make the lure dive deeper in the water when the jerk bait is pulled by the fishing rod. There is one more very important feature involved in using this jerk bait. It is the "pause" and "jerk" motion of the lure. This action should be performed after the line is fully cast out and fully under the water and all of the slack left in the fishing line is reeled in and gone. The reason for the "pause" i...
Looking to get some more out of Bachata dancing? In this video, learn how to do modern Bachata-style dancing, which is a little different from the traditional Bachata. Modern Bachata is much sexier and involves more hips. Use this video as a guide on your road to Bachata mastering!
This is a Video clip presentation from all3sports guides us on how to check and assemble the unpacked shipping box. The first step to assemble the motorcycle involves inserting the seat lifter to the reasonable depth and tighten the screws. After that attach the handle bars and front brake and make sure that there is an equal amount of gap between the top and bottom of the handle bars. Then, check the brake cables are properly fit. Then, assemble the arm gauge or arm rest with the two sets of...
In this video tutorial, learn the several methods to get black & white images from color originals in Photoshop. The first method is the simple desaturate by going to image > adjustments > desaturate and it will wipe out the color from your image. The second non-destructive way of doing this is going into the layers palette, adding a new adjustment layer, choosing hue and saturation and dragging the saturation slide all the way down to minus (-) 100. The next method is going to the channels p...
If you're into arts and crafts then you know that there is more that you can do with a long piece of string than just tie your shoes. On this TyingitAllTogether video you have the opportunity to tie the teacup decorative knot using one long piece of string folded in half. The author of the video first shows you what the end product will look like then methodically begins to walk you through setting up the string in Y-configuration to "crossing each bights crook" which involves overlapping and...
This educational math video describes the steps necessary to solve an equation involving absolute values. "Absolute value" refers to the magnitude of a quantity and is always expressed as a positive number. You can think of absolute value as the distance a number would be from zero if plotted on a number line. Positive 17 and negative 17 both have the same absolute value because both are 17 units from zero on a number line. Because of this, all absolute value problems have two answers, one wh...
The user tries to explain to us how to find the distance between two points. It should be noted that we are not talking about using a ruler to measure the distance between two points. The video creator is talking about the math problem that involves finding distance between two points. He uses an electronic white board to explain to us how this is done. He goes step by step and uses a basic equation to help the viewer understand these concepts.
In her video, Carol describes her skin care regimen, which she claims has been very effective in treating her acne and improving her skin. This regimen is for acne-prone / combination skin types and involves the use of multiple products, including cleansers, scrubs, masques, washes and moisturizers. Carol takes us through her morning, evening and weekly cleansing routines, explaining which of various products she uses for each such routine. She also discusses each product, explaining its stre...
Steps involved in calculating the lateral surface and total area are:
This video demonstrates the procedure involved in writing an uppercase "G" and lowercase "g" in Copperplate. You will need a writing utensil and something to write on. In the video, a nib and black ink were used on lined paper. The letters should be written slowly and carefully to avoid errors. The video may be useful for people who want to learn how to write a "G" or "g" in Copperplate style. After watching this video, a viewer would know how to correctly write a "G" or "g" in Copperplate.
If you lay tile it is rare to do a job and not have to cut a curved piece of tile. If you do have to cut a curved piece there are two ways to do it. First, you have to draw outline of the cut that you need to make on the tile itself and mark the part you are going to remove with an X. The low tech method involves using a pair of tile nippers. You nip away pieces of the tile until you have nipped away the whole area until you have a circular cut out. For a more polished cut you can use a spira...
Try out this old school street hustler card trick. See if you can find where the queen is hiding, then see if you can perform the trick. It's a truly amazing card trick that will impress anyone, or enrage anyone (if money is involved). This hustling trick is known as the "three-card monte".
This video will show you how to do a great bar trick puzzle. Connect the boxes to win some bets and free drinks. Once you know how to do it, it's very easy to accomplish. This involves some drawing, but you'll impress friends with this intersecting lines trick.
Want to know how to use the Pyro FX tools in Houdini 10? This masterclass will tell you everything you need to know about using Pyro FX fire and smoke tools in Houdini 10. The discussion covers the addition of exciting new fire and smoke tools. Topics covered include a powerful new fluid up-resing technique, advanced noise and turbulence control, and a highly tweakable custom fire and smoke shader.
This knitting demonstration is showing you a knit involved in the bee stitch cloth pattern. It calls for a stitch that you would knit into the stitch below. This is commonly referred to as k1b or knit 1 below.
You don't need a lot of money to build yourself an impressive home theater system. Yes, typically putting one together means piecing together a bunch of speakers, a supersized plasma HD TV, and whatever other add-ons you want. But really getting a great cinematic experience involves nothing more than having a computer with some fancy programs.
This is a 2 part Step by Step video that helps you learn how to paint an ADVANCED camouflage design Xbox 360 controller.
Do you want to be the next David Blaine, Chris Angel or David Copperfield? These magicians know how to do magic right, and they know how to do card tricks right, but why can't you? Just watch this video tutorial to see how to perform an amazing four card magic card trick.
Do you want to be the next David Blaine, Chris Angel or David Copperfield? These magicians know how to do magic right, and they know how to do card tricks right, but why can't you? Just watch this video tutorial to see how to perform the magic "ace thru four rearrange" card trick.
Do you want to be the next David Blaine, Chris Angel or David Copperfield? These magicians know how to do magic right, and they know how to do card tricks right, but why can't you? Just watch this video tutorial to see how to perform the magic "this 'n' that" card trick.
Do you want to be the next David Blaine, Chris Angel or David Copperfield? These magicians know how to do magic right, and they know how to do card tricks right, but why can't you? Just watch this video tutorial to see how to perform the magic "card switch" card trick.
Do you want to be the next David Blaine, Chris Angel or David Copperfield? These magicians know how to do magic right, and they know how to do card tricks right, but why can't you? Just watch this video tutorial to see how to perform the magic "greatest card trick in the world" card trick.
Do you want to be the next David Blaine, Chris Angel or David Copperfield? These magicians know how to do magic right, and they know how to do card tricks right, but why can't you? Just watch this video tutorial to see how to perform a magic mathematical card trick.
Do you want to be the next David Blaine, Chris Angel or David Copperfield? These magicians know how to do magic right, and they know how to do card tricks right, but why can't you? Just watch this video tutorial to see how to perform the magic "snap change" card trick.
Do you want to be the next David Blaine, Chris Angel or David Copperfield? These magicians know how to do magic right, and they know how to do card tricks right, but why can't you? Just watch this video tutorial to see how to perform the magic "card jump" card trick.
