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 5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create seven types of charts — X-Y scatter diagrams, pie charts, column charts, bar charts, stacked bar charts, line charts, and column and line chart combined. ...
In this brief tutorial brought to you by TutVid.com, the host teaches you how to make a swirling rainbow graphic that you can use in many diverse ways. This vector images is made in Illustrator can be used in conjunction with several of the most popular photoshops. He uses several different techinques, like making a circle, cutting it in half, and recycling and rotating the image until you have a full, s-curve line. Superimposing several of these lines upon each other, he creates the finished...
First step in a free throw is when the ref passes you the ball. At this point you should step back and take a breath, this will slow you down and help you concentrate. You have 10 seconds to shoot so there is no rush. Next, approach the line. You will find a nail, dot, or spot of paint. This shows you where the center of the court is. Line your shoulders up with the dot, to prevent the ball from going to the left or right of the hoop. Next, you should use a routine you've established to get y...
This video shows us how to fold a simple origami swan. Here are the following steps: Step 1: First of all take a paper and then crease it diagonally and then open the crease and then fold the paper on the crease line so that a cone is obtained with a triangle on the top.
This video shows us the method to draw a fashion concept sketch. You must show the figure of the person you are drawing. You can draw the figure wearing a scarf you have designed. You can draw the flowers on it. A lot of sketches are very long. There are a lot of vertical lines and plates in the sketch. There are long legs at the bottom of the sketch. The parts of the body are not in human proportion. You can draw bracelets and a purse in the sketch. The sketch would be finished with color, v...
Microsoft excel is a powerful tool used to work with numbers and data by filling them down in rows and columns of a table. Excels also supports macros, which are small scripts to automate certain functions. In Microsoft Excel you can select entire rows and columns using the range property. You can also use macros to select individual rows and columns as well as multiple variations of rows, columns, and individual cells all at once. In Excel a horizontal line of data is called as row and a ver...
This video illustrate us how to create a sassy red, black and white nail design. Here are the following steps :step 1: First of all remove any previous nail paint.Step 2: Now apply some primer on the nails for long lasting effects of the nail paint.Step 3: Now take red nail paint and apply it all over the nails, let it dry.Step 4:Now take black nail paint and draw fine horizontal lines all over the nail.Step 5 : Now take white nail paint and apply polka dots on these lines as well as on the e...
Plangere Culture Lab demonstrates how to use the opacity feature in Final Cut Pro. The opacity feature is a beneficial tool to use when working with layers. Opacity is an attribute which relates to how much you can see through a clip. To layer clips, create a new video track on the timeline. Make sure that the source tab is in the right position. The track on the top of the stack is the dominant track and will be shown. Select the volume and opacity overlay button. Click on the line over the ...
New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 329th installment in their series of digital spreadsheet video tutorials, you'll learn how to create a frequency table. Then see how to calculate the midpoint of each category and make a frequency polygon with two or more lines (two or more data sets).
Each player starts with 15 marbles that are a color distinct from his opponents marbles. Toss a coin to choose a start line, placed 3 meters from the hole. The players then take turns shooting marbles, first from the start lines, then from wherever the marbles land on the field, all the while trying to make their marbles in to the hole. The player to shoot all his marbles in to the hole first wins. In a case where both players have 1 marble left and the final shot is made by the person who to...
This video is describing how to make a LEGO version of the Matrix bullet. The first step is gathering all of the supplies. You will need as many of the one by one transparent squares as you can find and a black one by one circular LEGO. Then put all of the white transparent pieces together in a line and trail them behind each other. Twist the line, this will be your bullet trail. Then take the black one by one LEGO piece and place it on the end of your white bullet trail. Then you have finish...
This video is describing the steps needed to draw Tigger from Winnie the Pooh. The first step is to draw an oval on your black paper. Draw diving lines, and make sure that one is a little bit below center. Next draw in his muzzle by lining up the top part of his muzzle with the bottom part of his eye. Next draw his chin. You can draw the bottom by taking the distance of the head and putting the same amount of distance between the head and the muzzle that there is between the muzzle and the ch...
In this video, Lance Sisiolo draws a beautiful house using Microsoft Paint. He uses line tool to draw most part of the house. He uses different types of lines. He also uses curve tool to draw sky and the entrance of the house. The unwanted part of the picture is erased using erase tool. Then he uses fill with color tool and airbrush tool to paint the picture. He uses different colors to increase the beauty of sky and the house. Then some trees are added. Using airbrush tool he increases the b...
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...
As you type in Microsoft Word, take care to notice when the computer puts a red squiggly line underneath a word you typed. If you see a red squiggly line, the word is spelled incorrectly. If you right-click on the word, MS Word will show you a list of correctly spelled words that it guesses you were trying to spell. If you wish to check the entire document, you can click the Tools tab at the top of the page and then spell check. This will go through the document and point out every misspelled...
To scratch on a pioneer CDJ turntable, first select the sound you are going to use. Observe the position of the black line on the turntable in relation to the sound you've selected. Understand how much room you have to manipulate the sound and position your fingers accordingly. The platter will move in accordance to the black line and your finger. You can also lift your hand off the platter in the play and pause mode to let the sound move itself by its own accord and at its own speed. Move yo...
ConnersTutorials, teaches you how to put two videos playing simultaneously in one movie. You use Sony Vegas and drag both movies in the time-line below. Then you press Event pan/crop on the first video. Right click and choose Match output aspect. Then re-size and move the video as you want. Do the same for the other video. Go to Media Generators to choose the background, which can be a solid color, a picture or another video. Just drag that down in the movie time-line when you're pleased. All...
Dawn5377 teaches you how to make a twist box. Start with a piece of designer paper and fold it according to video specifications. Once done you will fold all the score lines, which are both horizontal and vertical. For the Xs you will fold in once one way and then the other. You will also crease the tiny line to the edge of the paper, using a sort of pinch motion. You punch three holes on each side - top and bottom. Fold the paper horizontally and glue it. Push the two ends opposite of each o...
This video tutorial is about basic sawing techniques. Before practicing it you need to wear safety goggles for protecting your eyes. First of all, make a practice sheet. Draw three lines in a metal piece. One line is straight, one is curve and another is zigzag. Lubricate the saw blade and start sawing. Hold the saw straight and move forward. Blow the dusts away. For making curve don't move the saw, rotate the metal piece to cut it. Hold the metal piece tightly when you sawing it. Addie kid h...
Learn how to sketch a realistic 3/4 profile of a female head and face. Begin by drawing a simple circle. Add a few more construction lines which outline the general shape of the drawing. The rough features of the face come next. Now you are ready for more artistic touches, such as shadows underneath the nose and lower lip. Experiment with different brushes and intensity of color until you like the result. Learn to play with lines and shadows to create a sketch of a female head.
This video shows us how to create an amazing 3D design using a single sheet of paper. You will need: cutter printed template of the 3D design. Procedure: Download the template using this link. Print the template. Cut all the solid lines on the template. Fold all the broken lines on the template as shown. Arrange the paper in such a way that it looks like the 3D design shown on the video. Follow these steps and you will have your very own amazing 3D paper design!
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...
This tutorial video, from tasktutorial demonstrates how to create animation using the motion guide function in Flash. You will learn how to create an object, in this case, a ball, and create an animation that makes it appear to bounce. The guide shows you, how to add a motion guide by selecting a key frame and drawing it in. Then you will learn how to snap the object to your guide line, and add motion to it by selecting another key frame between the first and last frames, and snapping the obj...
Hamid Reza Ebrahimi demonstrates how the Z and z are written in copperplate. For this video, Hamid used a Brause & Co. No. 86 Nib Persian black calligraphy ink. Also, he used a Brause marbled penholder along with a Persian leather pasteboard and Steinbeck pasteboard. Hamid writes the letter Z at 6 centimeters tall and the small z at 2 centimeters. The video shows how the Z is written, starting off with a loop from the top line on a ruled paper and moves on a slant to the left down to the bott...
This video instructs you on how to draw angles in geometry. The instructor begins by showing you 4 example angles you can create. He then draws a straight line that can be linked to any of the other four angles. The first example of an angle shown is 180 degrees. He draws a line at 50 degrees and then he continues to draw a 90 degree angle. The instructor varies whether he uses the left or right side of the protractor. He ended by noting some angles will be larger than the protractor.
In this video you learn the basics of how to draw a cartoon horse. The basic structure is laid out in a series of simple geometric shapes, lines and scribbles.
This video demonstrates how to write the letter P in calligraphy copperplate. The technique that is illustrated in this video show you the proper way draw the letter P effectively and beautifully. The video first shows you how to draw the capitalized letter P. The first step is to create a slightly S-curved stroke downward from the top margin to the bottom-middle margin--thickness in the middle. You end the line with a curled tail. To complete the letter you then have to draw a looping, curle...
In this tutorial the instructor shows how to find the Y-Intercept given the equation of the line in Point-Slope form. He shows how to do this with an example. He tells to substitute the value of x to zero to find out Y-Intercept as Y-Intercept is nothing but the point where the line meets x-axis, where the value of x co-ordinate is zero. By watching this simple tutorial you can easily compute the Y-intercept of an equation in point slope form.
This video is about shooting a sunset photograph.
This video shows how to paint Piet Mondrian inspired block print nails yourself. Apply a white base coat and top coat. Use black nail art paint because of the thin brush. Paint two black lines the length of your nails. Then paint black lines going across the width of the nails to make random size boxes. Dab the color of paint you are going to use on a piece of paper and use the nail art brush to get the paint off of the paper and apply the different color paint to the boxes. Wait about 10 min...
This video explains how to easy add decimals. Adding decimals can seem to be a tedious job, and a single mistake can result in a completely different number. In reality, it is quite easy, and with a good method and some practice it can be done quickly. Write the two sets of numbers out, lining them up in columns. Keep the decimal points on top of each other and line up the non-decimals with non-decimals and the decimals with decimals. Start at the right-most column and add it up. If it become...
You can replace the kitchen faucet by yourself. If you decide to do it start by turning off both the hot and cold water using the valves under the sink. You'll need a basin wrench to get at and remove the pieces up under the sink. First you will loosen and remove the water lines and then the retainer nuts that hold the faucet in the sink. Pull the old faucet out. Put some plumbers putty on the sink and press the nylon gasket firmly in place. Thread the spray hose through the hole for the spra...
This tutorial is about how to create a Kate Moss inspired makeup look. Start with an eye shadow base that is slightly paler than your own skin tone. Use a black cream eyeliner with a small brush along the entire lash line. Smudge the line down using a cotton swab. Next cover the entire lid with black shadow. Using a smudging tool take the black shadow under the eye as well. Curl the lashes and finish with a coat of black mascara.
Using the improper types and colors of makeup may in fact add years to your appearance rather than take them off. This video shows some simple tips to reduce signs of aging in less than ten minutes. For example, rather than using shimmery eyeshadow, which can in fact enhance wrinkles and fine lines, use a matte colored eyeshadow in order to blend the lines in your face. Using light, non-heavy lip liner and moisturizing lip gloss will make your lips look fuller, giving you a more youthful appe...
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.
Ron Hazelton shows the most secure way to hang heavy mirrors or art on plaster walls using toggle bolts. Attach a sturdy hanging wire to the piece if necessary. Draw a level line on the wall where the top of the piece will go. Stretch the hanging wire taut and measure the distance between the wire and the top of the frame. A two-bolt system will keep the piece level. Drill two holes this distance below the wall line. Using masking tape prevents the plaster from chipping. Fold the toggle wings...
Mark Donovan of HomeAdditionsPlus shows us how to install a towel ring in the bathroom. - Line the ring up on a wall stud.
Looking to make this Christmas a DIY Christmas? Why not make your own Christmas tree skirt, customized to fit your personality and home decor! Nothing says it’s Christmas like a beautiful Christmas tree. Now you can decorate the area below with a handmade Christmas tree skirt that you can be proud of.
The eyes of characters in Japanese manga tend to have a very distinctive look. They are large, childlike and shiny, with lots of little reflections. If you draw them right, they can look beautiful. But if you get them wrong, they'll just look bizarre. In this video, "Miki Falls" manga creator Mark Crilley shows how to draw manga eyes, line by line.
Did you know that rabbits can be litter-trained? Having a properly trained bunny means less mess and stress for you—and the bonus for your bunny is that she’ll get more freedom around the house.
