Excelは表計算ソフトであって、それ以上でも以下でもないのですが、プログラムを書く仕事が長いと、Excelのファンシーな部分が目に付くようになります。以下、Microsoftの2003年の論文です。
Simon Peyton Jones, Margaret Burnett, Alan Blackwell. 12 pages, March 2003.
We describe extensions to the Excel spreadsheet that integrate user-defined functions into the spreadsheet grid, rather than treating them as a “bolt-on”. Our case study is unusual in that it highlights the way that programming language insights can be applied to a product not normally considered as a programming language.
Even more unusual, our design is ruthlessly driven by principles of user-centred design developed by the HCI community, extending them to programming language design. Unlike other programming language research that focuses on usability, our project involves the evolution of the design of a well-established language, which raises compatibility with previous versions as a major issue, but also gives us access to a user base who are able to offer feedback in the user-centred design process.In this paper we present our extensions and the HCI design principles that lead to our design choices.
賛否両論あると思いますが、Excelのスキルを上げたい、Excelの壁を超えたい、という方は、一度、プログラミング言語を習得してみると良いと思います。アーストでは、プログラミング言語の習得を応援するカリキュラムを用意しています。