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 235th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a custom number format for inches that will allow you to type decimals or fractions and have it formatted as inches.
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 226th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply names to formulas and replace existing cell ranges as well as how to name ranges from selections.
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 578th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to grade student answers where more than one possibility exists using the IF and OR 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 181st installment in their series of digital spreadsheet magic tricks, you'll learn how to count words (case sensitive) using the SUM and EXACT functions in an array 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 178th installment in their series of digital spreadsheet magic tricks, you'll learn how to alculate the best value from two categories of values.
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 175th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function and an array of TRUE & FALSE to count values between an upper and lower bound.
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 149th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a value in a table and then return the row or column value when there are no duplicate values.
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 145th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will calculate the median 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 Excel tutorial from ExcelIsFun, the 554th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to weekends and holidays with Excel's NOT and NETWORKDAYS 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 336th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions to increment numbers in Excel 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 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to remove duplicate records using the Remove Duplicate feature which was new in Excel 2007.
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 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP & data validation to make an invoice when the product list is on a different sheet or different workbook.
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 263rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a completely dynamic math equation system (function of x) with formulas, data points, charts and chart labels.
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 and Mr. Excel, the 45th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract a number from a text string.
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 232nd installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally sum by array formula in Microsoft Excel.
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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use Advanced Filter to extract records from a table with 1 criteria, then use a Macro to automate the process.
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 483rd installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use both the sort and filter tools in Microsoft Excel.
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 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to prevent Excel from displaying a 13-digit number ID in scientific notation using the number formatting tool.
A video presentation by Jeff White on the role of Mattress and Box spring Encasement in bed bug management plan and how it will help in early detection of bed bugs
Using the Digi Effects plugin "Aged Film" in After Effects, learn how to take your digital footage and turn it into a Super 8mm looking reel. Author Oliver Mellan, shows step-by-step how to create that faux grainy look to make your 21st century film look as deep & rich as any 8mm or 16mm film.
This video shows you how to remove the Digital Rights Management(DRM) protection from iTunes music. DRM is a way for Apple ITunes to control your music and where you save it. Hack the iTunes so that it does not interfere with you like this.
The best way to transfer contacts from a computer to an iPhone is to use Mobile Me, formerly known as Dot Mac, which automatically synchronizes Outlook or Entourage with the iPhone. Keep track of contact information, on both the computer and the iPhone, with tips from a digital technology specialist in this free video on the iPhone.
Mark Dommen, chef-partner of San Franciscos One Market Restaurant, advises viewers against the wrong approach: Do not use a dull knife, do not carve at the dining table (as much as you might want to), and do not hack at your bird willy-nilly. This video demonstrates all the wrong ways to carve a turkey. Pay attention for advice on the correct way to carve a turkey!
Do you have hundreds of assets in your Final Cut Pro project, but you are only using a percentage of them in your sequences? Want to find out how to get rid of the unused assets in your Final Cut Pro project quickly? Watch this Digital Media Dude podcast and learn how to search for unused assets in Final Cut Pro.
Tagging real walls can get you in a lot of trouble. So why not let out your creative urges in Photoshop? This Photoshop CS3 tutorial shows you how to make digital graffiti on a digitally made brick wall. Watch and learn how to use layer effects and lighting to create graffiti text in Photoshop.
Check out this instructional cinematography video that shows you how to build the Genesis Super 35 Digital Cinematography Camera System. Watch and learn as this instructor sets up the Panavision Genesis camera and prepares it for a shoot. This cinematography tutorial is perfect for professional filmmakers.
Watch this quick instructional cinematography video that shows how to balance a Canon XL2 professional HD digital camera on a GlideCam 4000 Pro. Learn how to secure the camera using this handheld camcorder stabilizer to prevent unwanted swaying, shoot fluid traveling shots, and produce professional works.
This video shows you how to upgrade your consumer camcorder sound capabilities using a camcorder XLR adapter, a simple device that mounts to the bottom of the camera. It then tests and compares the various types of microphones that can be attached, including the lavalier, sennheiser, handheld interview, and the wireless clip-on microphone. WAtch this helpful instructional video, and boost the sound on your camcorder for professional audio.
All you need is a basic digital camera and GIMP photo editing software to create your own version of the Pan's Labyrinth creatures. The Keyboard Shortcuts used, in case you can't hear it properly:
Ever wish you could see in the dark? Well, you can't but this how-to will show you a way to build a device to help you out. You will need light polarizors, a flashlight, and a digital camera. Make an infrared night vision device, just follow along with the steps in this video tutorial. Now you can see at night!
Want to challenge the filmmakers who spend millions of dollars on their films, yet, still have the nerve to call themselves indie? Pick up a 35mm adapter or build one yourself and you can give your movies that "film look" and start being taken more seriously!
Israel Hyman is a weekend videographer headquartered in Mesa, Arizona. In this video, he demonstrates how to use “Shutter Speed” to make your digital video look better. A rule of thumb is: Set the shutter speed at a rate of 1/60 of a second for normal shooting.
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.
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!
In this tutorial, we learn how to get sharp images in low light w/ a digital camera. If you are wanting to take quality pictures indoors but don't have great lighting, there is still a way to make your pictures turn out great. First, you will need to take a camera with a long lens and zoom in on your subject. After you do this, hold the camera steady and take the shot. When you look at the picture you just took, the picture should be brighter than it would be if you took a wider shot and it w...
Forex— what is it? Any investor could tell you a complicated description of what Forex is, but the basics of the FX currency markets is— an over-the-counter financial market for trading currencies. The foreign currency exchange market has no central exchanges like the stock market and little regulatory oversight. With this beginner’s guide, learn the trading basics.
The ability to tune a guitar is a skill every guitar player should possess. With this tutorial, learn how to properly tune a guitar either using a digital tuner or by using the fifth fret rule. Though a digital tuner is by far a more convenient option, certain situations my require the player to tune an instrument by ear. Start by tuning the low E string and use that sound as a reference for the tuning of the other strings. If a tuning fork is unavailable, a guitar can still be tuned relative...
Kessler's flagship camera crane is the KC-8 Basic, and the KC-Lite 8.0 offers a stripped down, easier to manage version. In this tutorial you'll learn how to put together the KC-Lite crane, and you'll also get a quick demonstration of the crane in action.
Watch this Epson video tutorial to learn how to automatically enhance digital pics with the Epson Artisan 810 All-in-One Printer.
An instructional video by tradigital artist Merrill Kazanjian. Step 1- Scan the image
