Free online training | 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

Free online training

Free online training in basics of Excel

We offer free online training in Microsoft Excel. It forms an excellent base for students, people who need to brush up on skills, employees who have to convert to the Microsoft Excel 2007 version from 2003 and require assistance in getting to know the new interface, and for anyone struggling with a particular function in Excel.

How does the free online training work?

Simply view the training section and select a category. You will find sub-categories regarding the topic or can make use of the quick links at the left side of the screen to get to a specific tutorial. The tutorials are online and short enough to quickly run through under five minutes each. This means that you can skip all the introductions and go straight to the particular problem area for assistance.

A well qualified and experienced instructor who is also actively involved in accounting practices present the free online training courses. The screen is highlighted where the cursor is, making it possible to follow step by step. The tutorial is thus video based with audio for both visual and audio learners. In addition we provide a printable script of the tutorial for your convenience.

Some of the topics that you may find useful are that of:

How errors happen in Excel

What If tools

VLookup page

The basics

Excel Beginner Course

Apart from the free online training in the basics, more advanced functions are taught in three hour courses which are emailed to you. If you want to make use of the advanced courses also available for Access and Converting to Word 2007, PowerPoint 2007, and Outlook 2007 series contact us today.