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.
Here's a quick and dirty little series on the very basics of non-linear editing. If you're not using FCP, don't worry, every non-linear editing software package functions in more or less the same way.
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).
If you are planning on removing a wall or adding a door in your home it is important that you be able to identify walls in your home that are bearing the weight of other parts above them or around them. Learn clues to help identify bearing walls in various parts of your house. Identify bearing and non-bearing walls.
Microsoft has the HoloLens and Google has their money on Magic Leap (as well as their own Tango and Cardboard, among others), but we've heard next to nothing about how Apple plans to enter the virtual/augmented/mixed reality space. A new patent offers some clues.
Ad blocking on Android usually requires root access, but a pair of new browsers based on the open source Chromium and Firefox builds are looking to change this.
If you have scissors, measuring tape, 1-2 yards of a non-fraying fabric, and chalk, you can create a sleeveless cardigan without sewing one inch of fabric! Pick a fabric that you like and wear it proudly after only an hour's worth of work.
Butterflies are truly beautiful, delicate creatures. And while many people enjoy collecting them post mortem to stash like collectibles under glass, we personally find that a little creepy.
Learn how to to make a light, non-chain-stitched loop fringe using broomstick crochet. Though called the broomstick technique, you needn't use an actual broomstick, just something that recalls the shape of one—like, for example, a cardboard paper towel tube. For detailed instructions, watch this free video crochet lesson.