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

The Fun side of Spreadsheet Modelling- Predict the World Cup Scores

Thirty-two teams, eight groups and sixty-four World Cup Matches, can you predict who is going to score? Thanks to a proudly South African company and their innovative Spreadsheet Modelling that is downloadable from their website, you can now capture all the football statistics and make your own calculations of World Cup 2010. Miricle Solutions is South Africa’s premier provider of Microsoft Excel Consulting, Training and Excel Add Ins and they have no problem making Spreadsheet Modelling a fun activity.

There is already a lot of interesting facts surrounding the World Cup that is taking place for the first time on African soil. Keeping track of the ten stadiums where the games will be played, the world class players and the international fans will be enough to keep you busy until the finals on July 11th 2010. If you are betting on the World Cup, want to test your prediction skills or get extra training in Microsoft Excel then you have to access this unique download for your computer or mobile phone.

The spreadsheet is easier to use than blowing on a vuvuzela (the noise-making trumpet of South African football fans) and will give you a good idea what the knockout stages may look like. Once you’ve mastered updating the actual scores you can create your own version for the English premier league, the Super 14 Rugby or the Rugby World Cup in 2011. Some of the functions that might come in handy are the Automatic sorting of a list, the Rank function (that is great to see the placing of each team after you’ve entered the results) and the VLOOKUP function (which enables you to pull through various bits of information based on some reference point).

It’s time to download the World Cup Spreadsheet for free on the webpage and contact Miricle Solutions for any further assistance. You can also learn how to create your own Spreadsheet Modelling solutions for other sporting events with online excel training. Get creative and use our advanced Excel tips on automatic sorting and VLOOKUP tables to make your own retirement plan.