In daily work, if you want to create a standard document, you can create it quickly with the help of a large number of templates available in Excel. To create a loan analysis reimbursement schedule table as an example to show how to create such a document.
Operation Steps:
1. In an open Excel document, click the File tab, and in the Navigation Pane on the left, switch to the new view, as shown in Figure 1:
2. You can see all the templates available in this view, either using a sample template or searching for a template on the Office on Lan, where we select "Sample Template", as shown in Figure 2:
3, in the "sample template" has provided a "loan installment" Such a template, select it and then click the "Create" button, as shown in Figure 3:
4, the system has quickly created a "loan amortization schedule", no need to manually create the contents of the inside, in the use of direct input to the relevant data can be, as shown in Figure 4: