MCSE 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

MCSE Courses

If you need help to make a selection amongst the thousands of MCSE courses advertised read on as an overview of MCSE courses are provided below.

We offer the following core MCSE courses for Windows Server 2003 online:

Active Directory (70-294) series

Network Management (70-291) series

Administration (70-290) series

Network Planning (70-293) series

We also offer the Windows 2000 Professional series (70-210).

What will you need to get your certification for Windows Server 2003?

There are seven exams that cover all the areas of study. Our MCSE courses will help you prepare fully for the exams which consist of four core exams on the topic of networking systems, a core exam on design, one elective and one on client operating systems. Many people have asked whether the Windows Server 2003 certification will retire at one or other stage. The good news is that the answer is a definite no. As such you can prepare for the exams with confidence.

Why do the courses?

The courses include challenges and questions in addition to full explanation of the various components to help you prepare well for the exams. If you plan to work in any of the core areas covered by the exams, you will benefit from certification. Since there is a single standard for testing, the IT industry recognizes the certification worldwide. With such a qualification you will be amongst the top earners and employers will immediately recognize the value of your qualification and the skills associated with such.