Non Segregated Storage Search Results

How To: Use AGGREGATE instead of SUBTOTAL in MS Excel 2010

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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...

How To: Pull the refrigerator handle switch prank

Pranks are the world's favorite pastime. Everyone loves a good prank, and there's nothing better than keeping someones stomach empty. Imagine the pain and suffering one would endure if he or she could not eat because the fridge will not open. Most refrigerators allow for reversing the door swing. Normally you also switch the handle. But not if you want to thoroughly confuse the victim of this practical joke.

How To: Play "Lua" by Bright Eyes on the ukulele

Want to play Bright Eyes' "Lua" on the ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing this indie folk song on your own ...

How To: Add color to the garden with perennials

Southwest Yard and Garden featuring John White, Dona Ana County Extension Agent, hosts a 6 minute clip with co-host Master Gardener Valois Pearce both of Dona Ana County, New Mexico host a short web show featuring plants that can easily survive on smaller amounts of water over typical plants. They begin by discussing the full sun Ice Plant, which comes in many species and colors as well as their hardiness, but unfortunately are easy targets for wildlife. They then move onto the Gopher Plant, ...

How To: Choose fruit trees

Doña Ana County Extension Agent John White and Master Gardener Benny Knudsen look at stone fruit trees on their tour of the "Garden of Weeden". The Mariposa Plum, the dwarf Stella Sweet Cherry, Elberta Peach, Tilton Apricot and the almond tree (which also belongs to the stone fruit family) are featured in this segment of Southwest Yard and Garden series. The suitability of these trees for a small garden is mentioned. Besides this, also discussed is the problem of late frost and its effect on ...

How To: Make sweet onion & dolcelatte cheese tarts

In this video chef Jo Pratt demonstrates how to make sweet onion and dolce latté cheese tarts with pear and walnut salad. This is taken from her recent recipe book. The ingredients needed for this is one sheet of regular puff pastry, some caramelized onions, some thyme leaves,250gm dolce latté cheese, two small pears cut into small pieces, two celery sticks finely sliced, some walnuts torn into halves, two tbsp walnut oil and two tbsp balsamic vinegar. To make the dish she firstly unrolls the...

How To: Dive into new features of Photoshop CS4

Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to dive into new features of Photoshop CS4.

News: Mentally Disturbed Woman Claims Implant Bomb as TSA Orders New Grope Directive

Just in the nick of time. The TSA has come under a lot of scrutiny lately as outrage grows around the country over goons in gloves touching the junk of everybody from toddlers to grandmas. Then there was a suspicious if not improbable al-Qaeda underwear bomber threat to get things back on track. Now we have a French woman with a “surgically implanted device” on transatlantic flight.

News: Making Sound Sculptures with a Speaker and Cornstarch

Posted below is an interesting video on the effects of low frequency square waveforms on cornstarch. To make, simply mix cornstarch and water, then place on a large speaker hooked up to an amplifier and a signal generator (generating around 20-30 hertz). An old stereo works great, as long as it has an aux-in. There is lots of free signal generating software at arms length, like this one. I found adding a little olive oil into the cornstarch mix makes it easier to handle, and contributes to th...

A Kit-of-No-Parts: "Crafting" Electronics at MIT

I recently came across this amazing MIT media lab site, Kit-of-No-Parts. Though not directly related to the content Cory has been posting, it is an interesting "craft" approach to technology/science. The site was created as documentation of a student's thesis work in the High-Low Tech research group at the MIT Media Lab:

How To: How Cross-Site Scripting (XSS) Attacks Sneak into Unprotected Websites (Plus: How to Block Them)

XSS stands for cross-site scripting, which is a form of web-based exploitation that uses client-side vulnerabilities in a web page to execute malicious JavaScript codes. JavaScript is referred to as "cross-site" because it usually involves an external website containing the malicious code. That code is most commonly used to steal cookies with a website that the attacker created and hosted on another server. The cookies can then be used to escalate privileges and gain root access to someone's ...

News: Phthalate free plasticizers - New material development.

One of the things that has always bugged me while working with PVC is that it is, as it is presently produced, a poison. Well, OK, it's not, but it contains a lot of poisons. Phthalates are plasticizing agents that are super toxic, and these people are working to phase them out. PVC also, in its present form, contains lead. Certain chemists are learning how to use stabilized zinc and calcium instead. Also, chemists are learning how to synthesize the vinyl chloride monomer from HEMP! That mean...

How To: Your DIY Bug Repellent Guide to Common Household Pests

Contrary to popular belief, eliminating household pests from your home can be accomplished without completely bombing your living space with a mess of toxic fumes. Whether you have annoying fruit flies in the kitchen, fleas on your beloved pet or silverfish lurking around your bathroom, it is very likely that a DIY, non-toxic and super inexpensive solution exists for your household bug problem.

News: Introducing Indie Games Ichiban: "Better Games for Less Money"

Are you a gamer with a fondness for oldies, bargains & the non-mainstream? If so, tune in. WonderHowTo is excited to introduce another regular to join our cast of front page contributors: Nick Battjes, our resident indie video game expert. Nick, a graduate of video game design at the University of Southern California, is a passionate gamer & owner of 13 consoles (and counting).

News: The Secret World of Exotic Fish Zealots

WonderHowTo pal and contributor Sean Conaty shot this beautiful short for Scion Magazine about exotic fish and the people who love them. The fish veterinarian is particularly fascinating. Who knew that some lucky sea creatures experience greater longevity with the aid of surgery, x-rays and vaccinations?

News: Drop Through Floor

Subject enters a typical office where someone familiar is sitting behind a desk across from the door. Everything in the room is fixed to the floor or walls and the person behind the desk is secretly strapped into the desk chair. As the subject approaches the desk to sit down in a chair he will eventually come to the center of the room at this time the floor of the entire room will flap open (either 4 triangular flaps or one major flap) and subject will fall 20 feet onto a air bag below

News: iMovie on iPhone, coming in June

So as of now June 24th or whenever it is precisely that the new iPhone comes out, we'll likely be in a situation where two of the most popular, talked-about filmmaking tools will be non-traditional video cameras: the new 720p-shooting/cutting Apple Flip-smasher and the Canon 5d. I feel positively old fashioned, a dinosaur, an archaic wreck, stumbling about with my mammoth Canon XH-A1. I can't slip it into my pocket, I can't take the lens off and put a f/1.8 50mm on it and get kabonkers depth ...