Teach Excel describes how to create a dynamically updating named range that goes from left to right using Excel. First, you define the named range by highlighting the cells containing numbers in a certain row. In the name box to the left of the formula bar, type the name of the data. In this example, the numbers correspond to sales, so type "sales." To check if the named range works, click on an empty cell and enter =sum(sales). That should return the sum of the highlighted cells. However, as...
This video shows you how to idiot-proof a data set in Excel pretty much. It demonstrates how to enable data validation in a cell, so that when you type something in it must be in a predetermined list or will not work. Start by typing in your data table in a second tab. His example is a date, then information about certain employees based on that day. To enter the data validation menu, click the cell you want to use and then hit ALT+D+L to bring it up. Go to settings, then under the Allow menu...
This is a great way to charge your phone if you ever loose your car charger. Simply splicing a USB cable with an adaptor for your cell phone will create a homemade charger that can easily hook up to your computer and charge your cell phone.
Even before we are born, our immune system is hard at work. New research shows how the developing fetal immune system takes advantage of the time and opportunity of gestation — in the presence of mom's cells and tissues — to develop a sense of self.
When the mosquito that carries the malaria parasite (Plasmodium falciparum) bites someone, the parasite must travel to the liver where it undergoes part of its lifecycle before infecting red blood cells and spreading to its next host. Until now, the first step of how the parasite gets to the liver hasn't been clear.
Excel is great, and if you're a Mac user, Excel 2008 for Mac has a lot of new and useful great features you can use to maximize efficiency in your spreadsheets. Excel doesn't have to be the boss anymore, you can! The Microsoft Office for Mac team shows you all the great features in this how-to video.
Outside mount cell shades are easy to install. This Home & Garden how to video you will learn how to install them. Installing outside mount cell shades is so easy all you need is a screwdriver.
Cells in Numbers '08 are the same as in Excel. Basically, they are where you store your data. This tutorial will show you how to use the different functions of cells.
If you want to block your cell phone number for all calls, this is the video for you. Learn to block not just one call, but all further calls with the push of a few buttons. Now no one will be able to see your cell phone number.
We've seen a variety of AR experiences related to athletic footwear over the years, but Puma is betting sneakerheads will buy into a version of interactive design where sneakers are the augmented reality experience
New research reveals how E. coli bacteria construct elaborate and effective tunnels to pump unwanted molecules like antibiotics and other toxins out of cells. The discovery could help us better understand how antibiotic resistance occurs and give us a leg-up to beat them at their own game.
Usually, we think of vaccines as preventative, a shot we get to prevent the flu or some childhood disease like measles or mumps. But there are vaccines for other purposes, such as the ones studied by researchers from the Netherlands.
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 explain what you need to do to successfully download and install the Gingerblur rom for a Motorola ATRIX cell phone. Watch this video if you are interested in flashing this ROM to your Android smartphone. Using ADB is optional in this install.
This is a great gift idea for anyone on your gift list this holiday season who has an iPhone, iPod or Droid. Crochet a cell phone pouch for their smartphone! This tutorial is for someone who is already familiar with the basics of crochet.
Set custom ringtones and alert sounds on a Motorola Citrus WX445 cell phone! This brief, unofficial guide from the folks at Wireless Zone will teach you how it's done. For all of the details, and to learn how to use custom ringtones (or, if you like, ring tones) on your own Google Android smartphone, take a look.
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.
In this video tutorial, we learn how to navigate and use the basic functions and features of the Verizon LG Octane VN530 cell phone's built-in camera. 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.
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.
