Exporting Demographic Overlay Data to Excel
You can export demographic overlay data and other information to Excel by choosing the layer to export, making it the working layer, and clicking the Export to Excel button on the Standard toolbar.
Adding Navigation Tools and Running Totals to the Selection Toolbar
You can add tools to let you navigate through selection sets or keep running totals for a certain field of a selection set by clicking Options in the Selection Toolbar and checking the appropriate boxes.
Create New Layers from Address Information
Use the Locate commands found by following Tools>Locate if you want to create a new layer from address information contained in your data.
Clearing Cells
You can clear cells by right-clicking on a highlighted range of cells and choosing Clear.
Creating a New Blank Field for Data
If you want to create a new blank field to fill with data, modify the underlying table using Dataview>Table>Modify. Then, click Add Field and set up the field as you need.
Copy and Paste Cell Values
You can use the copy shortcut (Ctrl+C) to copy cell values and the paste shortcut (Ctrl-V) to edit cell values with data that has been copied. You can paste these cell values into another dataview or into Microsoft Excel.
Writing Formula Fields
If a field name contains spaces or other special characters or starts with a digit, you must put square brackets around it. For example a field called “Age <5" will need to be "[Age <5]" in your formula. Fields that require brackets will automatically display with them in the Formula Builder Field List.
Picking a Base Layer for Territories
When creating Territories, you will need to choose the smallest geographic areas that will be represented in your territories for the Geography Layer.
Export Data to Excel
You can export demographic overlay data and other information to Excel by choosing the layer to export, making it the working layer, and clicking the Export to Excel button on the Standard toolbar.
Converting Points to a Line
You can connect various points on a map using the Point to Line Conversion tool under Tools>Editing>Point to Line Conversion. Combine this with GPS to track vehicle routes.