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

Excel Training Solutions For Corporate Clients

Inaccurate spreadsheets, improper usage of spreadsheets and under-usage thereof are all symptoms of skills shortage in spreadsheet usage. Miricle Solutions provides from basic to advanced Excel training solutions to help client companies ensure that their employees have the necessary skills to effectively use Excel in database development, financial modelling, data analysis, day to day bookkeeping, record keeping, and related applications.

Application In Industry

You may have an engineering company and have engineers that need to use the program for reporting and such 3D graphs will be essential. Although engineers certainly have no problem in creating 3D models in sophisticated graphic and engineering design programs, their knowledge of the spreadsheet program may be too limited to ensure professional presentations. For such it will be essential to train them in Excel for the specific purpose. We at Miricle Solutions recognize the importance of custom Excel training solutions also to address areas such as 3D graphs.

In addition, you may have an accounting division where accuracy of figures is of the utmost importance. New employees and clerical staff may know the basics of Excel, but working with the program for more advanced financial reporting requires advanced Excel skills. We provide a wide range of Excel training solutions to fit every department in your company.

Custom Training

Miricle Solutions offers online free guidance on the basics of Excel, tips and videos for training purposes in addition to self study courses that can be purchased for more advanced applications. In addition we present live Excel courses at preset dates as well as training at corporate client premises. As such you can select the option that fits the particular training needs for your employees. We can assist in determining the skills levels of employees and their specific Excel training needs to ensure targeted training. View our range of Excel training solutions and contact us today to book a solution that suits your particular requirements.