A promising new antibiotic has been discovered in, of all things, another bacteria. Burkholderia bacteria live in diverse habitats, including soil, plants, and humans where they thrive by knocking out other microbes that compete with them for resources or threaten their existence. Scientists have discovered they accomplish this by producing a very effective antibiotic.
Bioluminescence — the ability of an organism to produce and emit light — is nature's light show. Plants, insects, fish, and bacteria do it, and scientists understand how. Until now, though, we didn't know how fungi glow.
BioShock: Infinite just came out today, and some people will no doubt play the game all of the way through with the object of beating the game. Others, though, will not only want to beat the game, but will want to earn every single achievement (or trophy) possible—and the A Real Pistol achievement is one of the very first (and easiest) ones you can get. In order to complete this task, you will need to kill 25 enemies with the Broadsider Pistol. You can pick up a Broadsider Pistol in the first...
Traveling often is super fun, but sitting through 13 hours on the flight from California to Bangkok is killer on your skin, especially since the airplane recycles air and therefore dries out your skin.
You only get one picture day per year while you're in school. It only takes a minute or so, but the results of that one shot stay with you for life in the form of your yearbook. So instead of being the one girl who got too lazy to put on makeup and then sneezed in your photo shoot, turn up your game a little this year and be the perfect model for your picture. Makeup done for photograph purposes requires a bit of extra effort.
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...
Have you ever been in a situation when you needed to remember something real important, but you didn't have you didn't have your trusty cell phone or other electronic savior with you?
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 658th installment in their series of digital spreadsheet magic tricks, you'll learn see how to use the COUNT & COUNTA functions correctly. COUNT counts numbers. COUNTA counts non-empty cells.
We all have our reasons for erasing personal data from a phone. Whether you just ended a bad relationship whose face you never want to see again (lots of text messages) or just want to restore your privacy on the cell phone, erasing may be your only option.
There's no need to lug a big, heavy camera around all day when you have a perfectly good one already sitting in your pocket. In this tutorial, learn how to set up your iPhone so that you can capture high quality landscape shots. If you find yourself staring at a beautiful sunset with no camera in sight, just reach for your phone and follow these easy tips to get a great snap. No one will even be able to tell you used a cell phone if you do it right, so give it a try tonight!
In this clip, learn all about the brand new cameras on your iPhone 4. The latest iPhone from Apple has made major improvements on the cameras from the older models. Not only do you now have a flash, but you also have TWO fully functioning cameras with great picture resolution for a cell phone. In addition to that, the iPhone 4's new camera has face recognition software, a zoom lens AND an autofocus. There are so many fun things you can do with these cameras from photography to video to two-wa...
Oh, we feel you, guys. You're at the bar and you spot across the room a woman who, in all her godlike perfection, is too perfect to be true. Your heart rate pulses, your pupils and, er, other things dilate, and you get the urge to go up to her and try to start something.
In this clip, learn how to make the right phone calls and press the right buttons to "trick" your phone company into giving you a free phone upgrade before you are due. You will also learn how to save money on you phone bill by using a few choice words on the telephone. This trick works for Sprint, Verizon, T-Mobile and AT&T, so not matter who your carrier is you will be golden. This clip is hosted by an ex-employee from a cell phone company, so it is full of insider tips.
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 631st installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a transactional record when the date is 90 days past due using the TODAY function and mixed cell references in a logical TRUE-FALSE formula.
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 633rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create conditional formatting that will highlight the dates within a given year using the Year Function and Mixed Cell References in a logical TRUE-FALSE formula.
In this clip, learn how to tether your rooted Droid to a WiFi network and use it as a modem for your other Wireless devices. This process is pretty easy and only requires a network and that your phone be rooted.
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 621st installment in their series of digital spreadsheet magic tricks, you'll learn how to write a logical formula using the AND and COUNTIFS functions with mixed cell references in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is unique and matches the s...
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 11th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create a formula that will randomly select a name from a list of names without having the list of names sitting in cells.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 7th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with VLOOKUP function formulas in MS Excel. Specifically, you'll see the following:
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 7th installment in his series of Excel array formula series, you'll learn how to create array formulas for summing and counting when there are multiple conditions. See how to use Boolean logic and array formulas to calculate when there are multiple conditions.
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 583rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGEIF & IFERROR functions with absolute and mixed cell references to create a large table of conditional average calculations (averaging with criteria).
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 582nd installment in their series of digital spreadsheet magic tricks, you'll learn how to understand and fix the nine most common formula errors in Microsoft Excel. Specifically, you'll learn how to interpret and resolve #######, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Cell Reference, and #NULL! errors.
In this tutorial Brandon from Pocketnow.com will show you how to set up and use your remote desktop on a Windows mobile smart phone. Windows mobile remote desktop allows you to remotely access and control your Windows computer from your cellphone device, it is just like controlling your computer but in the palm of your hands. This guide will also show you how to get the Remote desktop software on your cell phone device if you don't already have it. The remote desktop requires for you to have ...
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 580th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE, MID, COLUMNS and SEARCH functions to extract numbers to the right of a decimal into their individual cells.
How to prune small trees
New to 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 Excel tutorial from ExcelIsFun, the 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...
Curtis Smith of Yard and Garden teachers viewers how to protect outdoor plants and shrubs in the winter. For instance, Lilacs and be burned by the cold weather so it is advised to not place lilac to the South or the West against a wall in the winter. Next, with a privett plant there may be damage on the leaves but others are perfect - but this is normal. This plant is an evergreen and some cells in the leaf may die which will make the leaves look damaged. This will be shown on last years leav...
This video shows how to make a quick pivot table data filtering by using Excel 2010's ‘Slicer’ functionality. ‘Slicer’ delivers enhanced visual filtering method to allow you to get the data you need more quickly. When selecting a cell in the pivot table you will find ‘Slicer’ in the filter group of the ‘Insert’ tab. Click on ‘Slicer’ and an 'Insert Slicer' dialogue shows up where you can pick particular data fields from the slider list. Once you click on ‘OK’, the ‘Slicer’ objects with filter...
In the GetConnected TV show BlackBerry expert Darci Larocque from Swirl Solutions gives an easy tip on how to call voicemail directly with one (1) key. This option can be seen in other cell phones also, but in a BlackBerry you can set a password for this. Hold the green button or call log , go to menu - Voice Mail, set your password, click escape and save. Now when you dial No.1 or hold it down you go directly to your voicemail.
This video is a quick overview of the construction of a Blubberbot, an artificial "life form" that uses electronic sensors to seek out lights, sound, or cell phone signals.
Have you ever locked your keys inside of your car before? I net you have, you've felt the frustration, you've felt the pain, but don't pull out that cell phone just yet... you don't need a locksmith.
If you've just been introduced to the suicide zombie in Dead Island, you're now able to unlock the 'Steam Punk' achievement which requires you to create a weapon with the shock or torch mod. The shock mod is available during the Black Hawn Down quest in the game.
Bastion is an indie game developed for the PC and XBLA. There are several different challenges in it, and one of the most difficult to beat is the Brusher's Pike challenge located at Camp Dauncy. You will need to activate all of the switches in the area without dying to the spike lines. This walkthrough should provide you with a pretty clear path to follow.
If you're on the first mission of Deus Ex: Human Revolution, you can unlock the 'Ghost' achievement by entering the building from a special direction. Take a look at this guide to find out where you need to head in the manufacturing plant to get this achievement on the Xbox 360.
Having incredible superpowers is cool, but having all the PS3 trophies from Infamous 2 is epic. Be epic. Watch this Infamous 2 trophy guide video and learn how to score the Knockout in the Blackout trophy from Infamous 2 for PS3.
This is your Infamous 2 video guide to the Dazed and Defused trophy from the Gauntlet mission. If you are trying to fill your PS3 trophy collection with all of the trophies in Infamous 2, this video it for you.
Tired of the game turning off your Underground Jungle lava trap? Watch this video and learn how to exploit the game so that it turns back time, allowing you to earn more gold and platinum. Put this Terraria hack to use.
Don't throw a hundred bucks at an expensive router! Watch this video and learn how to connect to Xbox Live through your laptop. Once you've got Xbox Live online you can earn achievements in all of your favorite Xbox 360 games, watch Netflix, and more.
This video will show you a clever strategy for creating a mob trap in the lava level of Terraria. By luring mobs into the lava you'll earn lots and lots of gold in very little time. This is so easy, you can watch a movie while you rack up the gold and silver.
To pay homage to the 30 year anniversary of Pac-Man, Google turned their home page into a fully playable version of the game. This video shows you a fun way to hack the game to earn a higher score when you play.
