In this Excel basic video the instructor shows how to setup a spreadsheet and use cell references. Cell references are used in Excel to refer to other cells in a formula. When a formula contains data based on the cell reference the formula auto generates the result each time the value in the cell changes as the formula contains only the reference to the cell and not the actual data present in it. In this video the tutor goes on and shows how to write a few basic formulas using cell references...
The materials that you need are a white mask, black sharpie, a printed copy picture of the mask, and a pencil. It is recommended that you sketch the picture using the pencil first. So, your first step is to sketch the picture using pencil on to the white mask. After you have finished sketching on the white mask. If you like, you can add extra details to make the mask looks better. You begin to go over it with the black sharpie. When you are done, the result will look like a Jordison mask from...
This is how you can vector an eye in Adobe Illustrator. You will first want to upload your photo to PhotoShop and then increase the contrast to highlight your picture better. Increasing the highlights is not a necessary step however. This is an intermediate process but the end result with be a cartoon looking eye on a real person. If you used this effect for the whole picture it would look very neat like your own cartoon character! If you only subtly vector the eye then you still have an edit...
This video describes the "green screen" process in iMovie. The shirtless presenter has setup a green screen in his home along with several lights to provide realistic lighting. The presenter then places the object, in this case a porcelain troll, in front of the green screen. The background scene in this instance is a busy downtown area. By watching the background video while filming the green screen footage, the presenter is able to position the troll so it appears to be interacting with the...
In this video the instructor shows how to solve a system of equations by elimination method. First you need to know how many possible number of solutions you can get by solving a system of equations. There are three possibilities. In the first case there are two lines with different slopes, so they intersect at a point which is the solution to that system. In second case there can be two lines with same slope but are parallel to each other. In this case the system has no solution. In the thir...
This video explains how to find the area of irregular shapes. Draw the shape on a grid or graph paper. This will help you divide your shape into pieces. Draw dotted lines to divide the shape into squares, rectangles or triangles. For instance, if you have an "L" shape, you can divide the shape into two rectangles. Be sure your shapes do not overlap. Calculate the area of each individual shape. The graph paper will help you determine the length and width of each shape. Add the resulting areas ...
In this video the author shows how to draw a rhombus when given with the values of long diagonal (D) and a short diagonal (d). Now he draws the long diagonal of size D horizontally on a sheet of paper. Now he points the mid point of the line as he explains that the diagonals of a rhombus meet at midpoints. So now he takes the ruler and draws an another line perpendicular to the first line through its marked mid point such that the length of the perpendicular line is d/2 both above and below t...
How to subtract positive and negative integers: There are four types of subtraction:
In this tutorial the instructor shows how to convert lengths between different units. He show a two step approach where in the first step he setups a relation between centimeters and meters showing that 100 cm equals 1 meter. Now he writes it down in a fraction form and equates it to another similar centimeter upon meter fraction where the value in meters in unknown. Now he cross multiplies and solves the fractions giving the result of the unknown meters. This video clearly explains how to co...
Make your embroideries more accurate and beautiful by designing the letters and words on a computer software called Compucon EOS 3.
This video demonstrates the simplest method for multiplying fractions. According to the tutor, one should first identify the highest common factor with which to reduce the two fractions, by themselves, and in relation to each other. The numerators of the two fractions are multiplied and the product is written down as the numerator of the resultant. The same operation is carried out on the denominators of the two fractions, resulting in the denominator of the resultant fraction. The final answ...
How to make some delicious and creamy fettuccine alfredo. Ever try and make some that just doesn't turn out quite right? Well here we show you how to make it with perfection. You will need, Fettuccine noodles, cook these to 'al dente' which means soft and fully cooked. Also, you will need heavy cream, milk, parmesan cheese, ground black pepper, shredded Romano cheese, egg yokes, and salt. Bacon is optional, and if you use it, make sure it is fully cooked. Watch the video to observe how to pro...
Learning how to make a piece of jewelry can be a daunting task, but this straight forward tutorial gives you all the skills needed to perfect the craft of making friendship bracelet. Starting with just a few simple pieces of string, one can make this very simple DIY project. Although the materials are cheap to procure, the end result is anything but cheap looking. The candy stripe design adds to the charm of this whimsical bracelet. Make one for all your friends today!
If you need to draw a demon monster in a hurry then watch this video to see how you can sketch one up in a flash. The great thing about sketching is that you can just sort of etch out the form, refining it until you have the scary demon you are looking for.
In this video the author talks about the secrets of quitting smoking forever. there are basically four tips to achieve this result. The first is you need to keep your hands busy, so that you can avoid the desire to hold a cigarette. Similarly you also need to keep your mouth busy, by chewing gum or anything to draw your attention away from cigarettes. It also helps to keep a pack of cigarettes in your pocket all the time to continuously remind yourself that you have to stop smoking and there ...
Learn how to do two step math problems with this video tutorial.
Watch this video to learn how to multiply fractions by fractions. First multiply the top numbers together. For example, if you have 3/5 * 4/7, multiply 3 * 4 and put your product on top of the fraction you will get as a product. Next, multiply the bottom numbers together and put them on the bottom of your resulting fraction. Next see if you can reduce your product to simplify it. You could also do the reducing step first by canceling out any common factors in the numerators and denominators o...
In this math tutorial the instructor shows us how to add three fractions with common denominators. He says that it is similar to adding two fractions with common denominator. He tells us first to add all the numbers in the numerator which gives us a new number which is the numerator in our answer and the denominator to our answer is the original common denominator. Now, if the resulting fraction is improper fraction, you will have to convert it into a mixed number. In this video the author sh...
This how-to video is about how to find a number when its percent is given. This video is really helpful and effective in finding the number when the percent is given, the following steps are explained in the video to find the number when its percent is given:
In this Excel basic video the instructor show how to setup a page in Microsoft Excel. Now you before go to a page setup, first you have to make sure that all the cells are visible in a spreadsheet by extending or contracting the size of different columns. You can also select all columns and make their column width a constant. Now go to the orb and select a print preview to get a preview of how the print out is going to be. Now after checking it out you can make necessary changes in the origin...
Gourmet Magazine's food editor Lillian Chou introduces cooking enthusiasts to a little-known method to peeling a ginger. She addresses the problem of cooks taking too much of the ginger off with the skin when peeling with a knife. To reduce this wasteful practice and get dependable results every time, she encourages the use of a spoon! This simple tool can take the skin (and only the skin!) off ginger without any hassle. It also is apparently very good at getting the hard-to-peel spots on gin...
Having trouble with sharpening your serrated knives? Wayne Dolik, an expert sharpener from www.sandiegocutlery.com tells you how. In this video tutorial, Wayne explains the essential tools of serrated knife sharpening and where to get them. Wayne also offers great tips and advice on sharpening safety, how to minimize the chances of damaging your expensive knives, how to make the job as easy on yourself as possible, and how to get the best overall results. You don't have to struggle in the kit...
This fast ab routine shows you how to get a six pack in less than four minutes using nothing but your couch within 2-3 weeks. Please consult your physician before you begin this program. This program guarantees results if you strictly follow the few routines. The first routine is shown in this video where you have to do a series of short bursts of exercises including crunches interlaced with static pauses and breaks as shown in the video. The following routines to be performed can be found on...
This how-to video shows viewers how to solve math problems with brackets in polynomials. The person in the video teaches people how to solve the problem with a positive sign before the brackets. This segment does not show how to solve the trickier problem where there is a negative sign in front of the brackets. The tutor shows everything from removing the bracket due to the positive sign, to combining the similar terms for the result of the problem. This video can help anybody deal with brack...
A bloody knuckle knot is the result of a row of half hitches fused with a blood knot--this video teaches you how to tie one. Make two loops with your rope then loop them over your thumb. Take the tail of the rope and keep making loops and adding them to the others on your thumb, to produce a row of loops. When you have five loops, slide them off your thumb, take the end of the rope and pass it through the loops. Pull out the slack but do not tighten, then take the other tail and pass it throu...
How to draw a face in MS Paint. The video is obviously made by a professional, it shows a sped up replay of a man using MS Paint to draw a very well done face. He starts with the basic outlines, then moves into coloration and shading. Notice all of the shading is done in unison and correlates with a particular direction that remains the same with all shading properties. Also take note of the fact, that the colors and lines are blending together, that the detail isn't as sharp as a high resolu...
In this video the tutor shows how to multiply fractions. She says that compared to adding or subtracting fractions, it is easy to multiply fractions. She says that to multiply fractions first we need to multiply both the numerators together to arrive at the new numerator. Similarly we multiply the denominators to arrive at the new denominator. Now we can further reduce this new fraction to its simple form which is the desired result. This video shows a small step-by-step method to multiply eq...
In this how-to video you learn how to apply neon color nail polish. The process begins by applying a base white coat and allowing it to dry. You use white because it brings out the neon the best. Once you have the base coat you begin applying the neon colors in any design of your choosing. If you use an outline it helps solidify your design and the results are much clearer. The entire process takes about six to seven minuets and is perfect for teenage girls.
In this video the tutor shows how to solve the missing ratios or proportions. He explains it with an example, where a number in one of the ratios is missing and he intends to find this value. He shows the example of cross multiplication, where you multiply the values on the either side of the equation diagonally and finally solves the equation which results in the value of the unknown value. This is an introductory video explaining how to use rations and proportions to find missing values.
In another installment of its boxing series, Rival Boxing Gear experts show, how to defend and counter-punch against a right hand punch. This video shows viewers three basic techniques for defending against the right hand punch: the parry, the block, and the slip. It also demonstrates effective counter-punches (right hand, right uppercut, and left hook) to throw and describes when each counter-punch is best used. This 6 minute, 20 second video makes good use of repetition and multiple camera ...
Stretching your ears out to fit in a gauge looks totally counter culture and cool, but if you get too excited to load one in and stretch your earlobes too quickly there could be huge (and nasty) consequences.
This instructional video walks you through how to get great abs in 3 minutes. The person that did this video lost 100 lbs in just 3 months. You should perform each exercise for 20 seconds with a 10 second break in between daily. After completing all 6 you should repeat 2-3 times. It shows you exactly which exercise to do without talking but using music. After successfully doing these exercises daily you should see results in no time at all.
This video is a discourse about saltatory conduction in the neurons. According to the author, it begins with the opening of a gate on the membrane of one of the dendrites of a neuron, and positive charge enters through this gate. The positive charge spreads throughout the cell, and gets dissipated as it spreads, so that, by the time it reaches the Axon hillock of the neuron, it is left with very little potential. However, the potential which results from the simultaneous excitement of many de...
In this video the instructor shows how to graph a line using X-Y table values. He specifies a four step approach. In the first step he picks numbers for the value of x. In the next step he substitutes the values of x in the equation of the line to obtain the corresponding y values, in the third step he plots these ordered pairs on a graph sheet. Finally in the fourth step he joins them resulting in a straight line for the given equation. This video clearly shows how to graph a line using an X...
Interested in learning how to get that Cleopatra eye look? This step by step video will show you how to get that ancient Egyptian look here in the twenty first century. Our host narrates while applying the makeup on her own eye and shows how to apply the make up and which brushes to use. The video shows a close-up of her eye along with step by step instruction on how to apply the various makeup techniques. The end result is a dark smoky eye with a strong liner.
Want to get ripped abs fast? Follow Vince DelMonte's fitness plan and you will soon find yourself with hot, irresistible abs. With cardio and a few changes in the way you think, you will be able to reach that goal of obtaining fit abs. Watch this video to learn more about his fitness regime that will get you the results you want, fast. These simple rules will get you where you want to be quick, and you will soon have abs.
In this tutorial the instructor shows how to solve linear and quadratic equations. It is a liner quadratic system where he shows a parabola and a straight line and he intends to solve the points where the line intersects the parabola. Now he uses comparison to compare the values of y in both the equation resulting in a equation in x. Now he shows the factors of the obtained polynomial equation and there by finding the values of x coordinates. Now he substitutes these values of x in the origin...
In this tutorial the instructor explains how to divide fractions. He gives a three step approach where in the first step we take the reciprocal of the second fraction. In the second step the newly arrived at fraction is multiplied with the original fraction. Now finally in step three the result is deduced and the answer is obtained. This video explains clearly and simply a three step procedure of how to divide fraction.
In this Adobe Acrobat tutorial the instructor shows how to export PDF files to other office formats. He shows how to do this with a live example. He chooses the file menu and from there goes to the export sub menu and shows all the different file format options that are available for exporting. For demonstration purposes he saves the current PDF in Microsoft Word format. He opens the converted file and shows the results of conversion. This video demonstrates the features of Adobe Acrobat 9 to...
This is a great video about how to unclog your toilet without a plunger. The author of this video explains which ways she tried to unclog her toilet initially, and how they failed without any results. She then tells you how you can unclog your toilet with dish soap and some hot water, which actually works. If you are facing the same problem with your toilet, just try the method explained in this video and see if it actually works or not. Also, use this method to unblock a sink without a plung...
