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.
Have you ever taken a photograph indoors and found that all the colors turned out wrong? Everything may have looked far too yellow or far too blue. It was not the fault of your camera. Instead, you probably forgot to set the white balance. What is white balance? Lets find out.
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.
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.
It doesn't matter how great your digital camera is, there are going to be times when you take pictures and your subjects have red eye. So watch this Photoshop tutorial and learn how to use Photoshop to "get the red out". Removing red eye is a basic and easy to learn process in Photoshop.
Watch this piano tutorial video to learn how to effectively teach group piano lessons through the digital piano lab. Piano teachers will find the detailed instructions and tips in this how-to video very helpful. Included is an example of a group piano lesson like the ones you'll be able to teach after you've watched this instructional video.
This heart-shaped chipboard scrapbook is a hybrid album using both digital and traditional scrapbooking methods. This video scrapbooking tutorial shows how to make a heart-shaped scrapbook mixing different scrapbooking techniques. Learn how to make this scrapbook photo album by watching this instructional video.
