How To: Create a power cell icon in RealWorld Icon Editor
A tutorial showing how to create an icon of a power cell for Windows XP or Vista in RealWorld Icon Editor.
Cell Phone Search Results
News: Researchers Look to Cows to Create Vaccine for HIV
A vaccine against HIV might prevent the disease that we can't seem to cure. Some HIV patients make antibodies that can take down the virus, much the way a vaccine might. But, scientists haven't been able to provoke that type of response in other people. However, in a process that might work in humans, a group of researchers has successfully generated antibodies in cows that neutralize multiple strains of HIV.
News: Defective, Infectious Proteins Linked to Type 2 Diabetes
More than one in ten people in the US have type 2 diabetes — that's over 29 million people. It's characterized by excessive sugar (glucose) in the blood due to the development of resistance to insulin, the hormone that normally metabolizes glucose.
Toxic Shock Syndrome: How Bacterial Toxins Can Turn Our Immune System Against Us
Streptococcus and staphylococcus bacteria produce toxins that can cause toxic shock syndrome.
News: Taking Genetic Scissors to Infected Cells Could Cure HIV
Being infected with HIV means a lifetime of antiviral therapy. We can control the infection with those drugs, but we haven't been able to cure people by ridding the body completely of the virus. But thanks to a new study published in Molecular Therapy by scientists at the Lewis Katz School of Medicine (LKSOM) at Temple University and the University of Pittsburgh, all that may change.
News: Teeny Sponges Being Created to Float in Your Blood, Sop Up Bacterial Toxin & Prevent Flesh-Eating Disease
It's not the bacteria itself that takes lives and limbs during invasive flesh-eating bacteria infections. It's the toxins secreted by the group A Streptococcus bacteria invading the body that causes the most damage.
News: Viral Infections Blur the Line Between Bacteria & Complex Life Like Plants & Animals
Using extreme time-lapse microscopy, scientists watched a virus take over a bacteria to create a cell that looked and functioned more like a plant or animal cell. True story.
How To: Make an SMS Intruder Alarm
This tutorial shows you how to create an intruder alarm that sends you text message alerts when motion is detected. This may sound complicated but I am pretty confident any beginner with electronics should be able to do this just fine. The range sensor senses motion and tells your Arduino board to send the text (SMS). So you can leave the intruder detector at home, connected to your network, and still receive the SMS alerts, no matter where you are, as long as you have cell phone service.
How To: Use a Venn Diagram to Solve Probability Problems
Video covering how to set up a Venn diagram. The video covers how to draw the diagram and then look at a set of data and place the data in the correct part of the Venn diagram. The sample problem is as follows.
How To: Install WhatsApp on a Kindle Fire HDX or Other Amazon Kindle
This past year, Facebook spent $19 billion purchasing the popular messaging app WhatsApp, and for good reason. Mark Zuckerberg isn't going to spend that type of money on just any application. WhatsApp is widely popular and frequently used by more than 500 million users worldwide, which is almost twenty percent of the Earth's population.
How To: Beer—Could It Be the Answer to Your Smartphone Addiction?
Often, when you crack open a beer with friends, your buddies are more focused on texting and Snapchatting than what's happening right in front of them. Smartphones have wedged their way into bars around the world—but an innovative new beer glass is encouraging patrons to put down the phone and engage with friends.
How To: Turn Your Smartphone into a 175X Digital Microscope for Incredible Macro Photos
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.
How To: Mod a Calculator into a Custom Name Badge for Your Desk
There isn't as much use for old-school four-function calculators anymore since we all have them on our cell phones now. If you've still got one lying around, you can hack it to play recorded sounds, use it to make a metal detector, or turn it into a custom name plate that says anything you want...
How To: Use worksheets in Microsoft Excel: Mac 2008
Data can be troubling, especially if there's a ton of it plaguing your Excel worksheet. But Excel 2008 for Mac makes life a little easier and less confusing thanks to a few worksheet tips and features you can utilize to work with your data in worksheet cells. The Microsoft Office for Mac team shows you just how to work with worksheets in this how-to video.
How To: Retrieve the cell address of the minimum value in a column in Microsoft Excel
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 create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP functions.
How To: Return every other cell in a row in Microsoft 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 700th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve every other cell in a row as you copy the formula across the columns.
How To: Clear data & cell contents in Excel using a macro
In order to clear the cell content in Excel, using a macro, you will first need to have a table. If you don't already have a spreadsheet, you will need to create one with random numbers. Next, highlight some numbers, by clicking one box and dragging in order to select a number of boxes. Click Alt + F11.
How To: Enter formulas in Excel with a macro
In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.
How To: Build and use array formulas in Microsoft Excel
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 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.
How To: Use TEXT & custom number formatting in Microsoft Excel
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 270000000000000000000000000000000th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use custom number formatting for cells and the TEXT function. Specifically, this lesson covers the following:
How To: Fix other people's Microsoft Excel spreadsheets
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 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:
How To: Create an array constant from cell values in MS Excel
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 10th installment in his series of Excel array formula series, you'll learn how to create an array constant from values in cells. This is a great trick that can save tons of time when you want your array stored in memory.
How To: Get rid of chapped lips
This video involves beauty tips on how to get rid of chapped lips. The video starts out by listing items needed to take care of chapped lips; the first item listed is chap stick. The video specifically recommends a chap stick that has SPF protection. The other items needed are a tooth brush and a clean towel. The video next explains to rub chap stick on your lips. Next, a tooth brush is used on the lips in circular motions to remove dead skin cells. The purpose is to allow your lips to heal m...
How To: Return the address of the 1st non-blank cell in Excel
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 363rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula using the ADDRESS, MIN, IF, COLUMN & ROW functions that will return the address of the first non-blank cell in your Excel spreadsheet.
How To: Work with tables in Microsoft Word 2007
Mike Callahan with Butterscotch demonstrates how to work with tables in MS Word 2007. Tables are useful for creating information charts and address lists. First, open up Microsoft Word. To create a table, click on the insert tab on the top tool bar. Highlight the elements that you would like to appear in the table by selecting the desired number of columns and rows. Pressing enter inside of a table, it will increase the side of the cell all the way across the table. It will not just increase ...
How To: Make an Excel dynamic named range across multiple rows
Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...
How To: Fix ear funk from gauges
What is that smell? If you've got large gauge ear gauges, it's probably dead skin and buildup in your ear lobes.
How To: Diagnose & treat oral squamous cell carcinoma in cats
Learn how to care for your pet with help from VetVid. See how to test, diagnose and treat oral squamous cell carcinoma in cats.
How To: Build a 32 plate 31 cell series HHO electrolyzer
This small but very powerful electrolyzer produces gas that increases the fuel mileage of your car. The elctrolyzer runs on baking soda (4 volts/cell) and produces hydrogen. Electrolyzers in general are machines that uses a direct electric current to drive a chemical reaction that would otherwise not occur on its own.
How To: Download Wireless Tether for a rooted Motorola Droid X
You've managed to get your Motorola Droid X rooted, so now what? What's one of the first things you could install on your Droid X? What's the most valuable items you need on your cell phone? Everybody knows the answer… wireless tether, a way to suck the internet from your Droid X to your laptop or home computer. Well, this video tutorial will show you how to get the free Wi-Fi tether mobile hotspot app, called Wireless Tether, on your Droid X from Verizon Wireless. You don't have to pay tons ...
How To: Operate the new iPhone 3G
Since it's introduction, iPhone has become the standard for design and ease of use, redefining what's possible on a mobile phone. And now with iPhone 3G, this revolutionary device gets even better, offering even more advanced capabilities. iPhone 3G works with fast 3G cellular and wi-fi networks around the world to keep you connected wherever you go. With its integrated GPS technology iPhone 3G makes it even easier to find where you are and where you're going. iPhone 2.0 software includes sup...
News: Some Shiny New Pixel 3s Aren't Registering SIM Cards & Google Is Dragging Their Feet on a Fix
You just brought a brand new Pixel 3 from the Google Store, and you insert your SIM card only to find the phone won't recognize it at all. No matter what you do, the SIM card won't register and your Pixel won't connect to your carrier network. That's what happened to me and several other Pixel 3 owners. The good news is a fix is coming, the bad news is Google doesn't have a date for that fix.
How To: Make Anonymous Calls from Your iPhone
When you don't want somebody you're calling to know the real phone number associated with your iPhone, whether it's for privacy reasons, to avoid being called back, or to prevent being ignored, there are multiple things you can do to block it on their caller ID.
How To: List of Phones with Unlockable Bootloaders
If you want to root your phone, it's a huge plus. If you want to install a custom ROM like LineageOS, it's an absolute must-have. Custom kernels like ElementalX, custom recoveries like TWRP — none of this happens unless you buy a phone with an unlockable bootloader.
News: Strep Bacteria a Deadly Participant in Development of Colorectal Cancer
Colorectal cancer — cancer of the colon or rectum — is the third most commonly diagnosed cancer in the US. To reduce the chances of a diagnosis we are all urged to stop smoking, keep our weight down, decrease our intake of alcohol and red meat, keep active, and get screened for colon cancer. But, new research has found something that participates in the development of colorectal cancer that might not be as easy to control: A strep bacteria that promotes tumor growth.
News: And the (Heart) Beat Goes On ... Thanks to Newly-Discovered Role of Macrophages
Electrical impulses course through our heart and keep it beating. That's why a jolt from an automated external defibrillator can boost it back into action if the beating stops. But new research says there may be more to keeping a heart beating than just electrical impulses.
News: New 'Trojan Horse' Salmonella Bacteria Kills Tumors Instead of Making You Sick
We usually associate Salmonella bacteria with a dangerous type of food poisoning, but they actually are pretty good at seeking out tumors. That trait made the bacteria a great candidate to deliver a protein that would help knock tumors out.
News: An Unhealthy Vaginal Microbiome Can Increase Risk of HIV Infection
The presence of certain bacteria can indicate whether the vaginal tract is healthy or not. It could also impact the likelihood of acquiring certain sexually transmitted diseases, like HIV, a new study suggests.
How To: Schedule Ringtone Silence for Weekly or One-Time Events on Your Samsung Galaxy Note 2
We've all had that moment when we enter into a classroom, meeting, or theater and completely forget to put our cell phones on silent.
How To: Reply to Messages While You're Busy with SMS Replier for Android
At a time when virtually everyone has a cell phone, it's almost inconceivable to think of a time when we're without them. At work, in bed, and even in the bathroom; we're always with our smartphones. I mean, hell, someone even designed a way to bring your smartphone into the freaking shower. It's not THAT serious.