Excel Consulting And Training Services

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 Consulting

Excel Consulting And Training Services

Miricle Solutions is not only a leading provider of basic to advanced Excel training courses online and live, but also a top Excel consulting firm. Our well trained and experienced Excel consulting specialists will be able to assist you with advanced and complex Excel development requirements.

We provide a range of Excel consulting services such as assistance with:

Feasibility assessments

Reporting packages

Cost cutting exercises

Valuations

Spreadsheet auditing

Financial modelling

Development of new spreadsheet models

We have an impressive track record and client list including the likes of:

MTN

AngloGold Ashanti

Excel spreadsheet errors can cause tremendous problems and embarrassment. The majority of spreadsheets however, contain some form of error. Although still acceptable for one or two worksheets, such errors, if present in a financial model can cause projection errors and severe financial losses. As such, clients making use of our Excel expertise benefit from obtaining accuracy in their Excel models. We also provide expert assistance regarding valuations and offer a range of reporting packages.

Whether you need Excel consulting assistance to determine the level of user knowledge regarding the software package for training purposes or need expert help in the development of complex spreadsheet models, you will appreciate our professionalism. Our consultants work in the financial, accounting, business risk management, and auditing fields. As such we understand how to create, evaluate, and audit risk models.

In addition, we also provide onsite and venue specific training solutions. Once the training requirements of staff have been assessed you will be able to select who should attend which course. We also make it more cost effective for companies to offer advanced Excel training for their employees by ensuring that companies can also purchase training packages online. Contact us today for Excel consulting and training assistance.