This Software video tutorial shows how to organize images in Lightroom with multiple cameras. Kerry Garrison will explain how to do this by adjusting the time offset of all of the images from one camera. You can take a shot in the beginning and synchronize the rest of the images. There is a tool in Lightroom to accomplish this. Select the live drawing mode, then go to the grid mode and the meta data bar should be displayed on top. The different cameras used in the shoot are listed there. If y...
You can use the vlookup function in MS Excel to create a dynamic table in your document. Creating a new dynamic table and a new dynamic lookup area enaables you to add new data or new columns to the lookup table. You can also create dynamic named ranges by using offset, vlookup table and the match table. This function is very useful to businesses working on Excel. This video will show you to create a dynamic table for vlookup in Excel.
There are few animated characters more iconic than Disney’s Cinderella. Her tale is one of wonder, and her likeness is easy to recreate through a simple process. This video tutorial demonstrates how to draw and color Cinderella. Start with a basic line sketch of the princess herself, making sure to include puffy dress sleeves and a large pleat in her gown. In a new layer, trace over her figure with more definite lines and draw on her facial features. Color in her glorious ball gown with vario...
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.
Homemade, handmade - Poppy Seed Dinner Rolls are amazing - made will all natural ingredients. With this recipe, you can totally resist the totally resist the urge to reach for those popping ones on the supermarket shelf.
Compared to ladies of the '40s and '50s, we are damned lazy ladies today. Most of us wouldn't flinch to pull on some sweatpants to go the grocery store or even to go to school. And while we totally dig comfort, which is a good thing, it's nice to "put on your lady face" every once in a while an dress up a bit before you go out.
Longboarding is one of the most fun things that you can do in a dry, hilly, sparsly-populated (if you value your life) area. This video will teach you how to do a cool downhill longboarding trick, a toeside predrift. It's gnarly, dangerous, and totally awesome.
Turn your American Apparel Le Sac dress into a cute Gathered Mini. It's a fun look and really easy to accomplish. The Le Sac dress has at least TWELVE different configurations for you to enjoy, which means more closet space, and less laundry! It can be a totally new dress each day of the week. Follow along and get this easy, sexy style that's perfect for summertime.
You're not going to be good at Parkour and freerunning if you are wearing the wrong type of shoes. This sport depends totally on your feet, so make sure they are outfitted in the best soles possible. In this tutorial, learn how to choose your shoes so that you get the highest jumps, the slickest runs and the coolest tricks.
In this clip, learn how to perform the "ferris wheel" with your Zippo lighter. You will learn how to toss an unlit Zippo into the air and spin it, and then catch it lit. You will fully rotate your lighter just like a ferris wheel and look totally rad, from now on, everytime you light a cigarette.
Assemble tools and materials. You'll need a rim, a hub, and the proper length spokes and spoke nipples. You'll need a wheel truing stand, a spoke wrench, a flat screwdriver, and medium weight oil. A spoke tensiometer, a dishing tool and a nipple driver are optional. Place the rim in your lap with the valve stem hole directly across from you. Hold the hub in the middle of the rim with it axle vertical. These instructions assume you are building a front wheel 3x. Drop one spoke though every oth...
We totally get it if you're a present wrapping procrastinator. Thinking about what presents to get your friends and family is hard enough, and then actually going to the store and shopping around for them for hours on end is exhausting. By the time you have everything in front of you, the thought of wrapping them is just painful.
Facebook doesn't make it easy to export your contacts' email addresses from their site. But you can totally do it. And this clip will teach you everything you need to know. (Note: To follow along at home, you'll need to create a new Yahoo! Mail email account.)
On the new iPhone 4 and in iOS 4 you are able to set a wallpaper as a background. In the past, wallpapers were only used on the lock screen and in this clip, you will see just how easy it is to set the old lock screen as well as the screen behind your app keys. This feature was only available on jailbroken devices in the past and now it is totally safe and made especially for you, by Apple.
In this video, learn what to do when your Zippo runs out of fluid. You won't be able to get a good flame or perform any tricks without a totally full Zippo and in this clip, you will get a step by step on refueling. Follow along and stay safe and strong with your flame.
You don't have to be a Cirque du Soleil freak to show off fire-eating skills. Learn how to use a clever science trick to eat fire without totally killing yourself.
It's always wonderful when you're sporting a fashion accessory at school that you know nobody else has. This tutorial gets you looking mighty fine for the price of a dime (sort of), and all in less time than it takes to steam rice!
This video tutorial will show you how to create a hair look like Rikku from Final Fantasy part 3. This hairstyle is totally perfect for Cosplay, or if you are daring - everyday wear!
Proper Scene style requires the right clothing and accessories. You can't look totally Scene without the right finishing touches. Check out this video and accessorize yourself Scene.
There are different types of Scene girl hairstyles, and in this video you will learn how to make your's extreme. Extreme Scene style is usually made up of crazy colours, and funky spikes and layers. You will be the hit of every party with your new, totally awesome Scene style.
If you're a serious film buff then these glasses will totally give you a cinemagasm. This polarization filter uses a pair of 3D glasses as a base and combines the glasses with a lens cap to reduce glare and any reflections that could tamper with your viewing experience.
Want to know how to grip an offset driver when golfing? An offset driver is one where the shaft is behind the head, propelling the face forward and giving the club a closed appearance. The advantage of the offset club is that it helps you to hook the ball.
If we had the time, we would totally make all of our own Valentine's Day cards. But if you have kids, then you know that crafting 36 individual cards for each student is more than a pain in the behind.
When it comes to Halloween, you can go all out with your macabre self and have fun being sinister and it'll be totally normal. So instead of settling for cheapo fake scars, bruises, and tears that you buy at Halloween discount stores this time of year, why not make your own?
If you remember Kristen Stewart's makeup at the New York City screening of The Twilight Saga: Eclipse movie on June 28th, then you know it was her best yet, with a totally unique smokey eyes look, with a combination of red and black eyeshadows. This makeup tutorial will show you how to get that exact makeup look for yourself!
If you've recently upgraded from Windows XP to Windows Vista, the first change you may have discovered is the start menu. It looks totally different, and if it's just too much change for you, there's an easy way to convert that new start menu in Vista to the classic style from XP. This video outlines the simple steps to getting it done.
Learn how to get that perfectly girlie look with this tutorial. In it, you will learn how to use pink eyeshadow and rose shades to make yourself look totally adorable. This clip is easy to follow and fun to do, and works great for spring or summer.
In this clip, learn how to take two totally unrelated images and manipulate them so that you get one crazy new picture. This is a relatively advanced Photoshop tutorial, so make sure you know what you're doing or you might find it a bit tricky. In this particular video you will be adding a lion's mouth to an apple and the files you are using are listed below.
Your guests will be very impressed with all the effort you put into these origami invitations. In this clip, learn how to make a totally unique invitation for your next event. These origami letters will set the perfect tone for your next gathering. Have fun!
In this tutorial, learn how to get a little bit of Droid on your iPhone. You will get a step by step on how to install the Android locking screen on your iPhone 3G or 3GS. This requires a jailbroken, Cydia-enabled phone and a little work, but the cool effect is totally worth it. Check it out!
In this clip, learn how to use corn syrup, food coloring and a baby bulb syringe to fake slit your wrists. You will also need a razor blade. Use this trick if you are feeling super emo, or need a special effect for a movie you're making. This trick will totally freak out friends and family - it looks so real! Have fun and be careful!
In this clip, learn how to make a very cool duct tape wallet with multiple credit card flaps. This detailed billfold can be made into a bi-fold or tri-fold shape and is sturdy enough to carry an array of cards and cash. So, follow along and start building your very own, totally unique, wallet.
Check out this totally radical re-vamp of a game. In this tutorial from IGN, learn how to hunt some awesome new achievements in Teenage Mutant Ninja Turtles: Turtles in Time Re-Shelled. This awesome reboot is fun to play and if you are an achievement junkie like most gamers, you will love these quick tips. Cowabunga, dude!
Wallpaper is totally outdated, isn't it? Have you ever moved into a new house and decided - yikes - this wallpaper HAS to go? We have all been there and in this tutorial, Lucky Larson will show you exactly how to get rid of those icky flowers or ugly stripes. Lucky uses enzyme spray and a simple putty knife to remove the paper in the easiest way possible.
In this video, draw a totally tough pirate skull with burning flames coming out of it. This will make a cool tag or tattoo and this tutorial will show you exactly how to draw it.
In this tutorial, Elizabeth Gleeson shows you how to take an ordinary thrift store find like a slip and repurpose it into a totally cute and wearable minidress for summer. This look is so cheap to create and will look great all season long! So, follow along and save money this year with this quick and easy video from Emerging Thoughts.
In this video, Elizabeth Gleeson shows you how to take one of your husband/dad/brother's old ties and turn it into a stylish belt in less than ten minutes.
Have you ever wondered what you would look like with bangs but don't want to cut your hair? Check out this tutorial, then! In this video, Judy will show you how to create fake fringe that looks totally real so you can try out a new look without a big commitment. Have fun and see how many compliments you get on your new bangin' bangs!
Shreds aren't only for jeans these days, you can also shred your leggings and tights. In this tutorial, learn how to properly rip tights yourself so that they don't get totally destroyed. If you rip tights the wrong way you can cause a bigger tear and wind up unraveling!
Double flared plugs are everywhere these days. So...how do I put them in?
