Rays Systems

Making an exact copy of a formula When you copy a formula, Excel adjusts its cell references when you paste the formula to a different location. Sometimes, you may want to make an exact copy of the formula. One way to do this is to convert the cell references to absolute values, but this isn’t always desirable. A better approach is to select the formula in Edit mode and then copy it to the Clipboard as text. You can do this in several ways. Here’s a step-by-step example of how to make an exact copy of the formula in A1 and to copy it to A2: 1. Double-click A1 (or press F2) to get into Edit mode. 2. Drag the mouse to select the entire formula. You can drag from left to right or from right to left. 3. Click the Copy button on the Standard toolbar. This copies the selected text to the Clipboard. 4. Press Enter to end Edit mode. 5. Select cell A2. 6. Click the Paste button to paste the text into cell A2. You also can use this technique to copy just part of a formula, to use that part in an...

ANALYZING DATA IN EXCEL Your users might not know that they can use Excel to analyze data from the various databases in your organization. They can use the powerful analytical tools of Excel on data they previously only viewed or edited within the database user interface. Using these features, they can pull data from your customer database, sales tracking database, product catalog, and HR systems into various sheets in a workbook and perform complex PivotTable analysis not possible using the separate applications. This ability is provided by the use of Microsoft Query, an Office application that lives "behind" Excel. You can access Microsoft Query by clicking Data | Get External Data. You'll find three options: Run Web Query, Run Database Query, or Create New Query. The Query interface is very similar to the Design view of a query in Access. Point Query at a database, and it will allow you to build complex relational queries to get the data you need. Running the query wil...