Financial Modelling in Excel | Mirical Solutions

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

Financial Modelling in Excel

Back to Basics - Financial Modelling in Excel

If you work in finance, property, mining or telecommunications then it’s time to go back to the basics of keeping your finances and budgets structured, by using Financial Modelling in Excel. It makes sense to use one model (preferable Excel 2003 or Excel 2007) that is well-known to everyone in your office and won’t cause blood, sweat and tears to the average employee. By sticking to a simple model and method you can organize your data and audit your spreadsheets with ease.

After you’ve selected your financial model the next step is to reduce spreadsheet errors to the minimum so that you lower the risk of losing money due to human error. This can be done by sending your employees and yourself on training to learn the basics of Advanced Excel. Miricle Solutions is the ideal training partner who will provide your entire workforce with the required skills to indentify input errors and understand the fundamental aspects of Financial Modelling in Excel. Important features that will be covered are formulas and outlines, manipulating data, workbooks, templates, macros and customizations, advanced options and conditional formatting.

Live Training and In-house training are available right through the year. Miricle Solutions even offers free Excel skills assessment so that you can determine who needs to attend Excel for Beginners and who qualifies for training in Advanced Excel, Pivot Tables and Graphing. Included in the course material is a CD with video clips of all the areas taught and a lot of customized examples. The highly qualified trainers of Miricle Solutions all have years of practical Excel experience and Adrian Miric, David Theron, Colin Human and Eelco Lodewijks credentials speak for themselves.

With this simple approach to Financial Modelling in Excel business owners and managers now have the support to go back to the basics of finance and improve their overall performance. Contact Miricle Solutions to schedule a public training course or to discuss an in-house training session.