Excel
® Training Courses (Excel 2003, Excel 2007 and Excel
2010)
BEE
certification number- BEE6853244.
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
Sept 2010
16&17 Sep 2010-
Financial Modelling Course
 
20,21,22 Sep 2010-Advanced Excel
incl
Pivot Table Course &
Graphing in Excel
Download the
registration form
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 or
info@AuditExcel.co.za
Excel Course in Rivonia
and Sandton, Johannesburg
Financial Modelling
16 & 17
Sept 2010
Advanced Excel
20,21,22 Sept 2010
Pivot Tables
Part of
Advanced Excel course
Graphing
Part of
Advanced Excel course
CLICK HERE to download the Registration Document for the above course
which includes the pricing and map
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
|