MCSE | Training Courses South Africa

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

MCSE is the short for Microsoft Certified Systems Engineer and is the preferred qualification for professionals in the IT industry that have to assess IT requirements, do the designing and installation of network systems and regularly have to do trouble shooting on the systems. The MCSE certification is useful for any IT related engineer and professional working with the Windows 2003 Server or the Windows 2000 platform.

One of the normal requirements is that the candidate must at least have a year’s experience in the appropriate environment regarding network services, dial-in servers, proxy servers, web hosting etc. The candidate must also have experience in the network design and management of an operating system ensuring that they will not only be an MCSE on paper, but also someone with the required experience at the end of the day.
Certification in Windows 2000, Microsoft NT 4.0, and Windows Server 2003 are available. There are core and elective exams according to the choice made from one of the above three that have to be passed. The exams generally have around 45-55 questions and a minimum percentage is established for passing. The course online will be paced by the student. In general around 200 hours of study will be needed. Once certified and having gained a year’s experience in the field, the candidate can expect a handsome salary as the MCSE is normally well paid.

It is expected from the certified engineer to show excellent command of exchange servers, operating systems and the Windows 2003 server. The candidate will be able to work with advanced internet security, WAN and LAN with ease. The company that employs the candidate will benefit from improved productivity in the network systems division and will save money regarding installation and maintenance in the long run. Contact us today for information regarding our MCSE courses.