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 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.
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.
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.
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.
Your Guitar Sage provides the viewer with a good way to learn how to play an Amy Winehouse tune on an acoustic guitar. Amy Winehouse's song, Rehab has a few open chords and bar chords to be mastered. The videos demonstrates how to play the piece through first and then takes the viewer through each part of the song. The names of the chords and bars are provided. The verse and the chorus pieces are split to provide the viewer with help in fingering, pace, rhythm and timing within each part. The...
Improve your customer service by mastering the ABCs of customer service--attitude, business knowledge, and customer-oriented customer service--with expert training tips in this free online customer service training video series.
Poison Ivy is one of our favorite female antagonists from "Batman." Sure, girl was a little crazy about her precious plants, but she was hot as hell and wore cute, skimpy outfits that flaunted her bodacious curves. She was also pretty damn gorgeous, all the more perfect for ensnaring her victims.
In this medical-minded video tutorial from the folks at ICYou, we learn about the potential risks associated with providing emergency care to an unconscious person. For all of the details, and to learning more about providing aid to a person who is unconscious, take a look.
In a bad economic environment, providing a great customer service experience is even more important than normal. Word of that great experience will spread via Twitter and Youtube, helping your business attract buzz without requiring it to spend cash on marketing. This video features a business technology expert explaining how to create a "wow" experience for your customers and use the ability to do so to improve your business.
Network mapping lets PC users organize multiple computers into a system that provides informational data access. This video tutorial shows how to set file sharing permissions and assign users designated privileges within a network. Establishing a network provides functionality within a workplace and facilitates virtual communication among users.
Yoga is a great way to strengthen your body and increase flexibility. This how to video teaches a yoga pose for arm balance, Vasisthasana or the side plank yoga pose. Yoga instructor Christine Navarro demonstrates the Vasisthasana or the side plank yoga pose and provides instruction on getting into the posture. Strength building exercises are also provided.
Do you like songs by Oasis? Want to play them on your guitar? Tbone Wilson provides the viewer with a neat way to learn "Fade Away". He provides the viewer with really good closeups of where to place your fingers for the chords in the song. The viewer can rewind and replay any part of the piece that they need. He includes a written list of the chords as they appear in the piece, as well as the written words to the song. They are found at the left of the video. He also provides a place to subs...
Wanna play the bass like a pro? Paul Wolf provides a superlative video, for beginners, to learn how to play Michael Jackson's "Billie Jean" on the bass guitar. The use of a picture within a picture provides beginners good closeups of where to place the fingers of both hands to accomplish the task. He includes a slower version and a breakdown of the parts of the piece, the chords and metronome settings to help with the changes in tempo of the song. He provides great insights to all of the rift...
Simon Leach from Simon Leach Ceramics provides some great workshop footage on preparing to glaze Raku ceramic pots. This tutorial video provides answers on the beauty and function of Raku pots, as well as some great ideas for home decoration. Simon walks you through the process of glazing these pots, including important specifics about proper materials and methods, easy recipes for making your materials and tools at home, as well as common mistakes that you should avoid when glazing your cera...
YouTube user s2pandapple shows viewers and subscribers how to self French braid. Before beginning with simple step by step instructions, s2pandapple provides personal tips on simplifying the braid process. Using down to earth terminology, s2pandapple proceeds to verbally instruct viewers on the process of French braiding while performing the tasks and providing viewers with multiple angles of the braiding procedure. While this tutorial is mainly a precursor to s2pandapple's instructional vide...
This is the eighth episode of "Walk, Talk and Learn French" provided by Radio Lingua Network and it focuses on French verb in the imperfect tense. The video mixes a host providing real life French, while speaking in both French and English, and provides examples with charts and written explanations teaching different verbs. The mix of spoken and written words helps the viewer understand the foreign concepts in a better way.
Check out this instructional Hungarian language video to learn how to speak Hungarian! In this lesson, learn how to pronounce names and surnames in Hungarian. This video provides typical names in Hungarian without providing their English equivalents. This instructional language video is great for advanced and beginners who would like to pronounce names and surnames in Hungarian.
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.
Link shortening is the process of cleaning up the URL link which is long and converting it into a short URL. You can use bit.ly to do link shortening. Using bit.ly you can not only shorten the link but also track the users who are using those links. To use this service go to the http://www.bit.ly website. There in the home page you are provided with a text box. Enter your long link in the text box and submit it. Now the website converts the long URL and provides you with a short link which ca...
In this video tutorial, viewers learn how to make turkey goulash. The video provides all the ingredients required in order to make turkey goulash. The ingredients include: 1 chopped onion, 2 chopped carrots, 2 chopped stalks of celery, sweat in olive oil over medium high, 3 tablespoons of Hungarian paprika, 2 crushed & minced clove garlic’s, 1/2 bottle of white wine, 2 roasted peppers, can of stewed tomatoes and turkey. This video provides step-by-step instructions that allow viewers to easil...
The first thing anybody really thinks about after watching Rear Window is how much they want their own telephoto lens. These days, they aren't cheap, so how do you go about spying on your neighbors without putting down so much dough?
Thinking pasta is too heavy for your new diet? Think again. Pasta can provide a healthy meal rich in fiber and vitamins. Follow these steps to make healthier choices for your next pasta dinner.
Quit hogging your own backyard. Make it a haven for your fine feathered friends. Learn how to attract birds to your yard.
The front camera on the Droid Bionic from Motorola is a perfect match for the Google Talk application provided with the Android smartphone. Using the Verizon Wireless 4G connection, you can stream video and voice to friends and family members on the go. This guide by Motorola demonstrates how to video chat on the Bionic.
This video, incredibly short for it's massive content, will teach you how to make a laser tripwire that, combined with a photoresistor, can trigger just about any device. You can make traps, alarms, awesome party decorations, and all sorts of other awesome things with this easy-to-make device, provided you have a soldering iron and a local electronics store to buy some parts.
Adding links to your blog will provide people with more information. In this video, Cindy will walk you through adding and changing links in your WordPress blog. You'll also learn how to add link categories, which will provide the reader with more information about your links. After watching this tutorial, adding and changing links will be a snap!
Watch this video fromt the Concrete Network to learn proper function and use of the vibratory plate compactor tool for preparing the concrete subgrade before placing the concrete. This is done to provide a stable foundation for the new slab as well as provide drainage.
Since the release of the T-Mobile G1, the Play Store has been flooded with apps that claim to improve performance by clearing cache and storage. These apps are typically useless, rarely providing more than a temporary fix which Android undoes immediately. As Android has continued to improve cache and storage management, such apps have become more trivial. However, there are few decent ones out there.
One shrinks their nose when the name of Durian fruit is brought up but are you aware of all the health benefits it can provide? The Durian fruit on its own can help control Blood pressure, blood sugar, Anaemia and depression. Not only this, the fruit has the miraculous qualities that can prevent cardiovascular diseases, better the digestive system, better the Libido and provide instant energy. For all the skin conscious people, here's news for you! The fruit can delay ageing process and make ...
In this video, we learn how to improve your resume with valid statistics. You need solid numbers to back up the information you are writing on your resume, not just words written on the paper. Most applicants look qualified on paper, but don't land interviews because they don't offer proof to validate their claims. When you provide proof of what you are stating, the person who is viewing your resume will be more likely to call you for an interview. Make sure to provide supporting documents an...
Repeating a task using a For...Next loop : Excel: VBA in Depth from lynda.com Watch the entire course at http://www.lynda.com/home/DisplayCourse.aspx?lpk2=62906&utm_source=youtube&utm_medium=viral&utm_content=youtube&utm_campaign=youtube
Eric Mayo teaches us how to put together a resume as an ex-offender. Your resume should be a one page paper of all your skills and work experiences. If you don't have a lot of experience writing resumes, get help from friends who have experience. When you write it, add your name, address and telephone number onto it so you can be contacted. After this, you will want to list: objective, work experience, education/training, skills/strengths, and references. Remember not to list your references ...
