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.
In these great, in depth videos, you'll learn how to process and finalize your RAW files in Nikon's picture capture program: Capture NX2. Over 40 minutes worth of material ranging from how to set up the process all the way down to the actually finalization. Definitely worth a watch for any camera nut!
Quinn shows the entire 19th Century wet plate Collodion process step by step, including a brief history of the process. He talks about taking wet plate "on the road" (mobile photography). Learn how to take pictures using the Collodian method by watching this video photography tutorial.
If you use Photoshop for work or regularly for fun, there are repetitive tasks that have probably made you want to throw your fancy monitor out the window to vent your boredom. Fortunately, there's help. This video will teach you how to create actions for batch processing in Photoshop CS4, allowing you to automate processes that you repeat regularly and saving you time and the money you would have spent on a new monitor.
Check out this video to learn how to make a professional epoxy fiberglass layup and epoxy laminating systems. This process is ideal for working on larger projects, a typical 'fiberglass layup' is a popular process for those who need a large, strong, and lightweight tool.This process can be used in automotive, mechanical, fine art and film special effects uses.
In the digital age, old fashioned film processing and developing may seem outmoded and obsolete. However, for professional and aspiring professional photographer who want o make classic-looking prints, this is far from the case. This three-part video describes how to do tray processing yourself for large-format sheets. It breaks down the equipment you will need, the advantages and disadvantages, and of course how to go about processing you own film sheets. The dark room is back!
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.
This image editing software tutorial shows you how to use Dr. Brown's 1-2-3 Process script for Photoshop CS3. Learn how to batch process large sets of images the easy way. Dr. Brown's 1-2-3 Process script works with Photoshop CS3 and CS3 Extended and is best suited for working in the Bridge.
In this video tutorial by photoshopuniverse, from Free Photoshop Video Tutorials, shows you how to automate the process of resizing images using Photoshop, primarily for sending over the internet. The guide takes you through the step by step process of creating a new action to record the process of resizing an image. Using this recorded action, you will learn how to go about applying that action to an entire folder, which will resize all the images contained in that folder.
Check out this video to learn how to use the paste laminating system and three part mold-making techniques. This is an advanced process that is not for beginners. This process is for working on medium to large projects, this is a labor-saving process for those who need a large, strong tool in the least amount of time possible. This video also demonstrates three-part mold construction. This process can be used in automotive, mechanical, fine art and film special effects uses.
This is an excellent video that covers creating a clear silicone rubber mold to deal with a complex parting line or irregular shape. When a project requires a complex parting line, it is often easier to pour the entire mold in one process with clear rubber, then cut your parting line. This process also saves at least a day in creating the mold. This process can be used in automotive, mechanical, fine art and film special effects uses.
We all learn a simple description of photosynthesis in grade school but there are a lot more complicated process going on. Plants can utilize carbon at night and this description will explain a very advanced understanding of how CAM works.
Wish there were a way to speed up process time when highlighting hair? It's easy! And this clip will show you how it's done. So easy, in fact, that this home beauty video tutorial can presenta complete and thorough overview of the process in about a minute's time. For more information, including detailed, step-by-step instructions, watch this handy hairstyling how-to.
Chaya Ryvka from Raw living foods teaches to make raw chocolate-pecan crust. You will need: pecans, raw cocoa nuts and powder, dates, vanilla, salt and food processor. First put the pecans into the food processor. Later add the raw cocoa nuts (make sure its raw ) and raw cocoa powder. At last add some fresh organic dates and a pinch of salt in the food processor. Now process all the ingredients until the crust starts to rise and repeat the process until all the nuts are broken down. Now add t...
Custom optioned installation includes the following: Copy the files to an external hard disk before starting your installation, then you will reinstall your programs by hand by using the windows easy transfer and transfer the data into the hard disk.
Fireworks has a great batch processing mechanism for images. In this tutorial, Mike Lively converts a PowerPoint presentation to jpegs and batch processes them down to a smaller size within Fireworks.
Using morphs to pre-process UVs is a great trick for any version of modo. You can leverage the embedded morph data to massage a model in 3D prior to UV projection. If that doesn't make sense, watch the video and learn how to pre-process UVs using morphs in modo.
Pre-production is a much less complex process for an indie film than a big-budget one that needs stars and permits and such, but it's still vital to shooting a good film in a timely fashion. This video will walk you through Ryan from Film Riot's entire pre-production process, including script breakdowns, free casting calls, budgeting, getting a crew and locations.
Whether you want to create a custom icon for an iPhone app or simply ape the glossy style, with Adobe Photoshop, the process is a snap. And this free graphic design tutorial will walk you through the entire process. For more information, including step-by-step instructions, watch this handy designer's how-to.
Want to run Apple's popular word-processing application, Pages, on an iPad? It's easy. That didn't stop Apple from producing this clean video overview, however. Get started creating, editing and sharing your own newsletters, reports, flyers & other documents with this how-to.
Watch this fine art video tutorial to learn how to illustrate with markers and colored pencils. "This video shows my process for making an illustration (non tradigital). I use illustration markers (usually prismacolor) and color pencils (usually prisma once again) and a wax blending stick. I make my illustrations in two steps:
Here’s a video on how to process your panos in Lightroom. Learn how to take those raw files and process them with a panorama in mind (it’s really a lot like processing a regular photo with just a small change at the end). We’ll process them in Lightroom and then take it through the Photomerge feature in Photoshop to finish things off.
Check out this video for creating a one piece mold using a repro laminating system. This is a professional video not for beginners. The repro laminating system is ideal for working on medium-sized projects, this process is easier, faster, and more economical than the epoxy laminating system. This process can be used in automotive, mechanical, fine art and film special effects uses.
Check out this video for how to create simple one piece silicone rubber molds. This technique is ideal for smaller projects (less than 12" x 12"), this is the easiest process for creating parts, patterns, tools, & molds. We demonstrate creating a silicone rubber mold and then the casting of parts with Repro, epoxy casting resins and polyurethane elastomers. This process can be used in automotive, mechanical, fine art and film special effects uses.
Welcome back, my novice hackers!
Cross processing is an old photography technique where the actual film is developed using the 'wrong' chemicals. It can add a unique color variation, like giving your subject green-tinted skin. It's possible to replicate this cross processing technique using Adobe Photoshop, and this tutorial demonstrates how.
Yanik Chauvin demonstrates how to create a batch using Photoshop and them Lightroom so you can decide which is faster and more convenient for you. In Photoshop, he first changes the color in the image, which he explains step by step the process, then saves the image as an action. He then shows you the process to batch the images so they will appear on your desktop. He also does the same thing with the image in Lightroom and shows you the process in which you would change the color and sync th...
Don from Lighting-Essentials.com explains the steps of cross processing in Photoshop. Using this he shows you that you can take great photographs of models without a lot of equipment. He starts by touching up his photograph before-hand; then he goes on to using an action called Cross Process. Cross Process is an action available from a link on his website. Acidify is the exact action he uses to make a unique effect on photographs.
This video goes through the basic step by step process of preparing Betty Crocker instant potatoes. It shows all the ingredients you will need as well as all of the utensils. This video also provide additional information on alternative methods of heating, such as using a microwave. This is a very informational, step by step video of the preparation process of these potatoes, and would be very helpful for someone wanting to better understand the process of preparing this dish.
This informational video from YouTube user curlmarx takes us through the step by step process of how to take on the intimidating process of soldering, or "sweating" copper pipes for the do it yourselfer at home. He illustrates the materials and tools you will need to successfully complete this type of plumbing project. Those of you who have never taken on a task like this will much appreciate the effort of this author to illustrate the complete process in a detailed and easy to follow informa...
