In this video tutorial, viewers learn how to convert music to ringtones using iTunes. Begin by finding a song. Right-click and go to get info. Go to Options and change the time to any 40 second period (check both boxes). Covert it to AAC. Delete New Version, but keep file. Then close iTunes. Find AAC song file and drag it to the Desktop. Rename from .M4A to .M4R. Double-click and it will open in iTunes under ringtones tab. Sync just like you normally would. This video will benefit those viewe...
This is a great way to charge your phone if you ever loose your car charger. Simply splicing a USB cable with an adaptor for your cell phone will create a homemade charger that can easily hook up to your computer and charge your cell phone.
Outside mount cell shades are easy to install. This Home & Garden how to video you will learn how to install them. Installing outside mount cell shades is so easy all you need is a screwdriver.
Cells in Numbers '08 are the same as in Excel. Basically, they are where you store your data. This tutorial will show you how to use the different functions of cells.
If you want to block your cell phone number for all calls, this is the video for you. Learn to block not just one call, but all further calls with the push of a few buttons. Now no one will be able to see your cell phone number.
This video will show you how to tether your Samsung Messager 2, (the MetroPCS phone) to your PC to use as a modem for internet access. This will allow you to use your cell phone as your internet connection point, meaning you'll connect to the net for the cost of your cell phone's data plan. You will need your Samsung USB cable, a PC with Windows 2000 or higher, all current drivers for your phone and PC, and you will also need to head here to get the Samsung PC Studio program. This is part 1 o...
Samimy is at it again. And this time, his ingenuity has tackled a clever way to take something old and broken and restore it to something new and useful. What are we talking about? Modding a broken hard drive and some busted cell phones into a useful rechargeable USB / solar-powered light, which also acts as a portable mobile charger.
The iPhone has always has one very big problem: that it is tied to AT&T. AT&T is a terrible network, and many iPhone users out there are probably dying to switch network but keep their awesome phone. Well now they can! This video will show you how to unlock you jailbroken iPhone 4, 3GS, or 3G using a program called Ultrasn0w, leaving it ready for use on any cell carrier in the country. Except Sprint, they don't have SIM cards.
Searching your phone just got easier with Google's Android operating system for your cell phone. With the Android Quick Search box feature, you can easily search your phone or the web, right from the home screen. It even provides you with search suggestions while you type. Watch this video tip to see how to easily search both your phone and the web with Quick Search box.
One of the greatest things about Google's Android operating system is the ability to "long press" on your cell phone. The android platform is full of many surprises and features, and this is just one of them. Long press (or 'touch and hold') is a nifty feature that reveals additional functionality on your Android-powered phone, like long pressing a picture to edit or share it, and download pictures from webpages, and get more options on your email.
Sending e-mail on the go is a must these days. People seem to be working 24/7, don't they? If you've recently bought a new HTC Magic cell phone, this tutorial will show you exactly how send an e-mail from your phone to anyone, just like you would on a computer. This is a very handy feature and is easy to access.
Check out this informative video tutorial from Apple on how to hide, filter and sort table cells in Numbers '09.
All fields of study have their own language. For people interested in learning about microbes, the language can sometimes be downright difficult — but it doesn't need to be. From antibiotics to xerophiles, we have you covered in an easy-to-understand glossary.
Specialized cells in the lining of the gut may provide a key to preventing an infectious brain disease caused by misfolded proteins.
This video will explain what you need to do to successfully download and install the Gingerblur rom for a Motorola ATRIX cell phone. Watch this video if you are interested in flashing this ROM to your Android smartphone. Using ADB is optional in this install.
This is a great gift idea for anyone on your gift list this holiday season who has an iPhone, iPod or Droid. Crochet a cell phone pouch for their smartphone! This tutorial is for someone who is already familiar with the basics of crochet.
Set custom ringtones and alert sounds on a Motorola Citrus WX445 cell phone! This brief, unofficial guide from the folks at Wireless Zone will teach you how it's done. For all of the details, and to learn how to use custom ringtones (or, if you like, ring tones) on your own Google Android smartphone, take a look.
Want to create a formula to count cells in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started counting cells by formula in your own MS Excel '11 projects, watch the video.
In this video tutorial, we learn how to navigate and use the basic functions and features of the Verizon LG Octane VN530 cell phone's built-in camera. Whether you own a LG Octane phone or are merely curious to see how they work, you're sure to enjoy this brief clip. For detailed, step-by-step instructions, take a look.
In this video tutorial, we learn how to use the music player application on a Verizon LG Octane VN530 cell phone. Whether you own a LG Octane phone or are merely curious to see how they work, you're sure to enjoy this brief clip. For detailed, step-by-step instructions, take a look.
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 51st installment in his "Excel Finance Class" series of free video lessons, you'll learn how to use the DATEVALUE, RIGHT, IFERROR, LEN, TEXT, SEARCH, TRIM and REPLACE to extract dates from a cell containing both dates and words.
The hydrogen fuel cell has great potential to replace carbon-based fuels in our vehicle fleets and stave off global warming. It's a difficult concept intellectually, so why not make this fun little science experiment to try it out for yourself? Yes, by following these simple instructions you can make a small hydrogen fuel cell at home that will even power some devices!
Jailbreaking isn't just for Apple devices anymore! You can jailbreak your G1 phone as well, which will give you access to third party apps outside the regular market store. After you've connected your phone to your computer, download the software, and you'll have a freshly jailbroken G1 phone! Make sure you have everything backed up before doing the jailbreak.
This clip presents an overview of the general technique required for pairing a mobile phone with a headset via the Bluetooth wireless protocol. For detailed instructions, and to get started pairing your own cell phone with Bluetooth-enabled devices, take a look.
Need a quick primer on how to get started using a Verizon Wireless ZTE Salute cell phone? Whether you're a proud owner of the Verizon ZTE Salute or are merely considering picking one up, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, take a look.
Whether you're a proud owner of the Verizon ZTE Salute cell phone or are merely considering picking one up, you're sure to benefit from this video tutorial, which presents a reasonably thorough overview of the device's various features and functions. For more information, including detailed, step-by-step instructions on how to perform a number of basic tasks, take a look.
Need a quick primer on how to get started using a Samsung Intensity II cell phone? Whether you're a proud owner of the Samsung Fascinate Google Android smartphone or are merely considering picking one up, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, take a look.
Android cell phones are highly customizable. You can put just about anything on any one of your home screens, but the widgets are an entirely different animal. They can make your home screens more than useful. CNET shows you how to create widgets, use them, and move them about your home screens. You can even put home photos on your Android smartphone's home screens.
Although the Motorola Droid isn't the newest Android cell phone from Verizon Wireless (e.g. Droid X, Droid Incredible), a lot of mobile phone users are reluctant to switch because of its reliability and QWERTY keyboard. If you're one of those users, but haven't quite fully realized the potential of your Motorola Droid, this video straight from Verizon Wireless will give the lowdown on all the features and uses.
One of the great features in cars nowadays, is the ability ti connect it with your cell phone. With states accepting laws about driving and cell phone use, this feature can be a much needed addition to your vehicle. In this quick and easy tutorial, you'll find out how to setup your bluetooth phone with a 2010 Ford Fusion. Enjoy!
If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the 8th installment in said basics series, you'll learn how to use both relative and absolute cell references in MS 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 8th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add across sheets using 3-D cell References and the SUM function.
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 504th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the borders tab in the Format Cells dialog box to create a 3D effect.
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 269th installment in their series of digital spreadsheet magic tricks, you'll learn how to get criteria from four (4) different cells and combine (join) them into one criterion for the COUNTIF function.
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 389th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a ctrl-period keyboard shortcut to quickly move the active cell in a selected range.
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 384th installment in their series of digital spreadsheet magic tricks, you'll learn how to use an easy go-to/enter keyboard shortcut trip that will allow you to highlight 1000 (100x100) cells.
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 4th installment in their series of digital spreadsheet magic tricks, you'll learn how to add data or a formula to a range of cells by using the Excel's ever-useful ctrl+enter keyboard shortcut.
In this video tutorial, we learn how to navigate and use the basic functions and features of a Verizon LG Touch cell phone. Whether you own a LG Octane Touch phone or are merely curious to see how they work, you're sure to enjoy this brief clip. For detailed, step-by-step instructions, take a look.
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 298th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and MOD function to add up all hours in one cell worked by employees when time in and time out data are entered as time values.
This tutorial teaches one on how to sort a given number of contacts in the Excel spreadsheet so that identical values in the sort appear after one another.
