In this clip, you'll learn how to gain root access on a Samsung Epic 4G mobile phone. Whether you're the proud owner of a Sprint Samsung Epic 4G Google Android smartphone or are merely considering picking one up, you're sure to be well served by this video tutorial. For more information, including a complete demonstration of the rooting process and detailed, step-by-step instructions, and to get started rooting and running custom ROMs on your own Samsung Epic cell phone, take a look.
In this clip, you'll learn how to gain root access on a Motorola Droid 2 mobile phone. Whether you're the proud owner of a Verizon Droid 2 Google Android smartphone or are merely considering picking one up, you're sure to be well served by this video tutorial. For more information, including a complete demonstration of the rooting process and detailed, step-by-step instructions, and to get started rooting and running custom ROMs on your own Droid 2 cell phone, take a look.
In this clip, you'll learn how to install and use a Sega emulator on a Droid 2 phone. Whether you're the proud owner of a Verizon Droid 2 Google Android smartphone or are merely considering picking one up, you're sure to be well served by this video tutorial. For more information, including a complete demonstration and detailed, step-by-step instructions, and to see what it takes to play Sega ROMs on a Droid 2 cell phone, take a look.
If you can't wait to see what's inside your new Motorola Droid X mobile device from Verizon Wireless, this video will show you the complete dissection process. Just because the Droid X is new, doesn't mean that the cell phone isn't prone to damage or minor repairs, like the touchscreen. Watch to learn the whole Droid X disassembly, and you can get step-by-step text and photo instructions at DroidX.net.
This video from accredited Maya 3D instructor Andrew Klein is a part of his wonderful series of videos covering different aspects of 3D digital art. It covers how to use Photoshop and Maya together to create, align, and sync image planes properly. Take some pictures of your cell phone and get started!
In this clip, learn how to use the Swype Key while texting with Swype on your cell phone. The Swype key is where all of your options are like dictionaries, tips and tricks, help menus and everything else you may need.
Swype is a brand new way to send text messages and e-mails from your cell phone. In this clip, learn how to use this new tool to send the world's fastest messages. With Swype, your fingers will never leave the keypad so you can type in half the time. Check out this tutorial for some helpful tips you can use to Swype on your Android phone.
If you're out in the wilderness with only one or two other people, it's easy to get separated. Even worse, if you planned for the trip to be "all natural" and decided not to bring any electronic gadgets like TVs and cells phones, then there are no lines of communication between you and your buddies.
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 618th installment in their series of digital spreadsheet magic tricks, you'll learn about a handy key command that will allow you to enter both today's time and date into a single Excel cell.
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 241st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a data validation drop-down cell list where the list shrinks as you select values.
Watch this science video tutorial from Nurd Rage on how to make a lithium thionyl chloride battery, which is capable of generating 2.8v with enough current to power a LED.
Check out this Greener Business Show video tutorial on how to make a portable solar powered USB charger with an LED flashlight inside an Altoids tin can. You will see in this episode how to modify a solar path light into the Altoids tin so that you can have a nifty LED flashlight and so you can charge your iPod or cell phone in the gleaming sunlight.
Craft a mobile phone holder for your car by bending and cutting an old CD. It doesn't actually hook up to your car but maybe with a little modding...
New research reveals how E. coli bacteria construct elaborate and effective tunnels to pump unwanted molecules like antibiotics and other toxins out of cells. The discovery could help us better understand how antibiotic resistance occurs and give us a leg-up to beat them at their own game.
Drug-resistant bacteria have made curing some infections challenging, if not nearly impossible. By 2050, it's estimated that 10 million people will be dying annually from infections with antibiotic-resistant organisms.
Usually, the mucus lining of the female genital tract presents a barrier that helps prevent infections. But, somehow, the bacteria that causes gonorrhea gets around and through that barrier to invade the female genital tract.
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.
In this tutorial, we learn how to make Splinter Cell prop goggles. You will need: goggles, a saw, pipe, a brush, black paint, duct tape, batteries, chop sticks, glue, a ruler, and a pen. First, mark three cuts on the pipe to 3 cm and 5.5 cm. Now, use the saw to cut these. Then, use sandpaper to smooth all the edges. Next, place these onto the goggles and glue them with a hot glue gun. Next, grab two batteries and wrap them in duct tape. Place these with them and then paint these all black. Af...
In this video, we learn how to make your own solar panel.The amorphous solar glass is the cheapest but it's also the least efficient. You can do anything you want with these and they are durable. The hexagon cells are the most efficient and most expensive as well. The poly crystalline is almost 2 watts a piece and can be purchase in lots of any size. You have to tab these cells together and they are extremely fragile. Be careful when you work with these. To make these, you will solder tabbing...
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 729th installment in their series of digital spreadsheet magic tricks, you'll learn how to lookup an item when multiple lookup items are in a single cell with the LOOKUP and SEARCH functions.
In this tutorial, we learn how to link two workbooks and cells in Excel. First, save both of the files that you want to link together. Make sure you only have one Excel window open, then double click the other Excel file, don't open separately. Next, type in the equals sign into the "A" column, then to go the window menu and you will be able to see all the Excel files currently open. Now, click "link" and you will be taken back to the original worksheet. Now, you will be linked to the other n...
In this video tutorial, viewers learn how to send a text message on a cell phone. This task is very easy, fast and simple to do. Begin by opening the text slider. Then select the message icon from the menu. To compose a new message, click on New Message. In the To field, type in the receiver's phone number or name of the contact. Now type in your text message in the bottom field. When finished composing the message, click on Send. This video will benefit those viewers who are beginning to use...
If you're looking for Easter Eggs in the Xbox 360 hit, Fallout 3, this next tutorial will show you one that is quite shocking. In this video you'll be going after the electric toilet that can only be found at Hubris Comics. It's a regular toilet but is wired to 35 microfusion cells. Try to drink from it and you'll lose some health thanks to a little shock. Now if you're repair skill is high enough, you can actually disarm the toilet and take the cells with you. But first, you need to find it ...
In this tutorial, we learn how to erase cell phone information on a Blackberry 7290. First, go to the home page of your screen the scroll to "options" and hit okay. Now, go to "security options" and click okay again. Now, click on "general settings" and click okay, then click on okay once more, and click on "wipe handheld". You will now see a warning, and click "continue" and type in the word to confirm you want to wipe your information. It will now take a couple of minutes to wipe the inform...
Sam Fisher is back and boy is he mad! The man, as well as the iconic goggles, are back in Splinter Cell: Conviction for the PS3 and Xbox 360. Aside from the original story mode, the game also offers a bunch of great P.E.C. challenges that are sure to keep gamers busy. Some of these challenges are easy to complete, while others are extremely difficult and require great skill to complete. So in this helpful tutorial from the people at IGN, you'll find out how to rule the challenges using some h...
The Motorola DROID is the hottest new mobile device on the market, and playing all of your favorite music on it is a cinch. The new Android platform makes it easy to navigate through your music files. Want to know how? Best Buy has answers. The Best Buy Mobile team explains how simple it is to access the music on your Motorola DROID cell phone.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to use a helper cell to remove a time-consuming (expensive) section of your formula to speed up calculations.
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 35th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the IF, AND and VLOOKUP functions to deliver the words Bid, No Bid, or Alert to a cell. Is VLOOKUP better than IF AND? Find out with this free video lesson.
Want to know the quickest and easiest way to access your Gmail email account from your Motorola DROID mobile device? Getting immediate access to your Gmail account from the DROID is as easy as three steps and only two buttons. Best Buy has answers. The Best Buy Mobile team explains how simple it is to easily access Gmail from the Motorola DROID cell phone.
In this how to video, you will learn how to create a diagonal sum in Microsoft Excel 2007. First, open the program and make a large selection. Type in =int(rand()*500) and then press control enter. This will create random numbers for the cells in the selection. From here, click conditional formatting and select new rule. From here, type in =column(A1)-row(A1)=$H$1. For the format, choose a contrasting look, such as a purple background and bold numbers. Click okay. If you type -1 or -2 in this...
Robert demonstrates how to quickly insert formulas into Excel. To create a sum, highlight your selected cells and press the sum key. Expand the formula by clicking on the fill handle. Double click on the fill handle to expand the formula. To sum vertical columns, highlight all the cells and click the sum button. Press and hold down the control key for another shortcut to work in accordance with the auto sum button. You can also select the average for the area. You can also select the area and...
This video describes how to create intricate nail painting designs. The first step is to choose a background color. You can either choose a lighter background color so the darker designs you paint over it will stand out, or a darker background color so the lighter-colored designs will stand out. For this specific design consisting of 3 flowers and a few dots, the former will be used. Next, take globbing paper and glob it with some white polish. Use a nail dotter to apply the polish from the p...
This is a presentation of different types of immune responses in human body. There are two types of immune systems i.e., non specific and specific or adaptive immune system. Again, non specific immune system is sub- divided into barriers. It is the first line of defense. The second line of defense is the inflammatory response. They are phagocytes. These are all products of white blood cells. It is also called as leukocytes. Lymphocytes are another type of white blood cells which are carriers ...
Ever wanted to know how to make a fire with your cell phone? All you need is a cell phone, a brillo pad, and material for tinder. First take the battery out of your phone and find the positive and negative contacts on the bottom of it. Next tear off a chunk of the brillo pad, roll it up until you have a twisted piece about an inch long. Bend the steel wool over and touch an end to the positive and the other end to the negative contacts on the battery. That causes the steel wool to smolder--no...
Want a way to dynamically reference the number of instances of a given word in a Microsoft Office Word document from Excel? Who doesn't, am I right? In this Microsoft Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how to do just that.
In this Excel magic trick video the tutor shows how to change operator in a formula from a drop down using Choose function. He shows a basic work book which can be downloaded from the internet for hands-on to the tutorial. In this trick the tutor shows how to include some operators in a drop down box of a cell and based on this drop down value change the operators in equations that are using this cell there by dynamically altering the equation and the value produced using the equation. For th...
Flowering bulbs require some few common tools before planting such as compost or peat moss, work gloves, fertilizer, garden trowel or bulb planter and the garden bulb of your choice. During the spring season you can plant tender bulbs such as, irises, gladiolus and elephant ears. In terms of fall plantings you can plant bulbs such as tulips, daffodils, hyacinths and crocuses which could give a beautiful bloom in the spring. In general the blooms will last till three to four weeks, bulbs such ...
The video asks the question "What would you do to gain respect?" This is the bad example. It says that you should turn the sound off on your cell phone before you enter the interview. The video suggests that talking on your cell phone during an interview will lower your chances of getting the job. The video also suggests that keeping your potential employer waiting while you take a phone call can also keep you from getting the job for which you are interviewing.