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:
Lasers are one of the coolest things that you can build yourself from a pure sci-fi fantasy standpoint. They're not easy though, but this video will help you somewhat by describing different types of laser diodes and how to connect them to a power supply.
Keep your art supplies organized. Learn how to build a toolbox to store your art supplies in this free woodshop project from a woodworking teacher.
Your power supply on the bottom of your Mac may need to be replaced. If you're not sure how to remove it, no problem. See how to remove the power supply from the Power Mac desktop computer.
Electroluminescent devices need electricity to light up, clearly, so if you're working on an EL project building a proper power supply is crucial. In this video you'll learn how to make a DIY power supply for your EL projects that is safe, effective, and cheap.
For most people, learning how to work with electronics is far from intuitive. Getting the diodes in your hands and working with them is the best way to go about it, and this video will teach you a great lab for learning about diodes, potentiometers, capacitors, photo cells, and power supplies.
Don't let your scrapbooks get destroyed, learn how to properly store them, preserving them for life, in this free video series that will show you how to protect you scrapbook for years to come.
Removing the power supply from the iMac G5 is a two step process. First, see where the power supply is located. Then begin the process of removing it. You can do using a very easy way described in this video. First unscrew the 4 torx screws that are located around the edges of the power supply. Be careful not to be too rough while doing so. Once you have unscrewed them, then gently lift or remove the power supply. However, we still have to unplug it from the iMac. Therefore, carefully unplug ...
Hate those cheap multi-adapter power supplies that only provide up to 500ma of power? Here's how to use one high-output power supply (up to 3.5A in this case) to run all of your power hungry gadgets, like laptops, LCD monitors, etc...
First of all, please DO NOT attempt to open any power supply and tweak what's inside unless you know what you're doing and/or are a professional. With that said, this circuitry video will teach you how to crack open a wall transformer power supply without destroying the transformer.
Upgrading your power supply can solve all sorts of problems that may arise after upgrading your PC's hardware. THe Lab Rats, Andy Walker and Sean Carruthers, will let you know how to tell if you need to upgrade your power supply and if you do they will help you figure out what kind you need and show you how to install it.
Most PC tower cases have the power supply mounted near the top of the case in the back. However, if you want your PSU to run a little cooler, watch this video to learn how you can mount your PSU on the bottom of a tower case, allowing it to draw cooler air from the bottom of the case rather than the hot interior of the case like a top-mounted traditional setup would.
Looking for a primer on how to remove the superdrive and power supply from your Mac Pro? This brief how-to will guide you through the process, the first necessary step of any upgrade or repair to either of the aforementioned parts. This tutorial will also be of use to those who wish to learn more about the guts of their Mac Pros without actually disassembling their units.
While breadboarding may seem like some odd combination of snowboarding and consuming the fluffy pastry at the same time, it's actually just the technical term for using a construction base to build a prototype electric circuit. Breadboards are solderless so they're great for circuit design and are reusable.
Looking for something fun to do with all those office supplies you've been stealing from work? Or maybe you just want to goof around in your cubicle? It's possible that you are an honest, dedicated, hard worker, but whatever the case may be- no judgement, just a video guide to making an office supply catapult.
Steve of Element Tattoo Supply demonstrates how to set up a tattooing power supply, specifically the Silver Bullet model. It has a voltage switch on the back. If in the US, set the power supply to the 115-volt setting. Outside the US, switch to the 220 volt setting. There are two power plugs in front for tattooing equipment (such as a foot pedal), and a dial for adjusting the power. The relative power is displayed on a LED display.
This instructional video provides examples various supplies for war game terrain and diorama making. Most of these supplies for miniatures can be found at a local dollar store. Look for cardboard tubes, plastic sheeting, high density foam, metal foils and wires, plaster, sand twigs and other found materials.
In this video you will learn how to make a high voltage, high frequency power supply in just five minutes, and for less than twenty bucks. All you'll need is a compact fluorescent light (CFL) and a flyback transformer to make that alternative energy source of yours.
This Home & Garden video shows you how to replace a running old style fill valve toilet with something more modern. Shut the supply line to the toilet and flush to remove the water from the tank. Then remove the supply line. Now take a wrench and loosen the plastic nut of the old fill valve located under the tank. Then lift the old valve and keep it aside. Take a 'flow master', which is a new type fill valve, place it in the same spot and hand tighten the nut under the tank to hold the flow m...
Do you have an old uninterruptable power supply you're not using or that's broken? Most people have scads of them these days, and they contain all sorts of useful electronics parts, including all of the stuff to make a little batter charger, which you'll learn how to do by watching this video and checking out the circuit diagram here.
These wee 3X3 cards may be small, but they sure do make a charming impact when sent to friends as Thank You cards or small "Just Because" notes. Made from craft supplies that can all be found at Michael's for $1 each, these mini blank cards are also wallet-friendly.
Attention aspiring horror movie makers! Have an interest in making fake heads to use as your gory extras? BITY Mold Supply has supplied the world with this great tutorial on how to cast a silicone head or face from Gel-10 and Polyfoam. In the later half of this video, BITY lends great tips on how to paint your finished silicone face for a realistic look.
Out for a leisurely hike in the woods? Well, don't leave home without a few simple supplies or you could be facing a survival situation out-of-doors. Make sure to take supplies along with you, like a compass, but make sure you know how to use it. Watch this video outdoor safety video and learn how to survive a hiking trip in the woods.
From Systm learn how to build a USB battery supply that can charge your cell phone.
This video is a step by step guide on changing or installing a power supply in your PC. This is a great video and a money saver, replacing the power supply yourself can save a lot.
After 12 years Starcraft 2 is finally here to blow your mind. If you're looking for help with the game, you've come to the right place. We have tons of videos about how to do just about everything in the game. We have strategies for winning campaign and multiplayer games. We have guides to using the immensely powerful level editor. We'll even teach you how to build a Terran Barracks out of Legos. This video will show you how to you can make a mobile wall of supply depots on your Terran base's...
If you're making a cheap horror movie, you're gonna need fake blood, and lots of it! In this video, you'll learn how to make a liter of fake blood. And the supplies are everyday household supplies, costing less than a dollar!
Crafting and sewing is lots of fun, but it calls for many accessories and notions that can clutter your craft area. This tutorial shows you how to create your own craft supply organizer out of some upcycled or recycled materials.
If you have an endless supply of purses and a limitless supply of wall empty wall space, it's about time you made some DIY purse racks. In this video, you'll see a very easy (and cheap) way to hang all of your purses (and please your boyfriend). For this DIY purse rack, you'll need some coat and hat hangers (hooks), feather boas, screwdriver and a tape measure.
This video tutorial is in the Home & Garden category which will show you how to save money & water with your toilet flush. The first step is to turn the water off. Then remove the lid of the tank, disconnect the bowl refill supply and make sure that the overflow pipe is open. The next step is to take the new sink, attach it to the water supply point, place the drain in the overflow pipe and position the sink over the flush tank. The modification is done. Now turn on the water supply and your ...
This video illustrate us how to make ramen noodle soup with a coffee maker. Here are the following steps:
Be a DIY superstar and impress your friends with your newfound craft skills by turning simple votive candle holders into a hanging candle tree. You can do it all with simple home supplies and by following the instructions in this video.
