1 / 28

Exporting Data in Aware to an Excel Spreadsheet

Exporting Data in Aware to an Excel Spreadsheet. All data cells that contain a green triangle need to be reformatted by Excel in order for the data to be manipulated correctly. After the data is highlighted a yield sign will appear in the corner of the highlighted data.

saeran
Télécharger la présentation

Exporting Data in Aware to an Excel Spreadsheet

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Exporting Data in Aware to an Excel Spreadsheet

  2. All data cells that contain a green triangle need to be reformatted by Excel in order for the data to be manipulated correctly. After the data is highlighted a yield sign will appear in the corner of the highlighted data.

  3. The data now must be reformatted by Excel to accept changes. This data must be converted to a Number.

  4. Highlight the column of data you wish to format

  5. After selecting the data, choose the Conditional Formatting button on the ribbon and follow the highlighted selections in the drop down menus.

  6. Choose Format only cells that contain and then fill in the rule description with the appropriate numbers that fit your range of data.

  7. Create the cell formatting by clicking on the Format tab. Notice that the Preview shows no current formatting selected.

  8. Select the Fill tab and then choose the color of your choice. The Sample will fill to the color you selected. Choose Clear to change to another color, OK to use the selected color, or Cancel to move back in the process.

  9. The formatting shows up in the column which was selected earlier. These cells contain data found within the range of the first rule.

  10. To create a second rule go back through the same procedure as describe in Slide # 9 of this instructional PowerPoint.

  11. A second rule has been created with Green highlighting all scores that fall between 16 and 18 in the column.

  12. The formatting shows up in the column which was selected earlier showing red for the first rule and green for the second rule.

  13. To edit the rules you can move to the Manage rules menu and edit the rules that appear for this document.

  14. Both rules we created show up in the Rules Manager.

  15. Now all three rules appear in the Rules Manager and are available for editing.

  16. Data cells containing numbers with percents are treated a bit differently. Notice the green triangle? That column needs to be converted to a number. Highlight the cell, click the yield sign and select Convert to a Number If you select a column to format that contains a percentage, the rule values must contain the percent sign.

  17. If you select a column to format that contains a percentage, the rule values must contain the percent sign.

  18. To save the document, click on the Office button, choose Save as… and then Save a copy of the document which works best for you.

More Related