Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 4nd installment of his "YouTubers Love Excel 2007" or YTLE2k7 series of free video MS Excel lessons, you'll learn how to use conditional formatting to add red to negative numbers and green to positive numbers using a single True/False formula!
For all your origami enthusiasts, take your art of origami to greater heights by using a dollar bill to create the impossible—fireworks! In this two-part video tutorial, learn how to fold origami fireworks from a single dollar bill. It's a great origami project for the 4th of July or New Year's Eve.
Creating text that catches the eye can be difficult. One great trick is to have your text actually composed from an image. Using Photoshop CS4, you can quickly create professional-looking text from a single or multiple images. Watch this video tutorial to find out how.
A gift is doubly special when the box it arrives in is also a gift. In this video, we'll see how to transform a single sheet of paper into an elegant gift box. This project isn't ideal for beginners, but if you have a little origami experience this shouldn't be too challenging.
If you find yourself in a tricky situation, such as your hands being bound together by handcuffs, you might be wondering how to get out of them. Well, with merely a bobby pin, you can pick your way out of most handcuffs using the technique shown in this video. Your bobby pin will need to be properly shapen for this to work. The handcuffs used are single and double lock handcuffs.
Welcome to a tennis lesson from FuzzyYellowBalls, the the best place to learn how to play tennis online. Our free video tennis lessons teach you how to play the game in a new way that combines technical analysis, visual learning, and step-by-step progressions.
This is an instructional video to learn the line dance for Alan Jackson's new single, "Good Time." Alan Jackson is a star country singer and known for making great music to line dance to. He's a Grammy winning artist that inspires many to learn line dancing so that they may participate at his huge stadium concerts.
A below elbow arm amputee demonstrates how to don and operate his body powered prosthetic hook. This video is made to help individuals use adaptive equipment and prosthetics for getting around with one arm. This is an equipment overview for amputees or individuals that have single limbs and need a hook prosthesis to enable them. It's equipment for handicapped or disabled individuals as taught by a man with a below elbow amputation.
Watch this instructional drawing video to draw and color a cartoon. Use a calligraphy pen to draw think lines and thin lines with a single pen. This allows you to draw expressions quickly and decisively. With a clean brush, dampen the paper where you want to add color. Mix marker colors with water to mix a quick watercolor palette.
Learn how to draw cartoons faces and expressions with a few simple lines. A professional comic strip in a book or a newspaper carries an idea across using a minimal amount of lines. Use a calligraphy pen to draw thin lines and thick lines with a single pen. This allows you to draw faces expressively and quickly.
Aperture's advanced filter and search tools make it easy to find an image or a group of images within a single project or album, a folder of albums, or across your entire library.
All digital cameras automatically record the date and time each photo was taken and store this time stamp as metadata within each image file. In Aperture 2, you can change these time stamps. This is particularly useful if the clock in your camera is set incorrectly or if you're trying to synchronize photos taken by multiple cameras at a single event.
With iPhoto and Mac OS 10 Mail, or other email programs, you can easily share photos with friends and family. You can send a single photo or multiple photos.
With a photo printer and photo-quality paper, you can create high quality prints of your photos. Using iPhoto, you can print a single image, multiple images, an album, or a reference page of thumbnails called a contact sheet.
A OneStep DVD is a great option if all you want to do is create a DVD that plays a single video with no menus or navigation.
In this lesson, Jared demonstrates four simple warm-up exercises that you can use to improve your drumming. They focus on hand to feet synchronization, and both single and double stroke rolls.
Charles Sedlak teaches you about three strokes and Arpeggio techniques for playing Flamenco. Learn how to play these chords, single note at a time. The strings will love you for this.
The single-player campaign mode in Call of Duty: Black Ops may be intense, but the multiplayer mode is a bloodbath of pure addiction. Black Ops takes the super successful formula of Modern Warfare and adds its own special twist. There's some changes, and Jessica Chobot from IGN Strategize is going to tell you all about them!
Michelle Trap, a Certified Personal Trainer from Gold's Gym, teaches the viewers how to do barbell leg squats. First, use the Smith machine to do the leg squats. It is beneficial because the machine holds you in place. You will also need to place a bench behind you since you will use this when you lift your legs. Rack the barbell slightly lower than your shoulder and have a slight split stance with your front food centered. With this stance, take your back legs and place it on the bench behin...
Check out this informative video tutorial from Apple on how to enhance your photos with a single click in iPhoto '09.
This video demonstrates how to create a one point perspective drawing. You begin by making a horizon line across your paper and adding diagonal lines from the corners which will all converge at a single point along your horizon line. You can then create boxes by creating squares or rectangles around the lines extending from the central point. The outer edges of your rectangle can further be connected to your single point in order to create a 3-dimensional shape for the boxes and cubes which y...
Artists discovered the almighty vanishing point during the early Renaissance and haven't stopped using it since. The genius of the vanishing point is that it gives a three dimensional quality to a two dimensional space, meaning increased depth perception and more believability.
In this video, Shirley shows her viewers an effective way to multiply your red fountain grass in order to create more grass from a single plant. After the growing season, find a large, overgrown patch of grass and use a shovel to dig out a section by the roots. After planting the grass in a pot, it is crucial that you shear the top of the plant so that the grass is only 4 to 5 inches tall. This will ensure that the plant focuses on growing roots rather than its blades at the moment. This meth...
This crocheting tutorial demonstrates how to do a chainless single crochet foundation. Foundation stitches replace the traditional foundation chain as well as the first row of stitches. It comes in handy when you don't know how many stitches you need to "cast on" for your project. The traditional method creates a tighter row. This method creates a stretchier row that will more closely match the rest of your rows. Watch this crochet how-to video to learn more about chainless crocheting.
More than any expensive exercise machine, more than any fad diet, and more than even having a trainer, the single most important thing you can do to lose weight and keep that weight off is to have willpower. That means having the courage to overcome cravings and eat healthy, and to work out rather than watch "Friends."
This video presents an overview of how to do a loopy fringe when crocheting. It's easy; all you'll need are loops of twelve chain stiches and then single crochet. For a complete overview, and to get started incorporating loopy fringes into your own garments, watch this video tutorial.
Make your milk come alive using this at home science experiment! Mix a few drops of various colors of food coloring into a shallow dish of milk. Then add some dish soap, and put just a single drop into the middle. Then watch the ensuing cool effects!
Tetris is without question the most popular single video game of all time, played on everything from keychains to the sides of skyscrapers. It's iconic song is a Russian folk song called "Korobeiniki", written in 1861, and in this video you will learn how to play an easy, beginner version of the entire song on piano.
As a Bass player you should probably try to learn every single Police song that you can. After all, they made a name for themselves for mixing unique styles such as Reggae, 80's rock and more! In this video you will get a tutorial on how to play the Police song "Walking On The Moon".
In this video tutorial, you'll learn how to view multiple folders within a single window when using Ubuntu Linux 10.04 Nautilus. It's an easy process and this video presents a complete guide. For more information, including a full demonstration and detailed, step-by-step instructions, watch this helpful home-computing how-to.
Yojimbo is a great Mac program which allows the the user to collect bookmarks, notes and entire webpages and assemble it into a single document. This tutorial shows you how to get it and then takes you on a visual tour of the program.
This tutorial takes four separate photographs and then uses several Adobe Photoshop techniques to blend them into a single background image. Using the layering and color overlay technique, this video demonstrates how you can get this unique and clever photo effect.
Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2007 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started formatting your own MS Word 2007 documents, take a look.
Iyaz is the next singing sensation to emerge from the Carribean, and his hit single "Solo" is awesomely catchy. This video will teach you how to play it on the piano or keyboard quickly and easily. The video only shows the left hand part because that is the backbone of the song, and the right-hand part is up to you to interpret as you see fit.
If you're a beginner piano student looking to improve in both music theory and practical piano playing skills, then this tutorial on how to play tetrachords is perfect for advancing your skills beyond playing single finger melodies.
When you've mastered the single crochet and have gotten a hang of the double crochet, it's time to really step up your knitting game and start the triple crochet, a more difficult but rewarding type of stitch that creates a very tightly woven fabric.
Learn different ways to create iMovie credits sequences using the titles feature. You can do more than just scrolling credits by stringing along sets of single-name titles or using images. This home-computing how-to from the folks at MacMost will get you off and running. For detailed instructions, and to get started making your own titles sequences within iMove, take a look!
This trick is fascinating! Check out this tutorial for advice on how to balance heavy objects like two forks on a single toothpick. This video will show you how to take two forks, two toothpicks, a wine bottle and a cork and make it all balance. You can thank gravity and this clip for all the free beers you are about to get!
Looking for an easy craft project? With this guide, you'll learn how to make a lucky paper stat from a single strip of paper using origami, the traditional Japanese folk art of paper folding. For more information, including a step-by-step overview of the folding process, as well as to get started making your own paper stars, watch this free origami lesson.
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 357th installment in their series of digital spreadsheet magic tricks, you'll learn how to pull data from individual sheets to a single master sheet given improper data setup.
