Microsoft Excel Courses | Online Courses

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

Microsoft Excel Courses

Background on the Microsoft Excel Courses Available Through Us

Audit Excel is one of the leading providers of Microsoft Excel courses online in South Africa. We provide users with several options to learn the spreadsheet program including:

Free online Microsoft Excel courses for beginners on specific topics.

Advanced training courses running over a period of one to two days at various centres around the country.

In-house training at client company premises to ensure that employees can learn at work with minimal travelling and time-off required.

Aptitude testing for client company employees to assess the level of expertise regarding the program in the company in comparison with other companies in the same industry.

Downloadable and CD-Rom based Microsoft Excel courses that can be purchased online on various Excel topics; from beginner to advanced levels.

The presenters of the various courses are not only highly qualified in financial and auditing aspects, but are also experienced Excel 2003 and 2007 users. As such they are able to not only instruct on the various steps, but also provide hands-on and highly relevant training for day to day accounting functions that need to be done through usage of the program.

Whether users want to learn how to use the new 2007 Excel interface, are totally new to the program, are intermediate users or already highly advanced users of the program, we have relevant Microsoft Excel courses for everyone. With our approach of targeted training, you will not have to waste time on functions and features of the program that you already know or will not use in your work. Contact us today for more information about the various options or for a quote on a specific course.