Microsoft 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

Microsoft Courses

Microsoft Courses available Online

We provide a wide range of Microsoft Courses which include for instance, the following:

Excel 2003, 2007, and advanced 2007

Office 2007 Conversion series

Access 2003, 2007, and advanced 2007

Office 2007

Outlook 2007

Word 2003 and 2007

Sharepoint 2007

The beginner’s Excel course is free and available right here. The more advanced courses are available from our ecommerce site at www.auditexcel.com. Compact, yet comprehensive, and easy to understand our Microsoft Courses range from three to 26 hours in length depending on the course selected. The Microsoft Courses for Excel 2003 are 26 hours and entail all the functions of the program. Each of the courses can be purchased online.

We also provide live Microsoft Courses in Excel. Workshop based, the courses are presented by experts in the program and entail focus on specific topics in Excel. The benefits of online training however, makes the online method the most preferred option as the information is available immediately and no software is required to study the various topics.

Each of the online courses comes with simulations, practical examples, and challenges. You can learn from anywhere if you have an internet connection and you set the pace. With this method you will be able to skip sections that you already understand and thus save time in learning the specific program. In addition you can complete the assessments and obtain a certificate for completion of the course.

Contact us today to enrol in any of the Microsoft courses whether online or classroom based presented by one of our instructors.