Digital Downloads Search Results

How To: Take a picture of your computer screen

Want to take a picture of your Microsoft Windows PC's screen using the computer itself? It's easy! So easy, in fact, that this guide can present a complete and thorough overview of the process in under a minute's time. For more information, and to get started taking your own digital screen shots, watch this free video tutorial.

How To: Convert YouTube videos onto a DVD, MP3, and more

This video will show you how to convert YouTube videos into files that can be shared on a DVD, CD, iPod, iPhone, or any other type of device you use to view digital media. This is an easy way to share your favorite videos with others and carry them with you. This process is pretty easy and doesn't take long to do. So, check it out and start taking your YouTube addiction with you wherever you go!

How To: Randomly select an employee name from an Excel sheet

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 169th installment in their series of digital spreadsheet magic tricks, you'll learn how to randomly select an employee from a list using the INDEX and RAND and INT functions (also RANDBETWEEN).

How To: Use VLOOKUP with TRIM in Microsoft 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 155th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the TRIM function to get rid of extra spaces when a VLOOKUP function should work but doesn't.

How To: Create a personal budget based on past data 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 154th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a personal budget based on past data via the SUM function, cell references, subtraction and the VLOOKUP function.

How To: Use a MODE IF function in Microsoft 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 145.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to a formula that will calculate the mode when you have more than 1 criterion.

How To: Use sheet cell references in Microsoft Excel formulas

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 140th installment in their series of digital spreadsheet magic tricks, you'll learn how to save time in updating a system of data and information by using sheet cell references in formulas.

How To: Name a Microsoft Excel cell after its content

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 138th installment in their series of digital spreadsheet magic tricks, you'll learn how to name individual cells after their cell content (i.e., the name of the cell is in the cell).

How To: Apply conditional formatting to a calendar 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 98th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a TRUE/FALSE formula and the TODAY function to format a calendar within a two-week period.

How To: Create a form from linked Access data 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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to import data from Microsoft Access as well as how to use the VLOOKUP function to populate data into a printable form.

How To: Find the average time between orders in an Excel sheet

New to 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 Excel tutorial from ExcelIsFun, the 371st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the average time between customer orders by adding a new column to a data set with an IF function formula.

How To: Install the D Focus DSLR Mount on a Canon 5D

When you're first working with a digital single-lens reflex camera, there's a lot to learn. Setting up a D|Focus DSLR mount can look particularly complicated, but in this tutorial you'll learn all the steps. Now you're ready to start taking shots like a pro. (Note that this tutorial is not for absolute beginners. You'll need to have some familiarity with these camera before you begin.)

How To: Use color theory to analyze color

Check out this video on color theory: analyzing color. It is important to understand color relationships and harmonies when designing everything from brand advertising, websites, video games, fine art, clothing and interior decoration. Tutorial video from Sessions Online Schools of Art & Design's "Color Theory" course. Part of Sessions' Graphic, Web, Digital Arts, Marketing, and Multimedia Arts Design certificate programs.

How To: Operate a video camera

That digital video camera is a delicate piece of equipment, you need to treat it right. Check out this how-to video and learn how to properly operate it to ensure good footage and a long camera lifespan. This video guide covers basic camera handling and maintenance, and these general rules are useful for whatever brand video camera you're using.

How To: Create an impressive photo slideshow online with Roxio

Why let all the photos you've taken over the years with your digital camera sit on your computer in loose piles, forsaken? In this video tutorial, you'll learn how to use Roxio's free photoshow application to create impressive photographic slideshows. For more information on photoshow, or to get started creating your own slideshows, watch this Internet how-to!

How To: Test out different photography tripods

There are many types of photography tripods for using in different shooting situations. Watch this instructional photography video to test out different tripods from mini to mighty. Make sure to label your tripod with your name and address, because at a large photo shoots, tripods often get lost, stolen, or confused with other tripods. Most of these tripods work well with digital SLR cameras and 35mm film cameras.

How To: Shoot panoramic photographs

Watch this instructional photography video on how to shoot Panoramic photographs with What Digital Camera Magazine. Panoramic photography is a format of photography that creates images with exceptionally wide fields of view. You don't have to use a tripod but it's much easier than eye balling it while taking a series of photos of the landscape, and you won't have to crop as much.

How To: Take a timelapse photograph

Timelapse photography needn't be complicated, for advanced photographers only. This video photography tutorial helps explain how to take a timelapse picture, even if you're a complete beginner. Learn the process of taking a timelapse photo with a web, video, and digital camera. Watch, learn, and start practicing your shutter skills.

How To: Add pictures to a document from a scan in Word 2007

If you're baffled about how to get your own photographs into your Microsoft Office Word 2007 documents, watch this instructional video. A Microsoft employee who uses Word himself shows you how to insert your picture or digital photo into a document and format it the way you want. He addresses questions about terms like "inline" and "floating," and explains how easy it is to set up a watermark.