![]() Microsoft’s blog calls formulas the world’s most widely used programming language - yet it had always been limited to a pre-defined universe of options. Programming with ExcelĮxcel users do much of their work using formulas - where the input into a cell starts with an equals sign followed by some kind of calculation (“=A2 + B2”). Here’s a look at these changes, and what they portend for the future of Excel, as a programming language. ✔ Transform custom functions and wrap them up in a LAMBDA function. ![]() ✔ Define custom functions in Excel’s formula language. ![]() Hey, Office Insiders- LAMBDA for #Excel is now available! And it adds that “early community response has been encouraging,” noting that Microsoft researchers are enthusiastically envisioning skilled Excel users creating functions “that appear seamlessly part of Excel to their colleagues, who simply call them.” “Being Turing complete is the litmus test of a full-fledged programming language,” explained a new article in Visual Studio magazine. You can now, in principle, write any computation in the Excel formula language,” a Microsoft blog proclaimed. “With LAMBDA, Excel has become Turing-complete. ![]() ![]() Microsoft’s researchers believe they’ve now finally transformed Excel into a full-fledged programming language, thanks to the introduction of a new feature called LAMBDA. So it feels almost historic when one of the world’s largest corporations augments a crucial component of its Office software suite - yet sure enough, Excel has been upgraded with a major new feature. Fast forward to the future, and the Irish Times noted in 2017 that Microsoft CEO Satya Nadella was calling Excel Microsoft’s most important consumer product, pointing out that it had over 750 million users. It was 34 years ago, just three years after Apple introduced its very first Macs, that Microsoft released the first version of its familiar Excel spreadsheet app, initially a rough copy of Dan Bricklin’s VisiCalc. It may be the oldest piece of software still in widespread use. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |