Loan to Value Ratio Search Results

How To: Do a complete loan analysis in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 18th installment in his "Excel Finance Trick" series of free video lessons, you'll learn how to use the PMT and RATE functions for a complete debt/loan analysis.

How To: Solve an interest loan problem for part/base in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 54th installment in his "Business Math" series of free video lessons, you'll learn how to solve a simple interest loan problem for part, base, or rate.

How To: The Best Phones for Watching Movies & TV Shows — Under $500

You might think you need to buy a thousand dollar phone to get a great experience while streaming movies and TV shows from services like Netflix, Hulu, and YouTube, but that's just not true anymore. While phone prices keep rising and the midrange segment now ranges from $300–$500, there are still cost-effective options that come with top-notch displays and media features.

Basics of Ruby: Part 1 (Data Types/Data Storage)

Ruby is a dynamic, general-purpose programming language created by Yukihiro "Matz" Matsumoto in Japan around the mid-90's. It has many uses but with it's flexibility, it makes a great language to write exploits in. In fact, the entire Metasploit Framework is written in Ruby! The sole purpose of this series is to teach hackers the basics of Ruby, along with some more advanced concepts that are important in hacking.

How To: Create a wireframe or sitemap for a mobile device in OmniGraffle 5

Want to make a wireframe for something that's ultimately going to end up on an iPhone 4 or Google Android smartphone? This quick clip offers some advice. Whether you're new to the Omni Group's popular task management application or simply wish to get better acquainted with the program, you're sure to find value in this software tutorial. For more information, including step-by-step instructions, take a look.

How To: Modify table of content styles in Microsoft Word 2007

Want to tweak built-in table-of-content styles in Microsoft Word 2007? This guide will show you precisely how it's done. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2007 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started edding ToC styles yourself, take a look.

How To: Make Healthy Homemade Kale Chips, Not Junk Food

Potato chips are cheap and delicious, but terrible for both your body and the environment. They have lots of packaging and nearly no nutritional value. This video will show you how to make a homemade substitute snack that is healthy and delicious: kale chips. Yes, that's right, baked chips made from something that's good for you! Sorry potatoes, but you've got nothing on these guys.

How To: Create and add behaviors in Apple Motion 4

In this clip, you'll learn how to go about creating behaviors for use within Apple Motion 4. Whether you're new to the Apple's popular motion graphics editor/compositing application or are a seasoned digital video professional simply wishing to get better acquainted with Motion 4, you're sure to find value in this tutorial. For more information, and to get started using this trick yourself, take a look.

How To: Start an Action list in OmniFocus

Want to create an Action list in OmniFocus? See how it's done with this free video guide. Whether you're new to the Omni Group's popular task management application or simply wish to get better acquainted with the program, you're sure to find value in this free tutorial. For more information, including step-by-step instructions, take a look.

How To: Work with Photoshop's new HDR photography features

Whether you want to be subtle or brash, the greatly improved HDR features in Photoshop CS5 are worth a close look. This tutorial presents an overview of Photoshop's new HDR Pro and HDR Toning high dynamic range functionalities. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this free video tutorial.

How To: Create a quick layer mask within Adobe Photoshop CS5

Want to create a fast layer mask in Photoshop CS5? It's easy. Learn how with this video guide. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this free video tutorial.

How To: Dodge midtones and shadows in Adobe Photoshop CS5

Part of your image too dark? The solution might be a few clicks away. Learn how to use the new color dodge tool within Adobe Photoshop CS5. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this free video tutorial.

How To: Desaturate pictures in Adobe Phototoshop CS5

Use Photoshop CS5 to create dramatic black-and-white landscapes with this free video tutorial from Lynda. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this video guide.

How To: Use the Scrubby Zoom tool in Adobe Photoshop CS5

Learn how to take advantage of Adobe Photoshop CS5's much undervalued Scrubby Zoom tool with this video tutorial. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this video tutorial. For more information, and to get started using CS5's Scrubby Zoom feature yourself, watch this video lesson.

How To: Apply automatic lens correction in Adobe Photoshop CS5

Want to correct for lens problems after the fact? With Adobe Photoshop CS5, it's easy. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this video tutorial. For more information, and to get fixing lens flares and abberations in your own digital images, watch this video lesson.

How To: Use the content-aware fill feature in Photoshop CS5

Learn how to take advantage of Adobe Photoshop CS5's new content-aware fill feature. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this video tutorial. For more information, and to get started using the content-aware fill tool for quick, seamless edits, watch this video lesson.

How To: Reduce camera raw noise in Adobe Photoshop CS5

Learn how to take advantage of Adobe Photoshop CS5's new noise reduction capabilities. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this video tutorial. For more information, and to get started denoising your own raw image files, watch this video lesson.

How To: Extract characters without leading zeroes in MS Excel

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 331st installment in their series of digital spreadsheet magic tricks, you'll learn how to extract individual characters without extracting the leading zeroes through use of the MID, VALUE and COLUMNS functions.

How To: Light a green screen properly for podcasting

Matt, the Shirtless Apprentice, advises viewers on the proper procedure for lighting a green screen. The successfully implemented chroma key technique can significantly raise the production value of any video podcast. He gives specific advice on how to separate the light that falls on the subject from the light on the greenscreen, a traditionally tricky technique.

News: Making Art with the Golden Ratio

You can do some pretty cool stuff with the golden ratio. The image above is made from taking each quarter-circle in the golden spiral and expanding it into a full circle. In the second image, the spiral and the golden rectangles are overlaid on the the first image, showing how it works.

How To: Simplify rates and ratios with simple arithmetic

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to simplify a rate or ration using simple math.

How To: Use natural products to clean your home without toxins

We all want to spic and span our kitchen countertops, our tile floors, and our bathrooms. But for the most part we can bet you've been unwittingly using storebought detergent cleaners or bleach. While these cleaners are in fact excellent at removing grime and buffing your dirty floors to a Midas touch perfection, they also come filled to the brim with known cancer-causing agents, synthetic chemicals, and other gnarly, hard to pronounce crap.