Variety Of Excel Courses To Select From | 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

Excel Courses

Variety Of Excel Courses To Select From

Although there certainly are no shortages of Excel courses to attend or download from the Internet, the level of presentation, skills learned through the courses, and the applicability to daily business should be considered when browsing for Excel courses.

We at Miricle Solutions have extensive experience in the usage of Excel as spreadsheet, financial modelling, and database tool in day to day accounting, forecasting, project management, and financial analysis applications. We convey this information in an understandable manner through well structured presentations. Delegates to our advanced Excel courses thus have the benefit of experienced presenters to explain complex applications in an easy to understand manner while the delegates also have ample time to do hands-on exercises.

Apart from the advanced Excel courses presented at specific venues we also offer in-house advanced Excel courses for companies. This offers companies the benefit of onsite training with less time lost due to travelling. The delegates do not have to book accommodation and as such it is an economically viable option for the company that wants to train several employees in Excel at once. We offer skills assessments to help companies determine the skills levels of employees and thus ensure more targeted training according to skills level.

In addition to the advanced Excel courses onsite and specific venues, we also offer online Excel courses ranging from very basic to advanced courses addressing specific modules of the spreadsheet program. Interested parties can simply select the relevant course or courses, make payment and download the complete tutorials. The tutorials are video based with printable scripts showing exactly how to do specific formulas, use functions, and work with the various Excel tools.

No matter how you prefer to learn Excel you will benefit from the interactive instruction offered through our wide variety of Excel courses. View our training pages and contact us for more information.