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.
Prius models that are equipped with tilt-slide moon roof have a remote control button on their smart keys for the remote air-conditioning system. Before leaving the vehicle, make sure the headlights are switched off or set to auto. All windows are closed and check the temperature setting of the AC system. As you return to the Prius, press the remote AC button on the smart key remote to activate the air conditioning system. The cabin will cool to the pre-set temperature without turning on the ...
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.
Have you ever been the victim of theft? It sucks. Why would these lazy scumbags rather steal from us than work hard like everybody else?
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.
As with any media asset management system, your catalog of assets will keep growing. As your storage fills up, Final Cut Server makes the task of archiving and restoring simple. Final Cut Server sets up your storage system into online and archive systems.
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.
Lawrence Perez, from Saddleback College, and his assistant Charlie, give this pre-algebra lesson on the metric system. If you want to know all about that glorious metric system, well, need I say more?
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.
In this clip, you'll learn how to create a a simple membership system for a website with PHP and MySQL. Whether you're new to the PHP scripting language or a seasoned developer mereley looking to pick up a few new tips and tricks, you're sure to benefit from this video tutorial. Take a look.