Learn how to find the difference between two dates with MS Excel 2010's DATEDIF function. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.
Learn how to make time-based calculations with the TODAY and NOW functions in MS Excel 2010. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.
Learn how to round to a given interval when making time-based calculations in MS Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.
Need an introduction to Excel's useful TODAY & NOW time functions? You're in luck as this clip provides just that. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.
Foosball, the tiny table-based version of soccer, is one of the most popular games in fraternity houses and bars across America. It's great for bringing four people together, and is easy to learn but difficult to master. If you're looking to improve you game, watch this video. It will show you how to lift the ball off the table for aerial shots, which look really flashy and will score you goals if you can pull them off.
Want to play "I'm Looking Through You" by Paul McCartney of the Beatles on the ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started p...
Angelina Jolie is our hero. After all, she is a humanitarian, a loving mother of six, an Oscar-winning actress, and as of yet the only female actress out there who can play a usually male-centric spy role and be an action movie star without any sort of gender bias. Oh yeah, and she's the most gorgeous woman in the world.
For those not in the know, the Perrier ad campaign by Dita Von Teese is a sexy commercial that Von Teese did for the sparkling tonic water company that includes naughty burlesque dancing. In the commercial, Von Teese sports her signature pinup makeup look with false lashes, liquid cat eyeliner, and of course buxom red lips.
In this tutorial, we learn how to create an everyday contoured look. First, apply a full coverage foundation to your face. Mac is recommended, using a color that is a match to your skin. Blend this on the face using a foundation brush. Next, apply a loose powder over your skin with a brush to settle the foundation onto your skin. After this, you will brush a bronzer of your choice onto the cheek bones, followed by a blush brushed onto your cheekbones. After this, you can also brush the bronze...
There's no better time than summer to integrate bronzer and bronzy makeup colors into your primp routine. After all, your skin already radiates a lovely natural glow from all the sun you're getting, so the bronzy colors only help to emphasize your skin's luminescence.
Unfortunately for the greater portion of gals who live in or close to cities, we aren't blessed with idyllic, wide open spaces filled with green meadows, wildflowers, and perfect clouds in a perfect white sky. Uncommercialized or used spaces are hard to find, which is why getting a taste of green scenery is so important for our well being (it's easy to feel overwhelmed by city life!).
In this clip, you'll learn how to use nondestructive layer masks in Adobe Photoshop to create modern-looking posters and backgrounds. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
The lasers from Halo might not be quite as famous as the assault rifles form the games, but they are still a very cool-looking and integral part of it. This video will show you how to make your own replica of the Spartan laser from Halo out of a toy gun called the Belt Blaster. The end result looks so real it might get you arrested by any cops from the future that you may run into, so be careful.
In this tutorial, we learn how to create a burnt burgundy contoured face and eye look. First, apply a primer to the entire eyelid as a base. Next, apply a shimmer pink eyeshadow with an eyeshadow brush. Next, line the lash line with black eyeliner, and then blend a burnt burgundy eyeshadow onto the outside corner of the eyelids. Circle the brush so the colors all blend into one but will still have the darker color on the outside. Next, take the same burnt burgundy color and pant it onto the b...
Looking to make your Google Nexus One or HTC Evo smartphone even better? Unlock your phone's full computational potential while following in a tried-and-true geek tradition: Install Linux on it! This video guide presents a complete, step-by-step walkthrough of the process. For more information, and to get started installing the Ubuntu Linux distribution on your own Android smart phone (without blowing out your phone's Android installation), take a look!
In this video clip, watch and learn how to style your American Apparel Le Sac dress into a cure Jumper look. It makes the perfect day dress, and you can step into the dress as you would with the Classic look. This look is easy and will make it seem like you have on an overalls-type outfit. Follow along and look cute with this cool, versatile dress, which has at least TWELVE different possibilities. It's a new dress each day of the week!
One of American Apparel's most famous articles of clothing for women is their Le Sac dress, which is no ordinary dress. It's simplistic look mocks it ingenious design, which can be shaped, formed, mutated, tie, and tucked in at least TWELVE different ways to create a different dress for each day of the week. The Architectural Mini look is just one of the ways to style it, and this video shows you exactly that. Use this art deco style for a sexy, architectural inspired halter look.
Can you believe this dress? American Apparel have outdone themselves again! A dress that's not just "one" dress, but at least "eight" dresses. The Le Sac dress is a marvelous article of clothing because it can be worn every day of the week… without looking like a hobo. It's a different style each day, with at least TWELVE different styles. And there's even a look for you dominatrices out there, a super sexy and daring S&M style Dominatrix look. See how easy it is!
American Apparel is famous for selling articles of clothing that can be worn in multiple ways. Their latest creation is the Le Sac dress. This dress can be tied and twisted all over the place to come up with TWELVE or more styles! You can wear this outfit every single day and everyone would think you were in something new. So, if you are looking for a sexy, Greek-inspired off the shoulder look, check this official tutorial out for the Grecian look. Learn how to wear your Sac and look amazing.
Lady Gaga is known for her crazy fashion style and now you can achieve the same look at home. Using simple household products, you can assemble this gothic vampire queen crown that lights up just like Gaga's. This "Alejandro" look is one of her most extreme and would be perfect for Halloween or even a daring night out. Have fun!
In this episode of Bella TV, learn how to curl your hair into tight ringlets like Christina Hendricks in the Twilight Saga. Celebrity hairstylist, Philip Carreon from "Project Runway" will show you how to get those perfectly coiled curls just like Victoria at home. Go see Eclipse while rocking a look from the film with this voluminous hair look
If you are looking for a truly inspiring pasta, check out this tutorial from Food Mobs. This lemon prawn pasta dish is actually quite healthy and super easy to prepare so you can eat it at any time. If you are hungry and looking for something delicious and fast, this is the perfect recipe for you. Your entire family will enjoy slurping up this lemony dish. Enjoy!
Purple and burgundy are not two colors that immediately come into mind when you think about eyeshadow colors. After all, deep reds and purples are much more suited to bold lipstick hues than to pretty peepers.
Lady Gaga is the queen of crazy makeup and in her new video for her hit, "Alejandro" she certainly does not disappoint. Gaga dresses like a gothic vampire diva in this clip and by checking out this tutorial, you can learn how to achieve the style yourself. This detailed walkthrough is one of the best and you will look amazing just like Lady Gaga.
In her music video for "Not Myself Tonight," Christina Aguilera engages in some, er, racy antics, such as humping a guy with minimal clothing and practicing bondage/bdsm. All in a day's work for shock queen Aguilera, right?
Are you a fan of winged cat eye liner but don't want to go so bold with the color intensity? Then switch from your black liquid eye liner to a black pencil liner to create a more natural looking yet still defined eye.
A wire mandala is basically a wire halo of sorts, meant as a geometric configuration which contains the image of a deity. For some, a wire mandala can be used for meditation and stress relief, while for others it is a beautiful religious pendant that can be attached to earring clasps and chains to make necklaces.
Working with Lady Gaga for the "Telephone" music video must have opened up a whole new world of visual possibilities to Beyoncé, because for her new music video, "Why Don't You Love Me?," she goes way out of character to play a '50s housewife and several other '50s archetypes.
Learn best practices for lighting your canvas in Adobe Photoshop. Whether you're new to computer graphics, new to Adobe Photoshop CS4 or a seasoned design professional just looking to pick up a few new tips and tricks, you're certain to like this free video software tutorial. For more information, including detailed, step-by-step instructions, and to get started using natural lighting in your own Photoshop projects, take a look!
Learn how to use Smart Objects in Adobe Photoshop and how they protect your pixels when scaling images. Whether you're new to computer graphics, new to Adobe Photoshop CS4 or a seasoned design professional just looking to pick up a few new tips and tricks, you're certain to like this free video software tutorial. For more information, including detailed, step-by-step instructions, and to get started using Smart Objects in your own Photoshop projects, take a look!
Want to recreate the look of the titles used in Guy Ritchie's 2009 adaptation of Sherlock Holmes? See how it's done with this Cinema 4D lesson. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including detailed, step-by-step instructions, watch this 3D modeler's guide.
Looking for a way to light your flame with flair? Look no further! In this clip, learn how to light your Zippo by smacking it on something - the bar, a hand, a friend.. without ever flicking the starter. This is a cool little trick to earn you some cred in your local pub. So, the next time someone is looking for a light, be ready with this cool effect.
Got a deck of standard playing cards? Looking for your next great illusion? Prefer that it be Kafkaesque? Look no further. In this free video magic lesson, you'll learn how perform the "Metamorphosis" card trick. For more information, including a step-by-step breakdown, and to get started impressing your friends and family with this great trick, watch this prestidigitator's guide.
Got a deck of standard playing cards? Looking for your next great illusion? Look no further. In this free video magic lesson, you'll learn how perform the "Serenade of the Kings" card trick. For more information, including a step-by-step breakdown of the trick, and to get started using it to impress your friends and family, watch this prestidigitator's guide.
Taylor Momsen, eat your heart out. Become the hottest glam rocker in town by watching this tutorial on how to fashion a faded rock star makeup look. With dramatic inky black liner, sooty shadow, and even black rhinestones, you'll create a look that you definitely won't see on anyone else.
Unless you're an actual mermaid or a member of the Na'vi, this insane mermaid look probably won't get you any propositions on the street.
A poker face is sharp, beautiful, and intimidating, giving your target a peak at the cow without giving away the milk. Bring out your inner card-dealing bovine by watching this professional makeup tutorial by makeup artist Reiva Cruze.
In this tutorial, learn how to recreate Lady Gaga's soda can rollers look from the "Telephone" music video with Beyoncé. This look can be hard to get right, but with these steps you should be ready to dance and rock out while remaining confident that your 'do will hold still.
Want to create a realistic-looking fiery explosion? With Photoshop, it's easy. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from TutVids. For more information, including step-by-step instructions on how to create your own custom three-dimensional shapes and how to create a fireball in Photoshop CS3, watch this graphic designer's guide.
Looking for an easy way to create 3D abstract art? Have Photoshop CS3 or later? Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from TutVids. For more information, including step-by-step instructions on how to create your own custom three-dimensional ice sculpture and how to create and apply textures, watch this graphic designer's guide.
