audit excel spreadsheet auditing
audit excel spreadsheet auditing
Online Excel Training Links
 
MAIN PAGES
-Home Page
-Company Profile
-Free Tutorial Page
-Training Schedule
-Contact Us
BLOG
- Our BLOG
SOFTWARE
-Spreadsheet Auditing
-Spreadsheet Sensitivity
-Spreadsheet Security
NEW Videos
- IRR Calculator
- Count error checks
- Check import headers
- INDIRECT function
- IS number EVEN/ODD
- Is cell a number
- MATCH Function
- Identify missing categories
- Check that data within range
- TEXT Function
- Remove Spaces
- Use ADDRESS
Excel Basics
- Function Wizard
- Audit Toolbar
- Good Design
- Add In's
Tips and Tricks
- Identify missing categories
- 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 tips
- VLOOKUP Use
- Large VLOOKUP's
- VLOOKUP Risk
- Automatic Sorting
Financial
- IRR Calculator
- Interest rate
- IRR
- NPV
- CAGR
- PMT
- Amortization table
Database
- Database
Lookups
- Use ADDRESS
- MATCH Function
- INDIRECT function
- VLOOKUP
- Transpose
- CHOOSE
- OFFSET
- SUMIF/ COUNTIF
Dates
- DATE
- EOMONTH
- EDATE
Statistics
- Rank
- MAX/ MIN
Logical
- IF
- AND/ OR
Text
- TEXT Function
- Remove Spaces
- FIND
- Length
- Join characters
- Change Case
- Extract Text
Information
- IS number EVEN/ODD
- Is cell a number
- ISERROR
Maths
- SUMIF/ COUNTIF
Other Tools
- Data Validation
- 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
How errors happen
- Copy/ Paste
- Delete Cells
- Insert rows
- Insert cells
- IF functions
- Linked Sheets
- Hidden Cells
- Lookup's
- MIN/MAX function
- Referencing
What If's
- Goalseek
- Data Tables
- Scenarios
- Watch Window
Download All Videos
- 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
 

Buying our products

In order to provide better security we have created a separate e commerce site to handle our transaction.

 

To go there visit www.AuditExcel.com

 

If you want to go directly to the product you are looking for use the links below

 

Excel Addins

Spreadsheet Professional- for auditing and review spreadsheets

 

AssumeIT- for running sensitivities on Excel spreadsheets

 

XLSafe- for improving the security on Excel spreadsheets

 

http://www.auditexcel.com/c9/Excel-Add-In-Solutions.aspx

 

Online Excel Training

A variety of courses are available for Excel 2003 and Excel 2007

http://www.auditexcel.com/c8/Excel-Online-Training.aspx

 

MS Office Training

We also offer other computer based courses

http://www.auditexcel.com/c12/MS-Office-Online-Training.aspx

 

CPD Training

All our online courses can be verified and therefore can be used for CPD purposes. Besides the computer courses available we also have a number of courses on improving your business skills.

http://www.auditexcel.com/c17/SAICA-IRBA-CPD.aspx

 
     
     Read our privacy policy if you are concerned about your information
 

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