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 ...
Looking at homes is the fun part. But before you go house hunting, make sure you have your financial ducks in a row.
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 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:
Safecracking is something that most of us will only come in contact with in the movies, where strange men and women stick their head against safes and twist dials until the safe magically opens. If your interest in gaining entrance to safes that aren't yours goes beyond that, this video will teach you most of what you need to know. It features a prominent lockpicker giving a 30 minutes presentation on non-destructive safecracking techniques.
In this how-to video from Household Hacker, we show you how to disguise a common household item as a safe to hide all your goodies in.
This tutorial is a great guide on how you can make a set of safe, foam-tipped arrows. You'll need to start with some hobby arrows, metal washers, wall anchors, a small NERF football, a hot glue gun, glue sticks, measuring tape and a foam golf ball or blue camping foam.
Mary from VLine industries shows up how to Install a wall safe into a closet wall. For this example, she used a DOJ approved Wall Safe from VLine. The first step to the installation is to find where the studs are in the wall and make sure there is no electrical or plumbing behind the wall. Next, after locating the studs with a stud finder or by knocking on the wall, you measure and mark the space you will need for the wall safe. Use your dry wall knife to cut the space for the wall safe out b...
There are times when you must start up your Windows XP computer system in Safe Mode, for example if you need to remove certain viruses, key loggers, adware, etc. that cannot be removed while in standard mode. If you want to learn how to boot in safe mode in Windows XP, you should watch this. 1. Turn on your computer. Make sure your monitor is on and you do not step away from your computer, as booting into safe mode happens within the first minute of when you turn on your computer. You should ...
No water should be considered safe unless it is treated. Please take all precautions before drinking water you find in creeks and streams. Even water that looks safe may contain harmful bacteria and viruses. Learn how to recognize water that is safe to drink.
Make a hidden safe out of a whipped cream can. Kipkay shows you how to make a secret stash for valuables with just some magnets and glue.
One of the most memorable and fun activities during the summer is grilling hot dogs, slabs of steak, and chicken on the grill outside. But using a gas grill and propane tank can be potentially very hazardous.
In this video tutorial, viewers learn how to start a Microsoft Windows computer in safe mode. Begin by turning on your computer. As your computer starts up, press F8 before Windows launches. Tap the F8 key slowly (about 1 second apart) as soon as the computer starts up. Keep tapping until the Windows Advanced Options Menu appears. The use the arrow keys to select the appropriate safe mode option and press ENTER. You may need to log into your User account. This video will benefit viewers who u...
This tutorial shows you how to make a very safe short sword with a stabbing tip that will pass safety inspection for most games. You'll need filament tape, cloth tape, glues and adhesives, a fiberglass or graphite core and foam coating.
Add to your boffer larp arsenal with these foam arrows! This tutorial shows you how to make a modular boffer arrow out of three different kinds of foam, a cloth cover, arrowhead shafts, scissors, duct tape and your favorite kind of spray adhesive.
As far as landings go, it seems that there is nothing more basic than a standard, normal approach and landing. Even the name suggests that this is a bland procedure of routine and mundane performance. Despite disguise, however, the normal approach and landing is one of the most challenging parts of any flight to consistently master.
Learn the basics of safety play in 9 ball pool. This video covers some common misconceptions regarding breaking and running that many beginners hold.
No smartphone is immune to software issues, even one as advanced as the Galaxy S9 and S9+. Bugs can be caused by a multitude of issues, such as third-party apps that just refuse to play well with your device's OS. Thankfully, there's a simple way for you to check if your S9's bugs are due to uncooperative apps.
This tutorial shows you how you create a boffer larp safe pair of werewolf claws. Start with some basic heavy gloves, like gardening gloves, then cut out your claws from foam (at least three inches long!), and then follow along with the tutorial to end up with your own awesome monster claws!
In this tutorial, we learn how to make a safe password. Passwords are essential, and need to be safe for when browsing around the internet. Other people aren't meant to be able to nose around your information, so protect your information with an indecipherable password. Don't choose a password that is easy to crack, never use personal information. A random number in the phone book isn't a good idea either, software used by hackers can crack these. Make sure your password is 8 characters long ...
In this video tutorial, viewers learn how to dial open a combination safe lock. Begin by turning the lock 4 times to the left. Then turn the lock 3 times to the right. Now turn the lock 2 times to the left and finish by turning it one more time to the right. Users should hear and feel a click when they finish turning the lock. When locking the safe, turn the lock 4 or more times to the left. to ensure security. This video will benefit those viewers who have a safe lock and would like to learn...
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.
This is an easy step by step tutorial how to lock your jewels in a hotel room or in a public safe. Be aware that in a public safe it is more secure to use the second method of locking by a magnetic card, not by a PIN code that can be easily seen by someone nearby.
This tutorial video will show you how to run the browser in safe mode for faster internet speed. In browsers add-ons consume memory and slow down the browser’s speed. But you could open your browser in safe mode where the browser opens without add-ons. This safe mode increases internet or browser speed.
If you're only fighting with foam, you don't want a professional hunting weapon. But you can refit a commercial crossobw and make it larp safe. Starting with the Cobra crossbow, you can modify it to safely shoot foam tipped arrows at a boffer larp.
In the Colonist Mission of Safe Haven on Starcraft 2: Wings of Liberty, you'll have two choices, either to "Protect the Colony" or "Purify the Colony". This video will show you how to "Protect the Colony," because you want to make sure the Doc is pleased. Watch the full NextGenTactics campaign walkthrough to see all the action.
Need some help figuring out how to configure safe frames and grids in Maya 2011 when animating for specific output source? This clip will show you how it's done. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the Maya 2011 workflow, you're sure to be well served by this video tutorial. For specifics, watch this free video guide.
Need a way to hide your small pricey or memorable objects? Well, what better place to hide those cherished items than in a burning candle? Unless your robbers have a thing for scented and aromatic candles.
Check out this DIY video tutorial from Curbly, the best place to share pictures of your home, find design ideas, and get expert home-improvement advice.
Want a safe place to hide your stash? Here's how to build a miniature electronic safe out of an Altoids tin and a Hallmark musical greeting card.
Installing tweaks or themes onto your jailbroken iOS device is a pretty fun and exciting experience, but if you do it for long enough, you're bound to come across a bug that will cause your operating system to crash.
At the recent DefCon conference in Las Vegas, researchers opened many of the top commercially available gun safes with simple tools like a straw or a paper clip, and in one case, just by shaking it a bit. The investigation began after the researchers, Toby Bluzmanis, Marc Tobias and Matt Fiddler, learned that certain Stack-On safes, issued to some law enforcement officials to secure their firearms at home, could be opened simply by jiggling the doorknob.
There are many different things that could contribute to a power or gas outage or accident in your home. To be properly prepared for an emergency or other situations that endanger you, take a look at this video from SDGE on simple tips to keep safe, including discovering gas leaks and using power generators to maintain eletricity in your home during an outage.
Need some help figuring out how to install and uninstall programs when operating within Windows' Safe Mode? This clip will show you how it's done. It's simple! So simple, in fact, that this home-computing how-to can present a complete, step-by-step overview of the process in just over three minutes. For more information, including complete, step-by-step instructions, take a look.
In this tutorial, talk show host Jenny Jones shows you how to make a totally edible cleaning solution that is great around the house. The best part is that this is totally safe for kids and pets and can be used for so many different things. Jenny will also show you how to make a dispenser so that it is easier to keep this cleaner around the house and use it. Check it out!
