Optimized Cell Search Results

How To: Create a formula to count cells in Microsoft Excel 2011

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.

How To: Build a Small DIY Hydrogen Fuel Cell Science Experiment

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!

How To: Jailbreak your T-Mobile G1 cell phone

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.

How To: Sum the values from many cells to a single Excel cell

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.

How To: Set up text alerts in Edmodo

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...

How To: Know how long it takes to lose abdominal fat

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...

How To: Perform the cell phone mentalism card trick

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 ...

How To: Use Excel mixed cell references in formulas

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...

How To: Pair your cell phone in a 2010 Toyota 4Runner

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...

How To: Send different items from your phone to your computer

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...

News: 4 Billion Year Old 'Fossil' Genes May Be Our Secret Weapon Against Infection

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.

How To: Optimize performance on your Windows Vista PC with CCleaner

There is a built-in tool in Windows Vista that allows you to clean up your hard drive and system, and it could be found by simply searching for "disk cleanup" in the start menu. But this provides a really basic cleanup, so for all of you who want something more extensive, there are free alternatives available on the web. Once is called CCleaner, which is a lot better. It's the number-one tool for cleaning your Windows PC.

How To: SEO your website on a small budget and improve its Google ranking

Google is the biggest and best search engine on Earth, and if you are a webmaster and want your website to be a big success it would really behoove you to know as much about how it works as possible. The Google Webmasters series of videos and website were created to teach webmasters, SEO professionals, and others how Google works by answering their questions and giving them insights into how they can best integrate and utilize Google's functionality to improve their business. This video will ...

How To: Get better battery life on DROID smartphones

Battery life is a constant problem with cell phones today, and the Droid smartphones running Android software are no exception. If you want to learn how to get the most out of your Droid battery, then check out this helpful video that provides 8 tips on cutting battery-eating apps and features. If you want more battery life and are willing to sacrifice the cool features of the Droid cell phones, then you have to do these things. Don't let you Droid battery get drained!

How To: Use HipHop for PHP to improve website performance

HipHop for PHP is a source code transformer that allows you to optimize your PHP code easily, which will allow you website to run faster on less server space. This video is a record of a seminar on using HipHop done by a Facebook employee who had a hand in it's development. If you make websites using PHP, this will be very good stuff for you to learn.

How To: Play co-op story mode in SCC (St. Petersburg, Banya)

The new Splinter Cell video game has a co-op mode now, which means you don't need to play online anymore just to play against a human. You can have your best friend sitting right next to you… playing on the same Xbox 360. Forget the absurdity of playing in separate rooms, play in the same room. Splinter Cell: Conviction for the Xbox 360 is the way to go.

How To: Set up a secure lock on a Motorola DROID cell phone

You don't want anybody to have access to your cell phone. Nobody. Well, instead of the standard unlock mechanism, the one anybody can unlock your cell phone with, the Motorola DROID, and Android enable mobile device, allows you to create your own unlock pattern, secret to anyone else, which wakes it from sleep mode. Best Buy has answers. The Best Buy Mobile team explains how simple it is to set up a secure lock on a Motorola DROID cell phone.

News: This Genetic Defect Could Be Why Typhoid Mary Never Got Typhoid Fever

Whether or not a microbe is successful at establishing an infection depends both on the microbe and the host. Scientists from Duke found that a single DNA change can allow Salmonella typhi, the bacteria that causes typhoid fever, to invade cells. That single genetic variation increased the amount of cholesterol on cell membranes that Salmonella and other bacteria use as a docking station to attach to a cell to invade it. They also found that common cholesterol-lowering drugs protected zebrafi...

How To: Prank someone by changing their cell phone numbers

If you want to cause one of your friends some extreme discomfort and possibly ostracization, try doing this to them! This video will explain a simple prank that you can pull when one of your friends / enemies leaves their cell phone unattended in your presence. I won't give it away, but they are sure to feel the wrath of this one and will not be able to blame it on your concretely. Brilliant!

How To: Gmask your gadgets

In this short demonstration, see how a Gmask is made for a cell phone. A Gmask is a DIY skin for your gadget (such as a cell phone or iPod), that could last and protect your electronic device for up to 7 years if made correctly. The Gmask at times covers your gadget's corners, edges, screen and even keypad in some cases.