MCSE Courses | Online Help | Miricle 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

Why take the online MCSE courses available through Audit Excel?

In addition to numerous other online training programs such as the MCSA, A+, and Office programs we also offer online MCSE courses.
Why enrol for online MCSE courses through Audit Excel?

Online studying affords you more freedom. Instead of having to be at class at a specific time and date, you can plan your studies according to your schedule. Some people study better early morning, whilst others take their lunch time to get in a few minutes of intense study. Others work best late at night when they have completed all the tasks for the day. In addition you can study anywhere. You only need Internet access and with connectivity almost anywhere in the world, you can even study while travelling.

The cost of online MCSE courses is far below that of courses presented in a class setup. As such you will save a lot of money and if you are the sponsor you will be able to enrol more staff members than would have been possible in the traditional class instruction way.
Save on paper, postage and administration costs. Do the online quizzes and challenges to refresh your memory and develop your skills.
Another reason for selecting the online studying method is that of 24 hour instant assistance should you need help. Instead of having to wait until your next class, you can quickly get help and thus save valuable time.

Why study through Audit Excel?

We provide you with all the courseware online, assistance, and ample time to complete the courses. You will have 12 months access to the course material making it possible to study at a relaxed pace rather than having to rush your studies. We also provide various other courses and with help only a click away you will never be lost or frustrated.

MCSE courses