In this video we're going to work out how to calculate straight line depreciation. In this article, we'll teach you how to make a depreciation worksheet in Excel, from assembling column headers to entering formulas.5, Edit the information in columns B through G. See the link above for more information about using this template. Download a Depreciation Schedule Template for Excel. Includes straight-line depreciation and declining balance depreciation methods for financial reporting. This article will show you how depreciation reduces your tax liabilities and how a rental property depreciation spreadsheet can help you with this. Enter the name of the individual asset or group of assets being depreciated (e.g. Van, copier, computers).