Managing Data in Excel 2007

Sorted by:  

Managing Range Names in Excel 2007

If you’ve created a number of range names in an Excel 2007 worksheet, you can use the Name Manager to work with these names. The Name Manager provides a list of all names assigned in the current workbook [more…]

Splitting Data into Multiple Columns in Excel 2007

Use the Convert Text to Columns Wizard in Excel 2007 when you need to split combined data into separate columns, such as a first name and last name; or city, state, and zip code. This type of combined [more…]

Protecting Cell Data in Excel 2007

After you finalize an Excel 2007 worksheet by reviewing formulas and proofing text, you should consider protecting the document to guard against any unplanned changes. Each cell in the worksheet can be [more…]

Naming a Cell or Range in Excel 2007

Assign a descriptive name to a cell or range in Excel 2007 to help make formulas in your worksheets much easier to understand and maintain. Range names make it easier for you to remember the purpose of [more…]

How to Find Records in an Excel 2007 Table

When you work with Excel 2007 tables, you can use keystrokes or a data form to move through table records until you find the one you want to edit or delete. In larger tables, you can use search criteria [more…]

Adding a Data Table to an Excel 2007 Chart

Add a data table to a chart so you can easily see both the graphical chart data and the raw numeric data that created the chart. Adding a data table to an Excel 2007 chart is very easy, and this video [more…]

How to Create a Data List in Excel 2007

Creating a data list, or Excel table, can help you store a large amount of data consistently, as well as give you the ability to easily read, sort, and filter that information. This video tutorial shows [more…]

Sign Up for RSS Feeds

Computers & Software