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

 

Advanced Microsoft Excel Training

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

 

Live Microsoft Excel Courses

Johannesburg, South Africa

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

 

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

 

Next Public Course- Rivonia, Johannesburg

Two Day Advanced Excel (click here for details)

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

 

Other courses available (click to find out more)

 

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

 

*- 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.

Recent Testimonial

I found your site by accident. I am so glad I did. Your videos are easy to understand and saved the day here at work today!

Debra L. Barnes

 

If neither of these options interest you then consider

 

 

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

 

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