Training Courses | Online Training 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

Training Courses

Computer training courses available through us

If you are looking for quick and affordable training courses that can be completed in your own time and the comfort of your home, you have come to the right place. Just about every Office Suite program can be learned in a manner of hours. With our easy to follow tutorial based training courses, you can decide which part of the program you need to learn. This will help you to save time as you will not have to work through parts of the program that you are already familiar with. Targeted training allows for quicker learning of programs, and with the ability to follow on previous lessons or to skip to a particular part, you can also use the training courses as quick reference.

Whether you want to get familiar with the new 2007 interfaces of Excel, Word, PowerPoint, and Publisher or need to learn the programs from beginning to end, there is no better way than through our well written and proven to be successful training courses.

We also offer advanced courses ensuring that users can become power users of the various programs. We have wide selection of courses ranging from Access to Outlook, FrontPage, Projects and Excel to name, but a few. The courses have been developed specifically to make it possible to train without an instructor ensuring that you can learn on your own. You can also attend short courses at various locations around the country. View our range of training courses and select the one most relevant to your needs. Contact us for assistance regarding class based instruction and workshops or for more information on the various MCSE courses available online.