It's official, you CAN jailbreak your cell phone or other device without fear of reprisal from the police or government! If you've been waiting to jailbreak your iPhone, iPod Touch, or iPad (or other device) there's never been a better time. This video will show you how to use a program called Spirit to load Cydia, the popular jailbreak operating system, on your iPhone 3GS or lower or iPod Touch 2G or 1G. Basically, any Apple mobile device with firmware version 3.1.3 or 3.1.2 is fair game. Th...
Using Swype - the new lightening fast way to text message from your cell phone - and need to type a word like "juggle" or "bubble" or something else with a double letter? No problem! In this tutorial, from the creators of the Swype app, learn how to add words like these to your texts and e-mails with ease.
With all the little gadgets people carry around these days, those little cigarette lighter outlets just don't cut it for in-car power sources anymore. Unfortunately, that's often the only option our cars and trucks come with.
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.
Sometimes when it comes to long road trips, we find out that having just on power outlet in your car isn't enough. iPod, cell phone, GPS, etc. how can you be able to use all these items and have just one power outlet? Well in this video, you find out how to add multiple power outlets for those long road trips.
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.
Systm is the Do-It-Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. They will help you avoid pitfalls and get your project up and running fast. In this DIY episode, see how to share Internet access at highway speeds.
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.
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.
Achieve your goals by breaking them down into bite-sized pieces, and use digital shortcuts to track your steps towards success.
In this video, Jonathan Cohen demonstrates how to surf the web using a BlackBerry 8800. The explains how to start up the Internet on the cell phone, how to input an address, and give some hints on using the browser.
If you want to save some money on an iPod holder, you might want to watch this video tutorial. You will learn how to make a cool iPod holder out of a sock. It's very easy to do and more importantly... it will save you money. You can even use that dirty, raunchy, gym sock to protect your iPhone or other cell phone too! Really though, make sure you wash your socks before making this iPod protector. You may not be protecting the ingenious mp3 player is you don't.
This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...
Rooting a cell phone can give you so many different perks and advantages that you wouldn't normally have. But at the same time it can also cause damage to the phone itself that it may even cease to function properly causing any money that you spent, to go down the drain. This tutorial shows you how to root your T-Mobile G1. Be careful and good luck!
1. Select the cell for which the dropdown menu is to be applied. 2. once the cell is selected goto DATA menu select VALIDATION.Data validation dialog box will be displayed.
This is a very informative video; it shows you how to listen to music on your phone, for free. Yes for free. This service allows you to listen to any music you want for free just by signing up. This video shows you step by step how to listen to music for free on your computer or your cell phone. The service even allows you to buy music at a super cheap price (most songs for less than 50 cents.!!) This video shows you step by step how the site works and allows you to become very familiar with ...
This video from WirelessZone will show how to send and read text messages on the Casio G'zOne Rock cell phone. They show you step-by-step how to navigate the various menus to send a text message, as well as include pictures and animations to your text message. The video also demonstrates how to read sent and new text messages and set your text message options. Showing how to set up your voice mail is also demonstrated. If you're a new user of this phone then this video will show you many of t...
In this tutorial video Phil from DroidBoards will show you how to organize your Verizon Wireless Droid cell phone (smart phone) with folders on the home screen. This is good for keeping similar apps or frequently used apps in a quick and easy to access place. This video shows step by step how to create a folder on the home screen, select, and rename the folder. The video then shows you two different ways you can drag an icon into your newly created and renamed folder.
Ever need to text someone, but don't want to use up your texting limits? Or you want to text someone, but your phone doesn't have texting capabilities? As long as you're near a computer, this video has you covered.
This video tutorial is about Android, and no it's not a robotic creature, it's a software platform and operating system form mobile phones and PDAs. The Android system is based on Linux and was developed by Google and the Open Handset Alliance. Code is managed in the Java language, but can be written in C also, although C is not officially supported. A lot of the new cell phone and other mobile devices will be running off of Android, so know how to use it.
This video tutorial is about Android, and no it's not a robotic creature, it's a software platform and operating system form mobile phones and PDAs. The Android system is based on Linux and was developed by Google and the Open Handset Alliance. Code is managed in the Java language, but can be written in C also, although C is not officially supported. A lot of the new cell phone and other mobile devices will be running off of Android, so know how to use it.
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.
The search for a cancer treatment that selectively finds and kills only the cancerous cells has just made a giant leap forward.
Learn how to make your own cell phone signal enhancing device! You're reception will be awesome with a simple homemade coffee and cookie can antenna.
The one man Sam Fisher trusts, Victor Coste, has some information for him. To find out the intelligence, Sam has agreed to meet in person. Find out what the important intel is in this walkthrough for the Washington Monument (Mission 5), and where that lead Sam next.
Take a trip into the past as Sam Fisher gets captured by terrorists in the Iraq War. Instead of playing as Sam, you'll be playing the part of Victor Coste — the only man Sam trusts. Find out how Coste saved Fisher's life in this walkthrough for the Diwaniya, Iraq (Mission 4). What happens that day in Diwaniyah? Find out.
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!
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.
Watch a 4 part series on Spore's Cell Stage. This is the first stage in this new hit game of evolution and creation! How will you create the universe?
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...
If you want to save money on your electric bill, try building some of these solar panels using solar cells wired in a series. You can save money by using extra glass you or a friend may already own if it isn't being used. Soon you can harness the power of the sun by creating your own solar electricity.
The verb "stop" in the English language can be used with a gerund and an infinitive. The word "stop" has different meanings depending on how it's used. Look at the sentence, "I stopped eating fast food." Stopped is used in the past tense and eating is a gerund, or a word that describes an activity and functions as a noun. Look at the sentence, "I stopped to eat some fast food." In that sentence, there is an infinitive. The first sentence means I no longer eat fast food. The second sentence me...
1. The following instruction describes how to generate sub totals in Microsoft Excel Sheet. 2. Take Region as a Primary column and Sales Rep as a Secondary Column. 3. First method to sort: Select a cell in Region and goto Data select A to Z. 4. Second method to sort: Select a cell in Region and Right click and select Sort A to Z 5. Then click a cell in Region and select Data->OutLine->SubTotal 6. In the SubTotal Window select 1.Each Change in: Region 2.Use function:Sum 3.Add subTotal to:Sales...
You may think you'll never be in an emergency situation, but you can never be too prepared! This video provides excellent tips on what to bring and do in an emergency situation.
Those old cell phone and laptop batteries staring you in the eye? Don’t worry, recycling them is easy.
Whether your plane made a crash landing or your ship got lost on a three-hour tour, now you're stranded on a remote island. Here's how to get help.
Cancer cells do a pretty good job of flying under the radar of our immune system. They don't raise the alarm bells signaling they are a foreign invader the way viruses do. That might be something scientists can change, though.
The problem with HIV is that it attacks and kills the very cells of the immune system that are supposed to protect us from infections — white blood cells. But a new technique, developed by scientists at The Scripps Research Institute (TSRI) in La Jolla, California, offers a distinct HIV-killing advantage.
We fight cancer in a variety of ways, but no matter whether drugs, biologics, or our immune cells are part of the battle, they can do a better job fighting back cancer if we can help them find the tumors.
If you've ever used the automation app Tasker, then you know exactly how powerful the tool can be. If you haven't, suffice it to say that there's virtually nothing on your Android phone that Tasker can't automatically do for you.
