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

If you are looking for a provider of MCSE training courses look no further than Audit Excel (Miricle Solutions). We recognize the importance of basic to advanced MCSE training for full certification. Certification is possibly the best way to show that you have the core competencies to work on the Windows Server. This will not only be a benefit when looking for a new job in the IT industry, but will also enhance your chances for promotion in addition to building essential skills.
Our course also includes the final exams which cover areas such as communication, environmental aspects, security, safety and professionalism as part of the course. MCSE training is essential to improve your analysing skills regarding information systems and solutions in addition to improving your ability to implement infrastructures running on the Windows Server.
Minimum requirements to earn certification
You will need to pass seven exams involving four core exams on the all important component of networking systems, a core exam on client operating systems, an exam on design and the elective exam.
The core courses include that of Windows 2003 Active Directory 70-294 series, the Windows Server 2003 Administration 70-290, the Windows Server 2003 Network Management 70-291, and the Windows Server 2003 Network Planning 70-293 series.

Apart from the core courses on Windows Server 2003 there are also a range of design or elective courses which range from the MCSA/MCSE 70-284 series and the Microsoft Exchange Sever 2007 MCTS 70-236 series to the SQL Server 2000 Security Admin MCSA/MCSE 70-299 series and the Windows Vista Configuration MCTS 70-620 series to name, but a few examples of courses available.

MCSE training