Loan to Value Ratio Search Results

How To: Use the patch and clone tools in Adobe Photoshop

Remove blemishes, repair damage and otherwise alter your digital images using Adobe Photoshop's patch and clone tools. Whether your new to Photoshop or just new to retouching your digital photographs, you're sure to find something of value in this free lesson. For detailed, step-by-step instructions, and to get started touching up your own photos, watch this handy how-to.

How To: Perform a quadratic regression with a calculator

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 (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to find the partial derivative of a vector-valued function using a calculator to perform...

How To: Run advanced VLOOKUP queries in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 40th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to perform eleven VLOOKUP tricks including how to use VLOOKUP with the TRIM function to remove spaces from first column of lookup value.

How To: Fix common Excel spreadsheet problems & errors

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 25th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to interpret and resolve the nine most common Excel formula errors — namely, ####, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Reference, and #NULL!.

How To: Find confidence intervals with a sigma value in Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 80th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma is known known using the CONFIDENCE and NORMSINV functions.

How To: Use NORMSINV with critical values in Microsoft Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 87th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use NORMSINV to test a hypothesis with population standard deviation (sigma) known and proportions.

How To: Work around the 1-rule data validation limit in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 144th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to work around data validation's one-rule limit by creating a second shrinking list that looses values as they are used in the data validation area.

How To: Randomly generate 1s, 0s & blanks with Excel's CHOOSE

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 392nd installment in their series of digital spreadsheet magic tricks, you'll learn how to randomly generate 1, 0 and blank values with the CHOOSE, RAND, RANDBETWEEN and INT functions.

How To: Calculate commissions with Excel's VLOOKUP function

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 206th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate commissions with the VLOOKUP function when the lookup value is an account type instead of a number.

How To: Make buttercream frosting for decorative cakes

Edna shows us the basics of making buttercream frosting for professional, decorative cakes starting with the right ingredients. She uses a basic buttercream recipe, but makes sure that she does not over-mix the ingredients. She also explains how she used to use Crisco, but when the company changed its recipe to zero trans fat, she decided to started using real butter, which makes the frosting a lot less yellow. Additionally, use of Crisco, makes the frosting drier and much more crumbly. If yo...

News: LG G6 Features Dual Cameras, 18:9 Aspect Ratio, Waterproof Body & More

The LG G6 was officially announced by LG at Mobile World Congress 2017 in Barcelona and released in the US on April 7, 2017. The device is almost exactly what we've been expecting from all of the rumors and leaks building up to its release. The modular design we saw in the G5 is gone, taking the removable battery with it. However, we do gain waterproofing, an improved dual-camera setup, a larger screen with smaller bezels, and Google Assistant.

How To: Use SimpleXML to load XML into PHP

Learn to utilize SimpleXML in this PHP tutorial to load and access XML from within PHP. This video shows how to load an XML file into a PHP array variable and get values from within that array. This informative video from JREAMdesign shows you step by step.

How To: Undo an edit when mixing in Avid Pro Tools 9

Want to quickly undo an edit in Pro Tools 9? This free video software tutorial from Lynda presents a complete and thorough overview of the process. Whether you're new to Pro Tools or just new to Pro Tools 9, Avid's first native, software-only version of their popular Pro Tools DAW, you're sure to find much of value in this brief view.

How To: Use the menus in Avid Pro Tools 9

Learn to navigate and use the menu system in Pro Tools 9! This free video software tutorial from Lynda presents a complete and thorough overview. Whether you're new to Pro Tools or just new to Pro Tools 9, Avid's first native, software-only version of their popular Pro Tools DAW, you're sure to find much of value in this brief view.

How To: Compute a square root using the geometric method

With mathematics, as with anything else, not everyone progresses at the same rate. Happily, in the age of Internet video tutorials, this isn't a problem. Those who progress quickly can go beyond what's being taught them and those who are struggling likewise have all the time in the world to catch up. With this free video math lesson, you'll learn how to calculate the value of a square using using geometry.

How To: Value assets with discounted cash flow analysis in Microsoft 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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the PV and PMT functions together to do asset valuation using discounted cash flow analysis.

How To: Solve for total number of periods when you know PV & FV in Microsoft 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 23rd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to solve for the total number of periods when the present and future values are known to you.

How To: Make use of the 3D environment in Apple Motion 3

This clip covers the basics of creating and working with 3D models within Apple Motion 3, discussing a number of useful keyboard shortcuts. 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: Use HSV color correction in Blender

This tutorial shows how to adjust the Hue, Saturation and Value of an image to improve a photo and make it look like it was shot at a different time of the day. Whether you're new to the Blender Foundation's popular 3D modeling program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free video tutorial. For more information, including detailed instructions, take a look!

How To: Make a waving flag animation in Apple Motion 4

Learn how to make a rippling flag animation in Apple Motion 4. Whether you're new to the Apple's popular motion graphics editor/compositing application or simply wish to get a little bit better acquainted with Motion 4, you're sure to find value in this tutorial. For more information, including step-by-step instructions, take a look.

How To: Create an icy text animation within Apple Motion 4

Looking to achieve an icy text animation within Apple Motion 4? This clip will show you how it's done. 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 creating icy title text yourself, take a look.

How To: Create orbiting 3D text in Apple's Motion 4

Ever wonder how to make your text spin in 3D around an object? This clip will show you how it's done. 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 creating Universal-style animated 3D text, take a look.

How To: Design a small water feature in your yard

Installing a water feature in your yard is a great way to boost the value of your home. It's also a great way to create a nice and relaxing environment for you and others to enjoy. So in this tutorial, if you're looking for half of the work needed to create a large water feature, you'll be finding out how to make a small one. So check it out, good luck, and enjoy!

How To: Create user-interactive Flash scenes with Swift 3D v6

See how to use Swift 3D and Papervision to create user-interactive 3D scenes in Flash. Whether you're new to Electric Rain's popular Flash-oriented 3D modeler or just looking to better acquaint yourself with the program, you're sure to find much of value from this free video software tutorial. For more information, including a complete walkthrough of the process, watch this web developer's guide.

How To: Create custom animated logos in Swift 3D v6

Learn how to create and render custom animated 3D logos within Swift 3D v6. Whether you're new to Electric Rain's popular Flash-oriented 3D modeler or just looking to better acquaint yourself with the program, you're sure to find much of value from this free video software tutorial. For more information, including a complete walkthrough of the process, watch this web developer's guide.

How To: Apply custom bumpmap textures to models in Swift 3D v6

Learn to apply custom bumpmap textures and materials to 3D models in your swift 3D scenes. Whether you're new to Electric Rain's popular Flash-oriented 3D modeler or just looking to better acquaint yourself with the program, you're sure to find much of value from this free video software tutorial. For more information, including a complete walkthrough of the process, watch this web developer's guide.

How To: Create a circular text effect in Apple's Motion 3

Tired of text that walks the line? See how to create a circular text effect when working in Motion 3. Whether you're new to the Apple's popular motion graphics editor/compositing application or simply wish to get better acquainted with the program, you're sure to find value in this tutorial. For more information, including step-by-step instructions, take a look.

How To: Do wire and rig removal in Apple Motion 3

Need to get rid of a rig for a scene you're compositing? With Apple's Motion 3, it's easy. See how it's done with this free video tutorial. Whether you're new to the Apple's popular motion graphics editor/compositing application or simply wish to get better acquainted with the program, you're sure to find value in this tutorial. For more information, including step-by-step instructions, take a look.