Explore pure functional programming concepts applied to Excel in this 43-minute conference talk from GOTO Amsterdam 2016. Discover why Excel is considered the world's most popular programming language and how it can be leveraged for powerful computational tasks. Learn about Excel's Turing completeness, software engineering challenges in spreadsheets, and functional programming techniques using formulas and array functions. Dive into topics such as error handling, dynamic programming, code smells, and dependencies in Excel. Gain insights on visualizing data, working with external worksheets, and addressing common spreadsheet issues. Engage with live programming demonstrations and real-world problem-solving examples throughout the presentation.
Overview
Syllabus
Introduction
Why are spreadsheets code
Excel Turing Machine
Software Engineering Problems
Summary
Live Programming
Formulas
Spreadsheets
Functional Programming
Array Function
Error Values
Real Problem
Dynamic Programming
Spreadsheets are Code
Code Smells
Dependencies
Q1 Q2
Visualization
External Worksheets
Inter Worksheets
Smell
Bumblebee
Test
Questions
Taught by
GOTO Conferences
