![]() But until recently, Excel has lacked some key features for programming, including built-in custom functions, variables and custom data types. Millions more people know how to do what's effectively programming in Excel than in any programming language. Improving Excel as a programming platform But you don't have to go and learn a programming language like VBA or JavaScript, the way you do with existing options for custom functions. ![]() Effectively, you can build rules for manipulating data inside Excel that aren't the rules that come built into Excel, with as much power as any other general-purpose programming language. Now, the new LAMBDA feature that turns Excel formulae into reusable custom functions makes it Turing-complete. " 'Why did you build this yourself? Why didn't you go to IT and ask for a system in a programming language?'' And they said 'Yeah, we did that and they said it was going to be two million euros and six months, and then it was 10 million euros and nine months, and it had half of the features of this spreadsheet I built in an afternoon'."Ī few years ago, Hermans built a Turing machine in Excel. When Enron's company documents became public, it offered a rare chance to see how enterprises use spreadsheets for these kind of business decision models, prompting Felienne Hermans, associate professor at Leiden University, to interview typical business users about why they were effectively building applications in Excel. Excel is often referred to as the original low-code tool.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |