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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the COUNTIF, IF, COLUMNS, INDEX, TEXT, SMALL and COLUMN functions in an array formula to return multiple items (e.g., list free periods for a list of students).
In this instructional video, the young host demonstrates an excellent method for cleaning your DVD's, CD's, and Game discs using simple, easily found items that you always have laying around your house. The toothpaste he uses acts as a super mild abrasive (almost exactly the same that is used in professional kits, except they don't get the benefit of a minty fresh smell) that removes minute dirt and debris that gets stuck on the disc. When cleaning your discs, be sure to rub the toothpaste in...
Hurricanes can occur any time with out any warning. So it is prudent to prepare you self for disaster recovery in case of any hurricane. To protect your self from hurricane by staying at home or to flee from a hurricane you will need some items ready. The main thing is water. So arrange for one gallon of fresh water for one person per day. It is good to store water sufficient for one week. So store enough quantity of water for all the persons in the home sufficient for one week. Make sure tha...
This video illustrate us how to make a hovercraft with common household items. To build one, first of all, collect all of the items required for making it. You need a CD, bottle cap, balloon and super glue. Then start by applying glue to the lower end of the cap and sticking it to the center of the CD and let it dry. After it has dried, blow up the balloon and secure it up on the bottle cap tightly. Now open the bottle cap and let the balloon deflate.
New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 368th installment in their series of digital spreadsheet video tutorials, you'll learn how to create and use an array formula that will permit you to count unique items within a column while specifying more than one criterion. This guide uses the SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER functions (in a somewhat unusual combi...
Do Try This at Home brings us video on how to create a cloud in a container. With just a few simple items household items we can create a cloud. He explains to us the science behind what he is doing and why is works the way it does. After that he demonstrates how to create the cloud with quite amazing results. He easily has created a cloud and suggests that we try this at home because it much easier to see and enjoy in person.
Club Penguin is a flash-based website with an a virtual world of online games for kids to play. Learn how to hack Club Penguin with tricks and cheats. Watch this video tutorial to learn how to find hidden items in the Club Penguin catalog (09/29/09).
In this video, we learn how to tie a Knute hitch. The purpose for this is to make an easy dummy cord on something with a hold for it. To start, tie a simple overhand knot in one end and then make a bite in the knot. With this bite, insert this into the hole in your item. Once it's through, take the end with the knot and put it through the loop. Then, pull the end of the string until it's tight over the item with the hole. Then you can use this as a handle so you don't lose your item!
In this tutorial, we learn how to make a chemical indicator from kitchen items. First, make an indicator by grabbing some red cabbage and some vodka. Now, heat up some water until it's boiling, then place a smaller beaker inside the water with vodka inside of it. Place the red cabbage inside of the smaller beaker, then stir it up and let sit for 10 minutes. A lot of the color will come out with the cabbage being inside of the alcohol. After this, pour this into a storage bottle and pour the w...
In this tutorial, learn how to take funky items from around your home like a picnic basket, an easel, a backpack and other fun things and turn them into creative gift baskets. In this clip, learn how to accessorize the perfect gift box for a creative friend or family member. The recipient will love these personality specific, interesting presents!
In this video tutorial, viewers learn how to use googly eyes to liven up household items. This video provides 3 crafts that viewers can make with the googly eyes. The first craft is a homemade snake with googly eyes. The snake is made from a draft blocker that is stuffed with rive. The second craft is to apply two googly eyes on your footwear. The third craft is glue the googly eye around the frame of a pair of glasses. This video will benefit those viewers who enjoy making arts and crafts, a...
This video gives you tips on how to pack your backpack for wilderness hiking. A standard backpack will do just fine. As for the gear, there are a few essential items that you must pack, such as a sleeping bag and a ziploc bag to keep your clothes dry and bowls and spoons. You can combine a spoon and a fork and use a spork for the best combination. Other things such as measuring cups are also useful. Toilet paper is very handy, and pots and pans are essential for cooking things you catch. Othe...
If you're buried in e-mail (and who isn't?), Instant Search in Microsoft Office Outlook 2007 can save the day for you. The new Instant Search helps you quickly find e-mail messages, appointments, contacts, or any Outlook item. You don't even need to know which folder the item is in. Watch the demo to see how to use this fast search feature in Outlook 2007, and start finding what you want instantly.
One of the great features of the Zelda games is the number of magical items at Link's disposal. In Zelda: A Link to the Past, the magical mirror item was used to switch between the dark and light worlds. In this instructional video, learn how to get the cape item early before the Master Sword and the Titan's Mitt. Note that this glitch does not work on the Super Nintendo console, only for the Game Boy Advanced and the SNES emulator.
Add even more personal touches to your handmade crochet items. This how to video is a tutorial on how to crochet beads into yarn projects. You can add large or small beads to decorate your crocheted items.
G4's Cheat! will get you though the toughest parts of Resident Evil 4 for the PS2 and how you some hidden items including a futuristic gun.
This video will show you how to create the Smallville effect in After Effects. He doesn't talk, so if you see new items show up on the timeline, it's him hitting CTRL-D and duplicating the selected item. Also, some areas where it's repetitive are sped up.
Modern weddings can be expensive. Old-time weddings could be held outside barns with simple stools found around the house for seating and the bride would wear a dress passed down along generations of women from her family.
The story of "Alice in Wonderland" is one of childhood naivete, self exploration, and ultimately growing up. That's why we love the character of Alice so much - she's equal parts child and adult, fighting to find her own in an adult world filled with hypocrisy and craziness.
Sometimes a good looking accessory can be made by using simple things and a little bit of your own ingenuity. This video is a perfect example of the same.
Sloppy Joes, an American classic. Fed to more kids in more cafeteria's around the nation than anything else, besides those cardboard pizzas (ick). If you want to make one, don't run out to the store and buy the pre-made stuff, make your own! It'll taste a lot better and you will still feel the same nostalgia you would if you bought the canned stuff! In this great video you will watch as she shows you how to prepare the sauce and the meats into a delicious lunch item straight from your childhood!
In this video, we learn how to save time and money at the grocery store. At holiday time, grocery shopping can be extra tough. First, make sure you bring your own reusable bags. Then, place in your soda and water in the cart first so you don't have to re-arrange. Make a list before you go to the grocery store so you don't wander around the store. Also, see if you can place your deli order ahead of time so you don't have to wait around. Have your grocery clerk group like items together so unpa...
Many of today's cleaning products contain chemicals that can be harmful to pets, children, and even adults. Sure it can get the job done, but what's more important the health of others or your stuff?
While some parents like to spoil their little babies with the highest quality (and most expensive) items from Dior, most of us know that babies and toddlers grow out of their clothes faster than weeds overgrow a garden. While their clothes should be appropriately cute, there's no need to shell out thousands of dollars on pricey apparel when you can make your own.
If you need to add some decoration to your keys, a key fob is the way to go. Key fobs are decorative items that many people carry with their keys. There are many different ways to go when creating a key fob, but one of the best ways is to make your own using fabric from the store.
In this time of economic uncertainty, trying to save money is more important than ever. There are many ways that this can be done, and one is by making your own clothes. This can be achieved using materials that can cost less than regular clothing found in stores.
Potatoes are a common food that can be used to make an assortment of different dishes. It's a very good food item that gives the feeling of a full stomach. Buying them can be easy and relatively cheap, but making your own is so much more fun and can be better for you. So in this tutorial, you'll find out how to grow potatoes in a pot. It's easy to do and you'll have great tasting potatoes in no time. Enjoy!
Learn how to make a Swarovski crystal pendants that can be used to make your own necklaces by following the tips in this tutorial. You will need a pair of needlenose pliers, a chain, Swarovski beads, and bails (a pinch bail). You can get the beads from ArtBeads or FusionBeads, which offer shipping promotions and low prices. Once you have these items it is simple to put the pendant together. Simply take the bail and open it with the pliers. Slip the bail through the hole of whatever bead you b...
Ever wish you can have your own custom stickers? Well its not that hard and you can find everything you need at many major supplies stores. This video will show you exactly how to make professional vinyl stickers to stick anywhere!
In this video, you will learn how to make a mosaic stained glass window as well as techniques for using mosaic to decorate other items in your house. Host Laura says she's decorated her house so much that her neighbors say if you stay too long, they will become mosaic by Laura. The materials you will need for this project are a window, stained glass of which Laura says you can buy cut up, silicon, and grout. Laura takes you with her to her local hobby store and shows some different stained gl...
This video demonstrates the process for organizing your garage. The video interviews an employee from The Container Store which offers organizational products for every room in the house. They stress that organizing a garage is not a one day project. The Container Store recommends taking three full weekends to organize a garage, start out by focusing on one wall at a time. Labeling is a big part of The Container Store's organizational plan, everything has its own place with a label. The label...
Have a passion for crochet or knitting? This video is perfect for you! The free tutorial offers splendid advice and instructions about making a beautiful solid-striped scarf. Sit down and gather your supplies and prepare to make a cleverly constructed scarf while watching this video. Follow the instructions as precise as you can. Within the hour or so, you can loom knit your own scarf and maybe even a few other items using techniques and skills acquired from this video!
It is a compulsory work for every one who owns cars to arrange emergency kits for the car. For the first step, you should keep food items like water and food material. Keep the emergency book which contains what to do when a car goes into repair. Then carry a radium type object which will shine in the night during the repairing of the car. Then arrange the emergency lights near the back part of the car for repairing of the car.
Looking to spice up your kitchen? Watch as old, boring cabinets are transformed into new ones! Items you'll need are contact paper, acrylic paint, masking tape, scissors, plastic lids, stencils, and drop cloths.
Patty Moreno shows us how to make a worm compost bin with cheap, everyday, household items. • Get an 18-gallon rubber storage bin and at least two tops.
This is a tutorial on creating graffiti letters from duct tape to decorate and stick anywhere you like. Not your everyday graffiti, but if you have a lot of duct tape lying around the house, this project's an interesting way to spend an afternoon and stay out of trouble. Starting with graffiti letters from GraffitiGen and GraffitiCreator, this tutorial takes you through the steps to make your own graffiti duct tape letters to decorate just about anything.
In honor of our Earth, Meg shows us how to upcycle old items into a rad new pendant lamp. Plus, learn some easy ways to contribute to your neighborhood. This video home decorating lesson shows an ecological way to add some style to your space.
Want to learn how to harvest the sun? Just watch this science experiment video to see how to convert sunlight into hydrogen fuel. It's simple and environmentally friendly.
Importing and exporting are pretty easy in OnTime, but there are always questions that come up regarding the process. This installment from Axosoft's own series of video tutorials on the OnTime Project Management Suite will help new users understand the basics of importing and exporting items across the OnTime 2008 system. Take a look (and be sure to stay tuned for parts two and three).
Goggles are an effective way to protect your eyes. When you can't find a pair, don't resort to not using goggles; make your own. You literally won't have to spend a dime on Materials because you probably already have these items. You might even throw them away from time to time. Watch this do it yourself video tutorial and learn how to make a pair of goggles.
