Modify The Spreadsheets Lesson


In this lesson you will learn how to modify the spreadsheets you exported. 


Steps:

  1. Browse to the location where you saved the Excel files and open the first one.  

     

    Double-click the Training Example.xls list item.

    Step 1
  2. The Excel file will open. 

     

    Next we will open the second Excel file. Click the Windows Browser button so you can open the next file.

    Step 2
  3. Open the second Excel file. 

     

    Double-click the Training Example 2.xls list item.

    Step 3
  4. On the second Excel file select the rows you would like to copy and paste into the first Excel file.  

     

    Click Row 2.

    Step 4
  5. Press and hold the [Shift] key and click Row 11.

    Step 5
  6. Click the Edit menu.

    Step 6
  7. Click Copy.

    Step 7
  8. Go to the first Excel file.  

     

    Click the Training Example.xls button.

    Step 8
  9. Click in the first blank cell in the Account Number column.

    Step 9
  10. Click the Edit menu.

    Step 10
  11. Click the Paste menu.

    Step 11
  12. Sort the information by the Account Number.  

     

    Click in the upper left hand corner of the spreadsheet (the square above "1" and to the left of "A").

    Step 12
  13. Click the Data menu.

    Step 13
  14. Click the Sort... menu.

    Step 14
  15. Click the OK button.

    Step 15
  16. Delete the non-payroll object accounts and the object accounts that should not be encumbered since the expense is for July:

     

    515400 Life & Accident Ins Exp

    515500 Health Insurance Expense  

     

    Click "9".

    Step 16
  17. Press and hold the [Shift] key and click "2".

    Step 17
  18. Right-click in the highlighted field.

    Step 18
  19. Click the Delete menu.

    Step 19
  20. Modify the speadsheet as needed.  Use this spreadsheet to manipulate the percentage and/or import the data back into the Manual Encumbrance Journal Entry

    Step 20
  21. When finished click the Save button.

    Step 21

You have successfully completed this lesson.

Table of Contents  Start Topic