Looking for an introduction on how to work with macros in Microsoft Excel 2007? Learn how to create linkage formulas in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started using absolute and relative macros in your own Excel 2007 workbooks, watch this free...
Refining selections and creating masks are unglamorous but utterly essential Photoshop techniques—you've got to master both in order to perform tricky compositing tasks, such as extracting a person from an image and then adding a different background.
This video tutorial demonstrates Photoshop CS5's bristle brushes, which simulate traditional paint brushes—the kind your local art-supply store sells—and its new Mixer brush, which lets you give a photo a painterly look. Along the way, its host passes along a tip for customizing Photoshop's interface—one of those little chores that can save so much time but that so few of us do. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking...
Have a digital image that's a little bit too dark or otherwise lacking in depth? Your fix is just a few mouse clicks away. This free software tutorial will teach you how to use the new Brightness & Contrast tools within Adobe Photoshop CS5. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this free video tutorial.
With Adobe Photoshop CS5, it's easier than ever to work with HDR or high dynamic-range images. This video tutorial presents an overview of some of the bigger enhancements. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this free video tutorial. For more information, and to get started taking advantage of Photoshop...
Comic books are a great way to express yourself and you no longer need a pencil and paper to draw these books. In this three episode tutorial, learn how to use computer programs to draw professional style comics and share them online. This method of comic drawing is the new industry standard, so follow along and learn how to make your comics stand out above the rest.
"Sex and the City 2" is about to take the box office by storm and bring everyone's favorite foursome back into our lives. Get ready for this fun, sexy movie with a makeup look inspired by Sarah Jessica Parker.
Do you dream of being the next American Idol? Even the greatest singers can get lost with a bad audition. You sometimes only have one shot to prove your talent and singing alone in the shower and singing in front of judges is incredibly different.
There are so many different kinds of shoes, it's hard to keep up with them. There are casual shoes, professional looking shoes, athletic shoes, shoes for swimming, shoes for dance, and the list goes on. But one of the main constants about most shoes it the fact they have laces to them. Laces have been used for many years and is still the best way to ensuring your don't have barefeet. This video shows you how to bar lace an athletic skate shoe as well as a man's office dress shoe. Enjoy!
Chances are, if you're a branding or marketing professional, you've been tasked to come up with a new name for a product, a service, or maybe even a company at some point in your career. Maybe you're trying to come up with a new brand name right now. Well, there are objective measurements for choosing new names, and if you need help figuring these out, watch this video tutorial to learn how to develop a new product or company name that will stand out among your competitors, presented by namin...
The White Russian is the grandfather of all cocktails. This drink is a classic mix of liquor and milk that provides a creamy, delicious drink for any night of the week.
Just because it's called palm reading doesn't mean it's only "palm" reading. Palmistry involves more than mere palms — it looks at all parts of the grasping side of the hand, including the fingers. And in this two-part video from Jim Winter, a professional palmist, tarot reader, face reader and graphologist, you will learn the secret, underlying meaning behind a person's fingers. Knowing the digits is just as important as knowing the sweaty palm.
If there is anyone who can help you get closer to finding your true love it is Dr. Diana Kirschner. Dr. Kirschner is a love expert, media psychologist and bestselling author. She is the go to psychologist on most talk and reality TV shows and for newspapers and magazines in need of a relationship expert.
This video shows us how to draw an electric eel even if we are not professionals. We start by drawing a flag shape (like two cylinders connected) as this being the body. After this we can draw the eyes, one fully visible and the other only little because is in the back. Now we draw an open mouth and here we can let our imagination go wild an could put there some fangs, a tongue but do not forget to draw some shadows in there to be more realistic. For shadows you can use the edge of your penci...
In this instructional video, the young host demonstrates an excellent method for cleaning your DVD's, CD's, and Game discs using simple, easily found items that you always have laying around your house. The toothpaste he uses acts as a super mild abrasive (almost exactly the same that is used in professional kits, except they don't get the benefit of a minty fresh smell) that removes minute dirt and debris that gets stuck on the disc. When cleaning your discs, be sure to rub the toothpaste in...
This video shows you how to clean a compact disk using peroxide and toothpaste as the cleaning agents.First of all, put the disk in a mixture of water and a bit of peroxide and let it stay there for about 5 minutes. Then, you must take out the disk and apply a thin layer of toothpaste on the whole disk's surface. Let it sit like that for another 3-5 minutes. After that, clean the disk with water. Use it only when it is dry. If this method does not work, then you should either take the disk to...
Whether you're new to Adobe Photoshop or a seasoned graphic design professional after a general overview of CS5's most vital new features, you're sure to be well served by this (17-minute) official video tutorial from the folks at Adobe TV. In it, you'll learn how to do each of the following: realistically blend colors on canvas with the new Mixer Brush; create superior composites for print or web layouts with new technology that makes it easy to select even the trickiest image elements, like...
In this video tutorial series, DJ Sarah Main explains how to become a working professional DJ. She offers tips on how to set up your digital DJ rig, cueing up tracks in the mix, and cataloging your music library. In the second half of the series Sarah shows how to mix tracks with the cross fader, and progressively layer audio elements.
Head Judge for the World Latte Art Championship, Paul Meikle-Janney, shows how to make a latte using the Brasilia Opus Sublima espresso coffee machine. Paul briefly explains that the process is somewhat similar to creating a cappuccino, noting that the major difference is how much foam you'll be creating on top of the beverage. This video shows the necessary steps taken to create the latte, creating the foaming texture and the single espresso at the same time. During this process, Paul offers...
This how-to video is a vibrant and animated tutorial on how to paint children’s furniture: in particular, a little girl’s tea table and chairs. It’s fast paced yet easy to follow. The video couple takes you from the taping and preparation of the table and chairs to the completed and professional quality finished product, which would thrill any little girl. Their method of communicating the most important steps is to race to the camera and speak to the audience, in an amusing sort of wink, whi...
Professional trainer Joel Harper shows us how to do the "abs matrix" a runner's abs workout. -First, you are going to want to grab some weights.
Professional trainer Joel Harper shows us how to do the Tick Tock runner's ab workout. -Put your feet all the way together, put your hands in prayer position and bring them above your head.
Make the perfect decorative cake for a soon-to-be-mom's baby shower with an impressive baby-themed cake topper! In this two-part video tutorial, learn how to shape a mini baby carriage out of gumpaste for an exquisite cake decoration, sure to impress any party! Learn step by step how to assemble, mold and shape this cake piece to lend professional-looking results.
Looking to make your next cake stand out? How about giving it that extra "umph" with a unique cake decoration topper? In this three-part video tutorial, learn how to make an adorable angel cake topper out of fondant icing. Get step by step instructions on how to take pieces of molded frosting and turn them into this perfect & professional looking cake accesory.
Got a new Vivitar 285HV and having trouble using the flash? No problem! This video will describe how to use the flash on your new camera and gives some other great tips for new owners! The flash on this camera can be a little different to use than an automatic flash because you have to manually set the settings. Since you can see what the picture looks like if you aren't satisfied you can use the tricks in the video to play around with the flash settings until you get the perfect shot.
This Photoshop tutorial on performing a nose job using Photoshop contains detailed instructions on the use of Photoshop tools to, depending on taste, enhance the appearance of an individual. The person narrating the tutorial specifies the necessity of subtlety with the modification of the picture in order to remove any appearance of modification. The way described is essentially to select the general nose area, feather the selection by an optional amount, and set it in a separate layer. Then ...
In this video, viewers learn about factory maintenance schedules and how to care for a vehicle. The series explains the differences between repair and maintenance, and the difference between do-it-yourself repair and professional auto repair services. Tips address choosing an auto mechanic and following factory and maintenance schedules. Increasing your vehicle's safety, reliability and longevity through proper maintenance also is discussed. This video will benefit all viewers who own a vehic...
The Video On Demand highlights how amazing backgrounds are inserted behind characters and will show you how to composite video so your characters can seamlessly move in front of these images. Computer generated video objects may be superimposed over a background video image so as to create the illusion of a single composite scene. The leading edge of an object is detected and for a period of time the object and background video signals are mixed. After that period, only the object video is tr...
Rick Vanman reveals the secrets to professional video effects using your own computer software. Position your model houses into a setup of your liking. Take a picture of the houses with a digital camera using the macro setting. Edit your picture in Photoshop. Disguise any unwanted objects with the cloning tool. Separate the foreground and the background of the picture into 2 different layers. Film yourself in front of a green screen. Key out the green with your video editing software. Using y...
Correct the midtones (the coloring) of your photos with this easy to follow guide on using the Photoshop program. Make the true colors shine through and brighten those washed out photos with just a few simple steps. He shows you how to make the improper colors show themselves with just a few clicks of the mouse and then how to fix them with ease. Don't waste precious money having a professional retouch your photos when you can do it from the comfort of your own home by calibrating the color o...
This how-to video shows viewers how to create their own custom paint job at home by yourself. The segment is a continuous video in fast forward. The video explains how to do everything from taking molding off, sanding the old paint, fixing the dents with bondo, to the actual spray painting of the car. The person in this video uses an airbrush, spray-paint, paint markers and canned paint to create his custom paint job. The artist paints a picture of pirate ships, skulls, and other various obje...
Photoshop is a wonderful tool for photographers, from amateur to professional. If you have photos of waterfalls that you would like to tweak to make the water appear smoother, this video will walk you through the process step by step. If you are using a digital camera or don't want to use a tripod, then the only way to smooth out the waterfall is to use editing software like Photoshop. By following the easy to understand instructions in this video, you can edit your photos to look exactly how...
With yet another great instructional video Lowe's home improvement expert, Mike Craft, hosts this do-it-yourself demonstration brought to you by home improvement retail outlet, Lowe's on how to replace or install a new bathroom ventilation fan. The video will give you all the information you need on how to complete this project at home, and without hiring a professional. Providing a detailed list of the tools, supplies, and tips you will need, Mike shows you how to complete this project and h...
Ron Hazelton shows you an easy an effective way to wash windows. In a warm bucket of water you add one tablespoon of dishwashing solution, a scrubber with sleeve is used to apply the solution to the window, and dried with a professional quality squeegee. Each step is shown and explained in full detail to ensure the best possible completed outcome. After watching this video and walking yourself through the steps a few times you can wash a good sized window in about a minute.
This quick and simple technique shows viewers how to acquire a good manicure. After washing your hands and removing any existing nail polish, mix oil and sugar in a bowl and put it aside while filing your nails. Scrub the oil and sugar mixture over your hands and then submerge your nails in hot water for a few minutes. Push back any cuticles you may have and massage your hands in oil. Wet a damp cloth and put it in the microwave for a few seconds, then wrap it around your hands. If desired, a...
For people who would like to learn how to make a professional tattoo, this is the tutorial to watch. For making a basic arm tattoo, the subject should be seated upright in a military position. You should apply some alcohol and then some antiseptic to the area to disinfect the area and place the stencil over the area. It is suggested that the subject shave his or her arm in order to get the best effects. The tattoo stencil should be placed over the center line of the arm and align it properly,...
Sick of paying people to do things you could do yourself if you knew how? In this five-part video tutorial hosted by the Handyman Teacher learn how to install a brand new garage disposal in your home with the help of your own two hands. Don't waste your money on hiring a professional, learn how to do it yourself!
What could possibly make shooting home videos even easier than they already are? A camcorder handle. This is a cheap, easy, legit way on making a camcorder handle.
If you have some hybrid golf clubs, then you need to know exactly where to place the ball for correct contact. Learn to make solid contact with your hybrids by mastering ball position. Frank O'Connell shows us the proper stance and position for hitting hybrids.
Are you having trouble with your green reading? It's not an easy task, but you can learn it. Green reading doesn't start when you get to the green. In fact it starts when you approach the green. In this video, Rick Sessinghaus divides the art of green reading into four parts, from approaching the green to standing over the ball. See how to read the green on a golf course.
