Tag Archives: Development

Macros: Making Excel even more capable

There are several hundred functions on Excel, which can mostly be combined to produce thousands more, but sometimes even they cannot┬ácope with requirements. Excel’s programming language, VBA (Visual Basic for Applications) is there to help you achieve the missing capabilities, … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Good design – introduction

Spreadsheets mean that things can be tried out very quickly; and changes and improvements made (almost) immediately. However, in a ‘mature’ spreadsheet, the only changes should be to the data, with the functionality locked down and well documented. There are … Continue reading

Posted in Uncategorized | Tagged , , , , , , | Leave a comment