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

 

Excel Skills Assessment Test

"We went on an 'advanced' Excel 3 course where we knew more than the presenter. How do we know that we will actually learn something new on your courses"- Client Quote

 

The only way to know what your skill level is, and whether you will learn something new is by taking some form of Excel Skills Assessment Test.

 

We offer a simple, 20 question test, that will give you a visual picture of what your skill level is and what course would benefit you.

 

When you complete the Free Skills Assessment available to South Africans, your will end up with a diagram as shown below

 

 

What this shows is your skill level across 4 main areas. But what does this mean in terms of the courses you should attend?

 

Below is what the assessment looks like for Excel 1, 2 and 3 learners. If you are close to any of these then the level 1, 2 and 3 is too simple for you. The sample user in this example would not benefit from Excel 1, 2 or 3.

 

 

Below is a comparison of the Advanced Excel course we provide to our sample user above. This gives a good indication of the level of our courses compared to the standard Microsoft Excel 1, 2, and 3.

 

 

For your frees skills assessment click on this link- Free Skills Assessment

 

Contact Adrian on 011 563 3805/ 083 272 2552 or  adrian@AuditExcel.co.za

 

 

 

Excel Training Courses

Contact us for more information on 011 563 3805/ 083 272 2552 or  info@AuditExcel.co.za

 

Excel Course in Johannesburg

Download Price and venue and see dates below

17- 21 Oct 2011

14- 18 Nov 2011 (less 10%)

13- 17 Feb 2012 (less 20%)

12- 16 Mar 2012

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

 

   
 

   Read our privacy policy if you are concerned about your information

 

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