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 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function to sum with specific criteria.
Whether you're new to Adobe Photoshop or a seasoned digital photographer 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. New Photoshop CS5 helps you achieve the visual and emotional effects you’re after with re-engineered features for reducing and adding grain, performing post-crop vignetting, and sharpening. CS5 reinvents HDR imaging with Exposure Merge, which makes it easy to preserve the fu...
Horses don't kick their owners and handlers unless they think it is okay, or unless they think there won't be any repercussions for their actions. The gentleman in this video shows you that being gentle with your horse can go a long way!
When kicking a soccer ball to achieve the best kick you do not want to kick with your toes, you want to kick where your shoe laces are. To kick the ball you don't want your non kicking foot to far behind the ball because this leads to a toe kick. In fact, you want your non kicking foot to be right beside the ball so that when your kicking foot goes to kick the ball it is not a completed kick. This causes the lace part of your shoe to kick the ball. When kicking with the top of your foot it sh...
In this video the host of "Tying It All Together" demonstrates how to create a "Eternity Knot". This type of knot is an attractive way to decorate a rope or string. Strung along one after another on a rope or string, it creates elongated bead-like knots at intervals of your choosing. The Eternity Knot is named for it's resemblance to the symbol of Buddha's all-knowing wisdom and the uncommon quality of his realizations. In this video the host will lead you through the entire process of creati...
Photoshopuniverse will show you how to change a person's hair color in PhotoShop. You can achieve this by using hue and saturation adjustment layers and set to colorize. Set the saturation to about 50%. Go back to the background layer and select the color range select parts of the hair color, select the parts of the hair you want to change and with the eye dropper click it. Once the selection is made invert the selection the color will change. You can now change the hue to make it what you want.
This video tutorial, by photoshopuniverse, shows you how to reduce the depth of field after a photo is taken using Photoshop. This enables you to ensure that your main subject is clearly in focus while the background is out of focus or blurry. First duplicate the layer using the short cut that was mentioned and apply the filter lens blur to the new layer and adjust the radius so that an adequate amount of blurring is achieved. Add a layer mask and bring the subject to focus by selecting the b...
This how-to video describes how to properly contour your face. The process begins by applying a moisturizer followed by foundation, eyeshadow, color and powder. The end result is a perfectly contoured face that puts focus on the elegant features of the face. The entire process takes about 7 minuets to complete and is perfect for girls who want to achieve a modern and modest look that exemplifies their natural features. This is a great way to look great in a small amount of time.
Find out the best ways to use the creep swab in Houdini. An architect in New York came up with a very clever means of distributing various shapes onto a surface using a creep swab. So, if you want to know how it's done, watch this two-part video, which focuses on using the creep tool in conjunction with copy stamping to achieve some unique results in Houdini 9.
A simple water test can be used to check for a properly heated pan. Check out this short video tutorial from Rouxbe on how to test for proper pan heat. This video will support your cooking experience and will provide you with additional relevant information during your culinary time pan frying.
Get a sexy rock 'n' roll look that would be seen on the likes of such stylish celebs as Katy Perry and Gwen Stefani. In this makeup tutorial hosted by the experts at Smashbox Cosmetics, get tips, tricks and secrets to achieving this look without paying for a stylist. With dark, deep lips and a black pussy cat eye applied to your lids, you'll be ready to take center stage!
Upgrade your look this spring with these makeup tips inspired by the sexy style featured on the television show, Gossip Girl. Bronze your skin, add golds to your eyes and contours, and apply a high shine peachy gloss to your lips to achieve this sexy look for your next big outing.
In this tutorial, make-up artist, Kandee Johnson shows how to get Walt Disney's Snow White look down next Halloween! The following products were used of achieve this look: Ruby Woo lipstick by MAC, Chesnut lipliner by MAC, Lise Watier Concealer, false eyelashes, any white eye shadow, Copperplate eyeshadow by MAC, Cork (warm brown) eyeshadow by MAC, rice paper by MAC, and liquid black eye liner.
Watch as amazing make-up artist, Kandee Johnson transforms herself into Barbie with this step-by-step tutorial on how to apply the make-up and look of this famous blond bombshell doll! The following eyeshadows were used to achieve this look: MAC in Pen & Ink, Da Blng, Carbon, Vibrant Grape, Indian Ink, Fig 1, and Deep Damson. LARENIM mineral eye shadows in Bedazzle & Lust and Urban Decay's eyeshadow in Grifter were also used. Additionally used: Hot pink blush as eye shadow, Make-Up Forever ho...
Filming can get REALLY expensive, especially if you're just out of film school and starting on your first major short. It requires not only a camera, but a crane for swooping panoramic shots, a mounted camera rig for overhead shots, lens filters, and moving ground camera mounts, among other things.
"An older gentleman told me the other day "no one makes any records anymore!" Well, I thought to myself; "millions of people make records every week, just not on vinyl or tape like in the old days..."
Learn how to layer your favorite REX loops by linking Octo Rex (OctoRex) instruments within Reason 5. This official video guide from James Bernard of Propellerhead will show you how it's done. Whether you're new to Propellerhead's virtual music studio application, Reason, or their newer DAW app, Record, you're sure to find much to take away from this brief video software tutorial.
Want to know how to measure a chainsaw chain? Pitch, gauge, and the number of drive links are the three numbers you need when it's time for a replacement chainsaw chain. Learn how to take these measurements with this instructional video.
In this clip, you'll learn how to use PHP and CSS to generate active-page button links for your website. Whether you're new to CSS and the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look.
In this clip, you'll learn how to link two or more tasks in MS Project 2010. Whether you're new to Microsoft's popular project management application or are just looking to better acquaint yourself with the Project 2010 workflow, you're sure to benefit from this free video software tutorial from Lynda. For more information, including detailed, step-by-step instructions, take a look.
You can add PDFs, Microsoft Word, Excel or PowerPoint documents to your WordPress blog using version 2.7 of the WordPress software. This tutorial walks you through the steps of uploading your file, creating a link in your post and also pointing out the difference between the two WordPress "Media Libraries."
Google is the biggest and best search engine on Earth, and if you are a webmaster and want your website to be a big success it would really behoove you to know as much about how it works as possible. The Google Webmasters series of videos and website were created to teach webmasters, SEO professionals, and others how Google works by answering their questions and giving them insights into how they can best integrate and utilize Google's functionality to improve their business. This video expla...
In order to find out if an email is a scam, you should avoid clicking on any links in that are in any emails. The links that are attached to emails, in this manner, usually have cloned the website of the institution where you do your banking. The link will look similar to your banking institutions site. Do not enter any of your personal information in emails in this fashion. Your bank will not contact you in this way.
This video tutorial will show you how to create a list of links on a WordPress website. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about its features through videos like this one. Take a look.
Need a primer on how to add, edit and categorize links to your WordPress website? It's easier than you might think. And this free video tutorial presents an easy-to-follow, step-by-step guide of the entire process. For detailed instructions, and to get started working with hyperlinks on your own WordPress blog, take a look!
Want to add an email link to your webpage? See how to create a simple email mailto hyperlink when working in Adobe Dreamweaver CS3 or CS4. Whether you're new to Adobe's popular WISYWIG HTML editor or a seasoned web development professional just looking to better acquaint yourself with the CS4 workflow, you're sure to be well served by this video tutorial. For more information, including a step-by-step overview, watch this free video guide.
In this video, learn how to convert iTunes m4a files into mp3's so that you can share and listen to them anywhere. This tutorial will also show you how to bypass the restrictions on the program and convert as many files as you like for absolutely free.
In this video, we learn how to link turns on a snowboard. First, you are going to want to start in a good balance stance. You will need to learn to use your legs to release your edge and lean into the fall line so you're into a comfortable stance. To release the board into a new turn, drive towards the nose of the board while flattening the foot into the snow. Flex your ankle so you are in a better position to steer the board. You can also rotate your hips to help steer the board. Use your le...
When you register for a new Facebook account you enter your profile details. How ever these profile details can later be changed by editing them. To do this go to your Facebook home page. Open the link that says view my profile which is located beside your picture. You can also click on your name or your picture. This takes up your profile page. At the top you can see boxes which are links to various pages like info, photos etc. Open the info box and there you can see your profile information...
This training video will show you easy techniques to monetize fan pages and groups on the social networking site Facebook! To earn money, you must first crate an account on YouTube, then you need to upload a video. Also you have to sign up for Google Adsense, which will allow you to earn money from people clicking on the ads in your video. Then just create a Facebook fan page with a link to your video. Invite all your friends, and let the ball roll! If a video has 1000'000 views, and ONLY 1 i...
George3694 will show you how to jailbreak an iPhone or iPod touch firmware 3.0. This will work on the iPod touch first and second generation, the iPhone original and 3GS. Download Red snow software from the link provided. Click on browse download firmware and put it on your desktop. Next upload the firmware to your device. Install both features, make sure your device is plugged in and turned off. Follow the instructions and put device in DF mode. Just wait as the software loads to your machine.
This video is an excellent tutorial on how to system link with one's XBox 360. The author informs the viewer that there are four different types of ether net cables that one can use to connect the two consoles. The author then uses one of the cables to demonstrate how easy it is to system link the two consoles. Once that is done, it takes less than a minute to configure the two consoles so that they play in tandem, and the system is ready for operation.
The instructor from ClearTechInfo shows how to clean up and organize the Windows Vista start menu. He shows how the start menu consists of links to programs and not the program itself. He shows how to manage those links by removing those links, add new ones or rename existing ones, or move folders into other sub folders. He shows how to pin or remove frequently used programs to the main start menu. He advises to categorize similar programs under common folders, like 'Media Players,' 'Utilitie...
In this how-to video, you will learn how to access Gmail automatically every time you click a mail to link in Google Chrome. In order to do this, you must have a computer that has the Google Chrome browser, as well as a Gmail account. First, prepare Chrome to use extensions. Right click the shortcut and add the following command in the target path area. After this is done, add the new extension. A crx file from the blog must be downloaded. Install the extension and now you will be able to ope...
This video shows you how to remove the links from a metal watch band. This simple, five minute process will help you resize the band to fit your wrist. You can do it with simple household tools.
Here, Rich Pin demonstrates how to troubleshoot the door check link by working on the Saturn S series. Typical example is the popping sound you hear when you open and close the door.
Cheat and hack Castle Age on Facebook! Castle Age is a new fantasy flash game where you conquer the world with your army of mythical beings. Watch this video tutorial to learn how to get the Castle Age summoned monster link (11/17/09). See how to get the link to your summoned monster without posting a call to arms! See why it's done this way.
Cheat and hack Castle Age on Facebook! Castle Age is a new fantasy flash game where you conquer the world with your army of mythical beings. Watch this video tutorial to learn how to get the Castle Age friend add and invite link (11/17/09). A simple way to get the Friend Add and Castle Age Army link.
If you like to share websites via email, are a writer who needs to share email in her stories, or just need to make a quick written note of a website address, you need to know how to use web address shorthand. Some URLs can be hundreds of characters long and therefore too tedious to reproduce in writing. To make an easier-to-communicate link, you'll need to use a URL minimizer, like TinyURL. Learn how with this address-minimizing how-to!
Work with sterling silver wire to make a link for jewelry clasps, loops, chains, bead work, and earring hooks. All you need is some silver wire and a pair of needle nose pliers. Jewelers need to make these simple loops for beading necklaces, connecting rings, and making earrings. Follow the instructions to link two silver wire loops to begin making a chain.
