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

If you require MCSE help you have come to the right place. Audit Excel is the one website on the Internet that provides comprehensive information and also MCSE help.
For one you can do a relevant course through us and get all the MCSE help you will need to pass the Microsoft Exams.
There are various certifications available in the market. You can train and obtain certification as a Microsoft Certified Systems Engineer on the Windows Server 2003, Windows 2000 or Windows NT 4.0. In addition specialization regarding messaging or security on the Windows servers can also be done. This is what makes the qualification important as vital skills are enhanced.
It should be noted that the requirements set by Microsoft for certification on Windows Server 2003 and Windows 2000 differ. If you want to obtain certification for Windows 2000 you will need to pass a minimum of five core exams and two elective exams. The core exams focus on operating systems with one of the core exams focusing on design. The elective exams focus on technical skills and solutions designs.
The requirements for Windows Server 2003 includes six core exams which entail four that focus on networking systems, one on design and one on client operating systems. In addition you will have to pass an elective exam similar to that required for the Windows 2000 platform.
The first step is to select the path that you want to go – that is the server or platform to focus on. The second step is to contact us for enrolment and pricing. The third step is to do the training and finally to write the exams.

MCSE help