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 and Mr. Excel, the 43rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to calculate weighted average cost ending inventory value from transactional records on 2 different sheets using the COUNTIF, SUMIF and SUMPRODUCT functions.
Do you wonder if what you are seeing on your trees or plants is a problem, or simply natural? John White and Lois Pierce discuss various issues with Manzanitas, Red Buds, Viburnums, Mexican Buckeyes, and Cacti.
A wedding budget can quickly get out of hand as your planning progresses. Things like centerpieces are a major cause of skyrocketing wedding costs. If you have a little time and want to easily trim down the cost of your wedding, think about making your own floral centerpieces. You'll learn how to with this simple tutorial from EZ Bouquet. You'll soon see how easy it is to make a beautiful floral arrangement in an open container and how to secure the arrangement in the base of the container. A...
This video shows you exactly how to weather-strip a door to keep down heating costs. Step by step instructions on how to check your doors to see if they need weather-stripping and how to install the weather-stripping. This also teaches you how to check to make sure that your weather-stripping has been installed correctly on your door to keep out any drafts. All that you need is some weather-stripping, a tape measure, a utility knife, a power drill, and some screws. This video teaches you how ...
Three point lighting is the standard used to illuminate a subject for amateur film, video, and even theater application.
The iPhone is an indispensable part of it's owners lives, and very fragile. If yours has broken and you don't want to shell out the cost of the phone again to have it fixed, watch this video for an easy guide to repairing a broken screen and digitizer (touchpad) using parts you can order for cheap on eBay.
Your home's siding will only last so long, so when it's time to replace it, what will you do? Well, calling a professional will cost you thousands, but this home video from Buildipedia will walk you through the steps to replace your home's siding yourself.
You can certainly use Skype to make free Internet phone calls through your iPod Touch, though the microphone/headphone combo headset sold by Apple is thirty dollars. Make one for a fraction of that cost using a headphone splitter and the mod process outlined in this video.
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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to allocate $950 across 7 days including the extra penny with a single formula.
Real rockets require top ingenuity from physics and engineering experts, but you can construct a smaller replica that costs almost nothing can can be made from materials you already have at home or can find at a hardware store.
You already drop mad stacks for your MAC eyeshadows and Lancome blushes - why not save money and go eco-friendly with reusable, recycled makeup organizers?
Lightweight rod support bracket from Long Valley Equipment mounts directly to front of the camera, saving weight and cost of other methods. Holds 15mm rods at 60mm spacing to support matte box, follow focus, remote focus, zoom motor.
Living well doesn't have to cost an arm and a leg. And living cheap doesn't have to look like you're living cheap.
Kevin Rose is joined by John Todd, a well known, leading Asterisk expert, to introduce you to the amazing VoIP (Voice over IP) world of Asterisk, the open source voip telephony toolkit. In this episode, Kevin and John take you through the installation and configuration of this powerful tool, and show how it can be used to give anyone complete control over their phone experiences, such as voice over wifi, eliminating phone costs, choosing from hundreds of VoIP providers, creating your own voic...
Using infrared (IR) light pens and the Wii Remote, it is possible to create very low-cost multi-point interactive whiteboards and multi-point tablet displays. Johnny Chung Lee, Carnegie Mellon University. The software can be downloaded at http://johnnylee.net
This video shows how to make an origami swan using 471 paper triangles. Your loved one will appreciate this gift because you put in a tremendous amount of effort, dedication and patience required for origami, but its easy to assemble and the only money you will spend is cost of 15 paper sheets. Good luck!
Unfortunately, the very places we go to receive health care put us at risk for becoming infected with superbugs, bacteria exposed to so many antibiotics that they have become immune to their effects. Clostridium difficile (C. diff) is one such bacteria. It causes inflammation of the colon and rampant diarrhea that can have life-threatening consequences. Part of its virulence lies in the tough spores formed by the bacteria. They are responsible for starting infections in the colon and for spre...
Add breathing in your house as another possible danger to your health. If your home is sick, it's possible you could get sick too.
Look no further than Flint, Michigan, to discover the serious consequences of contaminated drinking water. Around the world, water polluted by pathogens and toxins sickens people or cuts them off from safe drinking water. Looking for a solution, researchers created tiny, swimming robots that pack a powerful punch against waterborne pathogens.
What can you do when you're suffering from a pounding headache and you're in too much pain to drive to the nearest drugstore? Fill a large plastic bowl with hot water, add one tablespoon of dry mustard powder, and soak your feet for twenty minutes.
If you've never had a reason to keep some Epsom salt in your home, I'm about to give you seven good ones, some that will surely surprise you.
"Your bathroom is a minefield of toxins." Sounds a wee bit dramatic, no? But the video isn't kidding around here. A lot of the shampoos, lotions, creams, and soaps you use have ingredients linked to birth defects, cancer, and learning handicaps. And just think about it - we're using these gnarly ingredients on our skin every single day.
Detoxification is the removal of toxic substances from the body carried out naturally by organs like the liver and kidneys. However, you can aid these systems by cutting down on the toxins you ingest, and eating healthier foods for a short period of time. Before you get started on a detox diet you need to prepare yourself in a number of ways so let this video show you how! Prepare yourself for a detox program.
In this video tutorial, viewers learn how to rent bikes in Europe. The cost to rent a bike is about $15 and the cost decreases per day the longer you rent it. Bikes can easily be rented in towns in small rental shops. Europe has many bike paths with signs for tourists to travel along without any traffic. To find these paths, users should get information from the tourist information centers or bike rental shops. This video will benefit those viewers who will be visiting Europe and would like t...
PeteMcCormack2 teaches viewers how they can live off the grid! First, you will need shelter, heat and water! And possibly some electricity. You need head so you can use a high efficiency wood stove. You always need to have water so you can use a well or a water pump. Also, for a pump you will need power, you can use solar power for this! You can also use a pressure tank. This way of life does not necessarily cost much and with self installation it will lower the cost also. All you have to do ...
CadNYC demonstrates how to open the Nike iPod sensor casing. Replacing the iPod Nike sensor battery is easy and low cost with a few simple steps. First, place the sensor in a vice clamp and saw off the casing using a very thin hacksaw blade. then, open up the sensor compartment to have access to the battery. You can now remove the battery and replace it with another battery which will cost about two dollars. After you replace the Nike iPod sensor battery, use a strong adhesive to glue the cov...
In this video the instructor shows how to solve mixture problems using two variables. Usually in these kind of questions the problem statement goes like, if A costs $x for a pound and B costs $y for a pound, in what ratio should they be mixed such that one pound of the new mixture sells for $z a pound. So, in these kind of problems start with a box where you list down all the given data in the form of a table as shown in the video. Now denote the unknown quantity of A and B by two variables a...
Feeling like you need to rid your body of a few toxins? A nice, hot cup of tea isn't just soothing; some varieties have health and diet benefits. See which brew might be right for you. Learn how to tea-tox with help from this video.
There's a reason why printer companies want you to recycle your old printer cartridges. Because they can be reused. It cuts costs and saves them money, but you can save money, too. You don't have to keep buying new cartridges, you can recycle your used ones yourself by simply adding more ink. It could save you a ton of money on printer costs.
Getting a fish? The first thing you'll need to learn in order to keep it alive, is how to prepare your aquarium and its water. Ensure a healthy, balanced environment in your aquarium by following this simple process.
Not sticking to your New Year's resolution of finally getting rid of that spare tire? Trade in those love handles for a slender waistline by following these tips starting today!
An inflamed throat is often the first sign that you're getting sick. Help nip it in the bud with a few simple tricks.
The most basic way to to cut back energy costs is to keep your house from losing heat in the winter or getting too hot in the summer. Curtains, awnings, ventilators, and weather stripping are all simple changes that can keep the heating costs down, while florescent bulbs can last longer and use less power than traditional light bulbs. Watch this video home improvement tutorial and learn how to save energy at home.
In this video tutorial, Wess does some research and builds a steady-cam for under fourteen bucks. Hooray for no more motion sickness!
Want to give your face a natural glow while reducing wrinkles, improving blood circulation, removing toxins and dead skin cells, and improving your mood? With a little face lotion and about five minutes of your time every day, you can give yourself a DIY facial massage that will work wonders for your face in the long run.
Snapchat just rolled out a feature that lets you create custom Filters and Lenses. While the average Geofilter won't run you more than a few bucks, it's not that hard to exponentially jack up the price. Amazingly enough, Snapchat's latest attempt to monetize their platform can ultimately cost you as much as $999.99. Ignore the penny, let's call that a cool grand.
Keeping things clean is very important to prevent food born illnesses. Washing fruit is important. You can take care of many problems by just running them under water. You can use white vinegar and hydrogen peroxide to clean fruit. Start by spraying some white vinegar on the fruit and then a little hydrogen peroxide. After you spray the fruit with white vinegar and hydrogen peroxide rinse it in water and that will wash all the vinegar and peroxide off of the fruit. The vinegar and peroxide wi...
It was a good weekend for OnePlus 5T rumors — it looks likely the 5T will be first appearing in New York, and we got a spec leak that supports the rumors we've already heard. However, perhaps the best 5T news came from OnePlus' CEO himself: The OnePlus 5T may cost $600 or less.
Growing evidence suggests that neurodegenerative diseases like Parkinson's may develop in part due to environmental factors, including infections that can cause inflammation in the nervous system. New research from investigators from Jude Children's Research Hospital and Thomas Jefferson University has strengthened that connection.