Digital Downloads Search Results

How To: Use zoom and telephoto lenses on a Canon DSLR camera

Need a primer on how to use zoom lenses with your Canon DSLR camera (a 7D, 5D, or Rebel T2i, for example)? This brief video tutorial from the folks at Butterscotch will teach you everything you need to know. For more information, including detailed, step-by-step instructions, and to get started using zoom and telephoto lenses on your own Canon digital camera, take a look.

How To: Calculate Commission Based on Varying Rates in Excel

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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.

How To: Average the last three values for an entity in Excel

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 677th installment in their series of digital spreadsheet magic tricks, you'll learn how to average the last three scores eneterd for any Player using the functions: AVERAGE, IF, ROW, COUNTIF, MIN, LARGE.

How To: Ignore hidden rows with MS Excel's AGGREGATE function

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 662nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add or average while ignoring values in hidden rows. In addition you can ignore both Hidden Rows and Error Value.

How To: Ignore nested subtotals with AGGREGATE in MS Excel

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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how to make a calculation on a column of values that contain subtotals that you do not want to include in the calculations. The AGGREGATE function will ignore nested SUBTOTAL and AGGREGATE functions when making calculations.

How To: Customize the Blender user interface

There seems to be a growing number of people who decide to try out blender but when you download Blender and start it the first time, it doesn't look very inviting, does it? Well, here's a little tutorial for those who are annoyed by Blender's default setup. 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 ...

How To: Make bio diesel

Make your own backyard biodiesel with the help of Kipkay. It's easy to make a small batch that will work in any diesel engine. You won't need any special equipment--an old juice bottle will serve as the "reactor" vessel--and on such a small scale, you can quickly refine your technique and perform further experiments. Thanks go to Rob Elam for the original article in Make Volume 3To download Making Biodiesel MP4 click here or subscribe in iTunes. Check out the complete Making Biodiesel article...

How To: Use color correction in Photoshop

Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to use color correction in Photoshop.

How To: Use a light meter to properly light a digital film

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

How To: Import footage from Sony's XCAM EX into Final Cut Pro

Do you have some footage from the Sony XDCAM EX digital camera memory card that you need to get into Final Cut Pro? Well, check out this brief tutorial on ingesting that XDCAM EX footage into Final Cut Pro with ease by downloading some software, like upgrades. You'll need the Sony camera and a USB cable, then just watch the video to see how it's all done in Final Cut Pro. This will work with Sony EX1 or EX3.

How To: Do Photoshop painting basics for beginners

This series is the basic training you need to get up and running with Photoshop, so that you can be a better digital painter. Knowing how to use all the tools and options that pertain to digital painting, photomanipulation, and photo editing will save you lots of time, so it's worth learning the basics first.