Tutorials for Excel Amortization Table

MAIN PAGES

-Home Page
-Company Profile
-Free Tutorial Page
-Training Schedule
-Contact Us

BLOG

- Our BLOG

SOFTWARE

-Spreadsheet Auditing
-Spreadsheet Sensitivity
-Spreadsheet Security

NEW Videos

- IRR Calculator
- Count error checks
- Check import headers
- INDIRECT function
- IS number EVEN/ODD
- Is cell a number
- MATCH Function
- Identify missing categories
- Check that data within range
- TEXT Function
- Remove Spaces
- Use ADDRESS

Excel Basics

- Function Wizard
- Audit Toolbar
- Good Design
- Add In's

Tips and Tricks

- Identify missing categories
- Check that data within range
- Count error checks
- Check import headers
- CAGR
- Show all formula
- Fill in blanks
- Data Cleanup
- Multi sheet changes
- Automatic Sort

VLOOKUP tips

- VLOOKUP Use
- Large VLOOKUP's
- VLOOKUP Risk
- Automatic Sorting

Financial

- IRR Calculator
- Interest rate
- IRR
- NPV
- CAGR
- PMT
- Amortization table

Database

- Database

Lookups

- Use ADDRESS
- MATCH Function
- INDIRECT function
- VLOOKUP
- Transpose
- CHOOSE
- OFFSET
- SUMIF/ COUNTIF

Dates

- DATE
- EOMONTH
- EDATE

Statistics

- Rank
- MAX/ MIN

Logical

- IF
- AND/ OR

Text

- TEXT Function
- Remove Spaces
- FIND
- Length
- Join characters
- Change Case
- Extract Text

Information

- IS number EVEN/ODD
- Is cell a number
- ISERROR

Maths

- SUMIF/ COUNTIF

Other Tools

- Data Validation
- Group/Ungroup
- Autofilter
- Workbook protect
- External Links
- Goto Special
- Find/ Replace
- Conditional Format
- Pivot Tables
- Data Sort
- Data tables
- Multiple Windows
- Hyperlinks
- Protect cells
- Paste Special

How errors happen

- Copy/ Paste
- Delete Cells
- Insert rows
- Insert cells
- IF functions
- Linked Sheets
- Hidden Cells
- Lookup's
- MIN/MAX function
- Referencing

What If's

- Goalseek
- Data Tables
- Scenarios
- Watch Window

Download All Videos

- Download All

Amortization Table

Congratulations for discovering the company that will lead your business into the Excel brilliance with solid training and solutions for any business of any size in any industry. Yes, it can only be Miricle Solutions.

When you are in need of the incredible power of Excel and correlated software, but are unfamiliar with the functions, formulas or even the general layout of the program, Miricle Solutions’ consultants are only a phone call away. We will offer help and guidance to build your excel spreadsheet models to perform any requirement in business, from feasibilities, Amortization Tables, reporting packages, valuations and so many other useful programming solutions that will lift your office out of its current Excel rut.

When you need to draw up an Amortization Table, you should consider the following functions in Excel, beforehand. Simply because the Function Wizard gives you the option to calculate the repayments required to amortize a loan, or capital annual growth rate - all from the financial category:

Excel Rate calculators: Constant annuity cash flow interest rate calculations;

Excel IRR Calculators: Internal rate calculations for the return of a series of cash flows;

Excel PMT rate calculations: Repayments calculations for loan amortization;

Excel rate calculations of CUMIPMT and CUMPRINC: In Excel, you can determine the total interest or capital paid between any two periods, with these functions, making it easy and saving you the time of having to draw up amortization tables.