Protecting Excel 2007 Data Microsoft Excel / Getting Started
The concept of "protection" gets a lot of attention in the Excel newsgroups and forums. It seems that many users want to learn how to protect their workbooks from being copied or modified.
Working with Excel 2007 Files Microsoft Excel / Getting Started
This tutorial discover the new Excel interface that provides you with the right tools at the right time. In most Windows programs, you see menus and toolbars from which you select your options.
Load an XML Document ito Excel Microsoft Excel / Functions and Formula
If someone sends you an XML file containing data that fits into tables, you don't need to read the text and all its angle brackets. You can load the document into Excel directly, tell Excel how you want to present it, and work with the data through maps.
Creating Charts in Excel 2007 Microsoft Excel / Charts and Graphs
A chart (also known as a graph outside Excel circles) is a way to present a table of numbers visually. The visual display allows you, for example, to quickly examine trends or compare the relative contributions of various items.
Managing Workbooks in Excel 2007 Microsoft Excel / Getting Started
Working with documents is critical to using any software. Microsoft Excel documents are known as workbooks. This part covers the procedures that you need to know to manage workbook documents efficiently.
Address Data by Name Microsoft Excel / Functions and Formula
Although cell numbers are at the foundation of everything Excel does, it's much easier to remember names, such as Item Number and Quantity, than it is to remember cell numbers, such as A1:A100. Excel makes this easy.
Excel uses the same technique for defining named cells and named ranges: the Name box at the left end of the Formula bar.
Excel's Builtin Features Microsoft Excel / Getting Started
Data validation makes it easy to specify rules your data must follow. Unfortunately, Excel insists that lists used in data validation must appear on the same worksheet as the data being validated. Fortunately, there are ways to evade this requirement.
In this tutorial, we provide two methods you can use to validate data based on a list on another worksheet. The first method takes advantage of Excel's named ranges, and the second uses a function call.
Data Entry Microsoft Excel / Getting Started
As you are aware, when Microsoft Excel starts, it opens a workbook made of three worksheets. A worksheet is simply made of cells that are patiently waiting for you to enter data.