New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 497th installment in their series of digital spreadsheet magic tricks, you'll see a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock) for each store or branch of the company.
The Concrete Jungle guide to making concrete moulds and ornaments as a hobby or business is presented here. This is a short excerpt of a longer film. Mixing the concrete is presented. It is important to get the correct consistency to make the ornament successfully. Other features include the ingredients used and the filling of the latex mould and removing the mould. The mixing ratio for the cement is 4 parts gravel (6-10mm), 2 parts coarse sand, 1 part cement and water. The consistency should...
This video is about determining the right camera for the tripod.The video begins by explaining the ways of doing this, that is by ensuring that the camera is neither too large nor too small for the tripod and also by ensuring that the tripod is able to withstand the weight of the camera.When the camera is placed on the tripod it should be a right match for the base ply of the tripod and should not be lager or smaller than the base ply.This video is excellent for those who want to select the r...
In this video tutorial, viewers learn how to set a beautiful dinner table. The utensils, flatware and glassware is paramount is correct setting. The utensils are arranged in the order that a person uses them. The butter knife, forks, napkin and bread plate are placed on the left of the dinner plate. The knives, spoons and drink-ware are placed on the right of the dinner plate. Utensils and flatware are lined up about 1" from the table. There should never be more than 3 utensils on the side of...
This how to video shows you how to configure Microsoft Outlook 2003 to access an exchange server. This is useful if you want to use the program with an exchange server and do not know how. First, open up Microsoft Outlook 2003 on your computer. On startup, click next and yes. Select Microsoft Exchange server and click next. Uncheck use cached exchange mode and enter the server name. Enter your user name in the correct form and click check name. It will not be filled in. Click next and then se...
This is a video tutorial that is showing its audience how to play and master the song "Take Me Out to the Ball Game" on the ukulele. The first step is to grab your ukulele. Next you should play the following notes: C, G7, C, G7, A, Dm, Dy, G7. Then you will repeat this section of notes in tempo once again. Next you will play the following set of notes: F, A7, Dm. Then you can play F, and Ebdim, C, Cmaj7, C6, A6, G7, C7. Then finally end the song with the note G7. To fully play this song you m...
In this how-to video, you will learn how to prevent your new puppy from play biting. In the first 12 weeks, your puppy will start to bite. Encourage the puppy to lick your hand rather than bite. If the dog accidentally bites you, mimic the sound of a dog yelping. This will make the puppy respond by backing off. If your puppy is chewing on objects such as clothing or shoe laces, make sure you correct the behavior with a chew toy. Stick to it, as this will take time and patience. Viewing this v...
This video shows you how to tune the ACME attacker 1/8th scale nitro engine buggy. Use the high end valve and the idle speed screw as show in the film. Turn the engine and get it to the operating temperature and drive round to the see how the car performs. If the acceleration is sluggish then the low end valve should be adjusted. If the engine is having too much RPM then the idle speed should be reduced using the idle speed screw. If the engine bogs down and makes noise on full throttle and i...
In this how-to video, you will learn how to make a wooden bonsai pot. You will need pressure treated wood made of all weather oak. You will also need a strain brush and nails. Assorted plastic bins will also be needed. Drill holes into the bottom of the plastic bin. Next, cut it to size. Cut the pieces of wood to the correct size and then line and tape them up. Next, nail the wooden pieces together. Now, place two pieces of wood on the bottom for legs. This allows air to flow beneath the pot....
In this how-to video, you will learn how to update your iPhone or iPod touch to 3.1.2 firmware for free. First, make sure you have iTunes installed on your computer. Download the correct firmware for your specific model on the internet. Once this is download, open iTunes and select your device. Hold the shift key and click restore. Select the firmware file and open it. Hit the restore button in the new window. This will then update the device. This may take a while. Once it is done, the updat...
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...
Rebecca Robeson shows you how to remember which side of the plate to put the fork, knife and spoon. To set a table the correct way, follow these steps: The word 'fork' has four letters, as does the word 'left'. So, the fork goes on the left. The word 'knife' has five letters, as does the word 'right'. So, the knife goes on the right. The word 'spoon' also has fiver letters, so it goes alongside the knife. Remember that the safe side of the knife, the dull side, faces out to anyone sitting nex...
Learn how to say "Good night" in Polish in simple and easy steps. 1. First find out the correct Polish word for the English word "Good night" which is "dobranac". 2. Now spell out Polish correctly without any spelling mistakes. 3. Try to speak out the word slowly and ensure you pronounce the Polish word exactly. 4. Practice it a few times until you pronounce it correctly without any mistakes.
Use a q-tip (ones for little kids will have a larger base, but are not required). Put a few drops of red food coloring in a glass of water and stir it up as necessary. Dip q-tip in red water, get it nice and saturated. Remove q-tip and let sit overnight. Cut q-tip in half, then take a small rectangle of paper, apply glue from glue stick to one side, then make a small fold from a corner and roll (this may take some work). Use scissors to cut down to the correct size. Next rub q-tip's cotton si...
When a scene is filmed, problems can occur in the final outcome of a scene if the white balance is not set correctly. If the white balance is off, a scene may look too orange, blue, or the color is just off in general. This video tutorial shows how to set the correct white balance on your video camera. White balance is what the camera considers to be white. Most cameras have white balance presets for both indoor and outdoor. This is because the light we perceive will vary depending on whether...
This Sports video tutorial will show you how to practice away from the golf course. This video is from Golf Link. Sandy LaBauve presents this video tutorial. You can work on your grip while watching TV. Sitting on your sofa, take your golf club and keep on practicing on the correct grip. Make sure the face is square, use the visual check points, lower your hand and feel the grip. Check your posture in the mirror. Use your backyard to practice your arm swing. And finally you can work on your p...
This is a Fine Art video tutorial where you will learn how to cut plate glass. Measure the plate glass and make sure the measurements are correct. Then place the guide along the line of the cut, take your glass cutter and score along the edge of the guide. If the plate is small in size, take the base of the cutter and place it underneath the score mark and apply equal pressure with your hands on both sides of the score. The plate will snap with a nice clean cut. Another way to snap the glass ...
In this video tutorial, viewers learn how to avoid a bad finish to cure a golf push shot. Usually, when players make a swing for the ball, their arm separates from their body. This will take the club to the right of the target and as a result, pushes the shot. To correct this, connect your left arm to your left side as you make a swing. This will allow the club to stay with your turn and go down the target line. This video will benefit those viewers who enjoy playing golf and would like to le...
Have you ever thought of tuning your ukulele or guitar with your personal computer? Why not? One of the advantages is greater accuracy. Don't fiddle around too much with the instrument - just select the correct notes, and you're well on your way to a finely tuned ukulele or guitar. Get the most out of all your tools! Watch this video to learn how to tune your instruments properly!
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...
In this video tutorial, viewers learn how to prevent slice shots in golf. Slice shots are when the ball curves in the shape of a banana. A mistake that people make when they swing is that they drag their hands to far in front of the golf head, causing a slice shot. It also releases the head of the club too late and turn the club into another direction. The correct way is to swing and hit the ball at a straight line from the left shoulder to the club. This video will benefit those viewers who ...
This Home and Garden video tutorial is going to show you how to repair damage around wall elements such as outlets. The video demonstrates how to repair a gap around a socket that was created due to a miscalculation on the part of the mason. The simplest way of repairing this would be to take the cover off, get a patch which is pre cut to the correct dimensions, peel it off, place it correctly over the opening in the wall and press it on. You could paint the area with matching color. Then put...
This video turns teaches how to draw Peter Pan with ease. In less than 2.5 minutes he is drawn. Not only is he drawn be he is also colored. The drawing starts with a simple outline of the head and body. Color is then added to the hair, face, and clothing. Then some simple shading is done in the correct areas, such as the hair, eyes and shirt. It is so easy one could easily draw it by hand or on the computer using a paint-like program. The complete drawing is very recognizable and also very si...
In this video the instructor shows how to find out the fourth roots of a number. The properties of fourth root says that for any positive number of a, its fourth roots are real. And for any negative value a, its fourth roots are not real. So split the number inside the fourth root as the product of two perfect squares and then cancel out the power with the fourth root giving its roots. As the fourth roots of a positive number are real, the answer you get is correct. But you cannot find out th...
This video discusses how to add a sound effect to your video in Pinnacle Studio. You first select the video you wish to add the effect to and then, on the left hand side, select the sound effects button. It looks like a loudspeaker with a few lines coming out. The options include humans, gunshots, animals, instruments squeaks to name a few. You then have a variety of different sounds from that genre of effect. Select one and then drag the effect to the time bar when you want to have the effec...
Wrapping your wrists for boxing is very important to provide protection and support when you are throwing your punches. This video shows you the right way to wrap your wrists to prevent injury. You'll be putting the seam side of the wrap against your skin, and start by putting the loop at the end over your thumb. You will start by wrapping the wrist a few times, depending on how long your wrap is. Watch to see the correct way to cover the knuckles and secure the wrap against your hand before ...
In this video tutorial, viewers learn how to play the song, Silent Night on the violin. Silent night is a popular Christmas Song that can be played on the violin very sweetly. The song is slower and this video will show you how to play the correct rhythm and notes. This video provides all the string movements and order that the notes are needed to be played, in order to execute the song. This video contains voice narration and a visual demonstration for viewers to easily understand and follow...
This tutorial will help you uninstall software or programs from Windows XP. It can be used easily by beginners who have limited knowledge of the operating system. The instructor shows a visual step-by-step tutorial on how to find and use the Add or Remove Programs feature, clearly explaining and showing what you need to do, including some extra advice on follow-up checking. Make sure that when you do go to Uninstall a Program that it is the correct one and read all of the screens during the p...
In this video our musician friend is trying to teach the viewers how to play "Handlebars" by Flo bots on the violin . This proves to be quite a special lesson because it consist in using your finger from your right hand to pinch the chords of the instrument . He is showing us the best technique to use and the correct notes to sing this difficult song . After following the instruction of this step by step video , you will have a whole new vision regarding this rare way of playing the violin . ...
In this video you will learn how to make a cool looking paper box in a couple of minutes. To make the box you need to follow these steps: 1. You will need to bend the sheet of paper exactly like in the video.
This video, from Superior Building Supplies, demonstrates the proper technique for cutting the inside corners of crown molding. The presenter suggests downloading several diagrams from the Superior Building Supplies website. These diagrams show the correct position of the miter for several different cuts. When using a miter saw think of the fence as the ceiling and the table as the wall. Cuts for inside corners will always be made using 45 degree angles on your miter saw. Using these techniqu...
Know a little bit about film lighting, but can't quite grasp the concept of using light meters to measure light for proper exposure? You can't rely on your video camera to accurately capture what you see, so you need light meters to properly and accurately capture what you have created on set.
This video teaches you how to make small polymer clay pocket mirrors. You can put these in your purse or even wallet. It is a good gift, as you can customize them for the person you indent to give. Get small mirrors from a craft store. One technique is to make a separate cover for the mirror using clay. Another technique is to cover the whole mirror with clay. You can also create two separate covers. One on the back of the mirror and the other for the front. Stick the clay on the back of it a...
In this video, you will learn how to play the major chords on an acoustic guitar, including A, B, C, D, E, F, and G. First, you will be reminded to tune your guitar before playing these chords, which is important. You will be shown each chord, one after the other, and told the correct finger placement and exactly how to play them. With one camera showing the whole guitar and how the presenter is playing, you can also see a separate angle showing a close-up of the fretboard, and the position o...
If you want to learn how to play David Bowie's "The Man Who Sold the World" on the acoustic guitar, follow the steps in this video tutorial by TboneWilson. Tbone begins his tutorial with the introduction showing what strings to strum and what techniques to use. He then takes us through the various verses and chorus first strumming the strings, and then playing them at the correct tempo of the actual song. Follow the steps in this video to learn how to play "The Man Who Sold the World" on the ...
Richpin's Auto Repair shows you how to properly identify the rear axle of a Jeep Grand Cherokee. This information will allow you to obtain the correct information for replacing this specific automobile part. The video will show you where you need to look beneath the vehicle to find out which style of rear axle your Jeep Grand Cherokee has. You'll be shown where to clean the dirt off of a specific area of the axle to obtain this important information. In this particular case, the rear end axle...
Learn how to troubleshoot a toilet that won't flush at your home in simple steps. First lift the lid and check whether the float ball is broken or touching the sides. Bend it a little if its touching the sides or replace it if its leaking or broken. Now check condition of the flapper valve and replace it if needed. Now check the handle, if its loose tighten the screw inside to fix it. Finally check the chain and replace it if broken or correct it to the right tension to lift the valve.
Learn to say three romantic phrases in Polish, such as "I love you", "You love me", and "We love each other". When it comes to learning key phrases in different languages, nothing beats good old fashioned repetition. Speak the phrases one at a time, one after the other. Then repeat, as often as necessary, until you get them correct. Don't worry if you mess up, keep going! It can take some time to get it right.
The creative minds at Soulstyle show you how to juggle three clubs at once with some excellent tips to help get you started. Start by tossing one club in the air and catching it in the correct spot before you more forward into juggling. Once you've got that down pat, toss two clubs back and forth, in the shape of an "X" until you are completely comfortable with that. Keep your eyes focused on the highest point of the "X" and avoid the temptation to watch your hands. When you've mastered two, ...
This short tutorial will give you advice on approaching multiple choice exams. A multiple choice exam consists of one question and four possible answers, and only one of these answers will be correct. Make sure you know the layout of the answer sheet, and understand where you must mark your answers. Be careful of the trick answers, as there will almost always be one. read all the answers carefully and make sure you don't mark two answers for a single question. If you don't know the answer, ju...
