Financial Planning | 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 Planning

You can’t afford Not to do Financial Planning

‘Growth’ is the magic word for any business and without solid Financial Planning your start-up or large corporation won’t live up to its full potential during the changing economic climate. Not even to mention your own financial situation when you start with retirement budgeting or experience a dramatic change of lifestyle. The easiest way to forecast and plan for your business and individual needs is to use Microsoft Excel 2007 with the training services and assistance from Miricle Solutions. This well-known company are not only the experts in Excel solutions but they also offer knowledgeable and objective professional financial advice to a wide range of organisations in South Africa.

A lot of investment brokers, entrepreneurs, economists and insurance consultants want to know from Miricle Solutions why they should use Excel 2007 for financial planning. The truth is that even though you can appoint a programmer to tailor-make software for your needs it’s not necessary. That’s because Microsoft Excel is a cost-effective, user friendly alternative that saves you a lot of time, is highly compatible with other software, allows you to import large amounts of data, comes with an accessible help function and include an interactive interface.

Don’t be under the misconception that Miricle Solutions only caters for novice users of Excel 2007. A large percentage of their clients are professionals (i.e. Chartered Accountants and CFA’s) who use Excel spreadsheets for investment analysis, business plans, corporate reports and growth projections. They are able to perform complex calculations and present the findings in a sophisticated layout complete with visuals and colour.

Now that we’ve planted the seed and you know that you can afford to do Financial Planning with the help of Miricle Solutions, it’s time to grow your business and capital at alarming speed. No water or sunshine required, just Excel 2007 and the professional services of Miricle Solutions.