Financial Functions, Data Tables, and Amortization Schedules

Financial Functions, Data Tables, and Amortization

Schedules

Chapter 4

What we will cover

Controlling thickness and color of outlines and borders

Naming cells Using the PMT function to calculate

monthly payments Using the present value (PV) Creating data

tables

What we will cover

Adding a pointer to a data table Creating an amortization schedule Setting print area to print only sections

of a worksheet Setting print options

What we will cover

Using formula checking Hiding and unhiding cell gridlines Protecting and unprotecting cells

Financial Functions

Excel has many different functions that are dedicated to just finance. Some are:

Depreciation Methods

? declining balance depreciation, ? double declining balance depreciation, ? sum of the year's digits depreciation, ? straight line depreciation

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download