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. This workshop teaches you the basics of one of the most popular spreadsheet packages for Windows. Learn the formulas and definitions of each depreciation method, Excel makes it easy with the SLN, DB, DDB, SYD and VDB functions. Enter the name of the individual asset or group of assets being depreciated (e.g. Van, copier, computers). Registration for Lifelong Learning classes just got easier! Download a Depreciation Schedule Template for Excel. Includes straight-line depreciation and declining balance depreciation methods for financial reporting.