Spreadsheet Software | 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

Spreadsheet Software

Spreadsheet Software That is Inexpensive But Efficient

Most computers come with a Microsoft Office package that includes basic programs like Word, Excel and PowerPoint. Because these programs are so readily available and people are self taught on them, very few companies believe to send their employees for training on Microsoft Excel. Instead they spend a lot of money on designing their own specialist spreadsheet software that is not nearly as efficient as Excel, or as affordable. Miricle Solutions have seen the benefits of using Microsoft Excel as accounting software and they provide training to show how versatile Excel 2003 and Excel 2007 can be.

The founder of Miricle Solutions, Adrian Miric, has a lot of experience with financial models and immediately realised the potential of Excel. Miric noticed that Excel’s flexibility and versatility allowed it to be the perfect spreadsheet software that could automate tasks with macros and is great for data analysis. Since then Miricle Solutions have put a lot of effort in their live Excel training, teaching professionals the basic and advanced features.

The length of the courses differs but they all start with the basics and then become more complicated. There are a lot of practical examples to make sure that everyone can go back to their companies and implement what they have learned. Miricle Solutions will also do an in-house course at the company’s premises and then use scenarios that are relevant to that industry.

Book your space now for a spreadsheet software course and learn the basics of cells, worksheets and Excel toolbars. If you already know the basics then you can join the intermediate courses that focus on charts, databases, hyperlinks, data formatting and how to manage worksheets. All you have to do is contact Miricle Solutions to register for a two-day course in Rivonia or Sandton.