How to Create a Loan Amoritization Schedule in Excel. Microsoft Excel allows you to either create a spreadsheet from scratch with your own formulas or use a premade template provided by Microsoft.

I’m not referring to fancy formulas, just simple spreadsheets, so I’m going to share with you how to set up a spreadsheet, the common errors I see and how to fix them.

Learn how to control Excel worksheets with spin buttons, scrollbars, option buttons, and checkboxes.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.