MCSE Courses | Mirical Solutions

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

Prepare For The Future With MCSE Courses

Quo Vadis South Africa? This Latin phrase meaning "where are you going?" is currently on many executives minds. The 2010 World Cup is finished and the upgrading of our country’s infrastructure is also making good progress. For instance the Gautrain project is already operating between Sandton and the O.R Tambo Airport. The World Cup hype has died down and we are all thinking about the future of South Africa and its various industries. While the construction sector is taking a hiatus other industries like Information Technology and Financial Administration are booming. Miricle Solutions will help system engineers prepare for better career opportunities with MCSE courses that focus specifically on Windows Server 2003.

The MCSE courses for Windows Server Training are divided into two parts – five core courses and eleven elective or design courses. The main courses are:

Windows 2000 Professional MCSE 70-210 series;

Windows Server 2003 Active Directory MCSE 70-294 series;

Windows Server 2003 Administration MCSE 70-290 series;

Windows Server 2003 Network Management MCSE 70-291 series; and

Windows Server 2003 Network Planning MCSE 70-293 series.

The strength of Windows Server 2003 in the market today indicates that demand for related IT expertise will continue for years to come. While none of us can predict exactly how South Africa is going to grow in the future, we can prepare ourselves to the best of our abilities. Learning skills that won’t become redundant even in the next 20 years is surely the way to go forward.

It’s easy to meet the Microsoft Certified Systems Engineer credentials, when you take part in the MCSE courses designed by Miricle Solutions. There is always a mentor ready to help you with your progress and to advice you on specific sections of the exam. You can start downloading the courseware immediately from the website or contact Miricle Solutions who will give you more details on the more than 1900 online courses.