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...
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...
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.
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.
No one expects you to have a gym full of dummbells and exercise machines at your fingertips, nor does anyone expect you to drop hundreds of dollars monthly to tone your fabulous body at the gym.
Looking for a cool trick to impress your friends? Check out this tutorial from Stephen Ablett. In it, he will show you how to stick a pen through a dollar bill and take it out again, leaving the bill totally intact!
Are you sick of spending a ton of money on not so great cleaning supplies? Well, if cleaning the screens around your home are the problem, check out this tutorial. In this video you will learn how to make a super effective cleaning solution for your TV, PC, laptop, iPod screens, etc for about a dollar! This couldn't be easier to do, and your screens will be clear and shiny in no time.
You can find a humane squirrel and rodent trap at most all-purpose stores, this video recommends Home Depot and will cost about thirty-five dollars. To bait it you will need some peanut butter and crackers. Take out four crackers and break them in half. Spread some peanut butter on one side of each piece. In the middle of the trap there is a trigger that is raised when active. Place two pieces of the cracker behind the trigger deep in the cage. Next place two pieces upside down on the trigger...
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.
Need to spruce up (or wreath up) your trailer for the holidays? For this Christmas in your trailer park, let Jolene Sugarbaker show you how to make a classic trailer park Christmas craft... the wreath. This video will show you how to turn ordinary dryer sheets into a festive holiday wreath.
Need to keep people out of your precious room? Tired of all of those "do not disturb" signs not working? Locks just aren't cutting it these days? Safeguard your privacy with your very own electric fence. Remember Jurassic Park, when the kid got zapped by the electric fence? Think that, but in the doorway of your room.
Have you ever been the victim of theft? It sucks. Why would these lazy scumbags rather steal from us than work hard like everybody else?
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...
Wow! It's a dress! It's a trash bag! It's a trash bag dress! This dress is similar to the one Ke$ha wore this year to the MVA show, turning the fashion world on its head and showing everyone that you don't have to spend a million dollars to turn heads. In fact, you can create something cool for less than $2 in you check out this video. You probably already have all the supplies needed. For this project you'll need a trash bag, some scissors, some tape and a stapler. For your own flair, grab s...
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...
Forex— what is it? Any investor could tell you a complicated description of what Forex is, but the basics of the FX currency markets is— an over-the-counter financial market for trading currencies. The foreign currency exchange market has no central exchanges like the stock market and little regulatory oversight. With this beginner’s guide, learn the trading basics.
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!
The price of TLC plates can add up. See how to make thin-layer chromatography plates (TLC plates) for a few cents each that are as good as commercial TLC plates that sell for a dollar or two each. You can use these home-made TLC plates the same way you'd use chromatography paper, but the plates provide sharper separations and require far less analyte. They also lie flat, and are much easier to store for later reference. For more information, including step-by-step instructions, and to get sta...
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:
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.
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...
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...
This video illustrates the quick and easy method to Buy fresh ginger and brew a pot of ginger tea . The process is comprised of the following steps:Step 1: Visit a local store or a vegetable shop and buy some ginger. Identifying whether the ginger is fresh or not is a easy job. Just smell it and judge if the odor is strong. A strong odor indicates that the ginger is fresh.Step 2: Mesh the ginger pieces and peel off it's skin.Step 3: Take small pieces of ginger and add them to boiling tea.Step...
These days, everyone is looking to save a few dollars. In this 2 part tutorial, learn how to cut a man's hair, and save those extra bucks you would've spent at the barber shop. The process is quite easy, and its always fun to learn a new skill. So, grab your son, brother, nephew, boyfriend- anyone- and start snipping!
This video will show viewers various tips on how to shape your eyebrows depending on the type of eyebrows which you would like. Using a kit called "Million Dollar Eyebrows", which contains an instructional CD which will show you how to perform this technique, the host of this video shows how she uses the kit in order to shape her perfect eyebrows. Using a tool provided in the kit, she shows how to determine the length, height, and width of your eyebrows so that you will have the perfectly sha...
Food editor Ian Knauer shows you how to maximize the juicing potential of your citrus fruits. Follow along and learn how.
This video explains to the viewer the advantages of replacing washing machine hoses. As well as, rather more importantly, explaining how to complete the process. According to the creator the rubber hoses that are standard to most washing machines are subjected to high pressure water for many years. As they are only made of rubber they are apt to break and start leaking. This can cause many thousands of dollars worth of water damage. The creator recommends replacing the rubber pipes with reinf...
Defeat the Templars in Mission 8 on the Sony PSP and stop the attacks on the safe house. Altair doesn't really catch a break, although the Safe House assault squad comprises only six Templars. Slay them all. For more info, watch the whole gameplay.
Check out this bar trick of super sonic hearing. It is the trick that fooled Einstein by Brian Brushwood and Revision3's Scam School. Watch Brian scam Olympic gold medalist Jonny Moseley with a few coins, and some algebra!
Are you still watching television with an analog signal? If so, your TV may no longer work after February 17th, 2009. There is one easy fix to this problem though. There are many different kinds of convertor boxes out there, and the government is offering forty dollar coupons that you could use to get these digital-to-analog (DTV) converter boxes.
Learn how to do triceps single-arm kickbacks. Presented by Real Jock Gay Fitness Health & Life. Benefits
Hello! My name is Nicole Valentine and on behalf of Expert Village, I'm here to talk to you about how to coordinate birthday games for a birthday party. Now we're going to talk about how to appropriately shop for games for a birthday party. Let's be honest. The average person waits until the last minute to buy things for the birthday party. Before you get your keys and get in your car to leave to go to the nearest store, look around your house. Look for things that you normally use to enterta...
If there's one thing I know, it's that people hate buying mobile games. I'm the same way — no matter how good a game looks, if I have to pay for it, I have to fight the urge to immediately walk away. That's why it's such a big deal when a great game goes on sale. Right now, that game is 'Reigns.'
One of the world's largest music festivals in kicking off this weekend in southern California, the Coachella Valley Music and Arts Festival. With a diverse lineup ranging from AFI to Empire of the Sun to HAIM to Muse, the music world is on display this weekend and the next.
If I could think of one thing the world was missing, it would surely be more tablets. While people struggle between shelling out 200 to 500 dollars for a new iPad, Nexus 7, Kindle Fire, Microsoft Surface, or one of the hundred other tablets on the market, the folks over at DreamWorks have decided to make their own, aptly named the Dreamtab. The Dreamtab will have an 8-inch screen and favor applications with the use of a stylus, for coloring and the like. Total cost is rumored to be under 300 ...
Do you have two dollars and a water bottle? Then you can put together this simple but awesome solar-powered lantern that will provide more than enough light to read by at night.
If you say Ke$ha at the MVAs you saw her new look: a dress made from a trash bag! Well, if you're looking to create something cool for less than $2, check out this video and see how to make Ke$sha's inspired garbage bag dress. You don't have to spend a million dollars to turn heads, in fact, you likey have all the materials you need right under your kitchen sink! For this project you'll need a trash bag, some scissors, some tape and a stapler. For your own flair, grab sparkles, streamers or w...
Acne sucks, and if you have it then you've probably spent hundreds of dollars on salicylic acid face washes, benzoyl peroxide moisturizers, and stinging alcohol toners. But to what end? Most of the products you buy at the drugstore dry out your skin too much, especially when used in conjunction with one another. This leads to oil overcompensation and even more acne.
Need some wrapping paper? Want to go beyond the basic and bland Christmas wrapping paper in stores? There's one solution that's in everyone's pockets— money— cold hard cash— paper bills— money. We're talking George Washington (because Franklin might be a little extreme).
Depending on how well your T-shirt design is, you may never get caught cheating on your exams! The more words you throw on your shirt, the less likely any one would notice they're not just any ol' words! Learn the clever way to cheat on your test with a custom-made tee!