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 311th installment in their series of digital spreadsheet magic tricks, you'll learn three different methods for determing whether a Produt ID prefix matches a second specified prefix.
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 198th installment in their series of digital spreadsheet magic tricks, you'll learn three different methods for counting quantitative data in categories that include a lower limit but not an upper limit.
If you need to snap a diagonal chalk line on a sheet of plywood, you could hope that the hook will hold when you pull on it or try to find a third hand – or you can follow this video guide, which demonstrates a method for snapping chalk lines using a utility knife. For a complete overview of the technique, watch this free DIY tutorial.
It seems silly to have to burn an ISO disc image to a CD just to insert it back into your computer to install or watch its content. Fortunately, there is another way. In this free video guide, you'll learn a method for mounting ISO disc images in Windows without wasting a CDR.
This video will show you how to smoke Rainbow Trout in a fish smoker. This method of cooking will leave your fish chewy with a smoked taste that is so fresh you won't want to cook your fish any other way again! Oh, and don't forget to scale, wash & gut your fish first! Removing head is optional. Enjoy!
Protect your privacy. With this free video tutorial, you'll learn a method for clearing your Google search history in the Mozilla Firefox web browser. Note, however, that this only works locally and therefore will only prevent those who share the same computer as you from seeing your search history.
In this crafty parent's how-to, Erin Bried, author of How to Sew a Button (And Other Nifty Things Your Grandmother Knew) demonstrates a method for making a simple baby toy, what she calls the Cinchy Ichy Caterpillar.
Want to cut your own bangs? Without looking like a crazy person? Give this hair-styling how-to, which presents one particular person's method for cutting her own bangs, a go. For a complete overview of the process, watch this free video tutorial.
Brighten a glum, overcast picture with this Adobe Photoshop tutorial, which outlines a method for bluing grey skies in the popular image editing program. For a detailed, step-by-step look at the process, look at this free video how-to!
Sometimes when it comes to making a video or more specific a cartoon, the voice work can tend to be off. With this video tutorial, you get to learn how to sync animated mouths with voices using Flash. It's quick, easy, detailed and pretty fun to watch. Enjoy!
Kayaking is a great way to stay in shape and engage with the outdoors. This video tutorial demonstrates proper kayaking methods and offers a few helpful tips. When paddling a kayak, keep your strokes close to the side of the vessel. Make sure to use your legs to balance the kayak. Finally, adjust your core to get more out of each kayak stroke.
With some vinyl, matte, and a printer you can make customizable stickers to post anywhere. This is a really quick and easy method and this video shows you exactly how to make durable, custom stickers.
Because most professionals prefer recording audio independent of their DSLR camera using the double-system method, this video demonstrates how best to sync the audio to your video track in Final Cut Pro.
In this Windows 7 tutorial video, host Rich from PC Mech shows you how to create control panel shortcuts on your desktop in Windows 7. You will learn how to use the "drag and drop" method to quickly create shortcuts to various applications you may use quite often in "Control Panel", so that you may access them more quickly, without having to go into the Control Panel menu and drill down through menus and sub menus to find the applications you're looking for.
Photoshop Universe presents a step-by-step tutorial on how to mask images over text. First and foremost you'll need to have a poem or some other block of text in mind to use. Once you've selected your text you'll use methods such as copying and pasting, using clipping masks, and mild typeface editing. By the end of this tutorial you will have the abilities you need in Photoshop to make your very own text based image!
In this easy to understand video, intuitive instructions are given on how to divide mixed numbers. This video will help you quickly learn a fast and easy method for simplifying and then dividing mixed numbers. If you have ever gotten confused when trying to learn about mixed number division, this video will walk you, step by step, through the best process. The video contains a voice over and visual demonstration of how to do an example mixed number division problem.
Dividing mixed numbers may seem like a complicated operation. However, this brief video makes it simple. The illustrations in this video show you step-by-step how to divide mixed numbers using a very simple method. It involves taking the reciprocal of the second fraction. This math tutorial takes you the rest of the way and simplifies mixed number problems.
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.
Decimals are just as complicated as fractions, but they are written a bit simpler. In this video, learn how to divide a decimal number by another decimal number without a calculator. Follow the step by step presented in this tutorial and practice this method and it won't take you long to get it right everytime.
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.
In this how-to video, two friends, Medo and Rinker, show you their method for a light meal of scrambled eggs. A heavy-bottomed non-stick pan is sprayed with cooking spray to prevent the eggs from sticking. 3 eggs are broken into the pan, then cooked over a light heat whilst being stirred with a plastic spatula. This is a very simple video, perhaps aimed at older children who are learning how to use the kitchen for the first time.
Simon Leach from Simon Leach Ceramics provides some great workshop footage on preparing to glaze Raku ceramic pots. This tutorial video provides answers on the beauty and function of Raku pots, as well as some great ideas for home decoration. Simon walks you through the process of glazing these pots, including important specifics about proper materials and methods, easy recipes for making your materials and tools at home, as well as common mistakes that you should avoid when glazing your cera...
This how to video describes how to solve a Rubik's Cube by using a variety of methods. This is perfect for the puzzle solving game addict or anyone clueless about Rubik's Cube. The author observes different crosses and patterns on the Rubik's Cube and uses them to complete algorithms that solve the cube in lightning speed! Soon you will be able to solve a Rubik's Cube in under a minute just by watching this five minute video.
A very classy man named Matt from the Bow Tie Report begins this video by explaining that bow ties are making a stylish comeback especially among college students. He demonstrates the sort of complicated, yet easy to learn, standard method of tying a bow tie onto himself. After completing the process, which requires a bit of finesse and a lot of practice, Matt shows that a good bow tie needs a lot of tweaking to make the knot just right and looking good.
A very easy to make recipe using simple ingredients like salt, butter, potatoes (of course), etc. Learn how to make mashed potatoes in a step wise way using by viewing this video. The different part about this video is that the entire recipe involves no gravy. If, for some reason you don't like gravy or you want to try a different method of cooking potatoes just for experiments sake, see this video.
This video explains how to find the sign of slope of a line. The way shown means that you can find whether it is positive or negative without knowing its equation. It uses a simple analogy so that anyone would be able to use this method, even without much math knowledge. Being able to find the slope of a line is very important, as it leads to advanced function and calculus.
Regardless of what you might have seen on tv or movies, you should never throw a boomerang side-arm. The only proper method for throwing a boomerang is to throw it overhand just like you would with a baseball. There are two ways to grip a boomerang: either pinch it or cradle it. You can do whichever one is more comfortable to you. This video will show you how to throw a boomerang.
This video shows you how to access your iPhone if you forgot your passcode (or if someone unknowingly set one for you). Most importantly, this method details how to do this safely without losing any valuable data. Breaking the passcode on the iPhone will return it to the same condition (only without a passcode).
If you've ever attempted to remove Cydia apps from your iPhone or iPod Touch using the traditional long-touch method, you will have quickly discovered the Cydia-distributed applications have no 'X' to delete them. Watch this short video to understand the correct way to remove Cydia apps.
There are a couple of ways to even out stretch marks. First, if the stretch marks are newer and red, you can apply a variety of topical creams such as different kinds of retinol or cocoa butter. If the stretch marks are older, then laser surgery is needed. Laser surgery doesn't completely remove the stretch marks but it greatly reduces them.
Check out this tutorial on how to create heat displacement in Apple Shake 4.1, a 2D and 3D compositing suite that will help you with visual effects editing. This video shows you how to create heat displacement in Shake 4.1, resulting in a very realistic picture. The method is easy to replicate on your own personal computer, and assist you with compositing practice. For more information on Shake 4.1, search for Shake 4.1 on WonderHowTo.
This video will show you how to install CFW 5.03 MHU to a PSP 3000 using ChickHEN R2. This method will only work on a PSP with OFW 5.03.
Cheap method to create your own neat looking CD cases! Instructions on how to create cover for cd disc from A4 piece of paper.
Render shadows only in 3D Studio Max using vray. Once the tutorial is over you will also learn how to use the other options in the render elements, which uses similar methods. Skyrill Design brings us this tutorial
Use the piercing whistle in this how-to video on strangers at your own peril. Although it's commonly depicted as a pick-up method, it may not be particularly effective in that regard. All the same, the wolf whistle is a classic and will definitely be attention grabbing. Watch this video, and you may even be able to apply it as a practical joke of sorts.
Check out this video tutorial on how to store your extension cord without tangling.
Learn how to properly dices and mince food. If done right, dicing an onion ensures even cooking and makes your dish look professional. If you've never attended cooking school, chances are that you've never learned this easy method. It only takes two simple cuts. To dice and mince food, you'll need a sharp knife and your food of choice.
Learn how to julienne vegetables. Julienne is the French term for vegetables cut in long thin strips, like a matchstick. Mastering the method of julienning vegetables will not only improve your presentation, it will also endure more even, consistent cooking. To julienne, you'll need vegetables (like carrots and peppers) and a sharp knife.
Here is one method for threading eyebrows. You can mask off your eyebrows that you don't want taken away with scotch tape. Then you don't have to worry about taking out any hairs that you want to stay. Threading your eyebrows removes your hair at the follicle, for a longer lasting effect.
Have a computer too old to sell? A hopelessly dated phone? Don’t just toss them into the garbage, where they will leach toxic materials into the soil and water. Recycle them. You need to research recycling options, and you will need a delivery method. No reason to toss old electronics, recycle them!
