Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 348th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to build a formula that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock).
To make a french spiral bouquet you first start with straight stemmed flowers such as roses. It is very important that you rid the stems of foliage such as leaves as well as removing all the thorns. You can do this by using a gardening glove or washcloth and sliding it down the stem. Once that is completed it is time to begin the bouquet. The first step is to pick a base flower. It is important to use a flower that has a straight stem. From there you begin to add flowers by crossing them with...
Nick from Greyscale Gorilla shows you how to take your flat, uncorrected footage from a DSLR like a Canon 5D or 7D and make it sing.
Michael from Mauro Media demonstrates how to simply update the firmware for the Canon 5D Mark II. In a few quick steps, you're up and running, shooting full manual video mode and correcting many previous issues associated with the 5D's first build.
Picking up the flute and look for the most basic of lesson? In this tutorial for beginners, learn how to play the E note on the flute. Correct fingering for the E note is gone over and demonstrated by Dan Lefler of Danman's Music School.
Looking to practice and improve your chipping technique in golf? Pay attention to the straight angle of your front arm. Learn the correct form for chipping by watching Mel demonstrate common chipping mistakes.
To play footbag, you only need a footbag (and some feet), but you can't kick that hacky sack around unless it's clean. Watch this video tutorial that will teach you how to properly wash and clean your footbag, to restore it to its original beauty. That little round 32 panel bag of yours won't draw any attention if it's not cleaned the correct way. See how!
Classically trained singers will tell you that screaming is the worst thing you can ever do to your vocal chords, but if you're into singing/screaming heavy metal or rock then it's necessary to know how to scream with minimal damage.
Hairdressers swear that shampooing the correct way does make a difference. Learn how to properly wash your hair with his how to video. You will need:
Learn how to make a beautiful origami swan. Watch this origami video for all the correct folds - be sure to practice if you want your origami swan to come out flawlessly.
Get an instant boob job, just by putting on the right bra. Wear a white t-shirt when you go bra shopping (if your breasts look good under a white shirt, they will look good under other colored shirts as well). Learn how to calculate your correct bra size. Minimize the appearance of back fat and accentuate your cleavage. Replace your bras every six months.
A light meter can prove to be an invaluable tool on any film set, allowing you to quickly and efficiently set lights and know the correct exposure values of those lights. Light meters were initially designed for still photographers and cinematographers can easily calibrate them to a given film stock speed for shooting film. But what about today’s digital cinematographer? I’m glad you asked. In this video tutorial you'll see how you can use a light meter to quickly and efficiently light a scen...
Microsoft Outlook 2007 Tip - Setup Signatures for Multiple Email Accounts - One of the difficulties with using multiple mail accounts is making sure your messages have the correct signature, or sig, attached to them. The new Signatures feature in Microsoft® Office Outlook® 2007 takes the hassle out of creating and applying signatures to your email.
This Adobe CS4 tutorial shows you how to achieve accurate PDF content with Acrobat 9 Pro. Make your PDF look right on-screen, in a browser or in print by using enhancements to previewing and color conversion tools within Acrobat 9 Pro. Learn how to maintain consistent and correct PDF output with this Acrobat 9 Pro tutorial.
Look at these examples to begin drawing figures in space. It always helps to begin with a cube. Even if the form isn't anatomically correct, it will appear believable of the forms are drawn in relation to other objects. Watch this instructional drawing video to draw human figures using a few visual examples.
Sometimes, there's no way to avoid a fall. If you are aware of the inevitability of a fall, you can at least prepare properly to fall. Watch this video safety tutorial and learn how to fall down the correct way forwards or backwards, all the details on how to do it safely to reduce the risk or lessen the severity of injury.
This Adobe Photoshop tutorial covers using adjustment layers in Photoshop CS2 to help out a badly desaturated photo from the early '70s. Learn to use Photoshop levels, curves and color balance tools to color correct and fix faded old photos.
Watch to learn the correct way to hold a cello bow. This is good for beginners because it requires no prior knowledge of cello or string instruments.
If you are having trouble getting the right thread tension for your sewing machine, check out this video.
Trying to learn the English language? Then it's vital to start with the basics: the alphabet. Learning larger words won't be difficult once you understand how each letter of the alphabet is pronounced.
Using a computer screen and a sheet of glass you too can create a hologram! As this video shows, simply use the correct monitor (depending on what you want to do) and a piece of glass positioned appropriately to create the holographic image.
Learn how to make this classic vodka drink, the Cosmopolitan from acclaimed bartender Anthony Caporale, of The Art of the Drink. He shows how to put in the correct ounces of vodka, cranberry juice, triple sec & lime juice and he also shows very interesting techniques with the lemon garnish as you will see when you watch.
Quinten shows us how to protect your hands in boxing using a correct hand wrap in this video. When you punch something, you put a lot of pressure on your hands and wrists so wrapping your hands before this is highly recommended. First, start on one end of the wrap and put your thumb through the loop at the end. Go over the top of the wrist first, then go over the top of the hand over the knuckles. Keep your fingers parted so the wrap doesn't become too tight at the end. Go between the knuckle...
In this video Chuck Cook shows how to correct the push shot posture. He demonstrates that the correct posture for the shoulder should go down and out toward the ball which drives the club head around back to the left. To obtain this posture, stand with the feet shoulder width apart, the back should be straight up. Take the club handle and stick the end into your belt buckle with club head sticking straight out. Next extend the arms straight out keeping the club at the level of your belt buckl...
There are many different effects and filters in Sony Vegas Pro 10, and one of the plug-ins you can use is the "Sony Color Correction" option. Using it, you can edit your video to apply color correction effects to your movie or film.
A DLC update to Mortal Kombat 9 has introduced the blood thirsty combatant Skarlet to the mix. Like the other Mortal Kombat characters, Skarlet comes equipped with several fatalities unlockable using the right button combinations. Take a look at the top of the screen as the folks at Rooster Teeth showcase each of her fatalities for the correct button combination necessary to perform them!
In this video, expert yoga teacher Kay Bray shows you how to correctly assume what's called a dancer's pose when practicing yoga. This pose will not only help improve your balance, it will also help focus, strengthen and extend your body.
If you want to learn how to do a headstand in yoga, the first step is to make sure you have sufficient upper body strength. Then, find the right position to make sure that your body will be in the correct and safe alignment.
Cake pops, popularized by bite sized goddess Bakerella, are a food fad that you should definitely sink your teeth into (literally), but to make sure your cake pops appear professional and uniform you have to consider your sizing.
If you've made any donations to charity this year, there are several important rules about deducting charitable contributions on your tax return. Most importantly, the correct paperwork is needed to document the transaction for the deduction. Find out in this informative video from IRS.gov.
This seam is ideal for use on garments that will be washed often, such as lingerie or children's wear. It also adds a professional, finished look to your final garment. Here's an easy and quick way to sew your own French seam.
This tutorial shows you how you can draw a picture of Eminmem almost completely from memory. Draw the rap star in three quarters view, and make sure that you have all the facial proportions (such as the spacing of the eyes and lips) correct.
So you have your figure, all mapped out and rendered. And now you need to make it walk. This tutorial shows you how to set up a walk cycle in Blender by arranging your various poses in the correct sequence for a realistic stride.
Osmos is a clever little indie game where you must have your cell incorporate all the other cells. This short video shows you the correct solution for level A2-3 of this game. Direct your cell around the petri dish using the spacebar!
Learn how to color grade your Call of Duty: Black Ops videos with the latest version of Sony Vegas Pro! Whether you're new to Sony's popular non-linear editor or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
Want to start drawing fantasy art? This tutorial shows you how to start in Adobe Photoshop and draw an imposing fantasy style dragon. Make sure you get all the scales, wings, claws and other features correct for your digital drawing!
In this free video software tutorial, you'll learn how to use the Saturation Curve editor when color correcting or grading footage in Color. Whether you're new to Apple's popular non-linear editor or a seasoned digital video professional merely looking to pick up a few new tips and tricks, you're certain to be well served by this video guide. Take a look.
The frame size of a mountain bike plays a large role in how effectively you will be able to ride it, and it doesn't translate readily into common measurements like weight. Watch this video to learn how to determine what frame size is right for you.
Many traditional Japanese homes lack the Western shower we know and love and favor instead the traditional Japanese bath called an ofuro. Like many activities in Japan there is a culturally tied correct process for using an ofuro, and this video will teach it to you so you can be clean and comfortable on your next trip to Japan.
Draw characters interacting with each other using Adobe Photoshop. This tutorial shows you how to draw two lovers kissing. Start with a basic line sketch to get your proportions correct, and then flesh out both characters as they embrace each other.
