Whether you're the proud owner of an Apple iPhone 3G or perhaps just considering picking one up second hand, you're sure to benefit from this free video tutorial. For more information, including a detailed overview, watch this iPhone user's guide.
With this quick clip, you'll see how to easily create a 3D box inside of After Effects with a little help from a free script. Whether you're new to Adobe's popular motion graphics and compositing software 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.
Cyberlink Webcam 3 is a very fun piece of software to have if you use your webcam a lot. Why pay for it? This video will teach you how to get the popular software for free by downloading this file and installing it on your computer. Do this as fast as you can and then get back to Chatroulette!
Whether you're the proud owner of a Verizon LG Fathom Windows Mobile smartphone or perhaps just considering picking one up, you're sure to benefit from this free video tutorial, which presents a complete overview of the phone's various features and functions. For more information, watch this free video cell phone guide.
This clip discusses the process of downloading and installing Blender, the free 3D modeling and animation application. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instructions, take a look!
In this tutorial, learn how to easily download any music for free onto your Android phone by using the Music Junk app. This clip will walk you through the process of selecting and downloading this app from the Android Market and using it to add all the tunes you need. Rock on!
Learn how to achieve a stunning glass text effect. Whether you're new to the GNU Image Manipulation Program, GNU's popular free graphics editor, or a seasoned designer just looking to pick up a few new tips and tricks, you're certain to enjoy this free video software tutorial. For more information, including detailed, step-by-step instructions, and to get started creating glass-like text headers in GIMP yourself, take a look!
See how to create a splatter brush within the GIMP image editor. Whether you're new to the GNU Image Manipulation Program, GNU's popular free graphics editor, or a seasoned designer just looking to pick up a few new tips and tricks, you're certain to enjoy this free video software tutorial. For more information, including detailed, step-by-step instructions, and to get started making your own custom splatter brushes, take a look.
Overhauling the wheel hubs on your bike is important to ensuring proper wheel spin. Proper wheel spin means you get more power out of your pedaling. This video features a professional bike mechanic explaining how to overhaul the free side of a Mavic wheel hub. Keeping the hub clean is vital to making your rides as fun and easy as possible, so don't skip it!
Looking better (but equally free) way to burn DVDs from within Apple's Mac OS X? See how to use Burn, the open-source optical media authoring tool, acheive just that with this home-computing how-to. For details, including step-by-step instructions, and to get started burning your own discs with Burn, watch this home-computing how-to.
Connecting pvc pipes may seem like an easy task, but in fact it can be a difficult job for anyone who may not have done it before. It involves time, patience, and the right tools needed for making sure you have a leak free fit. So check out this tutorial on how to properly fit your pvc pipes. Enjoy!
Looking for a to-die-for flank steak recipe? In this free video cooking lesson, Bobby, of the Food Network's "Grill It!" prepares a grilled flank steak with a balsalmic vinegar barbecue sauce. For more information, including a full recipe and step-by-step preparation instructions, and to get started making this dish yourself, watch this free video culinary guide.
Looking to start using Skype? With Skype, you can call regular phones from your very own computer without the hassle of long distance charges. Thanks to Be Your Own It, learn how to install Skype and get free Internet phone calls. Get rid of those long distance charges by using Skype today!
hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 52.5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about macro security. For more information on how to use macros safely, watch this free video guide.
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 4th installment in his series of Excel name tricks, you'll learn to use short Excel names to expedite the formula creation process. For detailed instructions, watch this free video Excel lesson.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 141st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to generate a series of dates with the TODAY and ROW function that will always show today plus the next 10 days.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 99th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create and use the mathematical constant e in Excel. Also learn about the EXP function.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 75th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use name, the INDIRECT function and data validation drop-down lists to create DV lists based on DV lists.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 84th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use custom true/false formulas for data validation and also see how to add an error message.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP function in a formula to replace a long IF function formula.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 63.5th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the advanced filter "Unique Records Only" option and the VLOOKUP, COLUMN, IF, ISERROR and IFERROR functions to merge 2 tables.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 59th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an aged accounts receivable report using a pivot table (PivotTable) and grouping.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 58th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 table dynamic range feature with a data validation drop-down list without using the table name!
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 57th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to avoid a #NUM! error when changing the formula input numbers for the NPER function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 55th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 remove duplicates tool and the COUNTIF function to count unique records that are greater than $30. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 32nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the MATCH & ROW functions to create a logical test to find the first occurrence of items in a list with duplicates.. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 35th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the IF, AND and VLOOKUP functions to deliver the words Bid, No Bid, or Alert to a cell. Is VLOOKUP better than IF AND? Find out with this free video lesson.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 37th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a table of formulas and labels based on formula inputs in an assumption area.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 36th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP function to determine an increase in salary based on a rating scale.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 112th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to solve a common VLOOKUP problem — how to look up approximate values. If the lookup table for the VLOOKUP function is looking up approximate values, the first column of the table must be sorted in ascending order. Learn to love digital spreadsheets more p...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 28th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the INDEX, RANDBETWEEN, COUNTA, IF, AND, & VLOOKUP functions together to select a random employee from a list, determine if they have meet the given criteria and then conditionally format the relevant cells according to the result. Learn to love digi...
New to photography and looking to learn the fundamentals in a flash? This free photographer's guide, which discusses flash photography and its terminology, will help you to accomplish just that. To get started learning the flash/strobe/speedlight basics (as well as to get a basic handle on the jargon), watch this free video tutorial.
Need to build a for a set for a film, TV, stage or photo production? This free video tutorial will walk you through the entire process, from design and sketching to fabrication and assembly. For detailed instructions, and to get started building your own professional quality sets, watch this free set designer's guide.
In this video tutorial, viewers learn how to use a GPS/navigation free on a Verizon Blackberry Storm phone. Begin by clicking on Browser and go to this web address: Google Maps. Now install the application onto your phone. To access it, go to Applications and select Google Maps. Once downloaded, users will be able to use the application to navigate the map. It will also trace the point of where the user is onto he map. This video will benefit those viewers wo have a Verizon Blackberry Storm p...
When applying makeup for the first time, it's all too easy to overdo things. This free video guide will help you teach your teenager moderation when it comes to all things cosmetic. Help your teen to achieve a natural makeup look with the help of this free video tutorial.
Work those glutes with this free home fitness guide, which presents a number of simple exercises that you can perform at home that will help you to firm your posterior—namely squats and hip lifts. Tune into specific muscles when exercising isolated areas with help from a personal trainer in this free video on glute exercises for moms.
In the words of Gertrude Stein, a rose is a rose is a brightly-colored cellulose fiber sculpture. With this free video guide, you'll learn how to liven up your home's décor with your own small, custom decorative paper roses. For more information, including a step-by-step overview of the process, and to get started crafting your own paper flowers, watch this free video tutorial.
Before you make that extended trek out into the wild, there are a few things any self-respecting camper should know how to do. And one of those things is how to feed oneself. With this free video guide, you'll learn how to safely and efficiently cook food when backpacking. For more information, watch this free video guide to camp cooking.
In the words of Gertrude Stein, a rose is a rose is a brightly-colored cellulose fiber sculpture. And with this free video guide, you'll learn how to make your own small paper roses from folded paper using the Japanese art of origami. For more information, including a step-by-step overview of the folding process, watch this free origami lesson.
Want to design your very own custom YouTube background but lack either the money or desire to buy a full-featured graphic design suite like Adobe Photoshop? You're in luck. This designer's video tutorial will walk you through how to make a YouTube background using the free GIMP image editing program from the free software folks at GNU.
