Finance in Excel 4 – Calculate Straight Line Depreciation in Excel

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

Learn how to calculate Straight Line Depreciation in Excel using the SLN() function. This is the first in a line of tutorials on how to calculate depreciation in Excel and therefore covers the most basic method of depreciation, which is the straight line method of depreciation. This is a good tutorial for those needing to improve their finance skills as well as to simply learn to apply them within the Excel environment.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Duration : 0:3:7

Technorati Tags: accounting, depreciation, excel guides, excel help, excel teacher, excel tips, excel tricks, excel tutorials, finance, microsoft excel 2007, salvage value, SLN, spreadsheets, straight line depreciation, usefule life, workbooks, worksheets

Related posts:

1. Excel Lookup/Search Tip 4 – Vlookup Explanation 3 – Vlookup to Assign Grades to Students
2. Excel Macro VBA Tip 13 – Select cells with the Cells Property in Excel Macros
3. Excel Macro VBA Tip – 14 Using Variables with the Cells Property in Excel Macros
4. Excel Macro VBA Tip 25 – Make User Input Boxes for Excel Macros & Set a Variable Equal to The Input
5. Excel Macro VBA Tip 16 – Using Offset in Excel Macros and VBA