Excel
® Training Courses (Excel 2003, Excel 2007, Excel 2010
& Excel 2011 for Apple Mac)
These courses are generally
aimed at intermediate to advanced users.
If you are not sure what you or your organisations skill level is,
download this file
 ,
complete the Instructions and Questions sheets and email back to us for
a free skill assessment (South Africa and African countries only)
 We run a number of public courses during the year and can also
provide in-house courses customised to suit your requirements.
The primary focus is on Data Analysis (taking large datasets and
converting them into meaningful reports in the quickest, safest
manner) and Financial Modeling training (how to build good
decision making tools). On the right you can see the currently
scheduled courses. For more info mail
adrian@AuditExcel.co.za
Recent Testimonials:
“Data accuracy and consistency has improved dramatically
across Absa Capital, so much so that it has become compulsory
within certain areas for all staff to complete Adrian’s Data
Analyses Spreadsheet Techniques course.”- Anton Faber, Head of
Learning and Development, (ABSA Capital)
"The best Excel course I've ever attended. Thanks!"- F.
Swanepoel (Sun International)
"This course really offers value-for-money, as, there are
some training providers out there who offer more expensive
training, but do not teach these kind of practical things which
I can apply every day. The excellent handout, the
www.auditexcel.co.za website, the practical and usable
examples provided (and the CD with video clips which can be
played back at any time) really make this course highly
recommended."- A. Dawood (Transnet) |
Next Course- Rivonia, Johannesburg
Training Dates
13- 17
Feb 2012 (less 10%)
12- 16
Mar 2012 (less 20%)
16-20
April 2012
14-18
May 2012
11-15
June 2012
18-20
July 2012
13- 17
Aug 2012
17- 21
Sep 2012
15-19
Oct 2012
12- 16
Nov 2012
Get
Price and Venue details
Which Function should you use
We are working on a new tool to help you choose the correct Excel
function or tool to use.
Find out more
Recent Testimonials:
"I would like to thank you for a well thought-out course, it
was very insightful and I learned a lot and as a bonus it is
nice to state that it was great fun! Thanks for a course well
presented."- J. Vos (Nedbank) |
|
|
Search the site
Advanced Excel Training Courses
Contact us for more
information on 011 563 3805/ 083 272 2552 or
info@AuditExcel.co.za
Excel Course in Rivonia
and Sandton, Johannesburg
Download Price and venue and see dates below
13- 17
Feb 2012 (less 10%)
12- 16
Mar 2012 (less 20%)
16-20
April 2012
14-18
May 2012
11-15
June 2012
18-20
July 2012
13- 17
Aug 2012
17- 21
Sep 2012
15-19
Oct 2012
12- 16
Nov 2012
Get
Price and Venue details
Watch a video clip of what you will learn
Featured Product
Online Excel training based
on the Excel for dummies series.
For a sample register by
clicking on this
link for a trial
Contact Details
Mail:
info@AuditExcel.co.za
Call Adrian + 27 83 272 2552
Miricle Solutions cc PO Box
2683 Rivonia
2128 |
The Trainers
|
|
Summary of the courses
|
Adrian Miric CA(SA)
 Adrian
Miric is a qualified Chartered Accountant with a CFA (Certified
Financial Analyst). He completed his articles with KPMG where he
spent time on the corporate finance and computer audit
departments. He has established his own consultancy focusing on
the inherent risks of spreadsheets in the decision making
process.
He distributes Spreadsheet Professional
software and has developed the AssumeIT sensitivity tool. He has
assisted a variety of clients with the development of complex
decision models. He also assists clients in reviewing their
spreadsheet models including providing spreadsheet audits.
His industry expertise includes
-
telecommunication,
-
finance,
-
property and
-
mining.
Clients that have been assisted by
Adrian include: MTN, Anglogold Ashanti, Telkom, Internatonal
Housing Solutions, Standard Bank, INCA etc.
David
Theron CA(SA)
Mr. Theron
is a self-employed chartered accountant consulting and lecturing in
the field of financial modelling.
He served articles with Peat, Marwick, Mitchell & Co. (now KPMG) and,
after qualifying, spent some time with them in London.
He has extensive experience in the building of financial models dating
back to 1971, when punched cards were used on mainframe computers.
He has been instrumental in the development of a wide variety of
financial models, including the following:
-
A 5-year
plan for Illings (now Samcor), where he held the position of
Corporate Planning manager, embracing the production and sale of
Mazda motor cars in South Africa
-
A 1-year
plan for both BMW South Africa (where he held the position of
Financial Controller), involving modelling from the shop floor
through to the final sale of the motor cars, and culminating in a
set of financial and cash flow statements.
-
A 20-30
year projection for the implementation of a water reticulation
scheme in Nelspruit, South Africa, for the Development Bank of South
Africa
-
A 1-year
budget model for Bell Equipment Co
-
A 10-20
year projection for the establishment of nut and cherry farms for
the Industrial Development Corp.
-
A number
of comprehensive models involving numerous branches, consolidations,
and inter-company transactions for public and private companies
-
Audits of
financial models, including a model developed by Deloitte & Touche
for the National Housing Finance Corporation He has presented many
public and in-house financial modelling courses, amongst them
courses for the Kuwait Investment Authority (Kuwait), the Queensland
Competition Authority (Australia), Brunei Investment Authority
(Brunei), Merrill Lynch (Australia), BNP Paribas (Hong Kong), AMBank
(Malaysia), General Motors (Thailand), KPMG (South Africa), and
Deloitte & Touche (South Africa and New Zealand)
He is
currently presents public courses on corporate financial modelling in
He has also
lectured at the Wits Business School, and acted as external examiner
in the department of commerce at the University of the Witwatersrand.
Colin Human CA(SA)
Colin is a chartered accountant, with extensive
business experience.
He has occupied various senior management positions in
both public and private companies.
He is currently a non executive director of a number of listed and
private companies.
He is also Managing Director of GoalFix (Pty) Ltd, a
financial management consultancy, which operates in all aspects of
corporate finance, and specifically in the arena of corporate
performance improvement, financial health assessments, and building of
complex financial models.
GoalFix owns and utilises a unique corporate financial
analysis and forecasting software program, marketed under the name of
"ValueGenerator".
Value Generator has been developed over a period of ten
years, and is a highly effective tool used by senior management to
improve shareholder returns, evaluate corporate performance or
alternative strategic scenarios.
Colin became involved in lecturing and personal
executive coaching in 1998 when he presented "Financial Courses for
Non-Financial Managers" on behalf of The Mast Consulting Group.
In addition to the above course, he also presents
courses internationally in "Advanced Excel Techniques", "Advanced
Corporate Financial Modelling" and "Excel Project Modelling" on behalf
of:-
-
Enhance Training - Middle East
-
Corporate Impact Training - Southern Africa
-
Financial Training Company - Hong Kong, Singapore
-
Terrapinn International - Southern Africa, Asia
Pacific
International Clients include the Kuwait Investment
Authority, MTN Nigeria, and Merrill Lynch, Sydney.
South African clients include:- African Platinum,
Hallmark, City Power, Deloittes, Development Bank of South Africa (DBSA),
Lesotho Diamond Corporation, Mittal Steel, National Energy Regulator,
Nedbank, New Diamond Corporation, Premier Foods Limited, Rand Merchant
Bank, Standard Bank, UUnet.
Eelco
Lodewijks BSc Civ Eng MBA
Eelco is a
specialist in financial analysis, Microsoft Excel, and business
management. He has 25 years of corporate and investment finance,
business consulting and management expertise, arising from specific
experience in construction engineering, merchant banking and
financial, marketing and production management.
More
specifically, his experience is as follows:
Current year:
-
Strategic
& financial analysis & consulting to large listed corporations;
-
Developing
advanced Excel models for large listed corporations; and
-
Lecturing
week long courses in advanced Excel (2 days) and advanced financial
modelling in Excel (3 days) on the international circuit.
Past -
most recent first:
-
1997 -
2004 Purchased a loss making steel processing company, turned it
around and sold it in December 2004;
-
1986 -
1996 merchant banking - Industrial Development Corporation of SA.
Corporate lending (6 years), seconded to manage oyster & mussel
farm interest (2 years) & trouble shooting at defaulting borrowers
(3 years);
-
1985 -
1986 Production manager 25 000 m2 industrial textile production
facility; and
-
1971 -
1984 Eight years of construction site management experience on
multi million dollar construction sites both in South Africa and
the Middle East;
|
|
1 or 2 day Advanced Excel Course
A customisable course that focuses on taking data received
from other systems, cleaning it up, manipulating it, and turning
it into meaningful reports that can be used to run your
business.
For the
Advanced Excel course contents click here
Pivot Table Course
Half day course that focus on teaching the user how
to effectively use Pivot tables in Excel 2003 and Excel 2007.
For the
Pivot Table course contents click
here
Excel Graphing Course
Half day course that focus on teaching the user how
to effectively use graphs in Excel 2003 and 2007.
For the
Excel Graphs course contents click
here
Corporate Financial Modeling Course
2 or 4 day courses that focus on teaching the user how
to build a business financial model from scratch to assist in the
decision making process.
For the Corporate Financial Modeling course contents click
here
Excel for Beginners
1 day course that focus on teaching the user the basics of
Excel
For the
Excel Fundamentals course contents click
here
VBA Macros for Excel
Half day course that focus on teaching the user how
to a combination of macros and simple VBA to make their lives
easier.
For the
VBA Macros course contents click
here
|
.gif)
.gif)
