Microsoft Excel Support, Design and Development, Adelaide, South Australia

CypherBYTE has been designing, developing and supporting customised Microsoft Excel spreadsheets for Australian businesses since 1992.

A Microsoft Excel spreadsheet is essentially a large, flexible, scientific calculator set out in a table-matrix format. Because a spreadsheet is essentially a gigantic 3D table, you can use them in many ways, but by far the most common use is for recording financial information and building financial models. You can create formulas in Microsoft Excel spreadsheets and that is the strength of any spreadsheet. Because of it's flexibility, you can very quickly create nice lists of data and/or mathematical models. From there, you can analyse data in many ways, including creating charts.

Microsoft Excel spreadsheets can become quite complex and when they do, you can either work your way through the complexities yourself (if you are thus inclined) or you can opt to call someone else in to work through the complexities for you or with you. Microsoft Excel spreadsheets can become complex enough to also warrant automation - automatic procedures (macros) that simplify common tasks.

When your spreadsheet gets to the point where you are thinking that there MUST be an easier way or you recognise that the complexities are getting too much for you to handle, or maybe you just plain and simple get stuck, you would benefit from consultation, support or development of your spreadsheet. Spreadsheets can be designed and developed in similar ways to Microsoft Access databases and in fact, most Excel spreadsheets eventually become custom database designs because of the limitations of a spreadsheet.

Microsoft Excel Spreadsheet design and development support can include:

Designing and developing complete Microsoft Excel spreadsheets.
Supporting the development of complex formulas and functions.
Supporting the development of charts.
Designing and developing data lists and macros that utilise them.
Troubleshooting.
Implementing complex filtering.
Creating or modifying custom forms.
Development of command buttons, macros and other automation tasks.
Simplification of interaction tasks between several large spreadsheets.

There are some limitations to using Microsoft Excel spreadsheets that you might not know:

Everything is handled in memory, so the larger the spreadsheet the slower it gets to open, save and work in.
There is currently a maximum of 256 columns. This is true of every spreadsheet.
There is currently a maximum of 65,536 rows.
Although Microsoft Excel can use lookup functions, there is no such thing as a relationship between data elements.
The development environment is nowhere near as powerful as something like a Microsoft Access database.
A custom function can only return a value, it cannot manipulate spreadsheet content in any way, for that you need a custom subprocedure, which cannot return a value.

Back to the Home page