Explore the power of spreadsheets for developers in this 48-minute conference talk from GOTO Berlin 2015. Discover how Assistant Professor Felienne Hermans from Delft University of Technology challenges the notion that spreadsheets are not "proper programming." Learn about the Turing completeness of spreadsheets and dive into practical implementations of programming concepts using Excel. Gain insights on selection sort, offset functions, name ranges, and high-order functions in spreadsheets. Understand the parallels between Excel and traditional programming languages like Python, and explore the research behind spreadsheet programming. Enhance your skills and broaden your perspective on the capabilities of spreadsheets in software development.
Overview
Syllabus
Intro
Selection Sort
Offset Function
Name Ranges
Song Name Ranges
Little Bit More Magic
Previous Row
Selection
Programming in Excel
What is my real job
Bumblebee
Research
Summary
Questions
Highorder functions
Excel is code
Excel vs Python
Taught by
GOTO Conferences
