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 307th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, ROWS, COLUMNS, LARGE, SMALL functions to create 4 different formulas that will invert a range 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 286th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate hours worked for a night shift where workers start at 9 PM and end at 5 AM.
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 275th installment in their series of digital spreadsheet magic tricks, you'll learn how to reduce a column of numbers by a set percentage (in this case, 35%) quickly!
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 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create sequential numbers in formulas using the ROWS function.
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 208th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the keyboard ctrl-enter keyboard shortcuts to speed up common tasks in Microsoft Excel.
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 249th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Advanced Filter to extract records from a database (table or list) to a new 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, the 239th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a chart for a linear function of X in Excel as well as how to use a text formula to display a function of X.
Windows 7 is fairly similar to Mac OS X out of the box. But what if it's not similar enough for your tastes? Then you follow this free video guide, that's what: with its help, you'll learn how to use Snow Leopard-style file stacks on Microsoft Windows 7 desktop. For complete instructions, watch this tutorial.
Losing weight can be simple if you follow one rule: Cut calories! In this Ask Amy tutorial, your neighborhood nutritionist shows you how to cut back on the calories and lose the weight easily without feeling like you are sacrificing your favorites. Follow Amy's advice and you will be fitting into your jeans easier sooner than you think!
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 151st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the days, months or years between two dates using Excel's undocumented DATEDIF function.
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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from standard table and put a record in a column using the VLOOKUP, IF and ROWS functions.
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 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.
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 568th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a SUMIFS function to tabulate a monthly running total from transaction data.
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 246th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a waterfall profit chart from a stacked column chart.
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 9th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Excel's EXACT function to check to see whether two text strings are equivalent and whether or not they have the same case.
Whether you're new to Adobe After Effects or a seasoned digital video professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn what you can do to optimize your hardware for optimum performance.
Whether you're new to Adobe InDesign or a seasoned digital video professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to create a more engaging experience with web DVDs that include a search interface for viewers to jump directly to content of interest.
Whether you're new to Adobe InDesign or a seasoned graphic arts professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to work with documents when designing in Adobe Indesign CS5.
Whether you're new to Adobe After Effects or a seasoned video editor after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to use the newest version of the Mocha 2.5D planar motion tracking software.
Whether you're new to Adobe Photoshop or a seasoned graphic arts professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll join Terry White as he runs through his 5 favorite Photoshop CS5 features, including the new enhanced selection abilities and noise reduction tools.
Whether you're new to Adobe Photoshop or a seasoned graphic arts professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll join Terry White as he walks you through using the new Photoshop CS5 and Photoshop CS5 extended (including the new Mini Bridge, which can be used across the full creative suite).
Origami is an art form, but origami using dollar bills? It takes this art form to a whole new level! In this three-part video tutorial, learn how to fold an F-18 Hornet fighter jet plane out of a dollar bill, origami-style.
For all your origami enthusiasts, take your art of origami to greater heights by using a dollar bill to create the impossible—fireworks! In this two-part video tutorial, learn how to fold origami fireworks from a single dollar bill. It's a great origami project for the 4th of July or New Year's Eve.
"You're lucky, he's lucky, I'm lucky, we're all lucky!" If you're quick to spot who said this great line in the ultimate 1975 cult classic, "Rocky Horror Picture Show" then you will enjoy this tutorial. In this makeup lesson, learn how to steal the look of the character Magenta (played by the amazing Patricia Quinn) with the help of makeup and hair created by a Fashion Face expert.
This video shows you how to apply a breezy, ocean inspired eyeshadow. With beautiful blues and greens you'll have the ocean at each blink of your eye. This is an easy to follow tutorial for anyone interested in having an ethereal.
Whether you & your friend are planning an "at home fashion shoot" for fun or you're looking to try something new, this look created by Misschievous explores the avant garde and high fashion makeup looks that hit the fashion runways. Apply this creative gothic-style makeup look with help from this step by step makeup tutorial. Wow your friends & others by stepping out in style & sporting this edgy makeup look!
This two part tutorial will teach you exactly how to close a wound like a doctor would. This is a good skill to master for emergency situations where medical help may not be immediately available. Watch this video for step by step instructions on how to suture.
Nothing soaks up sauce better than a big piece of French bread. In this two part tutorial, learn exactly how to make bakery style French bread from scratch and impress your guests!
This two part video will show you how to make the Japanese 8 in 2 patter, an important part of making a chainmail cube.
Nick from Greyscale Gorilla gives a great tutorial on not only how to adjust the hue and saturation of various objects in Photoshop, but he also demonstrates how to select and isolate these objects for better chromatic keying.
This video teaches you a wonderful alternative to eating ramen noodles, or eating on a budget. This creative easy to make dish is great for a college student, or anybody unfamiliar of the kitchen. Sick of those simple flavored ramen noodles? Well this tutorial shows you how to spruce up this dish in no time for yourself or your guest.
Have you ever wanted to create a background with one of your photos? This video shows you how to use one of your photos to create a photo background using Adobe Photoshop. It will show you how to use the free transform tool, overlay blend modes, hue and saturation, drop shadows, and other cool effects. Learn all about creating photo backgrounds with this video tutorial.
A nice way to wind down at the end of a hard day is with a face massage. In this tutorial, Athena, a Cranio Sacral Therapist, licensed Massage Therapist and a Lymphatic Drainage Therapist, shows you how to perform a very professional massage on someone's head and face. Follow along with Athena and she shows you step by step how to give someone a face massage and reduce their tension.
Darci Larocque, Blackberry Expert, explains a quick way to hide sent messages from your inbox folder with a few simple clicks, leaving clutter and needless distractions behind. This easy-to-understand tutorial is fully complete from start to save with visible screen shots and clear concise directions. There is even a simple two-button solution to see your sent messages again as needed. With a few easy steps, your inbox clutter can be a thing of the past.
Shrimp curry is the perfect spicy dish to warm you up on those cold winter evenings. This traditional Indian meal is not difficult to make. Follow along with this video tutorial, and you will learn how to make yummy shrimp curry - step by step. This unique recipe serves approximately four people and is usually served with plain or fried rice. Enjoy!
In this video tutorial brought to you by photoshopuniverse, you will learn how to apply mood lighting to images in Photoshop. This is achieved by applying an adjustment layer, called a gradient map, which allows you to adjust the color of the light in an image. You will learn how to access the gradient map from the adjustment layers menu, how to apply the gradient map, then overlay the new layer and fine tune the gradient to create more dramatic looking images.
If you've ever wondered how you could possibly create hairy balls in Cinema 4D, wonder no more. This video tutorial shows you how you can use the software and a picture of chicken legs to reproduce the texture of human balls and a scrotum. Follow along with smearballs as he shows you how to copy and clone the texture of chicken legs, create the balls themselves, and the scrotum. Check it out yourself!
In this makeup tutorial, learn how to apply the makeup look of movie character "Marla Singer", the badass chick from Fight Club, played by Helena Bonham Carter. To achieve the misty, dirty smudge look applied in this video, the following products were used:
A renowned pop-culture icon, Michael Jackson revolutionized the arts of pop music and dance with his large body of work. Learn one of the most famous dance moves, his 'Smooth Criminal' move, in this step-by-step tutorial.
Creating text that catches the eye can be difficult. One great trick is to have your text actually composed from an image. Using Photoshop CS4, you can quickly create professional-looking text from a single or multiple images. Watch this video tutorial to find out how.
