-
Recent Posts
Archives
Categories
Meta
-
Join 2 other subscribers
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
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 Development, Formulae, Functions, Good design, Logic, Robustness, Security
Leave a comment
Spreadsheet Expert Blog 