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:
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.
After leveraging the well-known intellectual property of Rovio's Angry Birds for its first game for the Magic Leap One, Resolution Games is singing a new song with a familiar refrain for its next game for the augmented reality headset.
This video series come straight from Google. It's about their new web-based product called Google Voice, which provides you with one phone number for all of your phones (landline, cell phone, etc.), giving you full online control of your telephone experience. Google Voice also allows you to make free domestic calls anywhere in the United States and Canada, gives you a cool voicemail account that's just like an email account, and many enhanced calling features.
When you decide its time to retire, you will most likely need to cash in your Social Security benefits. In this official two part tutorial, presented by the American Social Secuity Administration, learn exactly how to use their website and apply online. Applying online is very easy, and takes a lot less time than applying in person. By applying online for social security, you will bypass all of the long lines and waiting that usually happens in one of the offices. Plus, you won't ever have to...
Up until the last 15 years or so, watching the commercials during the Super Bowl was arguably more exciting than the game itself. Super Bowl XXIV featured the San Francisco 49ers blowing out the Broncos, 55-10, in the worst Super Bowl beatdown of all time. The game might not have been that exciting, but the commercials sure were.
One of the coolest parts of DC Universe Online is it's tremendously complex super hero character creation system. The system i pretty daunting at first, but this video will guide you through making an awesome character that will be the envy of your guildmates online.
Fighting in space is one of the aspects of Star Trek Online, and how you fight will depend on what strategy and tactics you employ. This tutorial goes over a few options and tricks to help you fight your best as a ship.
Space combat is one of the major aspects of Star Trek Online. This video walks you through one of the introductory missions of the game, and shows you how to use your ship to fight, pick up passengers and even fight the Borg!
It's time to boldly go where no man has gone before! This video walks you through the first few minutes of Star Trek Online, including how to customize both your character and ship, and a quick rundown on hand to hand combat in the game.
Mining is one of the best ways to earn resources when you play EVE Online. This tutorial includes everything you need to know in order to profit from mining - all you need is a ship and a mining laser!
Make sure your character progresses the way you want! This tutorial explains how character attributes and skill training work within EVE Online so you can maximize your character's potential in the game. This tutorial also explains how to navigate the character sheet function. Always be learning at least one skill!
Are you passionate about both Star Trek and Apple products? It's indeed possible to run Star Trek Online on an Apple Mac! This shows you how to download two separate mods that will allow you to play Star Trek Online on your Mac.
If you want to tool around in the user interface of Star Trek Online and modify your client, this video shows you how. Do note that Cryptic doesn't support modding, and it could break your system. But if you want to alter the mouse pointer or your camera point of view, here's how!
Kits are something your character might come across while playing Star Trek Online - special items which will augment or improve your character's specific skill set. This short video explains what kits do and how you find and use them.
Part of the fun of an online game is being able to chat with your friends! This tutorial goes over how you can use the in-game chat system to join a chat channel. It also gives you a few channels useful for everyone to join, especially new players. Or create your own channel. Avoid pirate corporations!
The concept of video game etiquette is foreign to many people, including a disgraceful number of frequent gamers. The combination of anonymity and role-playing in online games can lead people to be dicks in all sorts of obnoxious ways, making a fun activity distinctly less fun for everyone. Watch this video to learn about proper online gaming etiquette in the context of Call of Duty Black Ops. These lessons extend to most games, however, and practicing them will results in people liking to pl...
Sessions Online School of Fine Arts brings you this tutorial video on painting. Search WonderHowTo for Sessions Online School of Fine Arts for more art tutorials. This video art lesson demonstrates how to use color as value in the art of portrait painting.
Sessions Online School of Fine Arts brings you this tutorial video on painting. Search WonderHowTo for Sessions Online School of Fine Arts for more art tutorials. This video art lesson demonstrates how to do an underpainting for portrait painting.
Sessions Online School of Fine Arts brings you this tutorial video on painting. Search WonderHowTo for Sessions Online School of Fine Arts for more art tutorials. This video art lesson demonstrates what is needed in preparation for portrait painting.
Know your way around sector space when you're playing Star Trek Online. This tutorial shows you how to interact with the sector map in the game and get to where you're trying to go, and what you might find as you travel through space.
Crafting is someting you can do in Star Trek Online after you complete the Scientific Mandate mission at level 4. Once you do, you'll gain the ability to craft items. This tutorial shows you what to do once you acquire this ability.
This video explains one of the newer features of Star Trek Online and how to use it - the Accolade System. Also covered are the mechanics behind your ship's shields, and how to use that math to your character's advantage.
It's entirely likely to encounter hostile natives when exploring a new planet in Star Trek Online. Fortunately, you can easily outflank your enemy and triumph over the odds by using your Away Team. This video shows you a few strategy tips to decrease casualties.
In Star Trek Online, not only do you play an individual character, you can also play your own ship while on space missions! And just as the characters are customizable, so are the ships! This tutorial shows you how to customize your ship to get it just the way you want it.
Part of what makes EVE Online so much fun is the option to explore different moons, planets and asteroid belts. However, it can be dangerous. This tutorial explains the equipment you'll want and the best way to explore in a non-combat situation.
Need to find a good agent for your character when playing EVE Online? Starting from docking your ship in the station, this tutorial shows you how to find the best agent possible to help out your character in the game.
Planetary Interaction is a feature of the EVE Online expansion, Tyrannis. This video guide shows you how to use this new function. Choose your own planet, buy the command center and start exploiting its resources for your own gain!
Have some last minute edits to make to your photos before you publish them online? Don't have time to download and install software to your computer? This video guide has five free online photo editing services to share. For detailed instructions, and to get started editing your own digital images online, watch this free video tutorial.
This is a great video series from Yanik Chauvin demonstrating how to use Photoshop Express online for free. This great tool is a wonderful resource for those who can't afford Photoshop but still need to do basic photo editing.
With social networking systems, YouTube comments chains, chat rooms, bulletins boards, Twitter updates... It seems as if almost everyone has at one time publicly stated an opinion on the Internet. Nearly half of all prospective employers research job applicants online. Make sure that what you’re posting today doesn’t cost you a dream job tomorrow!
With the convenience of internet poker games, everyone wants to play Texas Hold'em online. If you know the rules and good strategy you will have the advantage. The rules of an online Texas Hold'em tournament differ from game to game. Learn the basic structure of most online Texas Hold'em tournaments with this how to video. This lesson is a must have for anyone who wants to start playing Texas Hold'em poker tournaments online. You'll be a pro in no time with this Texas Hold'em tutorial.
