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.
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.
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!
Ok, let's pretend that you just got back from the store with a $200.00, maybe $300.00 silk blouse. You put it on, it looks perfect. You go out on the town, everyone else loves it, you're the center of attention. Then you come home, you go to hang it up, and there is a huge stain on the back. This how to video tells you how can save that $200.00 blouse for only $1.50.
The hangtown fry is a delicious and decadent breakfast that was created during the California gold rush when a rich miner wanted a meal made from the most expensive ingredients in town: oysters, eggs, and bacon. See how to make hangtown fry at home.
The Canon EOS 7D digital SLR is the first Canon EOS camera that can trigger off-camera Speedlites with the cameras build in flash. The integrated Speedlite transmitter is fully compatible with the Wireless E-TTL Flash System. See exactly how all this works and how to use your flash functions.
You want the best quality photos you can get, and the Canon EOS 7D digital SLR camera makes perfecting your pictures easy. There is a range of technologies to enhance image quality. This video shows you the many options you can use.
If you are out with friends and don't have anyone to take your photo for you, you will need to take a self portrait. Instead of fumbling with a self timer, most people hold the camera themselves and take a snap. Unfortunately, these photos are hard to center and you often cut people off and lose what could have been a great shot.
This video describes how to import pictures from a digital camera onto your computer and use them in various ways. Simply plug in a flash drive with your stored pictures and they will immediately load onto your computer. Once this is done, you can share your pictures on Snapfish by opening the program and using its various programs. Within the program you can print your images, share, or even create gifts such as posters and mugs with your uploaded pictures. If you would like any more informa...
Got a Canon Powershot whose resolution or functions are not cutting it for you? Then amp up its abilities - without flat out buying a new camera - by checking out this digital camera hack video. By modifying the camera's firmware you'll be able to add games as well as a manual mode for ultimate control of how you produce your images.
Pro Tools is THE software choice for digital audio recording and editing. You've got some serious power at your disposal and you'll want to know how to handle it all. This video shows how to take your finished Mix from Pro Tools SE, and burn it to a CD that will play in any CD Player.
This is a lens you can make yourself easily. You will need a drill, a needle, a body cap, tape, aluminum foil, a ruler or measuring tape and a pencil or piece of chalk to mark where the hole should go.
