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 554th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to weekends and holidays with Excel's NOT and NETWORKDAYS functions.
Now that you've installed Microsoft Windows 7 on your computer or bought a new Windows PC, it's time that you made yourself at home. With this official Windows 7 video tutorial from the folks at Microsoft, you'll learn how to apply custom settings as well as how to keep your Windows 7 PC running smoothly.
Have a photo that's not sketchy enough for your taste? Are you maybe just a big fan of Norwegian new wave band, A-ha? Whatever the case, this free Photoshop video tutorial will walk you through how to apply the effect to your own images in Adobe's popular image editing program. Take a look.
Skype continues to be one of the most convenient and widely used methods of keeping in touch with people all over the world. For those of you on the go, having Skype on your Blackberry could prove to be an invaluable communication resource.
Educational Specialist, Jennifer Taggard shows her viewers a very easy and accurate process to making non-toxic flea killer. This flea killer will not harm children in a household or any dog being treated. To make the flea killer, 1/2 of a cup of baking soda and half of a teaspoon of orange essential oil was used. The two ingredients were mixed together and simply applied and rubbed into the dog.
This video starts off with a neat optical illusion that he uses to demonstrate the effectiveness of force card tricks. He shows a piece of paper with "Paris in the the spring" written on it, most people's mind will skip over the second "the" and will read it, "Paris in the spring." He then goes on to demonstrate a shuffling trick that allows you keep a hold of a given card while shuffling. Finally the presenter explains the difference between asking someone to "Pick a card" and asking someone...
This video is truly a god send for the ladies and gents who wear glasses, and want to look good wearing them. The lady in this video explains and teaches about the various types of makeup that is good to use, especially if you wear spectacles. The lady in the video tell people who, wear glasses about the makeup they can use to look better wearing glasses, alternative makeup for different types of spectacles is the agenda, methods about how to make your eyes look smaller behind those big focal...
Do you like Pakistani style chicken pulao or pilaf? Now you can learn how to make your own. All you need are:
Most people own a Wii system, or at least have seen the infamous Wiimote that serves as the controller for the console. What most people have overlooked is that this handy piece of technology can be set to work on PC. Surf the web or scroll through photo albums without the need for a mouse as the narrator takes you through an easy to follow, visual guide how to install these programs on your computer. You can even use the remote just like a classic NES controller for emulators on your compute...
Do you long for a Polynesian vacation? Do you wanna go back to your little grass shack in Hawaii? Well, if you can't afford that, you can at least have a stylish "staycation" at home with your own homemade tike bar. You'll learn to build one in this Decor It Yourself video tutorial.
Save the trees! Have a few extra wire hangers hanging around? Make your own retro Christmas tree for your next holiday season out of old hangers, wiring, and shiny tinsel. With help from ThreadBanger's Decor It Yourself, your new Christmas tree will be done in no time, standing tall and eco-proud!
Have you ever heard of wet felting? Well, it's the oldest form of textile making and relatively easy to work, thanks to this tutorial by ThreadBanger. Learn how to create a classic-looking beret for this winter season. No sewing required!
ThreadBanger give us a great recipe to make a unisex bomber hat using just a flannel shirt, white faux fur, a measuring tape, the bomber hat pattern, a sewing machine, and two and a half hours of your creative time. Add pom-poms at the ears to give it extra flavor! Super cool look for both dudes and ladies.
Traveling with a child can always cause problems, especially if you have an infant. Here is some helpful information on how you can get an infant passport. Everyone traveling abroad needs a passport, even a young infant, so make sure that you don't get stuck by the rules of a foreign country. Applying for a passport isn't as hard as you may think, so check out this video tutorial on infant passports.
Special Case has this handy video tutorial on Motion… the motion graphics editor in Final Cut Studio. See how to create light-writing with Motion's tracking feature. The motion-tracking feature is a great device to take advantage of, and doesn't just apply to light writing.
This week Corinne shows us how-to make a classic back to school accessory that can be worn by both the guys and gals. This quick and easy tie is sharp, and will start the school year off right. Just follow along with the steps in this how-to video and you'll be on an honor roll.
The Great Zenovka and her lovely assistant show us how-to make a cowl neck halter top. Just get an old t-shirt, follow along with this how-to video, and you're ready to go in style.
To kick off T-shirt Madness week, Threadbanger forum member ArtCrazed shows us how-to make an adorable purse out of two old tees! Follow along with the steps in this how-to video and learn how to refurbish some old clothes into something new!
This week Megan Nicolay returns to show us how-to make a sexy halter with a plunging neckline from her new book, Beyond Fashion. So get out the old tees and get to cuttin'.
You wanted more summer lessons, you got em. This week learn how to take an old mens shirt and turn it into a rockin new rockabilly swim suit. Just follow along with the steps in this video and take your new stylish suit to the beach.
Weddings, and wedding dress especially, can be very expensive. This how-to sewing video shows how to customize and personalize an affordable option. This week, Rob and Corinne answer a viewer question and show us how-to make a $10 wedding dress out of tee-shirts.
In honor of Rob and Corinne's trip to Makerfaire, we visit Zoh Morrigan of Morrigan NYC for a lesson on how-to make spats. Steampunkin it up!
This step by step tutorial will guide you through the process of how to design a paint scheme for your Xbox 360 controller.
Learn how to tie a Whipping - How to apply a whipping to a line to protect it from unraveling or to form an aglet at the end of a rope. This is a fine knot for camping, climbing, sailing or Boy Scout training.
This video tutorial from IndyMogul shows you how to create an ice frozen actor makeup special effect.
When someone uses a public restroom (former Idaho Representatives aside) they expect a degree of separation, the ability to wander in and move through the experience taking as little notice of their fellow excretors. Why not interrupt that flow and make some people cringe? This video will show you how to pull some great pranks while using a public bathroom. You could probably give someone hang-ups for a long time if you try some of these on the right person.
Microsoft Outlook 2007 Tip - Setup Signatures for Multiple Email Accounts - One of the difficulties with using multiple mail accounts is making sure your messages have the correct signature, or sig, attached to them. The new Signatures feature in Microsoft® Office Outlook® 2007 takes the hassle out of creating and applying signatures to your email.
In this software tutorial Paul Wyatt reveals how to get to grips with Photoshop’s automation tools. Whether you want to resize images, apply filters, or add effects, getting to grips with Actions will transform your workflow. Learn how to use actions to take care of small repetitive tasks in Photoshop.
This how-to video from makeup master Laura details a great smoky brown eye that will enhance the color of blue eyes. The demonstrator used these cosmetic products, MAC shadetsick sharkskin, BOBBI BROWN stonewash nudes palette, MAC mascara zoomlash, NARS lipliner bahama, and Stila convertable eyeliner onyx, but similar colors and textures will create comparable results. Follow along with the steps in this video makeup lesson and learn how to recreate this smoky brown eye look for blue eyes.
This motorcycle tutorial will help you familiarize yourself with a beginner bike and show you how to ride the bike for the first time. You will learn the basic handle bar controls first, then take the bike to the road and learn how to apply the different controls.
Check out this instructional beatboxing video that provides an in-depth explanation for two different lip oscillations & vibrations. These techniques really help improve your beatboxing skills. They are both done by applying a lot of pressure and vibrating your lips at high speeds. One is much quicker than the other, but the different in the oscillations make the sounds completely different. Practice your lip vibration techniques and beatbox like a pro!
This audio production software tutorial shows you how to set up audio and MIDI recording devices on a PC using SONAR 6 Home Studio. See how to plug-in cables, and set up audio and MIDI for optimized recording and playback on a PC. This video shows the process in SONAR Home Studio 6, but the concepts can be applied to most Cakewalk software.
Check out this instructional Hungarian language video to learn how to speak Hungarian! In this lesson, listen to a few dialogues in Hungarian. This video provides conversations exclusively in Hungarian without English translation or subtitles. This instructional language video is better for advanced Hungarian speakers who need to improve their listening skills. So check out this video and learn about changing the ends of Hungarian words to apply to gender rules.
MDD files are a great way to bring in character animation or any deformation based animation from other 3D software systems. This modo 301 video reviews the basic method for import and use of MDD files. Learn how to load MDD files and apply them to a specific object in a modo 301 project.
Nail artist Anna designed this spotted, dotty, and luminous manicure to be colorful and eye-catching. The spots are two-toned, and almost like an animal print, but done in blue. Flat sparkles and rhinestones add a lovely finishing touch. Watch this video nail art tutorial and learn how to create a two-toned dot, sparkle and rhinestone manicure out of white and two distinct shades of blue nail polish.
This Houdini 9 tutorial teaches how to sweep an object along a curve while orienting the object to the curve's direction. Learn how to apply a sweep sop to orient objects on curves in Houdini.
Let World Champion and Bikeskills instructor, Greg Minnaar help you become a better, safer descender on your mountain bike by watching this video tutorial on mountain biking. Always wear appropriate cycling safety gear when riding, especially when learning or applying a new skill.
If you need to whip up a quick batch of greetings but don't want to compromise on style, give this fab technique, foiled cards, a go. Fantastic foils are easy-to-apply, give a beautiful metallic finish, and can be used for a vintage, distressed effect that the recipient of your foiled card is sure to love.
Create gorgeous, sparkly motifs and embellishments out of beads to give your greetings a bit of bling. Corinne Bradd shows how easy it is to combine stunning gems, bright sequins and coloured wire for a unique, eye-catching effect. The finished bead decorations can be applied to cards, tags or gift-bags.
The buttonhole stitch is used in many types of hand embroidery - general surface embroidery, crazy quilting, whitework and cutwork, Mountmellick embroidery, needle lace, filet work - you name it, buttonhole stitch fits in somehow. It's a super versatile stitch, and once you have the basic stitch down, it's just a matter of applying it in a variety of ways. Watch this video from Needle 'n Thread to see how it's done.