Usually, we think of vaccines as preventative, a shot we get to prevent the flu or some childhood disease like measles or mumps. But there are vaccines for other purposes, such as the ones studied by researchers from the Netherlands.
If you're ever lost or hurt out in the middle of nowhere with a dead cell phone, you might be able to "flag" down help as long as you're near some railroad tracks.
Update: August 1, 2014 Earlier today, President Obama signed into law the Unlocking Consumer Choice and Wireless Competition Act, making the act of unlocking your unsubsidized cell phone 100% legal.
If you're into photography, you're probably no stranger to the myriad of ways you can take macros with your smartphone. Your phone's built-in camera may not take great pictures up close, but you can modify it to do so with anything from a magnifying glass to a drop of water. However, those types of DIY macro lenses can only get so close.
There are many functions in Microsoft Excel. One function that people rarely use is the Repeat function or REPT. In this video, an example used is a chart of people and their sales of a certain item. Just looking at the numbers, it is hard to compare the different sales easily, but a more visual approach may work better. Next to one of the cells, type in "=REPT(" which is the repeat function. A popup should say "=REPT(text, numbertimes)". For "text", type in *** or anything, really. For "numb...
Having a dropped call can be incredibly frustrating, especially when you look down and see that your iPhone has full reception. While there's any number of issues that can cause this, one common and often overlooked issue is your iPhone failing to switch cell towers as appropriately needed.
How can a drug used to treat cancer be effective against viruses, too? The answer lies in the drug's shared target — specifically, cellular components that control the activity of genes. A new research study showed that one such type of drug, histone methyltransferase inhibitors used in cancer clinical trials, has activity against herpes simplex virus, too.
As if the swollen, painful joints of rheumatoid arthritis weren't enough, the disease is the result of our immune system turning against cells of our own body. Ever since this realization, scientists have worked to find the trigger that sets the immune system off. Scientists believe that gut bacteria may have a role in initiating the abnormal immune response. Now, a team of researchers from Boston has figured out how that might occur.
Even though the Ebola virus was discovered as recently as 1976, over 30,000 people have been infected since, and half have died a horrible death. Since there's no way to cure the infection, the world desperately needs a way to prevent it — and the five similar viruses in its family, the ebolaviruses.
As drug-resistant bacteria become more commonplace, researchers are looking for new antibacterial strategies to disrupt disease-causing microbes. Some scientists are working to create new drugs, while others are trying out drug combinations. Another group, however, are ditching pharmaceuticals altogether and experimenting with non-drug alternatives.
This video is about finding duplicate entries in excel sheet. The example excel sheet contains different names. There are around 1000 different names in the sample excel sheet. CountIf(range,criteria) formula has been used to do the comparison and return of results in True or False mode. Type =CountIf( now move your left arrow key, this will generate the formula like =CountIf(A2. Now press Ctrl+Shift+Down arrow, this will select all the available values in the column. Now press F4 to lock it ...
ShowMeAcademy.com shows how to sort data in Excel 2007. Excel has many options for sorting data according to any given column. To sort your data, right click on a cell in the column that you want to sort by. A menu comes up where you will see the “Sort” option. Hold your mouse over “Sort” and another menu comes up showing the different ways to sort. For example, if you select “Sort Smallest to Largest” it will take all the data and sort it from the row that has the lowest figure u...
Today's Tech shows you how to fix a cell phone or computer that has gotten wet or jammed. With a wet cell phone, you must act quickly or it may be permanently damaged. The first thing you should do after pulling it out of the water is to take the battery and SIM card out. Dry both of them off. If you drop it in a liquid that is not water, rinse them off quickly. If you have a vacuum cleaner handy, you can use it to suck the water off. You can also place the phone on top of your cable box. Wai...
Creating a digital spreadsheet by hand can certainly be tedious, especially if you're copying a printed paper table word for word, number for number. Instead of typing information that's already there, however, use Microsoft Excel on Android or iOS to snap a photo of that printed chart and import it directly into your digital one.
As you already know, Hong Hong has been rocked in recent weeks by protests against their Beijing overlords. Promised free and fair elections, Beijing has reneged on this promise and is now telling Hong Kongians (that's what they're called, aren't they?) that they will only be able to vote on Beijing-selected candidates. All that is interesting from a political perspective, but from a technological perspective, the more intriguing story is how the protesters are communicating. Faced with their...
Leaving your Wi-Fi radio "on" allows your smartphone to auto-connect to trusted wireless networks in lieu of using cellular data, but it also consumes battery power while it's constantly network hunting.
Everyone loves using their cell phones for everything except actually making phone calls. Whether it's watching streaming video, listening to music or playing video games, it would seem that calling people is almost an afterthought to cell manufacturers in this day and age.
This tutorial shows you a very basic method to create an effective boffer sword using PVC pipe, a foam noodle, duct tape and some open-cell foam for a stabbing-safe tip. You're also shown a good method for constructing the hilt. This is a great tutorial for anyone looking to make a foam sword for their favorite boffer larp!
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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function with approximate criteria to add when criteria has other content in the cell.
Have you seen odd, square codes on some specific merchandise? These are called QR codes, or quick-response codes, and they are a type of bar code which your smartphone can read and then take you to a particular website, give you coupons or even a business card. Here's how you can get the most out of QR codes.
'Rooting' (also called jailbreaking) will let you install third party software or applications which the manufacturer may not allow (or get rid of apps that you don't want). It will void your phone's warranty, so make sure this is really what you want to do!
If you already own a copy of a song, it's silly to pay again for rights to use it as a cell phone. Especially in light of how easy it is to create custom, free ringtones with the latest iteration of Apple's digital music jukebox, iTunes 10. Take a look.
Need some help figuring out how to set up and configure your BlackBerry Torch 9800 cell phone? This clip will teach you everything you'll need to know. Whether you're the proud owner of a BlackBerry smartphone or are merely considering picking one up, you're sure to be well served by this official video guide from the folks at Blackberry. For detailed information, including step-by-step instructions, take a look.
The Google Android Market offers you thousands of free and for purchase applications to download to the HTC Droid Incredible cell phone. In this video, Verizon Wireless shows you how to navigate the Android Marketplace and download the newest and coolest Android apps.
You can customize the seven home screens on the HTC Droid Incredible cell phone by adding widgets, changing the live wallpaper, and creating scenes to fit your lifestyle. Live wallpapers move and respond to your touch and changing scenes is a quick way to match the Incredible to your current status. Verizon Wireless shows you how to personalize your phone.
Getting to know your HTC Droid Incredible cell phone will help you fully experience its benefits. In this video tutorial, Verizon Wireless shows you some basic navigation tips for the home screen for getting started with your Android device.
Just because you have more than one Gmail account doesn't mean you can't view them all on your HTC Droid Incredible cell phone. Verizon Wireless teaches you how to add multiple Gmail accounts to the Incredible's Android platform, making it easy to get all your emails as soon as they arrive.
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 619th installment in their series of digital spreadsheet magic tricks, you'll see how spaces in cells cause trouble in formulas and learn how to use the REPLACE, COUNTIF, CLEAN & TRIM functions to solve space-related formula problems.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 101st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use conditional formatting AND custom number formatting to add styling to a cell.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 94th installment in their series of digital spreadsheet magic tricks, you'll learn how to use and link a currency web query to a data validation cell drop-down list for money conversion.
You know it's not safe to drive and oeprate your cell phone, so why not learn how to take advantage of the latest voice features on the Samsung Rogue? Just watch this video and you'll be dictating, and voice commanding and controlling in no time. Give your thumbs a break, dictate your texts - the Rogue even recognizes commands such as "smiley face" and translates them into the appropriate emoticon. Cool!
In this video, learn how to send & receive text messages from your computer (Mac or PC) using your email.
Want to protect your investment and add some personal style to your cell phone, but aren't quite sure how to install that cool new skin? We've got you covered - just check out this quick video on how to install and remove an iPhone case. If only getting ready for work could be so easy!
If you're a geek, then this power pack will give you a total techgasm. The power pack allows you to charge pretty much anything you can fit into a 12 volt power jack in your car (where the cigar/lighter receptable goes). The power pack is a portable battery, so no need for charging your gadgets - like your cell phone - at home first before you head off to work.
Secretly shoot your voice across the room in stealth mode on a laser beam in this fun and easy project! Make Magazine and Kipkay present this cool spy trick. Build a simple laser communicator that transmits your voice across a room. You need an amplifier, radio, laser pointer, battery pack and a solar cell.
Whether your scavenger hunt is for group competition or just fun, add a tech twist and let the games begin.
In this case modding video tutorial, you'll learn how to install a cigarette lighter-style 12-volt accessory outlet into a PC case. Charge your cell phone and other accessories directly from your case with the hack outlined in this video. For detailed, step-by-step instructions, take a look!
We've all seen the popcorn cell phone video. Now, we have the exclusive inside into how those videos were created. A microwave magnetron is strapped covertly to the bottom of the table. Then the prank is ready. Gather the phones and wait for the exciting reactions.
There's a lot of questions about screen capture on Android cell phones like Motorola's Droid and the HTC Droid Incredible. Currently (and unfortunately) there is no simple way to take screenshots of you Droid's screen. There are no applications, except for ones that require a rooted phone. But this way may be the easiest for you…
