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 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to transform bad data into useful data using formulas and text functions such as TRIM, PROPER, SUBSTITUTE, REPLACE, FIND and LEFT. Also see how to use the ampersan...
This video gives detailed instructions on how to play a song called "If I Fell" by the Beatles. The instructor shows how to play each verse, cord by cord, and then the instructor follows his instruction by playing each verse for his audience. His demonstration teaches his viewers, not just the proper notes but also the proper timing, flow, and rhythm of the song. While playing each verse, the instructor sings along so that the viewers can hear how the song sounds in its entirety.
This 5 minute video covers the basics of photographing architecture using Nikon equipment. It gives good basic explanation of basic lessons in architecture photography, including selecting a proper position and distance to either provide or avoid distortion as desired, selecting the proper lens, selecting the film speed for indoor photographs, and how this may affect your choice to use a triPod, and even how to use Nikon's software to correct or adjust photographs after they've been taken. If...
Lowe's home improvement expert, Mike Kraft provides a step-by-step method for changing the oil on a walk-behind lawn mower. From assembling the proper tools and supplies you will need to complete the task, through disconnecting the motor for safety, through the proper drainage technique and finally refilling the crank case this video gives complete instructions for any mower maintenance. Changing the oil on your mower will extend its life. Following the steps in this guide will provide you wi...
Do you know how coiling effects golf swing? Swaying too far off the ball in the backswing and downswing is one of the most common power leaks in golf. Use five-time, Re/Max World Long Drive Champ, Jason Zuback's method for creating power through a proper coil and gain yards now. See how to create power in your golf swing with a proper coil.
We caught up with Doctor David Lorczak to discuss the benefits of proper outfitting and posture to promote a long and healthy kayaking career. In Dr. Lorczak’s opinion the advancements in the Bad-Ass outfitting allows the kayaker to maintain better posture while allowing slight movement of the lower torso. This movement is key to maintaining a healthy spine in a sport that is brutal to that area of the body. Have a listen to Dr.Lorczak as he explains the relationship between proper posture, g...
Learn the importance of good diction when singing.
Learn the importance of proper breath control while singing.
This video begins by showing what a folding painting canvas looks like and what the final stretched canvas should look like. The first step shown is to make sure the bars are measured and marked with a simple A and B for easy measurement recall. After a wood frame is added over the canvas you must fold the material over the back of the wood and nail in place. Once the canvas is nailed to the frame you must add A, B, C and D markings to continue proper alignment procedure. The last step shown ...
In this video, we learn how to exercise proper juggling technique with a soccer ball. When juggling the ball, keep it below your chin so you have complete control of the ball. When the ball is above your head there is more room for error. One way to learn is to put a bounce in between each touch of the ball, which will give you a sense of control. Also, keep it close to your body so you have a lot of control over it. When juggling the ball, do different moves and keep it under complete contro...
In this tutorial, we learn how to draw a skull with proper proportions. First, draw the outline of the skull with the light touch of a pencil. After this, use the pencil to draw two crossing lines that are the same length. Next, draw in the features of the face and head using the lines on the drawing. From here, you will start to add in the details to the features of the face and erase any background lines. Use the side of your pencil and the top of it to shade in the sockets and lines. To fi...
This video tutorial is in the Sports category which will show you how to properly throw a football. First ensure the football is the correct size for the thrower's hand. You can't throw without a proper grip. To get a proper grip the middle finger should be on and parallel to the white stripe on the football. The 4th and 5th fingers should be on the laces. The index finger must be separated from the middle finger and be parallel to the seam. While throwing, the thumb should be pointing downwa...
In this video, we learn how to play guitar using the proper technique on the fretboard. While playing on the fretboard, the speed and movement should be equal. Your fingers should be close to the fretboard at all times, not far away from it. When you play riffs, pick the notes that will make the music sound seamless and beautiful. All the sounds should flow together perfectly. Once you learn these basic tools, you should pick some easy sounds and practice them so you get the idea of how your ...
There's a proper and improper way to line a baseball field. Learn how to prepare the ball field the correctly in this video. After the field has been mowed and leveled, you can place the bases and begin to line the field. You'll learn that the proper way to line each baseline is to take a cord reel with a stake attached. Place the stake down on your starting base or home plate, and pull the cord to your ending point. This way you can make sure your line is correct before you begin lining. Onc...
See the proper method for doing push-ups and press-ups on a Pilates Reformer exercise machine. With pilates, as with any physical fitness system, a basic mastery of proper technique is essential for both maximizing the effectiveness of your workouts and avoiding accidental injury. Whether you're looking to slim down or merely tighten up your core, you're sure to be well served by this home fitness how-to from the folks at Balanced Body Pilates. For complete instructions, give this free exerci...
If you're looking for a great way to get the proper nutrients to your yard, you're about to find out. Aerating a yard is an easy task that involves you placing holes in your yard on purpose. This may make your yard look a bit ugly, but it helps with getting the proper nutrients and oxygen into the ground.
When you start playing racquetball, you will need to master a few moves. In this tutorial, learn how to perform a backhand splat stroke. This video will show you all of the proper techniques to get you started on the court. Once you get down the proper moves, you will be a force to be reckoned with at the gym.
HaverfordHighSchool shows viewers how to do a proper cartwheel. First, your starting position should be a lunge - with one foot forward, hands up in the air, and palms forward. Next, you should reach forward and put your hands on the ground. While doing this, you should kick and push off of the ground using your foot and swing it over your head. After doing so, you should return back to the lunge and finally land in the lunge position. Remember to keep your body as straight as possible and fi...
In this how-to video, you will learn how to do proper placement or postural alignment in classical ballet. First, make sure the tail is down, the ribs are in, and the back as flat. Also, make sure the arches are up and fingers are relaxed. You want to create as much space between the armpit and hip as possible. Do not stick the rib cage out and lift up the pocket muscles. Let the back be free. The legs pull down to the ground while pulling everything up and out. Just remember, bring the bones...
Fractions are numbers of the form a/b, where a and b are integers. Fractions are also called as ratios. Fractions are further divided into proper fractions and improper fractions. Proper fractions are those where the numerator is less than the denominator and improper fractions are those where the numerator is greater than the denominator. As fractions are ratios a fraction can have many equivalent forms. Multiplying the numerator and denominator of a fraction with a same number gives a fract...
In this video tutorial, viewers learn how to cure a push shot in golf with a proper ball position. If the ball is too far from your stance, you will not be able to make full contact. You will hit the ball to the right instead of hitting it straight ahead. Have the ball positioned so that as your body makes it's rotation, you'll catch the ball the moment the club goes down the target line. This video also provides a drill that will help viewers to properly position the ball. This video will be...
Friction from the water plays a major role in slowing you down when you are swimming. Without proper form and technique, your body will drag in the water. Decreasing drag can greatly improve your speed in the water.
This video shows how to ollie higher on a skateboard. It has demonstrations from Melvin the Nerd, who shows proper technique to ollie. The ollie is done best when your board is pushed backward as you are jumping, then pushed forward as you are elevating. To practice while moving, jump over an upside-down skateboard. Once you can do that, try over an upside-up board until you reach consistency. Keep adding boards or moving the distances until you become better. If you're having trouble, preten...
In the dead of winter, here are some tips to change your image to something more stylish and sexy in a few minutes. Using the proper accessories such as a scarf, hat, and the proper coat, you can completely change your look. Combinations of different accessories are just what you need to transform your look without having to change your clothes or your hairstyle. This video is a very interesting way for the average person to switch up their looks and look fashionable in the winter.
Lowe's home improvement expert Mike Kraft is back again to show to help us install laminate wood flooring in our homes. It has been assumed that proper sub-floor preparation has been done. All the tools, equipment, and materials are gone over in detail for your safety. Proper tests for moisture are described which is very important when dealing with concrete. Laminate floors are called "floating floors" because they are not physically joined to the sub-floor and can be installed over many dif...
This video teaches you how to hit the ball straight using proper golf stance. Golf tips magazine presents Joe Durant, one of the best PGA Golf hitters in the league. He first tells us the problems with bad posture in amateur golfers. He shows us the bad posture and then demonstrates why it goes wrong. Secondly, he shows us good posture. He bends his back slightly with a slight bounce in his legs. After following the instructions he says, you will be well on your way to hitting like a pro!
Pomegranates are very delicious fruits. They are very nutritious, too. This instructional video teaches you how to eat a pomegranate in the right and proper way. It teaches you how to eat pomegranate with using a juicer, glass or knife. First you should start crushing the fruit from the middle top of it. You have to go on crushing it slowly and gradually with out applying too much pressure on the fruit. at one stage you will get a small hole on the surface and you can start drinking the juice...
Team USA coach Ken Yokobosky on finger tip grip. This bowling lesson demonstrates the proper fit bowling ball finger tip grip.
This is a guided hands-on laboratory activity to help a student understand the proper and safe use of a multimeter to measure electrical resistance. These two video guides the student through the proper techniques for measuring resistance with a multimeter, but you'll need some assorted resistors, a rectifying diode, a photo cell, an electronic labs kit, and some other stuff.
Dumbbell flys are some of the best exercises out there for building your chest. However, many people don't know the proper way to do this and their workout suffers because of it. Follow the techniques and advice in this video to start building killer pecs.
The check just arrived; now what? Whether you sipped tap water all night or ordered a rare bottle of wine, we have an answer. Learn how to avoid over paying. Follow proper bill splitting etiquette with this how to video.
Start with a faint outline of the leopards head which is an oval shape and is body which is connected to the head, then add the outlines of the legs ears and tail. In the oval draw the proper perspective lines for the face of the leopard. Now draw the outline of the tree or branch the leopard is laying on. Begin to darken the outlines, drawing with proper perspective, while adding the outlines for facial features. Add your shading depending on your light source then begin to erase the faint l...
Worried your canine might bite somebody? Afraid to take them on walks anymore because of what could happen if a child walks past you? Afraid of a lawsuit? These are the worries associated with overly aggressive dogs. But with proper training, an aggressive dog can be transformed into a well-behaved companion you'll love having at your side.
Crimp can be made easily and covered to the jewelry by using the following instructions. First purchase the proper supplies of crimping tool. This tool acts like pliers and is used by placing the bead in the appropriate slot at the tip and then squeeze the handle together. The multiple slotted tips are the key to the tool, and are needed to create a proper crimp. Then, select the proper crimp bead. The thin metal crimp beads come in a variety of materials and sizes. This will be used to secur...
Check out this instructional RV video to learn how to maintain the LP gas system on your recreational vehicle. Open up the compartment and you will see your LP tank. There is a gauge that tells you how much is inside the tank, there is also a fill station where you fill it up, always make sure the cap is returned after filling it up, so no debris gets inside. There is also a pressure release valve so when you are filling it, the pressure can escape through there so you can get the proper amou...
If you suspect that there may be something wrong with the fuel pump on your Saturn car, you should make sure you have proper voltage in the connector in your trunk. If you do, the next step is to check the ground.
Battery drain is one of the biggest issues with Android phones, but with proper power management it is possible to do something about it. Advanced Task Killer is a free app with customizable settings that shuts down apps that are no longer being utilized. This informative video takes you step by step through the different configuration settings.
Learn how to tie subframe rails together with a Millermatic welder as this 1981 Camaro gets rebuilt into a racecar. In this video, Jeri Ellsworth welds the rails and shows proper preparation and technique. Tools and materials needed for this project include 1 3/4 x .120 tubing, an "Affordable Bender" tubing bender, a Millermatic welder and a Hypertherm 43 plasma cutter.
It's sometimes referred to as simply DC— the double crochet. It's about twice the height of single crochet, and is very popular for creating a looser feel. This video will show you the steps to making a double crochet. Just listen closely and follow along to learn the proper crocheting technique. You just need your crochet hook and some yarn.
Missing the pure fundamentals when it comes to crocheting? Well, this video will teach you one very important method— triple crochet. Listen closely and follow along to learn the proper technique of stitching the triple crochet. You just need your crochet hook and some yarn.