Microsoft Excel Consulting | 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

Microsoft Excel Consulting

Range of Microsoft Excel Consulting Services

Apart from online and location based Excel training courses, Miricle Solutions is also a leading provider of Microsoft Excel Consulting services to client companies. Our client profile includes Anglogold Ashanti and MTN. Our Microsoft Excel Consulting experts assist clients in financial modelling, spreadsheet development, feasibility analysis, and evaluations.

By making us of our Microsoft Excel Consulting services client are able to save on costs, develop advanced reporting abilities, and ensure that Excel streamlines their accounting and analysis operations.

Even with the best training and experience, users still make mistakes in spreadsheets. As such it is imperative to make use of a program such as Spreadsheet Professional to quickly identify mistakes, missing and duplicating data and more. In addition to spreadsheet auditing assistance, clients also benefit from our spreadsheet analysis expertise.

We in addition to the above, also offer clients services such as evaluation of the spreadsheet skills of employees in specific departments. This can be used to identify training needs and to ensure that the employees working with specific data sets will be able to do so with confidence.

By ensuring that spreadsheet errors are identified and corrected, models evaluated for feasibility, and employees trained properly, companies are able to improve on profit making, productivity, and the integrity of the financial decision making models.

Our consultants work with advanced Excel tools on a daily basis and are not only well skilled as presenters and trainers, but also in various financial and accounting areas. They are thus able to quickly identify pitfalls and mistakes in models as well as to develop advanced workable models according to client requirements.

Increase profits, productivity, and trust in your spreadsheet models by getting expert help. Contact us today for more information regarding our various Microsoft Excel Consulting services or to obtain immediate assistance with spreadsheet model development for your company.