Million Dollar Homes Search Results

How To: Validate data with dynamic VLOOKUP functions in 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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...

How To: Hack a single-use digital camera for continual usage

In the digital age, camera's have gotten better, more advanced and more expensive. Even those throw-away cameras have taken the leap to digital-ness, which means more money. But you don't have to be confined by the one-time use of these single-use digital cameras anymore. Kipkay teaches you how to hack a one-time-use digital camera so that you can use it over and over again— for only twenty dollars. There is a connector behind a sticker, so you have to peel the sticker off and then you must f...

How To: Make watermarks in paper for security

Don't fret too much if your watermark is barely noticeable when you're finished with this project - the less obvious it is, the better a job you've done. Watermarkers are present in many types of paper, especially the monetary kind. If you hold up a ten dollar bill you'll see a watermark of Thomas Jefferson's face on the right, proving the bill is real.

How To: Make a car-mounted rocket launcher prop for a film

Do you want to make your own action movies? Do you feel like your artistic vision would be enhanced by having a car with a rocket launcher on top of it in the film? You aren't alone. This video will show you how to make a car-mounted rocket launcher for $20 dollars out of simple materials. It won't blow up another car, but it will look really cool.

How To: Do the "fast on the draw" banknote bar trick

In this challenge, you need to grab the dollar bill without making the top beer bottle fall down. By just grabbing and yanking on the banknote, the bottle will fall. You need to grab the top beer bottle and slapping the bill away. Another way is to use pure speed. Try this "fast on the draw" beer bottle / banknote bar trick out and win money… or more beers.

How To: Make a homemade snow globe

This is a really easy arts and craft project that's a great way for the whole family to get together. Because this craft project calls for the use of a glue gun, kids should only do this project along with their parents. You'll use items you already have around your house, and if you don't, you can probably buy them at the local dollar store or arts and crafts store. If you've been looking for a craft project to help bond with your kids, this may be it! http://www.myartsandcrafts.com/article2...

News: Layar AR Creators Want Their Company Back, Believing Blippar Is Ruining It

With augmented reality making its way into the mainstream, consumers have been expecting a company bloodbath for a while now, one that will have a ton of casualties. Blippar has been expected to be one of those casualties due to the reported loss of millions of dollars earlier this year. Now, their situation might be made worse as the creators of the Layar app, Raimo van der Klein and Martin Lens-Fitzgerald, are rumored to be asking for their company back.

DIY Elsa Costumes: Icy Halloween Looks for Frozen's Snow Queen

When I was young, I wanted nothing more but to be able to freeze things just like one of my favorite X-Men characters, Iceman. Now, Disney's most successful animated film to date, Frozen, brought another icy childhood favorite to the scene—The Snow Queen. And with Halloween right around the corner, all of the princesses out there can get their chance at being ice royalty. While Princess Anna and Olaf the Snowman were the biggest characters in Frozen, Elsa is one of the movie's most memorable ...

How To: Perform a Smiling Georgie magic trick with one dollar

Want to turn George Washington's frown upside down? Then tune in to this trick! You will need a crisp one dollar bill. Sometimes we use materials that require adult supervision... like scissors, so make sure you have friends and family around whenever you do magic tricks. 1. Preparation: Give the bill a crease right in the middle of George’s smile. George should be inside the fold.

How To: Paint spring-loaded clothespins into colorful, decorative wooden fasteners

Spring-loaded clothespins are used for more than just clothes. If you looked in anyone's home, you'll see these springy wooden clothespins used for things like chip clips, photo holders and even for attaching sports cards on bicycle spokes. They're even used in the film industry (called C47s or bullets) for clamping colored gels or diffusion to hot lights on set. So, there's a million uses for these wooden clamps, but that doesn't mean they have to look the same— drab and unoriginal.

How To: Inspect hail weather car damage

In this Autos, Motorcycles & Planes video tutorial you will learn how to inspect hail weather car damage. Paint loss dent repair is the most common method used for this purpose. The first thing to do is to count the number of dents based on half dollar, quarter, dime and nickel size. All you need to do is to place the coins over the dents and count how many dents are there of various sizes. Once you have this information, you are on your way to handle the hail loss assessment correctly. If th...

How To: Make a comfy DIY camping chair for less than 5 dollars

Not every camper is looking to totally "rough it" while they are in the woods. In this clip, learn how to make a comfy, folding camping seat out of cheap supplies for less than five bucks! This foam pad is far better than the ones you buy at those expensive camping stores and because you made it yourself, you know it will work. The best part? If you lose it or it gets ruined out there in the wilderness, it was so cheap and easy to make that you can just create another one!

How To: Build frequency tables & histogram charts in MS 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've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 31st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to build frequency tables and simple histogram charts in Microsoft Excel. Specifically, this video addresses the following subjects:

How To: Make homemade fish bait

In this video, learn how to make fish bait - the easy way! This bait works well for perch, bluegills and other smaller fish. The ingredients for this type of bait are cheap and you probably already have a lot of them in your pantry or refrigerator.

How To: Calculate variable commission totals in MS Exce

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 46th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the DOLLAR, VLOOKUP, INDEX and MATCH functions and a previous bracket commission formula trick to calculate total commissions when you have variable commissions paid out. Learn to love digital spreadsheets more perfectly with the tricks outlined in t...

How To: Compare the difference of annual percentage rate

This video is about Annual percentage Rate(APR) and the Effective APR rate.The video begins with an example of a credit card which has a APR rate of 22.9% and daily periodic rate of 0.06274%.You can get the APR rate by multiplying the daily peiodic rate with 365, which in this case will be 0.06274*365 which is equal to 22.9.If you convert the daily periodic rate into decimal values , it will be 0.006274.So for example, if you have 1 dollar in your balance on day 1, on day 2 you will owe 1.000...