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 170th installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting to hide or show items in a list using a TRUE/FALSE formula.
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 151st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the days, months or years between two dates using Excel's undocumented DATEDIF 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 153rd installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to the MAX value in a set of three incentive pay plans.
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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from standard table and put a record in a column using the VLOOKUP, IF and ROWS 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 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.
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 572nd installment in their series of digital spreadsheet magic tricks, you'll learn about how to use conditional operators in your 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 Excel tutorial from ExcelIsFun, the 568th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a SUMIFS function to tabulate a monthly running total from transaction data.
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. With this video tutorial from ExcelIsFun, the 393rd installment in their series of digital spreadsheet video tutorials, you'll learn how to remove the last two words from column of data with the LEN, SUBSTITUTE, FIND, REPT, RIGHT and TRIM functions.
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 246th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a waterfall profit chart from a stacked column 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 101st installment in their series of digital spreadsheet magic tricks, you'll learn how to use IS functions (ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF &ISTEXT).
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 9th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Excel's EXACT function to check to see whether two text strings are equivalent and whether or not they have the same case.
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 94th installment in their series of digital spreadsheet magic tricks, you'll learn how to use and link a currency web query to a data validation cell drop-down list for money conversion.
Whether you're new to Adobe After Effects or a seasoned digital video professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn what you can do to optimize your hardware for optimum performance.
Whether you're new to Adobe InDesign or a seasoned digital video professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to create a more engaging experience with web DVDs that include a search interface for viewers to jump directly to content of interest.
Whether you're new to Adobe Photoshop or a seasoned graphic arts professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to use the new Protect Detail feature in Photoshop CS5 to prevent artifacts in your digital images when using the Sharpen tool.
Cassettes take up quite a bit of space, and can sometimes start showing wear, which can affect the sound. This video shows you how to take this information from your cassettes, and move them on to a CD. Detailed instructions, and photos in this video, will have you transferring analog information into a digital format within just minutes. This allows you to be able to use the audio recording on your computer, as well as being able to listen to it in a regular CD player.
Did you just pick up the impeccable Canon 40D but need a little help guiding through the menu? You're in luck. In this three-part video tutorial, learn everything you need to know about the Canon EOS 40D digital menu.
Thinking of buying the new Apple iPhone 3GS? This video tutorial straight from Apple is an iPhone 3GS guided tour, which takes you through a demo of the features of the fastest, most powerful iPhone yet. iPhone 3GS features video recording, video editing, voice control, up to 32GB of storage, a digital compass, mms messaging, internet tethering, voice memos, and more.
Get started using Adobe After Effects with the help of The New Boston! This beginner's tutorial is bound to answer the many questions you have about the popular digital motion graphics and compositing software. The main purpose of After Effects is for film and video post-production.
Get started using Adobe After Effects with the help of The New Boston! This beginner's tutorial is bound to answer the many questions you have about the popular digital motion graphics and compositing software. The main purpose of After Effects is for film and video post-production.
Understand how binary numbers work, including how to read binary numbers, and create your own. This mathematics or computer programming tutorial is a zip to get through. It covers practical and theoretical use and need for binary code understanding. Binary means zeroes and ones in a series. This is paramount to digital transmission versus analog that transmits in a sinusodial wave form.
Discover one of the new 3D features in Adobe Photoshop CS4 Extended. In this tutorial you will learn how to wrap an image around the inside of a sphere, to create a 3D panorama in Photoshop CS4 Extended. Then, simply step into this digital space and use some of the new Photoshop CS4 tools to look around your newly created world.
The macro mode on a camera can be baffling. What's it for? Well, if you've got something small and pretty to shoot, like a butterfly, macro gives you the best shot possible. It's also good for taking pictures of things that are small and ugly, like scratches in your car paint. Watch this handy how-to and collect all that insurance money next time someone dings your fender. Enjoy!
Learn how to remove grain from your photo in Photoshop to make older or poor digital photos to look much cleaner using a simple filter in Photoshop.
You can use Picasa to put some effects on your photos. Also, Picasa provides some simple tuning options for your digital photos.
Have a million 3-inch reel-to-reel tapes piling up in your garage? Keepsake audio tapes?
Aperture provides two sophisticated sharpening tools, edge sharpen and sharpen. Both help you improve the fine details in your images. Most images from digital cameras need a little sharpening, especially RAW files.
Aperture's metadata inspector is a one-stop location for editing the metadata associated with your images. Some of this metadata is automatically stored within the image files of your digital camera, and aperture automatically reads it when you import your photos. You can add other metadata, such as keywords, yourself.
All digital cameras automatically record the date and time each photo was taken and store this time stamp as metadata within each image file. In Aperture 2, you can change these time stamps. This is particularly useful if the clock in your camera is set incorrectly or if you're trying to synchronize photos taken by multiple cameras at a single event.
With iMovie, you can easily incorporate your digital photos in your movie or even use several photos to create a slideshow.
Once you've taken some photos, you'll need to move them from your digital camera to your Mac. Just connect your camera to the USB or Firewire port on your Mac with a cable. iPhoto will open automatically.
With iDVD, you can use your digital photos to create a DVD slideshow that will play in virtually any DVD player.
Final Cut Express makes it easy to convert or capture your videotapes into digital video files. All you need to do is set the desired capture format and destination for your clips. The Final Cut Express menu also provides an Easy Setup function.
Learn how to write your movie to tape or store it as a digital file using Apple's Final Cut Express in order to share it with others. Using this process, you can play your movie on a VCR, website, iTunes, iPod, DVD, or any other device or format.
Make your own pinhole camera from a juice box! A juice box, yes, that's right. Guaranteed to outlast any digital camera! Unless you sit on it, of course.
If you shot a video sideways with your digital camera, you may need to rotate it in order to get your video to appear right side up. Here's how to rotate that video using Windows Movie Maker
Donnie Hoyle pulls a digital end-around on a restraining order and vandalizes a Vanagon. This teaches you how to use the warp and distort tools in Adobe Photoshop. It also uses Adobe Bridge.
Customize your digital images and graphics - you can create a partial black and white effect in Photoshop Elements with these simple steps.
Do you have an old PC sitting around somewhere in your garage? Want a dedicated audio server that will play back MP3s, Internet radio, and other digital music files over your home stereo system? This CNET video teaches you how to convert your old PC into an amazing server!
Adobe Premiere Pro is one of the best video editing software suites ever conceived. Do you edit films? Do you want to be a film editor? Are you a director or screenwriter who wants to know how their movie gets put together after they're done with it? If you are any of those things or just want to learn how to do digital video editing for some other reason, watch this video. It will teach you everything you need to know about using Adobe Premiere Pro to edit digital movies.
