Exercise 3: Enter data, filter data, export to an Excel file
1. If the left panel with your task list is hidden, select the triangle button to display it.
2. Open the Update Data in Form and select the Budget – Non-Comp Expense tab.
3. To update data, you must be at the lowest level of detail for each dimension. Select a DeptID that you can write to from the first drop-down list. In the Page Dimensions box, detail members are shown in black and summary members in blue.
4. From the Fund list, select Unrestricted - Plan.
5. From the Chart1 list, select C1_SUMPLN.
6. Select the Go button to fetch the data.
7. There are many rows that do not appear to have any data. Right-click on an account and select Filter \ Hide rows with no data from the quick menu.
8. From the menu, select Tools \ Export as Spreadsheet.
9. Double-click the file to open it.
10. The system presents a warning message about the file format. It is safe to open the file, so select Yes.
Next Topic: Operating Transfers