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.
In this quick tutorial, I show you how to compare data using an in-cell bar graph in the Open Office Calc Program by using the '=REPT' formula.
Watch this video to learn how to change the LCD screen on your Nokia N95 cell phone.
Watch this video to learn how to change the fascia, or face plate, on your Nokia N95 cell phone with a T5 Screwdriver.
Watch this video to learn how to change the lense (the glass/plastic bit on the top screen) on a Motorola V3 series cell phone.
Kipkay teaches you how to make a USB cell phone charger and first you need a standard USB cable. Cut off one end of the cable and use a voltmeter to check which of the four wires has five volts.
How to make an instant, in-cell bar graph in a Microsoft Excel spreadsheet to make comparing data instantly visible.
With a little elbow grease, a sugar cube, and some can do attitude, you will be able to remove the logo off your cell phone. Simply polish up the area with the cube and remove any pesky logos left behind by the company.
Scientists know that bacteria create their own energy, get nutrients to run their cellular processes, and multiply. But, bacteria haven't been shown to respond to external mechanical stimulation or signals in a way that's similar to how our bodies respond to touch, until now.
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 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...
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.
This video you shows how to send your pictures, videos, music and ring tones from your cell phone to your computer. The tutor asks you to find the pictures that you want to send to the computer, and then mail those pictures to your e-mail. We can then later open our computer and through the email download all the pictures and videos that we sent to ourselves. So in this way we can send all our personal stuff from the cell phone to computer without ever connecting the cell phone to the compute...
Check out this informative video tutorial from Apple on how to hide, filter and sort table cells in Numbers '09.
This makeup tutorial video will teach you how to make a bronze eyeshadow look that is great for summer. This makeup look is fantastic for heading to the beach or just hanging out at home. Although it may be bronze eyeshadow, it gets the gold medal.
Kipkay is at it again with his pranks. In this video, he shares four fun and easy pranks that anyone can do to drive their friends (or victims) crazy! Their all very simple. They include a cell phone prank, a floss prank, and more!
On Thursday, Mojo Vision, a startup comprised of former engineers from Apple, Amazon, Google, and other Silicon Valley mainstays, emerged from stealth backed by $50 million in funding for a hands-free augmented reality platform that runs without smartphones, tablets, or other devices.
Once we recover from the respiratory infection pneumonia, our lungs are better equipped to deal with the next infection — thanks to some special cells that take up residence there.
Despite mounting scientific evidence that viruses can cause changes in learning and memory, the reasons have remained elusive.
The body's usual response to a bacterial infection in the blood — called sepsis — takes time. It requires a carefully orchestrated sequence of events that gets the body's immune system ramped up to deal with the invading bacteria.
The evolution of our infection-fighting systems may have something to teach modern scientists. That's what a group from the University of Granada in Spain found when they studied a protein that's been around for over four billion years. Their work, by senior author José Sánchez-Ruiz and colleagues in the Department of Physical Chemistry, was published in the journal Cell Reports.
Sometimes the best way to hide things is in plain sight. Whether you're trying to sneak some medication past security at a concert with a zero-tolerance policy, or you're just worried that maybe Omar comin', YouTuber MrGear has a clever way to put your mind at ease.
With over 1.5 billion people on this planet without electricity, it's hard for those of us in developed nations to even fathom how anyone can read, write, repair, or do anything else that we take for granted without any lights. While some of our First World problems pale in comparison, they remain issues nonetheless, one of the biggest being constant battery drain from portable electronics.
This is just a simple survival light source. You can use a cheap outdoor solar yard light like the one in the video from walmart. There only about 3 to 5 bucks but you can use them not only as a light source but a way to recharge AA rechargeable batteries.
As our society and population grows, more developments such as housing and restaurants are built. While this is beneficial for us, it's not so great for the environment and the animals that occupy it. Some of the victims of our prosperity have been the birds, forced from their natural habitats.
Harnessing the power of the sun is something that Captain Planet made cool before it was the go-to for renewable energy. Solar-powered energy is quick and cheap, and can make for some really cool DIY projects. And for those of you wondering what you should do with your old satellite, look no further. Aaron from Sharealikelicence offers up a way to create a DIY outdoor satellite cooker. He started with an old Ku Band dish and covered it with aluminum tape, for better reflection of the sunlight...
One of the most annoying things about summer is mowing the lawn. Depending on how big your yard is, it can mean spending hours out in the hot sun while you could be doing something a lot more fun like watching the Olympics or making giant soap bubbles. Reclaim your summer with this remote control lawn mower that does all the hard work for you.
Want an electric car without the price tag? You could always build your own, or maybe just hack your old gas guzzler into an eco-friendly electric machine... This weekend at Defcon, security consultant David Brown showed off his "Voltswagon" project, a 1974 Beetle named Shocky that he converted to electric for only $6,000. He removed the old combustion engine, radiator, and a few other unneeded parts to make it lighter. Then he loaded it with batteries front and back, ten Interstate DC-29, 12...
