Tutorials for Excel Interest Rate

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

Excel Interest Rate

Congratulations for discovering Miricle Solutions – the nationally trusted consultancy that focuses on expert online Excel training and consulting solutions for organizations of all sizes.

Since 2003, our founder, Adrian Miric, has driven Audit Excel to a level of international excellence, with a name and logo that has become instantly recognizable and synonymous with quality Excel training, as well as creative and professional Spreadsheet Consulting, with a team of dedicated and skilled consultants.

Indeed, when you are in a bind with lock and chain, and need solutions in Excel within the corporate world, Miricle Solutions has the golden key. Most commonly, businesses have the responsibility of calculating Interest Rates, regardless if it is for a negative amount in loan repayments or the amortization of outstanding monies from the bank, or a positive amount in bonds. And Excel is such a powerful program that it offers all the formulas to calculate any equation, quickly and accurately, with useful results that are crucial to functioning businesses – Some of the advanced Excel interest rate functions are IRR, NPV, PMT, CUMIPMT and CUMPRINC, as well as CAGR and XIRR.

Excel Interest Rate formulas can be both difficult and frustrating if you don’t have the skills and know-how to program them correctly, and that is why Miricle Solutions offers the best, systematical training videos for any Excel Interest Rate calculations and functions – free.
So why not further explore our engaging website, or contact us today for the better Excel solutions.