Check out this clip to get the most out of your "NBA Career". In NBA 2K10, there is a brand new career mode called "My Player". Follow along with this tutorial and build the ultimate player that will take you all the way to the Championships.
Check out this tutorial for some awesome techniques for the latest edition from Fight Night Round 4. In this clip, master some counter punch skills and it might mean the difference between holding the belt and holding your teeth.
Looking to catch up on your favorite programs while breaking neither the law nor the bank? Believe it or not, you have quite a few options. And this free video guide from the folks at CNET TV will walk you through them. For details, and to get started watching full episodes of your favorite TV shows for free online, give this clip a gander.
In this clip, learn how to fill up that failing bank account and boost your treasure intake in Fable II for Xbox. This tutorial from IGN will show you exactly how to dig up all of the buried treasure quickly and make money the easy way.
Learn how to interlace custom shapes in Adobe Illustrator CS4, an effect that's especially attractive when working with 3d perspective objects and shapes. Whether you're new to Adobe's popular vector graphics editor program or a seasoned graphic arts professional looking to better acquaint yourself with the new features and functions of this particular iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this designer's guide.
Save your Illustrator CS5 illustrations for the web. This clip will show you how it's done. Whether you're new to Adobe's popular vector graphics editor or a seasoned graphic arts professional interested in better acquainting yourself with the new features and functions of Illustrator CS5, you're sure to benefit from this free software tutorial. For more information, and to get started using this trick in your own Illustrator projects, watch this video guide.
In this video, learn how to take things you find in thrift stores and repurpose them as cool, new items. In this clip, you will learn how to cut up a frumpy old skirt and turn it into an adorable, stylish oversized tote. This is a fun project that costs just a couple of bucks and will become a unique bag you will love for years to come!
In this tutorial, learn how to make your own fabric that you can use to make bags, clothing and many more items! Etsy Labs technician, Anda Lewis shows you how to fuse plastic bags (from the grocery store or trash bags) in this quick clip. You can even use these bags to create your own reusable, Earth friendly shopping bag!
Learn how to use Pro Tools 8's time warp features to conform and quantize your audio files. Whether you're new to Digidesign's popular DAW or a seasoned audio pressional just looking to better acquaint yourself with the Pro Tools 8 workflow, you're sure to be well served by this video tutorial. For more information, and to get started conforming and quantizing audio clips in your own Pro Tools projects, watch this free video guide.
In this clip, learn how to get Aubrey O'Day's makeup look from the girl group, Danity Kane. Aubrey is arguably the biggest star of the group and was the definite stand out personality on P.Diddy/MTV's "Making the Band". This look is sexy and definitely screams party girl. If you are heading out to a fun event, try out this sultry eye look and stand out in the crowd.
In this tutorial, learn how to get a wild, avant garde Lady Gaga makeup look. This look is super bold and you will look great at the right type of event. Check out this clip and let Nikkie show you how to make a blue hued makeup mask just like Gaga's in "Love Game". This look will definitely make you the life of the party!
Check out this tutorial for a step by step on the new song "Haven't Met You Yet" by Michael Buble. Michael Buble is a fantastic performer and his songs are always hits. So, whether you are looking to play for your own amusement, to impress a girl or to practice singing, check out this great clip.
There are plenty of tricks for escaping from traditional police cuffs out there, but what about those plastic zip tie type ones? The plastic they use to make these cuffs is so thick that you can't possible cut it.
This video tutorial will show you how to create a hair look like Rikku from Final Fantasy part 3. This hairstyle is totally perfect for Cosplay, or if you are daring - everyday wear!
In flight school, at some point or another you will be asked to determine your density altitude. In this professionally taught tutorial, lean how to calculate density altitude on a flight computer. This lesson is taught by an instructor from the Golden State Flying Club at Gillespie Field in El Cajon, California. So, if you are just beginning to fly, check out this clip and make sure you know all there is to know.
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!
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 103rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Goal Seek to change a formula input number so that the formula is a desired result. Also learn how to use the PMT function.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 85th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to isolate unique records with the OR function.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 74th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to fix bad data with the CLEAN & TRIM functions.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 81st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to a chart by creating a new column of data with a formula.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 72nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to turn off auto formatting so that column and row formatting or formulas are not automatically created.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 101st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use conditional formatting AND custom number formatting to add styling to a cell.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 87th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to quickly remove rows of a table where the row has a blank in column A.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 91st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an average with multiple criteria using pivot tables (PivotTable). 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 86th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a TRUE/FALSE formula to change the function of pivot table as well as how to filter one.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. 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 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to pull data from a table on one worksheet to a second worksheet using the VLOOKUP and DGET functions.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66.5th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll see 3 different ways to hide formula errors.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 63rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an array formula to find the vendor with the maximum rating and the lowest cost 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 54th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count records exceeding a given hurdle using Excel's advanced filter tool. 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 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the COUNTIF function to prevent duplicate entries in a list. 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 47th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to calculate total plate cost for a print shop using the VLOOKUP 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 106th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use two alternatives to pivot tables.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 102nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count the number of days between two dates using an array formula.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 51st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a VLOOKUP function inside a Text Formula to add a variable word (e.g., Annual, Semi-Annual, Quarterly, Monthly, or Weekly).
In this video, learn how to make your own homemade electroscope. An electroscope is an early scientific instrument that is used to detect the presence and magnitude of electric charge on a body and for static electricity experiments. They are easy to make. This electroscope is made from a binder clip and two sheets of plastic (or overhead transparency film), and scissors.
Want to make a neat gift for a friend? In this Curbly video tutorial, steps are given on how to make an accordion style photo album without any glue or tape. Materials needed include: light to medium weight poster board (24x4.5"), a scoring tool & board, an Exacto knife, scissors, a hole punch, 0.25"x7.5" piece of elastic, and brad clips. Put photos of you, friends, and family on both sides of the accordion to make for a great keepsake.
For this Final Cut Studio video tutorial, Zach King will teach you how to apply a filter pack in Final Cut Pro and Final Cut Express. To apply a filter pack, you'll just click on the clip with all your applied filters, go to effects tab and press Make Favorite Effect. It saves your filters in the Favorites folder with the exact same settings. Let the Final Cut King show you how!
This is a how to BOOGALOO dance lesson. This tutorial covers the basics. Historically, it has been a difficult style to learn. I started learning online with dance clips, but then got the opportunity to learn from JAZZY J (EBs) and other poppers in NYC. This is another great Russian Tiger tutorial on pop'n'lock dance moves.
When there isn't space in a garden for favorite plants, they can be planted in containers and placed on a patio or deck. This how-to clip provides instructions for how to plant a beautiful and functional container garden.
