audit excel spreadsheet auditing
audit excel spreadsheet auditing
Online Excel Training Links
 
-Home Page
-Company Profile
-Free Tutorial Page
-Training Schedule
-Contact Us
-Our BLOG
-Spreadsheet Auditing
-Spreadsheet Sensitivity
-Spreadsheet Security
-=#n/a Error
-Dragging Boxes
-Address
-Picture Links
-Cut & Paste
-Manual Recalculate
-Advanced Filter
-CLEAN
-CTRL & ENTER
-Text to Column
-DatedIf
-Copy Sheets
-Date Problem
-Date Stamp
-Date Value
-Days 360
-Dollar
-Find Duplicates
-Cell navigation
-Import Web
-Import Data
-Net Working Days
-Record Macro
-Remove Duplicate
-Speak Cells
-Value
-Search
-Substitute
-Sum Sheets
-Weekday
-Workday
-Years fraction
-=#n/a Error
-Function Wizard
-Dragging Boxes
-CTRL & ENTER
-Sum Sheets
-Audit Toolbar
-Good Design
-Copy Sheets
-Cell navigation
- Add In's
-Cut & Paste
-Manual Recalculate
-Identify missing categories
-Find Duplicates
-Date Problem
-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 Use
-Large VLOOKUP's
-VLOOKUP Risk
-
Automatic Sorting
- IRR Calculator
- Interest rate
-IRR
-NPV
-CAGR
-PMT
-Amortization table
-Database -Use ADDRESS
-MATCH Function
-INDIRECT function
-VLOOKUP
-Transpose
-CHOOSE
-OFFSET
-SUMIF/ COUNTIF
-DATE
-EOMONTH
-Weekday
-Workday
-Years fraction
-DatedIf
-Net Working Days
-Date Stamp
-Date Value
-Days 360
-EDATE
-Rank
-MAX/ MIN
-IF
-AND/ OR
-TEXT Function
-Value
-Search
-Substitute
-Dollar
-CLEAN
-Remove Spaces
-FIND
-Length
-Join characters
-Change Case
-Extract Text
-IS number EVEN/ODD
-Is cell a number
-ISERROR
-SUMIF/ COUNTIF -Data Validation
-Picture Links
-Record Macro
-Remove Duplicate
-Speak Cells
-Import Web
-Import Data
-Text to Column
-Advanced Filter
-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
-Copy/ Paste
-Delete Cells
-Insert rows
-Insert cells
-IF functions
-Linked Sheets
-Hidden Cells
-Lookup's
-MIN/MAX function
-Referencing
-Goalseek
-Data Tables
-Scenarios
-Watch Window
-Download All

Downloads / Products

Spreadsheet Prof.

The world's No.1 spreadsheet testing tool. Try it out below

excel spreadsheets Watch Video Clip
Download Trial Copy
Spreadsheet Professional Quickstart Guide
Buy It
 

Excel ®  Training Courses

NOTE: We are BEE certified. Our Unique reference number is BEE6853244. Go to the DTI website to check it out.

 

Next Course- Rivonia, Johannesburg

Two Day Advanced Excel

18 & 19 March 2010

15 & 16 April 2010

17 & 18 May 2010

14 & 15 June 2010

14 & 15 July 2010

17 & 18 August 2010

15 & 16 September 2010

12 & 13 October 2010

16 & 17 November 2010

 

Together with our online training, we also provide live training in South Africa. 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 Testimonial:

“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

 

Search the site

 

 

Advanced Excel Training Courses

Contact us for more information on info@AuditExcel.co.za

 

Two Day Advanced Excel Course in Rivonia, Johannesburg

18 & 19 March 2010

15 & 16 April 2010

17 & 18 May 2010

14 & 15 June 2010

14 & 15 July 2010

17 & 18 August 2010

15 & 16 September 2010

12 & 13 October 2010

16 & 17 November 2010

 

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.

  • Train at your own pace

  • Learn from anywhere

  • Intuitive and easy to use

  • Review and practice what you learnt for a full year

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

Clients include:                                       MTN  ,  Anglogold Ashanti  ,  Old Mutual  ,  Sun International  ,  Sasol  ,  Telkom  ,  International Housing Solutions  ,  TUHF  ,  AFHCO  ,  Naspers  ,  Supersport  ,  Tiso Capital  ,  Standard Bank  ,  ABSA Capital  ,  Nedbank  ,  Gauteng Treasury  ,  South Africa Custodial Services,                                           AND YOU                                   

Adrian Miric CA(SA)

Adrian Miric Audit ExcelAdrian 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

    • Singapore

    • Hong Kong

    • Malaysia

    • Australia and New Zealand

    • Namibia

    • South Africa

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 Data Analysis Course

A customizable 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 data analysis course contents click here

Pivot Table Course

Half day course that focus on teaching the user how to effectively use Pivot tables in Excel.

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.

For the Excel Graphs course contents click here

Corporate Financial Modeling Course

2, 3, 4 or 5 day courses that focus on teaching the user how to build a financial model from scratch to assist in the decision making process.

For the Corporate Financial Modeling course contents click here

 

 

     
     Read our privacy policy if you are concerned about your information
 

Home | Contact Us | Site Map | Training | Sarbanes Oxley | Articles | Links | Blog