Want to give your new Android enable mobile device a personal touch? Well, your phone comes preloaded with wallpapers that you can use, and you just have to find the right one that fits your personality. Adding the wallpaper to your phone is easy. Go to gallery, flip through the stock wallpapers, and select the one you want by clicking "select" — Best Buy has answers. The Best Buy Mobile team explains how simple it is to set the wallpaper on an Android cell phone.
This video involves beauty tips on how to get rid of chapped lips. The video starts out by listing items needed to take care of chapped lips; the first item listed is chap stick. The video specifically recommends a chap stick that has SPF protection. The other items needed are a tooth brush and a clean towel. The video next explains to rub chap stick on your lips. Next, a tooth brush is used on the lips in circular motions to remove dead skin cells. The purpose is to allow your lips to heal m...
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 363rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula using the ADDRESS, MIN, IF, COLUMN & ROW functions that will return the address of the first non-blank cell in your Excel spreadsheet.
One of the great things about cell phones is the fact that they can accomplish so much in just a small piece of hardware. If you need help figuring out how much to tip, where a certain person lives and their contact informaiton, and even how many miles you have been walking since you left your home. Yup some cell phones can do all of that and more. In this tutoral though, you'll find out more about a basic, easy to use system that has been around for some time. The speed dial.
In this tutorial, we learn how to save a cell phone after dropping it into water. First, dry the phone off as soon as it gets wet then remove the battery and SIM card if you have one. Now, dry the crevices and all small areas of the phone with a towel. Once you have dried the phone out completely, let it set for over a day and it should work again. If it still doesn't work, charge the phone without the battery in it. If the phone works, you just need a new battery, not a new phone.
Mike Callahan with Butterscotch demonstrates how to work with tables in MS Word 2007. Tables are useful for creating information charts and address lists. First, open up Microsoft Word. To create a table, click on the insert tab on the top tool bar. Highlight the elements that you would like to appear in the table by selecting the desired number of columns and rows. Pressing enter inside of a table, it will increase the side of the cell all the way across the table. It will not just increase ...
Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...
What is that smell? If you've got large gauge ear gauges, it's probably dead skin and buildup in your ear lobes.
This small but very powerful electrolyzer produces gas that increases the fuel mileage of your car. The elctrolyzer runs on baking soda (4 volts/cell) and produces hydrogen. Electrolyzers in general are machines that uses a direct electric current to drive a chemical reaction that would otherwise not occur on its own.
Colorectal cancer — cancer of the colon or rectum — is the third most commonly diagnosed cancer in the US. To reduce the chances of a diagnosis we are all urged to stop smoking, keep our weight down, decrease our intake of alcohol and red meat, keep active, and get screened for colon cancer. But, new research has found something that participates in the development of colorectal cancer that might not be as easy to control: A strep bacteria that promotes tumor growth.
Electrical impulses course through our heart and keep it beating. That's why a jolt from an automated external defibrillator can boost it back into action if the beating stops. But new research says there may be more to keeping a heart beating than just electrical impulses.
We usually associate Salmonella bacteria with a dangerous type of food poisoning, but they actually are pretty good at seeking out tumors. That trait made the bacteria a great candidate to deliver a protein that would help knock tumors out.
The presence of certain bacteria can indicate whether the vaginal tract is healthy or not. It could also impact the likelihood of acquiring certain sexually transmitted diseases, like HIV, a new study suggests.
If you're tired of replacing the batteries on your remote control and you would rather have the TV remote charge by itself, grab a few solar cells, rechargable batteries, and a few extra odds and ends. With this mod to your remote, you can let light charge your remote and never buy another battery for it again!
A sonicator is a scientific device used to liquefy cells in order to study their proteins. The same tool can also be used to liquefy other things, including Gummy Bears! This video will show you how to use a sonicator to destroy a Gummy Bear completely in a very scientific way.
When you think of robots, you probably think of things that have more than three parts. Not this robot! If you want a robotics project to try that doesn't require an MIT degree, watch this video for instructions on how to build a 'Dizzy Robot' out of only some thin tin, a pager motor, a button cell battery, and this template.
Glow sticks are one of the few things used commonly by ravers and military personnel, but their uses extend far beyond dancing and illuminating. The juice contained in blue glow sticks can be used to make an organic LED (OLED) test board, and this video will show you how to do it.
In this tutorial, we learn how to make Splinter Cell prop goggles. You will need: goggles, a saw, pipe, a brush, black paint, duct tape, batteries, chop sticks, glue, a ruler, and a pen. First, mark three cuts on the pipe to 3 cm and 5.5 cm. Now, use the saw to cut these. Then, use sandpaper to smooth all the edges. Next, place these onto the goggles and glue them with a hot glue gun. Next, grab two batteries and wrap them in duct tape. Place these with them and then paint these all black. Af...
In this video, we learn how to make your own solar panel.The amorphous solar glass is the cheapest but it's also the least efficient. You can do anything you want with these and they are durable. The hexagon cells are the most efficient and most expensive as well. The poly crystalline is almost 2 watts a piece and can be purchase in lots of any size. You have to tab these cells together and they are extremely fragile. Be careful when you work with these. To make these, you will solder tabbing...
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 729th installment in their series of digital spreadsheet magic tricks, you'll learn how to lookup an item when multiple lookup items are in a single cell with the LOOKUP and SEARCH functions.
Charge your cell phone, mp3 player or other USB-equipped device with the power of the Sun! All you need is a 6-volt solar panel and a female USB cable. Solder them together (this video demonstrates how), and then you have a solar powered USB charger!
In this clip, you'll learn how to install and use a Sega emulator on an Epic 4G phone. Whether you're the proud owner of a Samsung Epic 4G Google Android smartphone or are merely considering picking one up, you're sure to be well served by this video tutorial. For more information, including a complete demonstration and detailed, step-by-step instructions, and to see what it takes to play Sega ROMs on an Epic 4G cell phone, take a look.
In this clip, you'll learn how to gain root access on a Samsung Epic 4G mobile phone. Whether you're the proud owner of a Sprint Samsung Epic 4G Google Android smartphone or are merely considering picking one up, you're sure to be well served by this video tutorial. For more information, including a complete demonstration of the rooting process and detailed, step-by-step instructions, and to get started rooting and running custom ROMs on your own Samsung Epic cell phone, take a look.
In this clip, you'll learn how to gain root access on a Motorola Droid 2 mobile phone. Whether you're the proud owner of a Verizon Droid 2 Google Android smartphone or are merely considering picking one up, you're sure to be well served by this video tutorial. For more information, including a complete demonstration of the rooting process and detailed, step-by-step instructions, and to get started rooting and running custom ROMs on your own Droid 2 cell phone, take a look.
In this clip, you'll learn how to install and use a Sega emulator on a Droid 2 phone. Whether you're the proud owner of a Verizon Droid 2 Google Android smartphone or are merely considering picking one up, you're sure to be well served by this video tutorial. For more information, including a complete demonstration and detailed, step-by-step instructions, and to see what it takes to play Sega ROMs on a Droid 2 cell phone, take a look.
In this tutorial, we learn how to link two workbooks and cells in Excel. First, save both of the files that you want to link together. Make sure you only have one Excel window open, then double click the other Excel file, don't open separately. Next, type in the equals sign into the "A" column, then to go the window menu and you will be able to see all the Excel files currently open. Now, click "link" and you will be taken back to the original worksheet. Now, you will be linked to the other n...
In this video tutorial, viewers learn how to send a text message on a cell phone. This task is very easy, fast and simple to do. Begin by opening the text slider. Then select the message icon from the menu. To compose a new message, click on New Message. In the To field, type in the receiver's phone number or name of the contact. Now type in your text message in the bottom field. When finished composing the message, click on Send. This video will benefit those viewers who are beginning to use...
If you can't wait to see what's inside your new Motorola Droid X mobile device from Verizon Wireless, this video will show you the complete dissection process. Just because the Droid X is new, doesn't mean that the cell phone isn't prone to damage or minor repairs, like the touchscreen. Watch to learn the whole Droid X disassembly, and you can get step-by-step text and photo instructions at DroidX.net.
If you're looking for Easter Eggs in the Xbox 360 hit, Fallout 3, this next tutorial will show you one that is quite shocking. In this video you'll be going after the electric toilet that can only be found at Hubris Comics. It's a regular toilet but is wired to 35 microfusion cells. Try to drink from it and you'll lose some health thanks to a little shock. Now if you're repair skill is high enough, you can actually disarm the toilet and take the cells with you. But first, you need to find it ...
This video from accredited Maya 3D instructor Andrew Klein is a part of his wonderful series of videos covering different aspects of 3D digital art. It covers how to use Photoshop and Maya together to create, align, and sync image planes properly. Take some pictures of your cell phone and get started!
In this clip, learn how to use the Swype Key while texting with Swype on your cell phone. The Swype key is where all of your options are like dictionaries, tips and tricks, help menus and everything else you may need.
In this tutorial, we learn how to erase cell phone information on a Blackberry 7290. First, go to the home page of your screen the scroll to "options" and hit okay. Now, go to "security options" and click okay again. Now, click on "general settings" and click okay, then click on okay once more, and click on "wipe handheld". You will now see a warning, and click "continue" and type in the word to confirm you want to wipe your information. It will now take a couple of minutes to wipe the inform...
Swype is a brand new way to send text messages and e-mails from your cell phone. In this clip, learn how to use this new tool to send the world's fastest messages. With Swype, your fingers will never leave the keypad so you can type in half the time. Check out this tutorial for some helpful tips you can use to Swype on your Android phone.
If you're out in the wilderness with only one or two other people, it's easy to get separated. Even worse, if you planned for the trip to be "all natural" and decided not to bring any electronic gadgets like TVs and cells phones, then there are no lines of communication between you and your buddies.
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 618th installment in their series of digital spreadsheet magic tricks, you'll learn about a handy key command that will allow you to enter both today's time and date into a single Excel cell.
Sam Fisher is back and boy is he mad! The man, as well as the iconic goggles, are back in Splinter Cell: Conviction for the PS3 and Xbox 360. Aside from the original story mode, the game also offers a bunch of great P.E.C. challenges that are sure to keep gamers busy. Some of these challenges are easy to complete, while others are extremely difficult and require great skill to complete. So in this helpful tutorial from the people at IGN, you'll find out how to rule the challenges using some h...
The Motorola DROID is the hottest new mobile device on the market, and playing all of your favorite music on it is a cinch. The new Android platform makes it easy to navigate through your music files. Want to know how? Best Buy has answers. The Best Buy Mobile team explains how simple it is to access the music on your Motorola DROID cell phone.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to use a helper cell to remove a time-consuming (expensive) section of your formula to speed up calculations.
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 35th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the IF, AND and VLOOKUP functions to deliver the words Bid, No Bid, or Alert to a cell. Is VLOOKUP better than IF AND? Find out with this free video lesson.
