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:
Here's a simple modification for your vintage Diana or Lomography Diana+. Watch this instructional photography video to make a velcro film counter cover. You can also use black masking tape to cover the film counter for subtle camera work.
Use this camera modification to secure the Holga back to the camera and to provide a light blocker for the counter window. You will need a small package of velcro with industrial strength adhesive. This photography tutorial provides tips for making your vintage Holga camera easy to use in hectic shooting situations.
In this video, we learn how to take apart an Xbox 360 for modification. First, take off the hard drive from the console. After this, get the grids off of the console by prying with your fingers. Then, you need to get the tabs off of the cooling cover to the console. Once you have all the sides off, you will be able to push in the rest of the tabs and remove the top and bottom to the console and enter the inside. You will see the motherboard, power supply, and all the other parts inside. Make ...
This Photoshop tutorial on performing a nose job using Photoshop contains detailed instructions on the use of Photoshop tools to, depending on taste, enhance the appearance of an individual. The person narrating the tutorial specifies the necessity of subtlety with the modification of the picture in order to remove any appearance of modification. The way described is essentially to select the general nose area, feather the selection by an optional amount, and set it in a separate layer. Then ...
Watch this instructional video to learn how to use Google Hacks. Google Hacks is a collection of software that explores Google's search function. Hacks is meant in this definition. "A Hack is a modification of a program or device to give the user access to features otherwise were unavailable to them. Watch this how-to video and find out how to use Google to access free media.
Do-it-yourselfer Kipkay salvaged parts from an old parallel port scanner and made a flexible, super-bright light in this how-to video. The modification is done by extracting the lamp and running it through clear tubing. He mounted the new lamp above his keyboard for night typing. Watch this video tutorial and learn how to turn an old scanner into a keyboard light.
You can get OS X running on your AppleTV without having to open up your system - all you need is an external hard drive. This tutorial shows you how to create a hard drive on your partition and create a file modification to allow OS X to boot on an Apple TV.
In this tutorial, learn how to mod your MW2 game into split screen using your PC and a data transfer cord. This clip will show you step by step how to get up and running with this neat modification.
The best way to make sure you don't throw your back out when moving a heavy television and that your body stays lithe and strong even as you age is to do push ups, chest exercises that work out your entire body at once while focusing on strengthening your back and core.
Here's a new handle system for the RED ONE Camera. Allows multiple mounting points as well as an isolation plate for RED DRIVES. It's extremely robust, versatile, and inexpensive.
This motorcycle modification tutorial shows you how to install a doohickey (bouncer level tensioner) upgrade on a Kawasaki KLR650 motorcycle. Watch and see how to do each step of this KLR650 bouncer level tensioner upgrade and if you get lost, the creator site has written instructions to follow as well.
This tutorial starts off by showing you how to sew a basic skirt by using just your measurements - no pattern needed. Then, once you've mastered that, turn your basic skirt into a classy pencil skirt with just a few modifications.
Make every Christmas a personalized one. This tutorial shows you how to start with some basic clear glass ball ornaments, and then add a few different modifications, decorations and crafts to turn them into your own personal Christmas tree ornaments.
You can make an inexpensive and effective microphone boom pole just by using a extensible paint roller handle. Add a few modifications (all you'll need is a few pieces of basic hardware), and you will have your own DiY microphone boom.
Start with a Targus Monopod, and then follow along with this tutorial to create a BodyPod - a body harness that will let you 'wear' your camera. This modification costs less than fifteen dollars, and lets you cut down on the gear you'll need when filming.
While safety belt warnings are there for a reason, the constant sound of "ping, ping, ping" can get pretty annoying. If you'd rather not deal with the constant reminders, check out this video to learn how to disable the warnings on your 2010 Chrysler Town & Country. Be warned - this modification may be illegal in your state, so proceed with caution.
If you just happen to own a Yamaha PortaSound PSS-80 keyboard (1989), why not try something a little out of the ordinary— like circuit bending? Circuit bending can help you create a new musical sound via your keyboard, and this video tutorial will show you 10 different ways to circuit bend.
Isn't it weird that only 30 years ago hoodies were not very popular? Since then the hoodless sweatshirt has all but disappeared, and most people have more hoodies than they know what to do with. Watch this video to learn how to turn one into a cute laptop bag with no sewing or modification of the sweatshirt required!
You might think that an idyllic shot like the one of the Bahamas in the thumbnail for this video doesn't need any modification to make it look tropical. You would be wrong! This video will teach you how to use Adobe Premiere Pro to give a tropical photo a more tropical look by adjusting the colors, the brightness and contrast.
Customize your Ford Mustang. Impress the best with these simple modification from US Muscle Mods. If you're looking for a new feel for your Mustang, then Mustang lighting will give you that different feel.
If you're bored at school, this trick will be sure to amaze your friends and give you something to do. With only a few slight modifications to the pen, you can give the illusion that you are making a penny appear out of nowhere.
Want to take flash photos with your Diana+, but don't want to drop $100 on a DianaF+? Here's how you take flash photos with your standard Diana+. You can use a simple two battery flash unit and flash bracket to hold the flash to the camera. Note well: There's a trick to making this camera modification work, so pay attention to this instructional photography video.
This video tutorial offers a demonstration of how to install a Mojo pre-wired guitar assembly on a Gibson SG guitar. The installation will show how easy the Mojo assemblies drop in without modification.
Here's an instructional DIY video on how to extend your I/Os using 74HC595 chip and CUBLOC CB280. The input/output of a computer's memory can be enhanced with a modification using a microprocessing board and a mini-board. Watch this video computer-circuitry tutorial and learn how to extend I/O on a computer using a 74HC595 mini-board and a CUBLOC CB280.
This motorcycle customization tutorial shows you how to modify the rear mud guard in the wheel well of a Kawasaki KLR 650. This is for riders who have installed an aftermarket exhaust that is rubbing on the wheel well. If you have the stock exhaust, you shouldn't need to do this modification, but if you have rubbing issues, watch the video and learn to modify the rear wheel well of your KLR650.
This is an instructional video on how to remove the fairings from my Ninja 650R. The fairings are essentially the Ninja motorcycle's plastic body. Removing these can allow you to put a custom body on, or make modifications under the fairings. Pretty soon, your Ninja 650R will be the best motorcycle around!
Many repairs and modifications require you to work under your car. If you are fortunate enough to have a lift skip this video! For the rest of us, we need to make sure we raise our cars safely—this video gives an overview of steps applicable to most cars.
DSP Manager, Dolby Atmos, ViPER4Android — how are you supposed to pick just one from the wide variety of Android equalizers? Depending on your OEM, your phone may have come with a stock equalizer, but they're usually not enough. Combine them with a third-party equalizer, and then we're getting somewhere. However, installing multiple equalizers at the same time has always seemed to cause audio glitches — until now.
Straightforward ab work with modifications for beginners and experts are shown in this pilates how-to video. Practice doing single leg lifts and changes with this pilates core workout. These pilates single leg lifts are sure to help tone and strengthen your abdominals in now time.
Want to add a little variation to the plank position? When you are ready to take it up a notch, lift a leg. Watch this video first, to see what it looks like.
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.
