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 225th installment in their series of digital spreadsheet magic tricks, you'll learn how to do a two-variable lookup when there are duplicates using the INDEX, IF, ROW and MAX functions.
Ready to bring your digital photographs into the world of tangible objects? Before you do, you'll need to understand a thing or two about aspect ratios and image cropping within Adobe Photoshop. Fortunately, this guide will tell you everything you need to know. For a complete overview, and to get started cropping your own images for printing, watch this free video guide.
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.
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!
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 168th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a simple dynamic database in Excel using lists in Excel 2003 and tables in 2007.
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 177th installment in their series of digital spreadsheet magic tricks, you'll learn how to format a column as text numbers to avoid data validation trouble.
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).
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.
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.
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.
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.
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).
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 136th installment in their series of digital spreadsheet magic tricks, you'll learn how to do two-way lookups with the VLOOKUP & MATCH functions.
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.
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 91st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the FORECAST function to solve linear algebra problems.
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.
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 294th installment in their series of digital spreadsheet magic tricks, you'll learn how to filter a pie chart.
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.
This is a great tutorial for photographing beautiful star trails on a 35mm SLR camera. Because only film has low enough ASA to shoot for such long exposures, this tutorial unfortunately apply to digital SLR's.
In this Final Cut Pro tutorial, learn how to make your digital film look like is came from tape. Step by step, learn how to create that "film look" in just a few clicks of your mouse.
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.)
Learn After Effects: the best digital motion graphics software programs out there.
Learn After Effects: the best digital motion graphics software programs out there.
Learn After Effects: the best digital motion graphics software programs out there.
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.
Check out this cinematography video tutorial on how to use the Panasonic HPX500 broadcast camera. The Panasonic professional digital camcorder HPX500 is an awesome camera for the new age.
Here are a few stop motion animation tips. You will need a digital camcorder, editing software, and clay or Legos. This video lends advice for basic stop motion animation. Avoid common mistakes if you are a beginner animator.
This is a very popular effect in film and television, where the camera switches focus on objects in one shot.
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.
In this Windows how-to, Digital Connector Jessica will show you how to change the appearance of your Windows XP desktop. Specifically, she addresses how you can use the classic Windows theme using the XP themes feature. For more on modifying the appearance of your Windows XP desktop, take a look!
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!
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.
This tutorial explains how to import photos from your digital camera into iPhoto '08.
Here is a demonstration of a custom designed brush for the TVPaint software. This pen is sensitive to a realistic method of gestural drawing. Watch this instructional video to use this software brush to make several types of digital drawing strokes.
How do you choose colors for a drawing without it looking like a child's drawing? Watch this instructional drawing video to use a digital color palette effectively. Examine a photograph to choose accurate, subtle colors based on limited perspectives.
Looking for a free way to convert images you took with your digital camera? This tutorial shows you how to use IrfanView 4.10 for Windows to view, optimize and convert images. Learn the very basics of IrfanView 4.10 with this video and get ready to start editing your photos and images.
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.
Take a look at this instructional video and learn how to install the Twilight hack for you Wii. The twilight hack is an exploit that reads a elf file off the root of your secure digital (SD) card. To start up this hack, you'll need to load the Zelda: Twilight Princess game before you can run any unofficial software.
There are lots of applications you can use to record audio for your podcast. Why use Audacity? It’s free; it’s exactly the same on a Mac or PC; and it’s completely adequate for
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.
