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.
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 140th installment in their series of digital spreadsheet magic tricks, you'll learn how to save time in updating a system of data and information by using sheet cell references in formulas.
New to 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 Excel tutorial from ExcelIsFun, the 270th installment in their series of digital spreadsheet magic tricks, you'll learn how to
In this video tutorial, viewers learn how to set up text alerts in Edmodo. Begin by opening your browser and go to the Edmodo website. Select Settings, which is on the top fight side of the page. Now click on the Notifications drop-down menu and select Text Message. Type in your cell phone number one the next blank space. Then select your cell phone provider. Then check the boxes that you wish to be alerted to. Finish by clicking Save Notifications. This video will benefit those viewers who u...
This video describes the ways people hold onto fat. There are three main types of bodies. There are naturally skinny, round with an easy time gaining weight and overly round with a hard time losing weight. Each person is different but in certain body groups there is an easier time to maintain a lean appearance. Fat cells in your body also play a part in you getting fat and staying thin. It is said that all of your fat cells have been fully grown in your puberty years. There are some new studi...
This video teaches us how to perform a magic trick with a deck of cards and a cell phone. The presenter starts by talking about a man named Eddie Carrol, who apparently hates the presenter for revealing these card tricks on YouTube. The presenter leaves his cell phone and a deck of cards and leaves the room. A spectator is chosen to pick one card out of the deck. When the card has been picked the magician's assistant calls the magician and says that the card has been picked. The trick is how ...
Excel is a powerful tool, but sometimes you need a guide to navigate its possibilities. This clip shows the difference between absolute and relative cell references so that any given formula, when copied, gives the results you want. Sometimes you will want to refer to the same cell, even when you are copying a formula to a different place on the worksheet. Other times, you will want the items in the formula to change as you copy them across the columns. You will see how such actions work thro...
Call internationally from a cell phone
This instructional video demonstrates how to pair a Bluetooth-enabled cell phone with a 2010 Toyota 4Runner that does not have a navigational system. In a series of simple steps, the 2-minute video covers the precise process of pairing one's phone with the vehicle. Then, it finishes by showing how the voice-activated system in the 4Runner can be used to make a phone call. This short, step-by-step tutorial is perfect for anybody with a Toyota 4Runner who is having difficulty getting a cell pho...
In this episode from Household Hacker, you'll see how to put video ringtones on your cell phone for free. Check the full list of compatible mobile phones over at Vringo to make sure it will work for your cellular phone. This is a really cool alternative to the normal ringtones for mobiles phones!
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about adding hidden comments (and metadata more generally) to data cells. For more information on commenting, watch this Microsoft Office Excel how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about concatenation using cell references only. For more on textless concatenation, watch this MS Office how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using '$' to prevent excel from changing formulae when copying or filling ranges. For more on absolute cell referencing, watch this Microsoft Excel how-to.
Sometimes the hardest step to operating a new mobile phone is just turning it on. This video guide to the LG C200 shows the basic getting started type functions, from turning it on and off, to charging, taking photos, and making phone calls. Watch this video cell phone tutorial and learn how to use the LG C200.
Facebook is a popular social networking site, that has a specific mobile phone application. The internet capabilities of the Palm Treo and Centro keep you on top of the game. Stay connected to friend updates, messages, upload pictures, and whatever else keeps you checking your Facebook compulsively. Watch this video cell phone tutorial and learn how to use Facebook on a Palm Treo or Centro.
In Microsoft Office Excel 2007, you can quickly insert new rows, columns, cells, and worksheets and just as easily delete them — with a few clicks.
Check out this video tutorial on how to take apart the HP iPAQ hw6515 Mobile Messenger cell phone to remove the screen for replacement or other minor repairs. See how to completely disassemble the cellular phone for all of those down and dirty fixes you need to repair.
Watch this three-part series on how to assemble battery cells for your radio controlled vehicle. First, see what is needed to assemble cells and to get them glued.
Here is the safe way to disassemble the Dewalt 36V A123 battery pack -- WITHOUT BLOWING THE BMS (metal covered circuit on top of cells) to use the cells with an electric bike or whatever.
This tutorial explains how to setup the gps cell phone app. Go to http://www.websmithing.com for the full explanation and source code, you'll find it on the programming menu tab.
