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 355th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP to create a mortgage calculator that can handle four different types of loans: begin annuity, end annuity, interest only and "other."
This video walks you through the steps of using geometric series sum to figure out mortgage payments. This excellent video shows you a clean blackboard, with the instructors voice showing exactly what to do. Don't fret, any question you may have, will be answered. Watching this video will make you feel like your back in the classroom but rather comfortably from your home.
Just because fixed rate mortgage rates have dropped to historic lows doesn't mean that you should automatically refinance. With the economic climate you might not be able to refinance because many banks have tightened the rules for refinancing. As for who is eligible, you will need a 700-720 on your credit score to get the best rates. To refinance at all you need at least a 600. Generally it is worthwhile to refinance if you can save at least a half point off of your current rate. But you do ...
Are you under a backbreaking amount of debt? In this economy, we don't blame you. If credit card bills, mortgages, and bank loans are making you want to crawl into bed and pull the covers over your face, then check out this video to learn how to consolidate debt.
Runescape has more sidequests than US Government has mortgage-backed securities. This video will teach you everything you need to know about one of them. It's a miniquest called Tarn's Laircommentary here is great, and will leave almost no room for you to lose, you lucky devil.
Looking at homes is the fun part. But before you go house hunting, make sure you have your financial ducks in a row.
Looking to get an FHA loan? The Federal Housing Administration, FHA for short, provides mortgage insurance on loans made by FHA-approved lenders throughout the U.S. Here's how to get your FHA-insured loan. Learn how to get one with help from this video.
This gem, an extensive cinematography video tutorial on Motion Control systems by Mark Roberts Motion Control. In some ways this video is an advertisement for the systems they create, but there is a lot of useful knowledge shared that transfers to planning, shooting, and compositing with lesser tools. This instructional video explains what motion control is and the features of the Milo Motion control system rig. A ton of fantastic commercial and music video creative work is shown, with shot b...
In this three-part video tutorial, learn how to manage loans with an amortization table in Excel. The three parts of this video go over the following:
Sure, the iPhone is a phone, but why use your phone service to call people when VOIP is cheaper? This video will teach you how to use a new App called Viber to make free VOIP calls on the iPhone.
Recording professional-sounding music at home is cheaper and easier than ever before, but still neither cheap nor easy compared to, say, grilled-cheese-sandwich-making. If you need some help getting started watch this video, which will teach you all about mics, cables, digital interfaces, and the other elements of the modern home recording studio.
Turn an old tennis ball into a nifty camera tripod in just minutes. Inspired by an Instructables.com project: http://www.instructables.com/id/SDMK5MWFDO29GEZ/
Going out and eating at those Chinese fast food places are the best! And a staple of all of them are the orange chicken! But instead of getting take out, you can make it at home for much cheaper, and healthier! In this video chef Jason Hill takes you through the steps of making his orange chicken recipe as a sautee' instead of a fry.
In her "Telephone" video, Lady Gaga wears very funky gloves multiple times. In the prison scene they are black, in the waitress part they are white and during her American flag inspired dance routine they're red.
This video shows you how to capture video from your console to your PC using a DAZZLE Video Creator Platinum. The total cost of this project was about $150 but I am sure you can do it for cheaper.
Here's an easy way to decorate your Valentine's Day handmade cards, gift wrap, envelopes, or gifts. Prima roses are teeny paper roses you can certainly purchase at a store, but they're a lot cheaper to make at home.
PhotoKey is a cheaper alternative to Photoshop if all you want to do is work with green screen effects. This tutorial shows you the basic Chroma Key functions available to editors in PhotoKey, so you can start adding your own backgrounds and special effects.
Gemstone necklaces are quick to make at home, not to mention cheaper and more customized. To make a gemstone round bezel necklace, you'll need a round bezel finding, a gemstone to match the finding, a jewelry chain, and bent chain nose pliers. Learn how to make a gemstone round bezel necklace by watching this video jewelry-making tutorial.
Flashback Max ties Barry's Pike Fly, so watch and learn. He likes the saltwater hooks, because they're stronger, but if you want to do it with a cheaper, weaker hook, well, don't come crying when it doesn't work.
An expansion vessel is a small tank used in water heating systems that performs the important job of absorbing excessive water pressure. If the expansion vessel in your plumbing is not working, you could call up the plumber and get it fixed - for a very huge sum.
You don't need to buy a whole new iPhone if your screen has accidentally cracked. You can effect this repair with a cheap repair kit you can buy online. Then follow the tutorial to replace your screen (be careful!). Much cheaper than getting a new phone!
Having Hummingbirds in your garden and yard is always a fantastic thing, but paying for those already made feeders are a hassle. With this video you'll learn how to create your very own feeder with items found all over the house and for much cheaper than buying one from the store!
If you are just getting started working with Flash, CS3 might be a good place to start since it's cheaper and simpler than it's newer counterparts. This video will teach you how to use Flash CS3 to perform a basic task: drawing a human eye. Once you can do this, you can start on the plethora of more advanced tutorials elsewhere on our site!
While ready-to-go seedlings have their place, it's also useful (and considerably cheaper) to know how to start your own seeds, which is where this free gardening tutorial comes in: with it, you'll learn how to germinate your own seeds for planting in your garden. Specifically, this tutorial looks at how to start tomato seeds.
Looking to buy a home? Why leave your current digs? Using technology has made it easier than ever before to find the home of your dreams. Learn how to buy a home online with help from this how-to video.
Hack into a TV to get more channels! Make this DIY antenna that will get you at least a dozen more channels. You need a fork, shoelace and an old metal desk lamp. This is way better and far cheaper than the ones you buy in the store.
One of the cheaper ways to create a captioned podcast is with QuickTime pro. This tutorial from Donna Eyestone will walk you through the captioning process, from generating a text document to deciding upon display settings. Take a look!
Jewelry can be quick to make at home, not to mention cheaper and more customized. All you need are the right tools and equipment, and to know how to use them. Learn how to make jewelry at home and what tools are needed to make any kind of jewelry.
Jewelry wire components are quick to make at home, not to mention cheaper and more customized. To make a wire component for jewelry, you'll need practice wire jewelry, a flush cutter, fine step jaw pliers, nylon jaw pliers, and a jewelery making jig with metal pegs. Learn how to make wire components by watching this video jewelry-making tutorial.
Gemstone earrings are quick to make at home, not to mention cheaper and more customized. To make gemstone low wall bezel earring, you'll need low wall bezel findings, gemstones to match the findings, ear wire findings and bent chain nose pliers. Learn how to make gemstone low wall bezel earrings by watching this video jewelry-making tutorial.
Gemstone earrings are quick to make at home, not to mention cheaper and more customized. To make gemstone lever back earrings with snap fit findings, you'll need snap fit lever back findings, gemstones to match the findings, and bent chain nose pliers will help. Learn how to make gemstone lever back earrings with snap fit findings by watching this video jewelry-making tutorial.
Gemstone earrings are quick to make at home, not to mention cheaper and more customized. To make gemstone post earrings with snap fit findings, you'll need snap fit post findings, ear clutches, gemstones to match the finding, and bent chain nose pliers will help. Learn how to make gemstone post earrings with snap fit findings by watching this video jewelry-making tutorial.
Homemade mayonnaise is one of those indescribable culinary pleasures. If you have a stick blender or regular blender, you CAN make your own mayo. So much cheaper, AND way more delicious, you must give this a try.
The Canon Powershot A560 is one of the cheaper digital cameras in the Canon digital camera range. Watch this video guide to learn how to use it.
Watch and learn how to make this awesome DIY toy car that runs off solar power. This makeshift mini-vehicle is made from a plastic bottle, small motor, tires, supports and a solar panel. See if you can replicate this interesting solar toy, or see if you can come up with a better and cheaper design!
With the carcinogenic additives in today's microwave popcorn, we at HoopajooLabs.com have developed a method of microwaving popcorn that is healthier, cheaper and (in the opinions of our test tasters) tastier. A delicious and healthy treat for about $0.10 that just about anyone can make. Great for students!
Learn how to make monster shadow puppets with paper and polycarbonate. Paper puppets are cheaper and faster to make, but there is a professionalism about polycarbonate shadow puppets that can't be matched. Go and create a show.
Ring Lights can create a specific lighting that brings out warmer hues from your actors/models, as well as giving you a cool effect for the eyes. If you're not looking to spend a fortune on buying an already made one, you can make one with items from around the house on the cheap, if you have to buy everything you need, you're looking to spend around $100 which is much cheaper than buying one brand new! Check out this video for a full tutorial on how to build your very own Ring Light!
Treat your acne and pimples the natural way with this video! Take some honey and put it in a small microwave safe bowl. You will want to heat it for maybe 8-10 seconds. You are not trying to heat the honey and make it hot. You are trying to thin the honey out a little bit so that it is not so thick. Before you heat it, it is harder to spread and sticky. Get a cheap foundation brush and use it to apply the honey. Start in the affected areas and spread it out over your whole face because it's g...
Origami double hearts are easy to make and a great way to show your loved one that you care. Plus, it's cheaper than a dinner out, so watch this video, follow the steps, and profess your love with a piece of folded paper. Hey, at least your loved one will know you went through the effort, and it's the thought that counts, right?
