MCSE Specializations | 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 Specializations

With many IT professionals entering the world of Microsoft Certified Systems Engineering the need for MCSE Specializations has developed to meet the demand for more specialized skills. With MCSE Specializations it is possible to focus on a specific technical area, and although not more advanced than MCSE certifications, the IT professional gets more focused training.
There are currently two main MCSE specializations available:

Security on Windows Server 2003 or 2000

Messaging on Windows Server 2003 or 2000

Security on Windows Server 2003
In addition to being certified as either a Microsoft Certified Systems Administrator or a Microsoft Certified Systems Engineer, you can also focus on the design and implementation of security infrastructure specifically for the Windows Server 2003 environment. It is the ideal specialization for an IT professional with a minimum of 12 months working experience in network and client operating systems. Systems analysts, technical consultants, and network specialists benefit from gaining the specialization.
There are eight exams to pass including two security specialization exams, a security design exam, four core networking exams and a core client operating system exam.
Messaging on Windows Server 2003
The candidate profile is the same as the one for specialization in security. The exams to be passed, however, differ and include four core networking exams, two messaging specialization, one design and one core client operating system exam.

MCSE specializations