From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,500 courses taught by industry experts.

Customizing templates to fit your unique needs

Customizing templates to fit your unique needs - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Customizing templates to fit your unique needs

- [Instructor] If you're about 2 to create a business type application, 3 say a loan amortization schedule, don't overlook the fact 4 that Excel has built 5 into it quite a few different templates, they're called, 6 and this is one of them. 7 I've modified this slightly. 8 I want to show you not only how to open one of these, 9 but also how to make changes to it 10 that could be to your advantage. 11 The loan amortization schedule 12 that we're seeing here is flexible 13 and the heart of it actually is the list 14 that we see starting in row 18 that shows the month 15 by month payment, in this case, 16 a payment on a house loan over a 30 year period. 17 First of all, how do we find this? 18 On the file tab in the ribbon, we can choose new. 19 Now, I've opened this recently 20 so it appears in my list here. 21 You wouldn't see this unless you had opened it recently 22 and you might not see it at all as you look up 23 and…

Contents