Live Excel Training Courses Presented In South Africa | 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

Excel Training Courses

Live Excel Training Courses Presented In South Africa

Miricle Solutions is one of the leading providers of live Excel training courses. Our Excel training courses are designed and presented by skilled and experienced Excel specialists. Adrian Miric, the head of designing and presentation of Excel training courses at Miricle Solutions, has more than 15 years experience in the building and reviewing of Excel based financial models in various industries. He is a CA with experience in IT and Corporate Finance. As such delegates to our Excel training courses have the benefit of an experienced Excel specialist to explain difficult concepts while also showing attendees the applicability of the various tools and functions of the program.

Benefits Of Attending Our Excel Training Courses Include:

We offer a 100% money back guarantee.

All courses will commence on the scheduled dates whether one or ten persons attend.

Every attendant receives a full DVD/CD with the course content upon completion of the course.

We also offer a pre-assessment to determine the skills level of the attendant prior to course commencement. This is an optional service.

We can also customize the course content according to customer requirements for in-house courses at the client premises.

We offer the following Excel Training Courses:

Pivot Tables

Excel Graphing

Financial Modelling

Advanced Excel

VBA Macros for Excel

Excel Fundamentals

Our live Excel training courses come highly recommended because of the presentation methods used; the experienced presenters, hands-on exercises for skills reinforcement, course content, and the duration of the courses. If you are serious about becoming a power user of Excel or want to have your employees trained in specific modules, the choice is easy. Select Miricle Solutions as your presenter of Excel training courses. View our range of courses including live, online, download based and free courses and contact us today for enrolment information.