In this lesson you will learn how to modify the spreadsheets you exported.
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
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
Open the second Excel file.
Double-click the Training Example 2.xls list item.Step 3
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
Press and hold the [Shift] key and click Row 11.Step 5
Click the Edit menu.Step 6
Click Copy.Step 7
Go to the first Excel file.
Click the Training Example.xls button.Step 8
Click in the first blank cell in the Account Number column.Step 9
Click the Edit menu.Step 10
Click the Paste menu.Step 11
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
Click the Data menu.Step 13
Click the Sort... menu.Step 14
Click the OK button.Step 15
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
Press and hold the [Shift] key and click "2".Step 17
Right-click in the highlighted field.Step 18
Click the Delete menu.Step 19
Modify the speadsheet as needed. Use this spreadsheet to manipulate the percentage and/or import the data back into the Manual Encumbrance Journal EntryStep 20
When finished click the Save button.Step 21
You have successfully completed this lesson.
Table of Contents Start Topic