How To: Use your Bluetooth enabled cell phone as a modem
No Wi-Fi? No problem. All you need is a Bluetooth-enabled phone and laptop to surf the Web from anywhere.
No Wi-Fi? No problem. All you need is a Bluetooth-enabled phone and laptop to surf the Web from anywhere.
Tearing yourself to pieces trying to format fractions in Microsoft Excel? Give this video tutorial from everyone's favorite YouTube Excel guru, ExcelIsFun, your undivided attention. With it, you'll learn how to format fractional values via the custom number formatting tool in the number tab in the format cells dialog box. This video discusses proper, improper, like, unlike and mixed fractions.
Even seasoned users of Excel might not know that you can use the COUNTIFS, DCOUNTA, and SUMPRODUCT functions to count the number of entries that fall between the values given by two other cells. Well, you can. And in this Excel tutorial from ExcelIsFun, the 545th installment in their series of Excel magic tricks, you'll learn how to do just that.
This video gives a tour of the Motorola Droid software. The video begins with the user turning on the cell phone and guides you through navigating the gui (graphic user interface). The easy to use Youtube desktop widget is featured as well as the scrolling desktop that's moved by a flick of the finger tip in either a left to right or right to left direction.
Check out this science video to see how to make a solar-powered miniature car. To make this solar-powered mini car, you'll need some balsa wood, a small motor, two steel rods, four wheels, four washers, a straw of any color, two gears, a solar cell, hot glue gun, a tape measure and a knife.
As a nurse one of the instruments you should know how to use is the autotransfusion cell Saver by Ortho PAT. Follow along in this nursing how-to video to learn the proper procedure for the Ortho PAT. It can be used for the knees and hips to give the patient blood after surgery. It is a closed autologous system to salvage, wash, filter blood and allow for re-infusion.
Have a Samsung flip phone and an affinity for Slavic video games? You're in luck! This how-to presents complete, step-by-step instructions for playing the Tetris theme song on most any Samsung flip-form cell phone. For easy reference, the keypad tab is as follows: 6 345 432 236 543 457 4 222. Play the Tetris themesong on your own Samsung phone with this video tutorial.
Combine your iPod and a laser to send your music on the beam. Easy project that anyone can do, with the help of a little soldering. You will need your iPod, a solar cell, a laser, and a soldering tool. Watch this video circuitry tutorial and learn how to hook up an iPod to a laser for a laser-wired music experience.
Can't make it to a computer to open up some important documents? Fortunately, the BlackBerry is basically a mini-computer that can get those open for you. BlackBerry can be a little tricky while trying to send and receive files through Bluetooth, but with the right help, you can get the hang of it. This video cell phone tutorial shows how to do it step by step.
In this tutorial, Gary Rosenzweig of MacMost.com shows you how to sign up for a free AOL Instant Messenger account that you can use with iChat on your Mac. Stay in touch with friends and family while avoiding troublesome cell phone radiation with this how-to.
The Formula AutoComplete feature in Office Excel 2007 helps you avoid syntax or typing mistakes that can break your formula and display an error in the cell. Every step of the way, Formula AutoComplete guides you with ScreenTips that show you how to build your formula. Watch this tutorial and then try it yourself.
Having problems with your Rubik's Cube stickers? Are they keeping you from solving that cube super fast? Well, learn how to take off Rubik's Cube stickers and clean the gunk. You can easily take off those stickers with a cell phone battery cover, then use a little Tide-to-Go Instant Stain Remover to not remove stains, but to remove the leftover sticky crap on your Rubiks Cube.
Want to play old school Nintendo on your Windows Mobile devices, such as smartphones? Well, this video tutorial will show you how to install the NES emulator on that Windows Mobile electronic touchscreen device. Just sync up your cell phone, and download the software off of the Internet. Just think, you could be playing Mario in the palm of your hand, on your mobile phone.
Do you have a Palm Centro Smartphone that has too many scratches on the screen? Well, this is the video tutorial for you. Here, you will learn how to take apart the Palm Centro cell phone for proper LCD screen replacement, and while you're in there, you can also do some other minor repairs if needed, like replacing the ribbon cable in the mobile phone.
Fix your wet phones by drying them in rice.
How to send SMS text messages from your cell phone -- for free. Just use an IM client.
Here are some concepts that Stanley Meyers had related to his patents regarding the Resonant Charging Choke, which is basically Telsa's BiFiler Coil Design, which basically is how to connect the WFC to the bifilar coil for maximum efficiency and if you have higher resistance and impedance than the WFC you can inhibit amp flow and allow voltage to go to the maximum.
This is a tutorial for how to use a multimeter to take volt and amp measurements of a silicon solar cell and solar modules.
Learn how to use text functions like mid and find to extract characters from a larger text string within a cell in Excel.
Watch this video to learn how to change the LCD screen on a Sony Ericsson W880 / W880i cell phone.
watch this video to learn how to replace the LCD screen on your Sony Ericsson W300 / W300i cell phone.
Cut and bend an old CD to make a mobile phone holder.
This video shows how to take off the top part of the housing and replace the LCD Screen and put it back together.
If you're looking to get on top of the game Plock for Facebook, then sometimes cheating is the best answer (and easiest). With Cheat Engine, you can easily hack Plock.
There's nothing to this Plock hack using Cheat Engine. If you want to get 5000000 points and totally impress your buddies, this is the cheat for you.
Use the Excel Vlookup function in Microsoft Excel 2007 to look up data in a table. This tutorial looks up the level and value of a product from a stock list using the Vlookup function in Excel.
Don't make people around you wish that cell phones had never been invented. Mind your manners by following a few simple rules.
The 'Bullseye' achievement is likely the hardest co-op achievement available to players of Battlefield 3. You will need to land several sniper headshots in order to unlock it. This guide will take you through the path you need to use to land all of the snipes you need.
The Hell's Gate Challenge Room in Batman: Arkham City has three unlockable medals that you earn depending on your performance. This Giant Bomb video guide walks you through the different waves of enemies and helps you figure out what enemies to focus on so you can get all three medals.
'Nightshift', the night mission in Battlefield 3, gives you a sniper rifle that allows you to unlock the 'Army of Darkness' achievement. You will need to shoot all four of the lights out without missing any shots. This Achievement Hunter video should help you out.
If you can clear the 'Comrades' mission in Battlefield 3 in less than 2 and a half minutes, you'll be rewarded with 'The Professional.' This Achievement Hunter guide shows you exactly where to run to get out of the area fast enough.
If you're headed through Uprising, the second mission in Battlefield 3, be sure to unlock the super quick 'Roadkill' achievement along the way. In fact, this Achievement Hunter video will show you exactly how to get 'Roadkill' in less than a minute by kicking a car and killing soldiers with it.
There are several methods in this guide that will help you earn the Boost Defense and Goalkeeper accomplishments in Fifa 12. Be sure not to change the formation of the BYA boosting team during step 3, otherwise the team data will become corrupt. This may be resolved in the future.
If you're trying to earn those unlocks quickly in Fifa 12, take a look at this guide featuring three easy ways to boost your virtual pro accomplishments in the game. Step 3 of the guide can be ignored, as there is an issue with Fifa 12 and the Creation Centre.
The new 'Lonesome Road' DLC has arrived for Fallout: New Vegas, and with it comes several different achievements. In this particular Achievement Hunter segment, the guys take us through unlocking the 'Ed-Ecated' achievement in just a few steps. So grab those points on your Xbox 360 gamer profile.
The 'Juggler' trophy requires you to burn, poison, and freeze four enemies all at once in Resistance 3. The best place to unlock the trophy is probably in the Pit at Graterford, PA. Take a look at this IGN trophy guide for a little assistance.
This Achievement Hunter segment showcases three different achievements that you can unlock in the Xbox 360 version of the zombie survival game, Dead Island. Specifically, they help you learn how to unlock the 'Everbody Lies', 'Ah! Spoiled Meat!', and 'One Is All I Need' achievements. You'll need a large medkit so that you can heal your injuries for the 'Everybody Lies' achievement.
Are you feeling lunky, punk? Well, if you are, why don't you try unlocking the 'Feeling Lucky, Punk' trophy in Resistance 3. Not only does this Achievement Hunter guide help you with that, it also gives you instructions on how you can unlock the 'Chamber Full of Death' and 'Short Out' trophies as well.
Not only will this Giant Bomb Warhammer 40000: Space Marine guide help you beat Warboss Grimskull, it'll also help you unlock the 'But I Am Finished With You' achievement for the Xbox 360 as well. You will need to dodge the boss over and over again to survive, and keep your stamina up as there are four stages to this boss fight.
This Achievement Hunter segment involves unlocking the 'Horny Devil' achievement in Crimson Alliance, a game available on the XBLA. If you want to add another few GP to your Xbox Live profile, you'll need to head into a boss fight against Gashadokuro.