Want to retrieve a value in a given Excel column based on criteria from multiple other external columns? You can. And it's not so very hard provided you know what to do (hint: you'll use the LOOKUP function). Get in the know with this, the 541st installment of ExcelIsFun's series of Excel magic tricks.
Want to make a time schedule in Microsoft Excel partitioned into perfectly regimented 15-minute intervals? It's easy, provided you know how to go about it. And in this Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how to do just that using the Fill Handle. For a complete walkthrough, watch this Microsoft Office how-to.
dubstepfm brings you this instructional video on how to create a peace sign design using tie dye techniques. Your host for this video takes you through the entire process from laying out the peace sign design on your shirt, to how to fold the shirt and band it properly to create this unique look. Whether you are an experienced tie dyer, or a newbie to the art, you will appreciate the level of detail dubstepfm provides in this great how-to video.
This origami dragon in flight is pretty difficult so if you're an origami novice it might be best to warm up on something easier. When you do get around to tackling this paper beast remember to be precise and patient. This instructional video provides a visual guide with which to follow along. Origami skills don't just happen over night, so if at first you don't succeed fold, fold again.
In this episode of Panlasang Pinoy, we are taken through the steps of how to make custard cake. The episode provides a shopping list of ingredients that are easy to find at any grocery store. Each step of the baking process is covered from mixing the ingredients and preparing the 9x13 pan to baking the cake. For an easy to follow recipe and guide to making fresh Filipino-style custard cake, follow the steps in this video.
Are you a woman looking to reconnect with the one that got away? Whether you are trying to overcome a divorce or a breakup with your boyfriend, this video provides some helpful tips. Covers tough issues disagreement over children, money problems, lack of excitement in the bedroom, cheating and dishonesty, and whether or not your love reconnection is likely to work out. If you are thinking about getting back together with your ex, this is a must-see video.
Pastryparrot1 shows you the perfect recipe to make the most savory meatloaf with breadcrumbs that will leave your family begging for more. This instructional cooking video takes you through the simple process of making this meatloaf, providing you with the list of ingredients and methods to create this simple recipe. It shows you the right way of mixing the ingredients and at what temperature you should bake and for how long. This easy meal is sure to be a crowd pleaser.
At first, the concept of converting decimals to fractions sounded very difficult. But after watching this video and following the step by step instructions, it was easy. It is important to know the basic concepts of numerals, i.e., tenths, hundredths, etc. They provided an example of making .12 into a fraction and then reducing it to an easily understandable number. Search on WonderHowTo to solve more math woes!
This video goes through the basic step by step process of preparing Betty Crocker instant potatoes. It shows all the ingredients you will need as well as all of the utensils. This video also provide additional information on alternative methods of heating, such as using a microwave. This is a very informational, step by step video of the preparation process of these potatoes, and would be very helpful for someone wanting to better understand the process of preparing this dish.
Back again with another in their great informational series for do it yourselves at home, Lowe's presents this video hosted by Mike Kraft demonstrating how to pressure wash your home's exterior siding. Mike describes in detail the tools, supplies, and steps you will need to take to remove dirt, mildew and mold from your home's exterior. Experienced do it yourselves and beginners alike will appreciate the detail and tips provided in this video, as well as some useful safety tips on using your ...
Check out this video for info on how to setup the quick launch toolbar in Windows 7. Quick launch makes it easier and faster to access your favorite folders and programs. The quick bar can be activated and deactivated depending on your preference and provides simple access to frequently used objects. This tutorial will show you a quick step by step to activate this handy tool in Windows 7 just like it worked in Windows XP and Vista.
Back again with another great instructional video, Mike Kraft, a Lowe's home improvement expert, demonstrates how to properly sharpen or replace the lawnmower blades on a riding lawnmower. Mike provides tips on inspecting your worn lawnmower blades to determine whether or not your blades need to be replaced, or merely sharpened. This video will give you an idea of the tools you will need to complete this project, as well as the steps involved in both removing and re-installing the lawnmower d...
Here is a basic walk-through of how to remove the harmful file known as the cmdd.exe. The cmdd.exe file is a backdoor trojan virus that can allow a hacker remote access to a computer infected with it. Your computer can be infected with this threatening virus at any time and it must be removed immediately. This video provides several techniques that can be used to completely get rid of the file from your computer.
This video tutorial shows both the basic features and more in-depth uses of the Blackberry Curve II camera's capabilities. The tutorial goes through many options, providing a good description of how to access and use each. The viewer will learn the specifications of the camera including its mega-pixels, zooming capabilities, and so forth. Manipulation of lighting effects, color effects, and options when saving and deleting pictures are just some of the components reviewed.
In this video, you will learn the steps to take to enable JavaScript in Microsoft's Internet Explorer (IE) web browser. Although JavaScript support is typically enabled by default in most modern browsers and many web applications depend on JavaScript being enabled to function properly, some persons and organizations may occasionally disable JavaScript to negate the effects of annoying or insecure implementation of JavaScripts on some web pages (such as pop-ups, hidden tracking links, unwanted...
Two guys from the YES magazine project crew provide a simple and very cleanly humorous way to make a toga and laurel wreath out of simple and common art supplies and household items. Some of the materials required include: some laurel leaves, some green tissue paper, a bit of red ribbon, scissors, and some cloth (which should be purple if possible). As they explain this simple process, they never fail to display a few silly antics that can amuse the average viewer.
Have you ever wanted to create a grunge background? This video tutorial shows you how to make a grunge background for your graphics projects in Adobe Photoshop. This video provides you with an easy, step-by-step tutorial for giving your projects the grungy look that you desire. Grunge backgrounds are great for logos, flyers, advertisements, and other forms of marketing or visual media.
Apply a bit of moisture to your palm and you can magically lift a coin off a table. It's a great trick for any bar bet. Try out the "coin lift" magic trick and challenge your friends.
Discover how to easily mix and combine individual audio tracks into a single muli-track file using Adobe Soundbooth CS4. This video tutorial also demonstrates the program's fading options, providing an upbeat techno mix as an example.
Now that you've got your hands on Windows 7, you need to learn how to get the best possible picture on your monitor. Veronica from Tekzilla provides a tutorial on how to optimize your screen display in Windows 7.
Nuts n Bolts is great at providing advice on do-it-yourself projects and woodworking. In this episode, Nuts an Bolts shows you how to build a breakfast tray. Make your significant other a nice breakfast and have a romantic breakfast in bed. For more do-it-yourself videos from Nuts n Bolts, search for diy on WonderHowTo.
Nuts n Bolts is great at providing advice on do-it-yourself projects and woodworking. In this tutorial, Nuts an Bolts shows you how to put up a ceiling cornice. For more do-it-yourself videos from Nuts n Bolts, search for diy on WonderHowTo.
Nuts n Bolts is great at providing advice on do-it-yourself projects and woodworking. In this episode, Nuts an Bolts shows you how to hang a sliding door. For more do-it-yourself videos from Nuts n Bolts, search for diy on WonderHowTo.
Get more out of Google Maps with their improved places pages! Most people don't know how much information Google Maps provides users with. This episode of Tekzilla will educate you on how to access this comprehensive page and make the most of your Google Map experience.
This video provides a basic tutorial on building an instant kill in a Y!PP swirdfight. Puzzle Pirates has a fairly similar layout to Tetris, but don't be fooled. This game features many other neat features. Once you start learning how to create insta-kills, you'll be dominating this game.
This video provides a short tutorial on how to install custom skins onto the popular online FPS Team Fortress 2. Custom skinning will make the models in the game appear differently, adding a bit of flare to your gameplay.
This menstrual hygiene video offers information on the insertion and removel of wearing a menstrual cup, the latest method in menstrual/period protection. Menstrual cups provide an alternative to potentially unhealthy and wasteful methods of feminine hygiene such as the tampon or sanitary napkin. Follow along with this feminine hygiene video and learn how to properly insert and remove a menstrual cup.
This how to video is brought to you by Handy Magazine. The Handyman Club of American provides reviews and how to's on a variety of home & garden project. This video covers what you need to know to use a wet saw to cut tile.
Check out this film and theater video tutorial on how to set up a wireless microphone for sound recording.
Watch this video tutorial to learn how to start a blog on Blogger.com. A support coordinator from Blogger provides this short demo on how to quickly create a blog in only a few minutes. You will need a Google account for this.
In this video golf tip, Mel Sole provides tips on technique and club selection for dealing with greens that are above shoulder level. If the green is above shoulder level you should adjust a little to improve accuracy.
This video demonstrates three different hip hop streetdance moves. If you like Chris Brown, you might like this dance tutorial video. The dancer demonstrates and provides text explaining each hip hop dance move. He does not list any of the names of the dance moves.
While mousse doesn't offer the vice-like grip of styling gel, it does provide a lighter, less sticky hold that makes it the go-to product for volume, volume, volume. Watch this video to learn how to style your hair with mousse.
The screenwriter Gene Fowler once said, “Writing is easy: All you do is sit staring at a blank sheet of paper until drops of blood form on your forehead.” Here’s how to make the process of writing your first screenplay a little less painful. You will need a formatting guide, a realistic set of expectations and source material. This video provides general knowledge on screenwriting.
Whether you're changing your tap for a new look or because the old one just doesn't work anymore, this how-to video can help you with this repair project. Follow along with the steps provided and get out your toolbox. Make sure to turn off the water first, or you're looking to flood your bathroom or kitchen. Watch this video home improvement tutorial and learn how to change a water tap.
This video provides a tutorial on how to get that victory roll 40's look. This vintage style is as pretty as ever, and popular with rockabilly circles. Watch this video hairstyling tutorial and learn how to create a victory roll hairdo.
NetBus—Swedish for NetPrank—is a Trojan horse application that will allow you to remotely control any Windows system that runs it (provided that system is not running anti-virus software). For more information, and to get started using the NetBus hacking tool for yourself, watch this video guide.
This how-to video provides a demonstration of slip slip knit, SSK, technique. Decrease stitches easily with this left-slanting knitting technique. Watch this video knitting tutorial and learn how to knit the slip slip knit, or SSK, decrease.
This how-to video provides a demonstration of pass slipped stitch over, PSSO, or slip knit pass, SKP. The PSSO is a very common way to decrease stitches on a row, and is much easier to do than say. Watch this video knitting tutorial and learn how to knit a pass slipped stitch over.
This how-to video provides a demonstration of purling 2 stitches together. Purling two stitches together, p2tog, is a way of decreasing stitches, and may be required in lace or ribbed patterns. Watch this video knitting tutorial and learn how to purl two stitches together.
