How To: Beat Mission 3 on Splinter Cell: Double Agent
A video walkthrough for Splinter Cell: Double Agent for the PS3 Mission 3 - JBA HQ 1 on hard, getting a stealth score of 100%
Cell App Search Results
How To: Run multiple applications on Android phones (1.5/1.6)
The Android operating system for cell phones from Google lets you run multiple applications at the same time! By long pressing your home key (touching and holding) you can easily go back and forth between your most recently used apps. When you listen to music, you can easily switch to other apps while still enjoying your tunes! This video shows you the gist of it. Learn to run multiple apps on your Android-powered phone.
How To: Remove the gloss from an iPhone app icon
On your Apple iPhone or Apple iPod Touch, your applications have icons, and those app icons have an automatic glossy feel to them, which presents a white streak on the top. If you don't particularly like that gloss effect, there is a way to remove it. This video tutorial will show you how to remove the gloss from any iPhone or iPod Touch app icon.
How To: Root (or jailbreak) your Android cell phone
'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!
How To: Use Google's Android Market on an HTC Droid Incredible
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.
How To: Hack the Pantech C530 Slate cell phone
This video is specifically for the C530 Slate cell phone from AT&T, though this procedure will probably work on similar models of phone. You can hack, or jailbreak, your phone to allow you to use third party apps or switch to a different service provider. You will need a non-AT&T sim card for this hack to work (T Mobile is shown in the video). Then turn it on, hit the unlock key and then enter in your unlock code. Make sure you get it right!
How To: Create new folders on an Android cell phone
It's really tempting to put every app and widget you can think of on your Android cell phone's home screen, but eventually you'll have a hard time finding anything in the clutter. That's where folders come in. Creating a folder on your home screen makes life a little easier, and a little more organized. Think about dragging all your games into a one consolidated folder. CNET shows you how to make a folder, how to rename it, and how to manage it on your Android smartphone.
How To: Input values & formulas into a cell in Excel macros
This video shows how to enter values into cells using Excel macros and Visual Basic. This includes a sample Expense Report that is used in this demonstration. In this demonstration, we will create the macro that inputs a title as "Expense Report", Three columns i.e. "Date", "Item" & "Amount", and the summery field as "Total Expenses", as well as the formulas located at the respective cells. Now, we're going to use two keyboard shortcuts i.e. "Alt + F11" to open-up the VBA window and "Alt + F8...
How To: Prepare animal and plant cells slides
When using a light microscope you need a very thin layer of cells on your slide. This how to video is a simple demonstration how to prepare onion cell Slides and human cheek cell slides.
How To: Beat Mission 9 on Splinter Cell: Double Agent
A video walkthrough for Mission 9 - Kinshasa on Splinter Cell: Double Agent for PS3 on hard, getting a stealth score of 100%
How To: Use the Formula Builder in Microsoft Excel: Mac 2008
Excel 2008 for Mac makes it easy to create formulas for cells. You could always do it before, but now with the new Formula Builder feature, building formulas just got one step closer to simple. The Microsoft Office for Mac team shows you just how to build formulas by using the new Formula Builder in this how-to video.
How To: Hack Restaurant City coins & gourmet pts (05/31/09)
Make sure you use FLASH Player 9 First: Deinstall Flash Player 10
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: Download applications to your new Android cell phone
Where do you get all of those cool apps for you Android mobile device? There's one place to go to find all of the latest apps for your mobile phone, so what is it? Best Buy has answers. The Best Buy Mobile team explains how simple it is to add a contact to your Android enabled cell phone.
How To: Make a list in Excel which only contains unique values
This tutorial describes how to make a list with unique values in Excel.This procedure makes the defined cells in a column (called as list) NOT to accept repeated values, which makes the list more simple, readable, easy to manipulate when preparing a worksheet.
How To: Pull text from Excel cells & separate into columns
Mastering your Excel skills? Have a busy Excel workbook or spreadsheet that needs to some organizing? In this two-part tutorial, learn how to pull text from cells & separate them into multiple columns in MS Excel. You will learn how to use the LEN(), FIND(), LEFT(), and RIGHT() functions to pull text from Microsoft Excel 2007 cells & assign them to different columns.
How To: Understand the red blood cells
Many people like to understand how exactly their body works. Understanding the blood will help you a lot when your doctor explains results from blood tests.
How To: Merge & center a cell in Microsoft Excel
This video tutorial belongs to the software category which is going to show you how to merge & center a cell in Microsoft Excel. Highlight the area that you want to merge. Press the "Merge and Center" button located in the tool bar at the top. The cell will be merged. Then, type in what you want to type and click on the cell that you merged. Right click on it. Next, select "Format Cells" and click on "Alignment" tab. Click on the drop box, select "Center" and click OK. Your text inside the me...
How To: Get free ringtones to your cell phone
Follow along as we learn how to get free ringbones for your cell phone. -To begin you are going to go to myxtertones.com/make. This site will be used to email your ringbones to your cell phone.
How To: Fill in the blanks with custom number format in Excel
This video teaches how to fill in the blanks with custom number format in Excel. Open any similar worksheet as shown in the video or type the same to use. Select all the cells in the columns E and F and press F5. Now click 'Specials', then select 'Blanks' and click 'OK'. All the blank cell will be highlighted, now enter the value and press 'Ctrl+Enter' to populate all the blank cells. Press 'Ctrl+1' to format cells, select custom if you want something to show up in the cell but not really be ...
How To: Use Microsoft Excel to determine statistical values
Follow this video to learn how to formulate calculations in Microsoft Excel. First type in a list of numbers in the cells. In order to calculate the median click on the cell where you want the answer to be shown. Then type equals, average, open bracket and insert the cell code where the first number is, colon, and then type in the cell where the last number in the list lies, and close brackets. In practice this is an example where the numbers are in a list from cell A1 to cell A11: =AVEARAGE(...
How To: Connect a cell phone with a MAC computer via Bluetooth
Did you know you can sync up your cell phone (any cell phone with Bluetooth) with your MAC computer? Doing so will enable you to do several things, including importing and syncing your address book, iCal (calender application), and even tethering your phone with your computer so you can get internet.
How To: Beat Mission 10 on Splinter Cell: Double Agent
A video walkthrough for Mission 10 - JBA HQ 4 on Splinter Cell: Double Agent for the PS3 on hard Part 1 of 2 - How to Beat Mission 10 on Splinter Cell: Double Agent.
How To: Beat Mission 7 on Splinter Cell: Double Agent
A video walkthrough of Mission 7 - Cozumel Cruise Ship on Splinter Cell: Double Agent for the PS3 on hard, getting a stealth score of 100%
How To: Beat Mission 1 on Splinter Cell: Double Agent
A Video walkthrough for Splinter Cell: Double Agent for the PS3 Mission 1 - Iceland on hard, getting a stealth score of 100%.
How To: Charge your cell phones with normal batteries
So you're on a trip and you forgot to bring a cell phone charger. Don't want to spend 30 dollars, but need to have your cell phone on? This video will teach you how to charge your mobile phone with regular batteries. All you will need are: a charger plug, resistor 2, cell phone, and 4 AA batteries AA.
How To: Force Your iPhone to Switch Cell Towers for a Stronger Signal
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.
News: Dying Cells Do Tell Tales & What We Learn Can Help Us Stop Cancer from Spreading
As our cells age, they eventually mature and die. As they die, they alert nearby cells to grow and multiply to replace them. Using a special imaging process that combines video and microscopy, scientists have observed the cellular communication between dying and neighboring cells for the first time, and think they may be able to use their new-found information against cancer cells, whose damaged genomes let them escape the normal dying process.
News: New Study Illuminates Role Our Cellular Powerhouses Play in Fighting Off Chlamydia Infections
Mitochondria are known as the powerhouses of our cells because they generate energy to power them. But they also play a key role in the death of cells when they're damaged, infected, stressed, no longer needed, or at the end of their life.
News: A New Project Lets Scientists Strap on a Vive & Walk Right into a Cancer Cell
Cancer is a complicated illness, but the more we understand it, the likelier we are to beat it. The 3D Visualisation Aesthetics Lab at the University of New South Wales took to virtual reality to help improve our odds by allowing scientists to walk through virtual representations of actual cancer cells.
How To: Use the Red Cell Phones and access Cabinet Info in Disgaea 4
After beating chapter 2 in Disagaea 4, the Cabinet feature for multiplayer unlocks. This allows you to interact with other Disgaea 4 Playstation Network players within the game. This guide overviews the functionality of the Cabinet, as well as how to use the Red Cell Phones in game to call upon other player's characters.
How To: Use the web browser on Android cell phones (2.0)
The browser on your Android-powered cell phone offers numerous features that enhance your overall web experience. Some of the great features include double-tapping to zoom in, searching for text on webpages, sharing websites with friends, and copying and pasting. There's a lot more, so watch this video tip from Google to see how to fully enjoy your web browser.
How To: Long press on Android cell phones (2.0)
Most people refer to "long press" as "touch and hold", but no matter which way you say it, it's an awesome feature for Android cell phones. Long pressing lets you get more information, download photos from the web, edit pictures and more! Watch as Google teaches you about long pressing, a nifty feature that reveals additional functionality on your Android-powered phone.
How To: Navigate the home screen on Android cell phones (2.0)
For a newbie, getting around your Android cell phone could be a tad confusing, but with the help of Google and this video tip, you'll learn how to navigate your Android home screen like a pro. Learn how to take advantage of the home screen's features on your Android-powered phone.
How To: Use the quick search box on Android cell phones (1.6)
The Quick Search box on your Android-powered cell phone allows you to search the web and your phone directly from the home screen. It provides suggested results from the internet, even while you still type! Easily search both your phone and the web with the Quick Search box! Google shows you how in this video tip.
How To: Use names in formulas and functions in Microsoft Excel
Looking for a primer on how to create and work with names 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 1st installment in his series of Excel name tricks, you'll learn to use names in formulas and functions as well as how to edit them. See how to name a cell or range of cells with this free video lesson.
How To: Make a cell phone case from duct tape
Need a new cell phone case and have a creative urge? With just scissors and duct tape, make yourself a crafty new protective cell phone case in just a few minutes.
How To: Make a solar cell with a condom
Make a solar cell from a condom with this video tutorial. Solar energy is plentiful and better for the environment, so why not take an easily accessible commodity (like a condom), and use it to harvest the power of the sun. To replicate this hack at home, you'll need the following materials: 12 iron hairpins, 2 pennies (pressed before 1982), 2 electrical wires, 1 sheet of aluminum, 2 strong magnets, a condom, and mineral water. For more on making your own condom-based solar cell, watch this h...
How To: Clear formatting from a cell 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 7th installment in their series of digital spreadsheet magic tricks, you'll learn how to remove the formatting from a given Excel cell without erasing the cell content!
How To: Use a written cell range in a function in MS 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 252nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use a cell range typed into a cell in a function.