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 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.
In this Home & Garden video tutorial you will learn how to test lawn irrigation systems. John White presents this video. This is done by a simple can test. Take a few cans of the same size with vertical walls and flat bottom. Place them around the sprinkler head at different distances and make sure they are horizontal. This will show whether the sprinkler is spreading water evenly. Then you can time it and measure the amount of water. This way in future, you will know how long to run the syst...
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.
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.
Right out of the box, iPhone is incredibly easy to use. If you want to get the most out of every feature, you’ve come to the right place. This video tutorial straight from Apple will teach you how to use GPS maps and the compass on the Apple iPhone 3G. The iPhone redefines what a mobile phone can do.
This is Hydroponics: At Home for Beginners.
This is a tutorial video from Sessions Online Schools of Art & Design's "Photoshop Basics" course. This video is part of Sessions' Graphic, Web, Multimedia Arts, Digital Arts, and Marketing Design certificate programs. You are distorting layers using the transform tool. Use the line tool to check the work. GO Edit: Transform - Distort.
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.
If your Windows PC has a virus and you don't have third-party antivirus software, or your AV program is otherwise unable to deal with it, you may want to try running a system restore, which will restore your machine to an earlier point in time in its history. For more information on getting rid of viruses with the System Restore tool, watch this video guide.
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.
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!
This video demonstrates how to triple boot a computer, which includes Windows XP, Ubuntu, and Backtrack 2 all on one machine.
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!
A Basic guide on how to build your own Aquaponic System. This system is based on the Barrel Ponics and the S&S setup and was built by me in the summer of 07'.
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...
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...
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
This video is a tutorial for setting up Native Instruments' Traktor Scratch system. While the setup can seem a bit confusing, with this video's help, you will be able to setup and use your system easily. You should practice setting this system up repeatedly, especially if you intend to use it in live performance, so that setup is quick, and troubleshooting is straight forward rather than a sweaty, nervous mess!
Your car's radiator needs to be cleaned to be cool. As time goes on, a car's radiator builds solid deposits that can clog the cooling system. A quick, inexpensive radiator flush can keep the system in shape. This automotive tutorial video will give you tips on how you can flush and fill the radiator and cooling system of your car.
Watch this video to learn the basics of installing an underground sprinkler system. The points discussed in this video are just a few of the ways a sprinkler system can be used and applied. The video covers ways to set up the system and calibrate it to effectively water your lawn and garden.
