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

 

Free Excel Video Tutorials

 

Below is a listing of our free online Excel Tutorial video clips.

You can either click on a category below to find the correct video, use the navigation on the left to quickly move between videos, or use the search facility on the right to find what you are looking for.

 

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

 

Next Course- Rivonia

9th & 10th February 2010- Two Day Advanced Excel

 

 

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

 

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

 

Tutorials Description
NEW- 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

 

9th & 10th Feb 2010 - Two Day Advanced Excel Course

 

audit excel spreadsheet auditingCLICK 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