Cell Gizmos Search Results

How To: Read eBooks on a Google Android smartphone with the Amazon Kindle app

Interested in using your Google Android cell phone to read your eBooks when away from your Amazon Kindle eReader? With the free Amazon Kindle app, it's easy. And this brief video tutorial from the folks at Butterscotch will teach you everything you need to know. For more information, including detailed, step-by-step instructions, and to get started reading books on your own Google Android smartphone, take a look.

How To: Send text & picture messages for free on an iPhone 4G

This clip will introduce you to an app that will allow you to send free SMS and MMS messages to your friends' cell phones. Whether you're the proud owner of an Apple iPhone 4G or perhaps just considering picking one up second hand, you're sure to benefit from this free video tutorial. For more information, including a detailed overview, watch this iPhone user's guide.

How To: Apply formatting to Excel cells that meet a condition

See how to apply condition formatting when working in Microsoft Excel 2007. Whether you're new to Microsoft's popular word processing application application or a seasoned MS Office professional just looking to better acquaint yourself with the Word 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the useful formatting feature in your own Excel documents, watch this free video guide.

How To: Setup and use your new HTC EVO 4G smartphone

Are you lucky enough to have gotten your hands on an HTC EVO - the world's first ever 4G cell phone? If you have, then check out this helpful tutorial. In this video you will not only get an introduction to your new smartphone but also a step by step walk through of how to set it up and start using it. So, follow along and start taking advantage of all the cool features of the EVO.

How To: Make an edible plant cell model for biology class

Science fairs are some of the most creative moments during the elementary school period. Not only are you able to research a topic of interest, but you also have try to find various ways in which to showyour scientific results. In this case, you'll find out how to make an edible plant cell model for an easy science fair project of for biology class. It's easy to do and will surely attract the attention of your teacher and others. Enjoy!

How To: Use the UPPER & EXACT functions in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 82nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the UPPER & EXACT functions to create a TRUE/FALSE formula to determine whether or not uppercase text has been entered into a cell.

How To: Extract a person's middle name from a 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 191st installment in their series of digital spreadsheet magic tricks, you'll learn how to how to extract part of a text string using a formula with the functions MID, LEFT and FIND.

How To: Take & edit photos & videos on the LG enV3

Cell phones aren't just for calling people anymore! The LG enV3 offers a ton of photographic and video options which this video shows you how to use to their full potential. Not only can the LG enV3 record photos and video, you can edit and enhance them as well. There's even a Face Beautify option for your bad hair days, and a Funny Face setting to brighten up any frowns.

How To: Put an unresponsive iPhone into DFU mode

iPhone not booting up? This video shows how to recover your iPhone if it is unresponsive or even getting ready to Jailbreak it, by putting it into DFU Mode. DFU, device firmware upgrade, mode bypasses the current OS and allows you to upgrade or downgrade. Watch this video cell phone repair tutorial and learn how to restore a crashed iPhone by putting it into DFU mode.

How To: Encode videos for YouTube

Did you just buy a $1,000 camera, upload your first video to YouTube, and find it looking like you used your cell phone to shoot the movie? Well, worry no more...this episode of Indy Mogul's Weekend Extra will help you get the best quality for your video before uploading it to YouTube.

How To: Make manganese dioxide electrodes

Various electrochemical reactions requires that anodes do not degrade when used. Carbon is cheap, but degrades easily and platinum is extremely expensive. In a previous video, you learned "How to make cobalt and manganese nitrates", and you saw that titanium could be used as a cathode, but not as an anode due to an effect called passivation.

How To: Prevent Acne with Doctor Recommended Treatments

Acne develops when pores become blocked with dead skin cells and oil. They usually disappear over time but sometimes they leave a scar. When those blemishes form white blood cells rush to the surface to help heal the area. But occasionally a scar forms. Popping and picking can send bacteria further into the skin and increase the blemish and it greatly increases the likelihood that a scar will appear. Nodules and cysts are more severe blemishes and have an increased likelihood of leaving scars...