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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract month and year data from transactional records by filtering, array formula and non-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 672nd installment in their series of digital spreadsheet magic tricks, you'll learn how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMALL in an array formula.
In this clip, you'll learn how to take full advantage of Magic Bullet Mojo when color grading digital footage within Final Cut Pro or Express. Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to better acquaint yourself with the popular video editing program, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, watch this tutorial.
Need a primer on how to get started editing video within Final Cut Pro or Express? This clip will show you how it's done. Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to better acquaint yourself with the popular video editing program, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, watch this tutorial.
Learn the many ways to preview un-rendered clips in the Final Cut Pro timeline. Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to better acquaint yourself with the popular video editing program, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, watch this tutorial.
In this video, you'll learn how to key in Final Cut Pro with a do-it-yourself green screen that can be built for around a dollar. Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to better acquaint yourself with the popular video editing program, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, watch this tutorial.
In this clip, you'll learn how to reduce camera shake digitally within Final Cut Pro. Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to better acquaint yourself with the popular video editing program, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, watch this tutorial.
Meet the Avid Media Composer 5 Auto-Titler tool! Whether you're new to Avid's popular non-linear editor (also known as "The Avid") or are a seasoned digital video professional just looking to better acquaint yourself with Media Composer 5, you're sure to enjoy this free software tutorial. For detailed instructions, and to get started using Avid 5 yourself, take a look.
Need a primer on how to set up automatic color correction within Avid Media Composer 5? Watch this helpful video guide. Whether you're new to Avid's popular non-linear editor (also known as "The Avid") or are a seasoned digital video professional just looking to better acquaint yourself with Media Composer 5, you're sure to enjoy this free software tutorial. For detailed instructions, and to get started using Avid 5 yourself, take a look.
Need to know how to keyframe (or key frame) audio within Avid Media Composer 5? Never fear: this guide will show you precisely how it's done. Whether you're new to Avid's popular non-linear editor (also known as "The Avid") or are a seasoned digital video professional just looking to better acquaint yourself with Media Composer 5, you're sure to enjoy this free software tutorial. For detailed instructions, and to get started using Avid 5 yourself, take a look.
This clip discusses how to perform trims with the Slip Mode in Avid Media Composer 5. Whether you're new to Avid's popular non-linear editor (also known as "The Avid") or are a seasoned digital video professional just looking to better acquaint yourself with Media Composer 5, you're sure to enjoy this free software tutorial. For detailed instructions, and to get started using Avid 5 yourself, take a look.
In this video lesson, you'll see how to sort and navigate clips within Media Composer 5. Whether you're new to Avid's popular non-linear editor (also known as "The Avid") or are a seasoned digital video professional just looking to better acquaint yourself with Media Composer 5, you're sure to enjoy this free software tutorial. For detailed instructions, and to get started using Avid 5 yourself, take a look.
This clip presents instructions on how to do A-side single-roller trims within Avid Media Composer 5. Whether you're new to Avid's popular non-linear editor (also known as "The Avid") or are a seasoned digital video professional just looking to better acquaint yourself with Media Composer 5, you're sure to enjoy this free software tutorial. For detailed instructions, and to get started using Avid 5 yourself, take a look.
In this software tutorial, you'll see how to add a shot to a sequence with the Splice tool in Avid Media Composer 5. Whether you're new to Avid's popular non-linear editor (also known as "The Avid") or are a seasoned digital video professional just looking to better acquaint yourself with Media Composer 5, you're sure to enjoy this free software tutorial. For detailed instructions, and to get started using Avid 5 yourself, take a look.
This clip presents a detailed overview on how to set up and organize projects within Media Composter 5. Whether you're new to Avid's popular non-linear editor (also known as "The Avid") or are a seasoned digital video professional just looking to better acquaint yourself with Media Composer 5, you're sure to enjoy this free software tutorial. For detailed instructions, and to get started using Avid 5 yourself, take a look.
See how Lightroom 3 allows you to apply auto lens profile corrections directly to raw and non-raw images. Whether you're new to Adobe's popular photo application or a digital photography professional just looking to better acquaint yourself with Photoshop Lightroom 3, you're sure to be well served by this free video software tutorial. For more information, as well as to get started using Lightroom 3 yourself, take a look!
This clip presents an overview of color grading footage shot with the new Canon EOS 5D Mark II Digital SLR (DSLR) in Apple Color. Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to better acquaint yourself with the Final Cut Pro workflow, you're sure to benefit from this free video tutorial. For specifics, watch this Final Cut Pro lesson.
In this FCP tutorial, you'll learn how to keyframe the mask shape filter with blur to track the movement of the camera. Whether you're new to Apple's Final Cut Pro non-linear video editor or just looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial. For specifics, including detailed instructions, watch this Final Cut Pro lesson.
In this tutorial, you'll learn how to blur out a couple of car number plates in a static shot in Final Cut Pro. Whether you're new to Apple's Final Cut Pro non-linear video editor or just looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial. For specifics, including detailed instructions, watch this Final Cut Pro lesson.
Learn how to create multitrack sequences within Avid Media Composer 5. Whether you're new to Avid's popular non-linear editor (also known as "The Avid") or are a seasoned digital video professional just looking to better acquaint yourself with Media Composer 5, you're sure to enjoy this free software tutorial. For detailed instructions, and to get started using Avid 5 yourself, take a look.
Need some help figuring out how to get started editing video in Media Composer 5? Whether you're new to Avid's popular non-linear editor (also known as "The Avid") or are a seasoned digital video professional just looking to better acquaint yourself with Media Composer 5, you're sure to enjoy this free software tutorial. For detailed instructions, and to get started using Avid yourself, take a look.
Learn how to import audio, video and images into your Media Composer 5 projects. Whether you're new to Avid's popular non-linear editor (also known as "The Avid") or are a seasoned digital video professional just looking to better acquaint yourself with Media Composer 5, you're sure to enjoy this free software tutorial. For detailed instructions, and to get started importing media into Media Composer 5 yourself, take a look.
Before you can work in Media Composer, you'll need to learn how to work with it. Whether you're new to Avid's popular non-linear editor (also known as "The Avid") or are a seasoned digital video professional just looking to better acquaint yourself with Media Composer 5, you're sure to enjoy this free software tutorial. For detailed instructions, and to get started using Avid yourself, take a look.
Who needs to hit up Taco Bell when you can fashion your own Taco Belle? Watch this soapmaking tutorial to learn how to create a melt and pour taco soap.
Relive your favorite recess exercise by watching this video on jumping rope, a simple but very effective cardio exercise that'll increase swimming stamina.
Creating pixel-perfect web graphics in Adobe Illustrator CS5. Whether you're new to Adobe's Creative Suite or a seasoned graphic design professional after a general overview of Adobe Illustrator CS5's most vital new features, you're sure to be well served by this from the folks at Lynda, which presents a detailed, step-by-step overview of how to use Illustrator to create scalar (i.e., non-vector) web graphics.
In this episode of Oliart, Olivia uses an old pair of socks and fabric to make a Babka (Grandma) doll. Although Olivia uses a sewing machine to make her doll, you can use a non-fray fabric and hand stitching if you don't have access to a sewing machine.
Light up your world with these beautiful and easy-to-make illuminated LED balloons. You will need:
Secret Ingredient host Scott Herbert prepares cheddar cheese biscuits using a non-food secret ingredient: a cast iron skillet. Learn why cast iron skillets have been an essential kitchen tool for hundreds of years and why they can be a healthy choice for your kitchen too. Follow along and see how easy these cheddar cheese drop biscuits are to make.
Animate clips by simply changing an attribute of the clip over time. You can easily animate your clips using the viewer, which allows you to change parameters and motion and updates the clip in the canvas. Animating with Final Cut Express is non-destructive, so you can always undo your work if it is not exactly the animation you want.
Sonic fabric is a textile woven from 50% cassette tape and 50% polyester thread. This video illustrates how to build a "reader" that will enable the user to listen to the sound embedded in the fabric. This allows you to play non-traditional music from clothing that's made of cassette tapes.
Watch this video to check out how to make a home made rabbit snare. If you can't find stainless steel wire, brass or copper will work just as well. Make sure your string is very strong. Consider using a braided twine that is treated with a non-slip coating to prevent knot slippage.
Laser Tag is using lasers and projectors to tag buildings with light! This is a joint project between Graffiti Research Lab and Make Magazine's Bre Pettis. Tag with lights. It's reversible and non-destructive.
Welcome to Minecraft World! Check out our advanced tutorials and come play on our free server. Welcome back to Minecraft World's Ultimate Survival guide! A few days ago, we reviewed a good way to start off right when you spawn, plus a small rundown of the mobs. Now we will continue on to combat strategies. Note that these are strategies, not specific How-To's, so the best way to get better at it is to do it yourself!
Steal too many sweet rolls in The Elder Scrolls V: Skyrim? Or did you *gasp!* kill a lowly beggar? No worry, because today we'll show you how to break out of jail!
In this video, we learn how to remove a tick with Vaseline. First, find the tick on the body of the animal. The tick will be obvious because the skin will swell up around where they are. Use a special tool to help pull the tick off, which has a slit in the middle of it. Now, slide the tool underneath the tick so it's in the middle. Twist the tool a couple of times and then pull the tick off from the body of the animal. After this, apply some Vaseline to the tick and it will kill it off, enjoy!
Call of Duty: Black Ops has a great Easter egg on the main menu which allows you shoot and kill tons of Nazi zombies! And it's really easy to find. Basically, from the main menu, look down at your restraints and start tapping LT and RT to break free. This will give you the "Just Ask Me Nicely" achievement. Next, go to the computer and type in DOA, which will unlock Dead Ops Arcade. When you start playing the game, you'll earn the "Insert Coin" achievement. That's it!
If you had the chance to pick up the Collectors edition of Fallout: New Vegas, you received a beautiful hardcover graphic novel of some of the events leading up to your eventual stroke of bad luck. If you read it, it follows the Great Khans as they travel with Benny to your location, and talks about Chance, the blonde haired, Conan-Like, Great Khan, killed by- hey wait, no spoilers! Anyway, if you'd like to find his grave and his equipment, check out this video! In it you will get the locatio...
This video tutorial gives you a way to access websites that you can not normally access because of a web block or filter. What you need to do is click on the ‘Start’ button and then click on ‘Run’. In the small window, type in ‘cmd.exe’; this then opens a black window. Then type in ‘ping’ and the website; this gives you an address that you type in directly to your web browser, granting you access to a normally blocked website. This comes in very handy when you are in such locations like schoo...
Club Penguin is a flash-based website with an a virtual world of online games for kids to play. Learn how to hack Club Penguin with tricks and cheats. Watch this video tutorial to learn how to wear member clothes as a non-member in Club Penguin (09/23/09).