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
-Pivot Introduction
-Pivot Tables
-New Pivot Ribbon
-Pivot Values
-Pivot Rows
-Pivot Columns
-Pivot Row & Column
-Grouping Pivots
-Pivot Report Field
-Pivot Graphs
-GetPivotData
-Calculated Item/Field
-Pivot Source Data
-Conditional Format
-Pivot Multi Range
-Pivot Setup
-Chart Tips
-Add Series
-Create Ribbon
-Format Ribbon
-Chart Title
-Chart Area
-Chart Legend
-Data point
-Chart Gridlines
-Chart Axis
-Chart Template
-Chart Label
-Area Chart
-Bar Chart
-Pie Chart
-Radar Chart
-Scatter Chart
-Stock Chart
-Chart Series
-Chart Trendlines
-Chart Conditional Format
-Chart Default Colours
-Combining Charts
-Secondary Axis
-Chart Links
-=#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

 

Advanced Microsoft Excel Training

These courses are aimed at intermediate to advanced users generally.

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)

 

 

 

 

Microsoft Excel Courses Excel 2003, 2007, 2010 & 2011 (Apple Mac)

Johannesburg, South Africa

To find out more about our live Excel training visit the Live Training Page or watch this brief video clip on what you will learn Video Clip.

 

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

 

 

How are we different from the rest

 

MONEY BACK GUARANTEE- If you don't learn anything on a live course you attend with us, we will give you your money back*

 

SCHEDULE GUARANTEE- If we can't get enough delegates that is our problem, not yours. The course will run even if we are only training 1 person.

 

CD with Video clips- Delegates receive a CD with video clips of all the areas taught

 

Presenters Practical Experience- All presenters have years of practical experience in working with Excel

 

Excel Aptitude Test/ Pre Assessment- each participant can be screened for relevance of the course to their skill levels

 

Customised Examples- For in-house courses we can customize the course to the clients exact needs e.g. use examples from your own organisation.

 

Excel 2003 or Excel 2007- We are happy to train in both versions of Excel

 

Other courses available (click to find out more)

 

Recent Testimonials:

 

*- less venue fees if applicable

Immediate (online) Training Solutions

For immediate, distanced based learning you can try some of our online Excel training which are available.

For Free online training refer to the index on the left hand side and watch our short tutorials on various tools and functions in Excel (try this tutorial as an example). Alternatively search the site using the search bar on the right.

For more formal online training where you can obtain a certificate, visit www.AuditExcel.com for options and pricing. Try a sample with this Free Excel 2003 Starter series.

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 was on an advanced excel course less than a year ago, and they touched on about 10% of what I learned in these three days. You met expectations that I did not even know existed"- T Connell (Clientele Life)

 

“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)

 

"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)

 

"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)

 

 

 

Below is a listing of our free and paid for online Excel Tutorial video clips. You can either use the index to the left, details below, or search the site to navigate to the desired training clip.

 

Tutorials Description
Online Excel Training

If you’re looking for online Excel training that’s dead easy, cost-effective and that you can do in your own time, try out our free Excel beginner course by clicking here.

Other courses available from our e commerce site at www.AuditExcel.com include

The Basics
(Free Excel Video Tutorials)
Learn the basics of using Microsoft Excel. Whether you consider yourself an expert or an absolute beginner, make sure you know about the Auditing Toolbar, the Function Wizard, how to design good spreadsheets and how to load your add ins.
 
Training by Excel's categories
(Free Excel Video Tutorials)
The functions available in Excel split into the categories as per the Excel Function Wizard. If you are interested in Lookup and Reference functions then follow this link.
 
Other Tool and Features in Excel 
(Free Excel Video Tutorials)

Excel has a number of time saving tools that are useful to its users. Learn about handling external links, the GoTo Special command, Find and Replace and Conditional Formatting.

 

VLOOKUP Page
(Free Excel Video Tutorials)
Learn all you need to know about the VLOOKUP function in Microsoft Excel.

Tips and Tricks in Excel
(Free Excel Video Tutorials)
Some tips and tricks in using excel. Learn how to show all the underlying formula in cells, fill in blanks in some easy steps, cleanup data in a convenient way etc.
 
What If Tools
(Free Excel Training video clips)
Learn how to use Excels tools to run what ifs, sensitivities, and scenarios. Find out how to goalseek and to watch what happens to key cells when inputs are changed (no matter where they are!)
 

Power Courses

(Free Excel Video Tutorials)

Short courses where we have used our experience to show various users what they need to know based on the type of work they do, or the industry they are in. Have a look, its free.
 
How errors happen in Excel
(Free Excel Video Tutorials)
Learn how easy it is to make errors in excel and how to avoid them. From simple functions like Copy/ Paste to more complex ones like VLOOKUP.
 
Vital Tips
(Free Excel Tutorials- Documentation)
Over the years it has become apparent that spreadsheets contain errors. This is clearly acknowledged by the addition of many audit functions to the more recent versions of Excel. These are very useful features which are seldom known about, understood or used.
 

Addressing Sarbanes Oxley with Excel Only

Ideas on how to address spreadsheet risks in terms of Sarbanes Oxley legislation.
 
Downloadable Training Training that can be downloaded for a variety of functions and features in Excel. Quickly learn about VLOOKUP, RANK, Conditional formatting etc.
 
Fun and Useful Stuff

World Cup Soccer Spreadsheet

Retirement Planning

Su Doku Spreadsheet

Some fun and useful spreadsheet related topics. If you are looking forward to the world cup, see how to build automatic sorting league tables. If Su Doku is you pleasure, then get a spreadsheet to make getting started easier. On a more serious note, see how your retirement planning is coming. Will you have enough??

 

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.

  • 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

 

Other Services

Visit the Home Page to find out more

Our YouTube Channel

Do you know we also have a YouTube Channel. The video quality is best on this site but if you prefer you can see our channel by clicking on the logo below

   
     Read our privacy policy if you are concerned about your information
 

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