Cell Phone Search Results

How To: Merge a range of cells in Microsoft Excel 2000

Using the Merge feature in Microsoft Office Excel 2007, you can quickly turn that worksheet into an easy-to-scan, appealing report. When you merge cells, you join several adjacent cells into one larger cell. Check out this tutorial and learn how to adjust the position of the contents of the merged cell and add borders and background colors.

How To: Enter Excel data into cells with drop down menus

In this video tutorial, viewers learn how to create drop down menus in Microsoft Excel. This task is very easy, fast and easy to do. Begin by highlighting a desired cell. Then click on the Data tab and click on Data Validation under Data Tools. When the Data Validates window opens, click on the Error tab and deselect "Show error alert after invalid data is entered". Then click on OK. Now simply type in the data into the selected cell. This video will benefit those viewers who use Microsoft Ex...

How To: Create drop down menus in Excel

In this software video tutorial you will learn how to create drop down menus in Excel using Data Validation. This example will show you how to display a list of parts in a drop down menu. Create the list of parts somewhere in your worksheet. Then in the cell underneath the one where you want to display the parts, go to the data validation window and enter the data. For this select the cell and then press 'Alt + D + L' to bring up the data validation box. Here you click on 'settings' and selec...

How To: Transfer music from an Android phone to Mac or PC

Staying organized with your digital music library can be frustrating, especially when you're downloading songs on different devices. Transferring music files to one central location doesn't have to be hard though, even when you download music on your Android mobile phone. So how do you get that music off the phone? Best Buy has answers. The Best Buy Mobile team explains how simple it is to transfer music files from your Android enabled cell phone to a Mac or PC computer.

How To: Use Excel formulas with cell references

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 3rd installment in said basics series, you'll learn how to use formulas that make reference to the values of a cell or multiple cells.

How To: Create drop-down menus in Microsoft Excel 2007

This video is a tutorial on how to create drop-down menus in Excel 2007. Select a cell on your spreadsheet and click on the “Data” tab. Go to the “Data Tools” section and select “Data Validation”. In the window that opens select "Allow" and choose "List". You will create a list of the values you want to allow. Type in the values, separated by commas, and click OK. Now you will see your selected cell has an icon to right that indicates there is a drop-down menu containing the value...

How To: Create a Pareto chart for categorical data in MS Excel

If you want to create a Pareto Chart for categorical data in MS Excel you should first have your data input into Excel already. From your data, you should highlight the cells that you want to count the frequency for and in the frequency box you should type in =COUNTIF and highlight the data you want the frequency for and put in F4 and then press , click on cell to the left and click enter. Now this will work all the way down. If you have not sorted it, you can right click and then click sort....

How To: Check if a cell is empty using macros in Excel

Microsoft Excel is used to store and work on data by storing them in rows and columns in tables. You can use a macros to check if a cell is empty. To do this you have to know two short cuts. The first is the VBA Window short cut which is Alt + F11 and the other one is View Macros short cut which is Alt + F8. So open an Excel spread sheet and insert some data into a small table. Now create a macro for this tutorial. You can use and IsEmpty() functions to check if a cell is empty. Use this func...

News: Sentinel Nerve Cells Spy on the Intestines, Linking Gut & Brain

If the all the fingerlike projections in our gut were flattened out, its surface area would be 100 times bigger than our skin's. It's so large that the actions of just a small part of it can impact our health. A new research study has found that enterochromaffin cells in the intestinal lining alert the nervous system to signs of trouble in the gut — trouble that ranges from bacterial products to inflammatory food molecules.

News: A Double Punch of Viruses & Immunotherapy Could Improve Outcomes for Cancer Patients

Activating the body's own immune system to fight cancer is the goal of immunotherapy. It's less toxic than chemotherapy and works with our body's natural defenses. The trouble is, it doesn't work for most patients — only about 40% of cancer patients get a good response from immunotherapy. But coupling it with another type of cancer therapy just might deliver the punch that's needed to knock out cancer.

News: Scientists Discover How to Track Down HIV's Hiding Spots—A Potential Pathway to a Cure

Tremendous strides have been made in the treatment and outlook for patients infected with HIV, the human immunodeficiency virus. Treatment with a combination of antiretroviral drugs can keep patients with HIV alive for decades, without symptoms of the infection. The trouble is, if HIV-infected people stop taking their medications, the virus takes over in full force again—because the virus hides out quietly in cells of the immune system, kept in check, but not killed by the treatment.

How To: Write a value to a cell using VBA in Microsoft Excel

See how to use VBA to write a value to a cell within a Microsoft Excel workbook. Whether you're new to Microsoft's popular digital spreadsheet application, new to Visual Basic for Applications (VBA) or merely new to using the two in tandem, you're sure to benefit from this free video software tutorial from the folks at Lynda. For more information, including detailed, step-by-step instructions, take a look.

How To: Use the flash and both cameras on your new iPhone 4

In this clip, learn all about the brand new cameras on your iPhone 4. The latest iPhone from Apple has made major improvements on the cameras from the older models. Not only do you now have a flash, but you also have TWO fully functioning cameras with great picture resolution for a cell phone. In addition to that, the iPhone 4's new camera has face recognition software, a zoom lens AND an autofocus. There are so many fun things you can do with these cameras from photography to video to two-wa...

How To: Allow only Monday dates in a cell in Microsoft Excel

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 593rd installment in their series of digital spreadsheet magic tricks, you'll learn how to add data validation to allow only Monday dates in a cell using the custom option and the WEEKDAY function.

How To: Count the number of characters in an Excel cell range

Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 9th installment in his series of Excel array formula series, you'll learn create array formula that counts all the characters in a range of cells.

How To: Call voicemail with one key on your BlackBerry

In the GetConnected TV show BlackBerry expert Darci Larocque from Swirl Solutions gives an easy tip on how to call voicemail directly with one (1) key. This option can be seen in other cell phones also, but in a BlackBerry you can set a password for this. Hold the green button or call log , go to menu - Voice Mail, set your password, click escape and save. Now when you dial No.1 or hold it down you go directly to your voicemail.

How To: Select cells in a spreadsheet using hot keys in Excel

This video is an Excel magic trick which shows how to select cells in Excel through keyboard shortcuts. He starts by the basics where he shows how to select a range of cells in excel work book. He shows how to jump to the top and bottom of the selection area. He even shows how to use shift key to select the whole range. Finally he shows how to hold control, shift and click to select the whole ranges. He even shows how to select ranges top to bottom and from left to right. This video shows how...

How To: Use a sodium potassium pump

This is a great video presentation of how Sodium Potassium Pump can maintain a voltage gradient across a cell. It also discusses various things like the differences between positive and negative charges and positive and less positive charges etc. The video tries to explain a lot of things happen within a cell when you fluctuate the voltage of sodium as well as positive and negative ions within a cell. You must watch it yourself to see the changes happen within a cell when you make some changes.

How To: Use OR, ISNUMBER and ISTEXT in Excel

ExcelIsFun shows you how to detect if a cell has a number or text. The first thing he explains is to find out what are the different types of things that can go into a cell. Next he talks about the use of "OR" and "IsNumber" to make it possible to determine if a cell has a number or text entered into it. The user then explains why certain rows where either "True" or "False". After watching this video, you should be able to determine if a cell is using text or a number.

How To: Pack a skydiving parachute using the psycho method

A brief video that illustrates parachute packing using the 'psycho method'. Part 1 of 2 shows the steps of; Sorting the 9 cells, slider, stabelisers, wrapping of the tail, flipping the pack job on its back, untwisting d-bag and cocking the pilot chute. Part 2 illustrates the final stages of the pack job called the 'psycho method'. These steps include; Making sure the pilot chute is cocked, roling the left 4 cells left, the other 4 cells right,the9th cell position, slider adjusting or 'pouting...

News: In the Ultimate Irony, Zika Virus May Cure Brain Cancer

A deadly type of brain tumor and Zika-related brain damage in developing fetuses are devastating brain conditions that, at first glance, may seem unrelated. However, thanks to new research, their paths seem to cross in a way that could benefit patients. A new study has shown that Zika kills brain cancer stem cells, the kind of cells most resistant to treatment in patients with glioblastoma, a deadly brain tumor diagnosed in about 12,000 people in the US each year.

News: A Common Cancer-Causing Mono Virus Has a Special Trick to Hide from the Body's Defenses

Most of us have already had an encounter with the Epstein-Barr virus, or EBV, for short. As part of the herpes family, it's one of the most common disease-causing viruses in humans. We get the disease with (or without) some nasty symptoms, then we recover. However, EBV stays in our body after the illness has ended, and it's one of the few viruses known to cause cancer.