Clip Talk Search Results

How To: Hack a Monster soda can to stash a beer bottle

In this tutorial, learn how to hack a can of Monster - or any large soda can - to stash a bottle. This is great if you are drinking a beer in public when you aren't allowed or if you'd just rather no one knew what kind of embarrassing beverage you are actually consuming. Follow along with the clip and learn exactly how to disassemble a simple can and use it as a cover for any bottle that will fit inside.

How To: Fix a blown-out sky in Adobe Photoshop

Looking for a guide on how to fix an overexposed sky? With Adobe Photoshop, it's easy. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from the folks at Britec Computer Systems. This video offers a step-by-step guide on how to repair a clipped sky.

How To: Perform a Cool Magician Magic Card Snatch Trick

Ever wonder how magicians can seemingly identify any card? Well, wonder no more! In this tutorial, learn how to identify a spectator's card when they randomly place it mid-pile. This sounds impossible and looks astonishing but, really, it is quite easy. So, follow along with this clip and you will learn all of the inside secrets to perform this trick on your very own.

How To: Highlight hot and cold areas in Apple Aperture 3

Ferret out any pixels with clipped highlights in Aperture. Whether you're new to digital photography or merely unfamiliar with Apple's Aperture 3, you're sure to benefit from this free video software tutorial from Lynda, which presents a thorough, step-by-step overview on how to automatically highlight hod and cold areas within Aperture 3.

How To: Work around the 1-rule data validation limit in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 144th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to work around data validation's one-rule limit by creating a second shrinking list that looses values as they are used in the data validation area.

How To: Update inventory records by formula in Microsoft Excel

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).

How To: Use the UPPER & EXACT functions in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 82nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the UPPER & EXACT functions to create a TRUE/FALSE formula to determine whether or not uppercase text has been entered into a cell.

How To: Average with the MONTH function in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 90th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll see a complicated average calculation with multiple criteria using the MONTH function on a date field. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Apply conditional formatting to a row in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 80th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to highlight an entire record (row) in a database that matches a bounced email addresss. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Calculate monthly sales with Excel's SUMPRODUCT & TEXT

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 45th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the SUMPRODUCT & TEXT functions together in 1 formula to sum the month's sales. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Take better time-lapse photos

Want to create a time-lapse video montage from photos shot on a DSLR? This tutorial presents a general overview of the equipment, settings and post procedures (e.g., cropping & color correction) necessary to create beautiful, finished-looking time-lapse clips. Get started shooting your own time-lapse segments with this free video guide.

How To: Embed a YouTube movie into PowerPoint 2007

Ever wish you could embed a YouTube video into a Microsoft Office PowerPoint 2007 presentation? If you have a live Internet connection when designing your presentation, and will have one when showing it, you can. And it's an easy process to boot. For complete instructions on how to put a YouTube clip into a presentation in PowerPoint 2007, watch this helpful video tutorial.

How To: Start and stop movie clips using buttons in Flash

TaskTutorial gives us an in-depth instruction on how to use Flash to create stop and play buttons. This is a great find if you are interested in creating videos with Flash program. These programs can also be downloaded for free on the website indicated on the videos page. Learn quick and easily how to use Frames and button applications on this easy to follow video.

How To: Do a slant gainer/cheat gainer

In this video tutorial the performer demonstrates the slant gainer, also known as the cheat gainer. Basically, it involves hurling yourself away from the ground, spinning in the air for a while and then trying to land without busting your ankles and/or head. If accomplished successfully, it looks extremely cool. If it ends in failure, at least you might get a hit YouTube clip out of it.

How To: Use Microsoft Office OneNote 2007

Do you ever wish you had a way to jot down an idea, and then illustrate it with a page from a document, a photo and a sound clip, all without opening multiple applications? Microsoft Office OneNote 2007 note-taking program is that advanced notepad, and is better than ever with new additions to the interface that make it even easier to organize yourself. For more on using MS Office OneNote, watch this video tutorial.

How To: Use keyframes in Final Cut Pro

This video editing software tutorial outlines using keyframes in Final Cut Pro. Keyframes enable a video editor to have different properties of a clip change over time (a la animation). If you are new to animating in software packages or Final Cut Pro, this tutorial will help get you started.

How To: Hit the angle shot

Check out this instructional tennis video that demonstrates how to hit an angle shot. Angle shots are hard to hit in tennis. Learn how to hit angle shots in tennis with this video clip.

How To: Hold a tennis racquet

Need tennis tips? Check out this instructional tennis video that demonstrates how to hold a tennis racquet. Learn about tennis fundamentals including the proper way to hold a tennis racquet in this video clip.

How To: Improve the sound of your digital camcorder

This video shows you how to upgrade your consumer camcorder sound capabilities using a camcorder XLR adapter, a simple device that mounts to the bottom of the camera. It then tests and compares the various types of microphones that can be attached, including the lavalier, sennheiser, handheld interview, and the wireless clip-on microphone. WAtch this helpful instructional video, and boost the sound on your camcorder for professional audio.

How To: Do power yoga also known as Ashtanga yoga

Watch this video to learn to do power yoga. In Ashtanga yoga, also known as power yoga, the yoga postures flow with an emphasis on strength and agility. In this video clip learn step by step yoga moves that will help you unite your body, mind and breath. And remember each pose can be modified to suit the practitioner's level of skill.

How To: Debunk the free candy cheat myth

This video clip shows you how you cannot fool any candy machine and debunks the mythical paper hacks in detail. Some say it works, some say it doesn't. Well, check out this video tutorial and decide for yourself what believe. It might just be easier to steal candy from a baby.