Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 47th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to calculate total plate cost for a print shop using the VLOOKUP function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
This video tutorial will teach you how to use the Nintendo Wii Shop Channel to download and play your favorite console games on your Nintendo Wii. To follow along, you'll need either a WiFi Internet connection or Wii Lan adapter.
Straight from the Little Shop of Horrors to your front lawn! Watch this video to learn how to build a flesh eating plant prop that you can use to give people a good scare, in your next movie or when Halloween rolls around.
Many Americans save all of the plastic bags that they take home from stores. They get used sometimes, but mostly they just accumulate in some corner of the kitchen until there are so many that you are FORCED to throw some away. If you have this problem, watch this video to learn how to fold plastic shopping bags in on themselves into a tiny package that takes up less room and is easier to grab than a balled-up bag.
Lighting a movie can be dramatically expensive and complex, but for the DIY filmmaker on a budget this can be a major handicap. In this video you'll learn how to create a serviceable lighting setup for your filming using only $25 worth of shop lights and 200w bulbs.
Looking for an easy way to track price changes? Look no further. In this clip, you'll learn how to use Google Alerts in tandem with Google's Product Search comparative shopping tool to monitor price changes and find the best value. Fore detailed, step-by-step instructions, and to get started using this online shopping trick yourself, take a look.
It's time to take control of your wardrobe. This week the Threadheads show you some quick and easy ways to apply applique's and iron on transfers.
There's a new way to shop, and it's called your phone! On an Android mobile device, there'a handy shopping application called Shop Savvy, found in the Google Marketplace. Okay, so you can't actually buy things with it, but you can scan barcodes of products to get more information about them, making shopping in the mall so much easier. But how do use it to buy everything you want? Best Buy has answers. The Best Buy Mobile team explains how simple it is to use the Shop Savvy app on your Android...
In this Home & Garden video tutorial you will learn how to step down or end your patio wall. This video is from www.allanblock.com. Get the installation details and the location of the nearest dealer from the website. The instructions are on How-to sheet #160. The easiest way to create step down is to create corner blocks. Simply place corner blocks at the end of each course overlapping the block as the wall steps down. Finish the wall with wall caps. Once the wall caps are in place, you can ...
This video illustrates the quick and easy method to Identify and control garden pests on grapes and roses . The process is comprised of the following steps:Step 1:Garden pests are quite common in grapes and roses.Step 2: To identify these gardener needs to keep a very sharp eyes on the plants every day. Negligence may lead to disaster of the entire crop.Step 3:Garden pests can be commonly seen on the leaves on inner side or on the shoots of the plant.Step 4:Randomly select the plant and check...
For frizzy and wavy hair, you can create a hairstyle using wide flat irons using the right techniques. Firstly, apply a good amount of moisturizer on your hair. One new equipment out on the market that you can use is Cloud Nine. To use it, you have to make different sections of your hair and then start with the one nearest to your face. With the flat iron in place on your dominant hand, grab a section of your hair and loop it around the flat iron. Hold it in place for a few seconds and let it...
This six minute video shows you how to sell your car on craigslist. First, go to craigslist.com and click on the nearest city (or country). Follow the links to list an ad for a car for sale. You will want to put the kind of car in the posting title because that is used in sorting search results. In the posting description it is important to be as specific as possible - again describing the car, giving some history of the car like if it has ever been in an accident and if you have had any work...
Check out this "Juicy Tutorial" to learn how to create a multicolor text effect in Paint Shop Pro 8.
This video will cover how to overlay textures using Corel Paint Shop Pro Photo XI.
Cashmere is a wonderful fabric, and if you've wanted to shop for a shawl or wrap made of the stuff, you've come to the right place. This video will give you tips for making sure that the cashmere you buy is high-quality, fairly priced, and will last you for a long time.
Want to do a little comparative shopping for your next big purchase? With Google Product Search, it's easy. So easy, in fact, that this video guide can present a complete overview of the process in about two minutes. For more information, including step-by-step instructions on how to adjust your own Facebook tagging settings, take a look.
Crepes, like guys who go jogging without their shirts on, only exist to make us happy. They're there for us when our sweet tooth urges overpower our diet and when our PMS cravings send us autopiloting toward the nearest bakery and patisserie. And we never thought that crepes, in all their godlike perfection, could ever be improved upon until now.
In this video, we learn how to make a flower hair accessory from shopping bag tissue. First, grab your tissue from any shopping bag and fold it down until you have a rectangle, then cut on the sides to make several different rectangle shapes. Next, start to accordion these together until you reach the end of the papers. After this, grab the middle of the tissue paper and tie a rubber band around it. Next, start to push up the tissue from both sides until you reach the bottom. After this, you ...
Many applications, especially those found in the Android Market are more effective when they know your physical location; like an app that's going to find the nearest gas station, restaurant or ATM. One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial, in particular...
Hey guys! Heres a video on how to make a layout. Its just a simple blend. Please comment if it helped you.
This tutorial with Bill Myers shows a quick and easy way to create video title graphics using Paint Shop Pro.
Unsharp mask in Paint Shop Pro is the preferred method in sharpening. What this tool does, is increase the contrast between light and dark. In other words, it makes lines darker, giving the illusion of being sharpened. This tutorial shows you how to use it.
Learn how to count to 10 in German and say shopping expressions like "how much?" and "I'll take it." For intermediate German speakers because there is no English translation.
This week, the Thread Heads want us to know how to shop smart at the thrift store. Not all used shoes are created equal. Goodwill isn't all that goodwilled after all. Don't get thrift ripped off!
For some, there's nothing more thrilling than carrying an armful of bags while wandering the mall; for others, there's nothing more annoying. No matter what category of shopper you fit into, the truth is that you aren't always in control of what you buy.
If you're interested in changing the recommended items presented to you each time you open the shop in League of Legends, check out this guide. You will need to have access to your Riot Games and League of Legends directories first.
In this video, we learn how to make a double chocolate malt shop cupcakes. First, make the batter by mixing together malt powder with chocolate chips, sugar, and the rest of the ingredients. These flavors work well together and will make a classic cupcake! Cook these in the oven until the cupcakes are fully cooked all the way through. When these have cooled, test each of the cupcakes to make sure they are baked through. Next, you will mix together your cherry butter cream frosting and place i...
Starcraft 2, like so many modern games in this age of modding, has a really robust level editor that's going to extend the lifespan of the game for years. You can edit almost anything about any of the game's many units buildings and maps, and make the game however you want it to be. This video will show you how to use Galaxy Editor to make Warcraft 3 style shops in your custom map where you heros can buy and sell items. If you want to make a Starcraft 2 RPG (you aren't alone) watch this.
The holidays are upon us, guys and gals, which means it's time to start thinking about how you'll set your table to look inviting and beautiful for the festive season. While you can always go out and purchase a wilting pre-made floral centerpiece at your nearest supermarket, you yourself can often make a much better looking centerpiece at home.
Mystery shopping is a great way to make money on the side while getting a chance to shop, check out new stores and restaurants, and over all improve the quality of service at these locations. The key is to not let them know that you are there evaluating them. If you think you've got a knack for blending in, then check out this video. In it you will learn the process of signing up and becoming a secret shopper, what to expect, and some tips for how to carry out your jobs.
Shopping for a perfume isn't like shopping for a new eyeshadow or lipstick. Whereas with one quick swipe on your skin you can immediately tell if the two aforementioned products look good on your skin and flatter you, with perfume it takes extra effort, time, and maybe a coffee bean or two to get the full exprience of how it'll smell on you.
Old t-shirts really don't get the loving they deserve. Most of us would either toss or donate our old clothes, thinking there's really no use for them other than the obvious clothing purpose.
In this tutorial, we learn how to stain a concrete floor. To start, you will need to prepare your floor by cleaning it vigorously. Remove all dirt from the floor, then use detergent and water to wash, when finished dry with a shop vac. You will have to use a hand brush to scrub alongside the walls. After this, wash your floor with a mixture of water and baking soda, then use the shop vac to dry. Next, rinse the floor off with plain water and dry with shop vac once more. To finish, apply faux ...
Headbands have never been more in thanks to "Gossip Girl" Blair Waldorf's fashionable, headband-topped getups. But don't just run to your nearest J.Crew for a pretty headband.
"Mean" is really the average on a set of numbers. The video uses the temperatures on a weather report as an example of a data set. Start by adding the temperature numbers of the week up. After you have the total, divide that number by 7, because you used 7 numbers in your data set. The answer that you get after dividing will have a few decimal places at the end of it. You can round the answer to the nearest whole number because all the numbers from your original data set do not have any decim...
This is a demonstration of performing the green triangle yo-yo trick. You can start with a trapeze, lift your non throw hand middle finger and swing the yo-yo off the trapeze. Take care that you do not drop the yo-yo, you can use the middle finger to hold the string. Swing just like doing the trapeze so that the string lands at your wrist. Slide your throw hand out of the loop and you will form the green triangle. To dismount pop the yo-yo out of the green triangle and land on the string near...
A small section of the hair is taken and separated into three parts. It is then braided nearest to the end. The centered hair of the three is held. Then there is the pushing up of the other two side hairs. This creates a design. Hair pin is used to attach the designed hair to the side of the head, leaving the end not platted. The remainder hair is grabbed into a side bun. The bun is loosely platted and crossed with hair pins until held firm. Parts of the bun are slightly pulled to create a me...
This video illustrates the method of dividing real numbers. The process is composed of the following steps -Step 1Take any two real numbers. Convert them to rational numbers taking denominator as one.Step 2Find the LCM of their denominators and multiply both the numerators and denominators by the LCM.Step 3Now find the reciprocal of the second number and move to the next step.Step 4Now divide the numerators obtained. The denominator are also to be divided and the quotient obtained should be r...
The video is about Wiccan Runes and to use it for prediction. Runes are small gems or stone with certain markings used for prediction. Firstly sit in a place where you can sit and meditate in peace. Place a clean cloth napkin in front of you where you can place the runes as per the natural elements. Sit and meditate on your questions and try to draw the divine power into yourself. Now pull out the runes one by one from the cloth bag. Place the first rune in the earth corner which is on the ri...
This how-to video is about how to simulate your own space vacation.
