excel

A reupload of Joel Spolsky's talk teaching spreadsheet users the Excel features they are probably missing, such as keyboard navigation, named ranges, tables and lookups. The original disappeared and this copy comes from the Wayback Machine.

Felienne Hermans argues that Excel is the world's most popular programming language and shows how spreadsheets work as a pure functional language. She implements a few mathematical problems in spreadsheet formulas to illustrate why they are so powerful and approachable.

A DConf 2019 talk by Robert Schadek arguing that spreadsheets are the world's dominant programming language and that D can be used to replace them. It looks at spreadsheet quirks and then at techniques for moving away from them.

A 1953 US Navy training film explaining the basic mechanisms in mechanical fire control computers aboard ships. It shows how gears, differentials and cams solved mathematical problems in permanent mechanical form.

Tom Scott's long explainer on YouTube's copyright system, Content ID and the DMCA. He argues the platform's system is a workaround for a broader copyright system that does not fit the modern world.

A Technology Connections video on how ground-source (geothermal) heat pumps work and why they hold efficiency in winter. It also covers related heat pump information, and the description notes air-source heat pumps have since improved.

A 38C3 talk on how advanced chips are made, centered on EUV lithography and the global supply chain behind it. It covers technical challenges from raw materials to finished chips and the geopolitical weight of semiconductors.

Steve Yegge records himself working in Emacs and shows off about a dozen features in a roughly 45-minute screen capture. It is an informal, enthusiastic tour rather than a structured tutorial.

David Kipping presents his proposed Terrascope, a telescope that uses Earth's atmosphere as a lens to achieve enormous magnification. He covers the history of telescopes and his path to the idea, plus Sol-scope and Jupiter-scope variants.

Will Wilson explains autonomous testing: using deterministic simulation and fuzzing, building on FoundationDB's approach, to test software continuously. It sets out the ideas behind his later company Antithesis.

Retro Game Mechanics Explained dissects how Atari's Quadrascan vector displays and vector generator hardware drew games like Asteroids and Tempest.

The first lesson of MangoJelly's FreeCAD 0.20 beginner course, covering setup, preferences and navigation. The series teaches fundamentals through complete workflows such as sketching, Part Design and STL export.

Chase Adam, founder of the nonprofit Watsi, speaks at Startup School 2013 about building a nonprofit startup.

Johann Korndorfer's NVScene 2015 talk on building content with signed distance functions. It focuses on patterns that make SDF modelling more structured, arguing that SDFs capture a shape's essence like vector graphics do compared with polygons or voxels.

Gaming Historian recounts how Alexey Pajitnov created Tetris in the Soviet Union and how a fight over publishing rights spanned the West, Mirrorsoft, Nintendo and the Cold War. It runs about an hour with chaptered parts.

Terence Tao and Grant Sanderson of 3Blue1Brown walk through the cosmic distance ladder, showing how humans measured distances from the Earth to the Moon, Sun, planets and beyond. It includes animations and the history behind each step.

Victoria Warmerdam's Oscar-winning Dutch short film in which a woman fails a series of Captcha tests and is plunged into a strange new reality. It is a dark, Black Mirror-like sci-fi comedy.

Karen Sandler's keynote at Linux.conf.au 2012 on the software running inside medical devices such as her own pacemaker-defibrillator. She discusses the difficulty of learning what code runs in life-sustaining devices and why open source matters there.

Part one of Sandia National Labs' first-person documentary on the use control, detonation safety and survivability of US nuclear weapons. It covers nuclear sharing in NATO and how control of use was separated from possession, leading to the always/never problem.

Biochemist Nick Lane gives a Royal Institution lecture arguing that the Krebs cycle is central to what makes cells alive, not just genetic information. He draws on the themes of his book Transformer to link metabolism to the origin of life, death, and aging.

A Veritasium video on how a feud between Russian mathematicians led to Markov chains and the modern prediction algorithms built on them. It covers the history and the math behind them.